Database Administration
Get the full GTU study material, English & Gujarati textbook PDFs, syllabus curriculum, and solved previous year question papers.
English Book & Chapters
English Book Coming Soon
We are working hard to add this material. Stay tuned for updates!
Follow on Instagram for UpdatesGTU Previous Year Papers
Papers Coming Soon
We are working hard to add this material. Stay tuned for updates!
Follow on Instagram for UpdatesDatabase Administration Syllabus — Unit-wise Content
The official GTU curriculum for Database Administration (subject code 3361605) as prescribed for Biomed · Semester 6 divides the course into 5 units, covering 31 listed topics. The unit-wise breakdown below is read from the GTU syllabus document for this subject code, so you can check what the course actually covers before deciding which papers to attempt.
Download the official syllabus PDF (3361605)Unit 1 Advanced SQL
- 1.1. Transactional Control: Commit, Save point, Rollback
- 1.2. DCL commands : Grant and Revoke
- 1.3. Types of locks : i. Row level locks ii. Table level locks iii. Shared lock iv. Exclusive lock v. Deadlock
- 1.4. Synonym : Create synonym
- 1.5. Sequences: Create and alter sequences
- 1.6. Index : Unique and composite
- 1.7. Views : Create/Replace, Update and alter views
Unit 2 PL / SQL and Triggers
- 2.1. Basics of PL / SQL
- 2.2. Data types
- 2.3. Advantages 2b.Use different Control Structures
- 2.4. Control Structures
- 2.5. Exceptions: Predefined Exceptions, User defined exceptions
- 2.6. Cursors: Static (Implicit & Explicit), Dynamic
- 2.7. Procedures & Functions
- 2.8. Packages : Package specification, Package body, Advantages of package Database Administration Course Code : 3361605 GTU/NITTTR/Bhopal/14-15 Gujarat State 3of6 Unit Major Learning Outcomes (in cognitive domain) Topics and Sub- topics
- 2.9. Fundamentals of Database Triggers
- 2.10. Creating Triggers
- 2.11. Types of Triggers : Before, after for each row, for each statement
Unit 3 Database Design And Implementati on
- 3.1. Database Application Life Cycle
- 3.2. Conceptual Database application i. Design ii. Retrieve transaction iii. Update Transaction iv. Mixed Transaction
- 3.3. Logical and Physical Database Design i. Response Time ii. Space Utilization iii. Transaction Throughput
Unit 4 Transaction Processing
- 4.1. Transaction concepts
- 4.3. Methods for Concurrency control i. Locking Methods ii. Timestamp methods iii. Optimistic methods
Unit 5 Database Administrator
- 5.1. Types of Oracle Database Users
- 5.2. User Creation and management
- 5.3. Tasks of a Database Administrator
- 5.4. Submitting Commands and SQL to the Database
- 5.5. About Database Administrator Security and Privileges
- 5.6. Database Administrator Authentication
- 5.7. Creating and Maintaining a Password File
- 5.8. Data Utilities Database Administration Course Code : 3361605 GTU/NITTTR/Bhopal/14-15 Gujarat State 4of6
Study on Android App:
