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 DI04016061) as prescribed for Biomed · Semester 4 divides the course into 5 units, covering 10 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 (DI04016061)Unit 1 Advanced SQL
- 1.1 Transaction Control o 1.1.1 Commit
- Rollback 1.2 DCL Commands o 1.2.1 Grant and Revoke 1.3 Types of Locks o 1.3.1 Row Level Locks o 1.3.2 Table Level Locks o 1.3.3 Shared Lock o 1.3.4 Exclusive Lock o 1.3.5 Deadlock 1.4 Synonym o 1.4.1 Create Synonym 1.5 Sequences o 1.5.1 Create and Alter Sequences 1.6 Index o 1.6.1 Unique and Composite 1.7 Views o 1.7.1 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 2.4 Control Structures o 2.4.1 Conditional o 2.4.2 Iterative o 2.4.3 Sequential 2.5 Exceptions o 2.5.1 Predefined Exceptions o 2.5.2 User defined Exceptions 2.6 Cursors Program Name: Diploma Engineering Level: Diploma Branch: Information Technology Subject Code: DI04016061 Subject Name: Database Administration o 2.6.1 Static (Implicit & Explicit) o 2.6.2 Dynamic 2.7 Procedures and Functions 2.8 Packages o 2.8.1 Package Specification o 2.8.2 Package Body o 2.8.3 Advantages of Package 2.9 Fundamentals of Database Triggers 2.10 Creating Triggers 2.11 Types of Triggers o 2.11.1 Before o 2.11.2 After o 2.11.3 Row o 2.11.4 Statement
Unit 3 Database Design and Implementation
- 3.1 Database Application Life Cycle 3.2 Conceptual Database Application o 3.2.1 Design o 3.2.2 Retrieve Transaction o 3.2.3 Update Transaction o 3.2.4 Mixed Transaction 3.3 Logical and Physical Database Design o 3.3.1 Response Time o 3.3.2 Space Utilization o 3.3.3 Transaction Throughput
Unit 4 Database Administrator
- 4.1 Types of Oracle Database Users 4.2 User Creation and Management 4.3 Tasks of a Database Administrator 4.4 Submitting Commands and SQL to the Database 4.5 About Database Administrator Security and Privileges 4.6 Database Administrator Authentication 4.7 Creating and Maintaining a Password File 4.8 Data Utilities
Unit 5 Modern Database & Cloud Database
- 5.1 Difference between SQL and NoSQL 5.2 Types of NoSQL databases 5.3 Introduction to MongoDB (basic CRUD operations) 5.4 Advantages
- limitations, and use cases of NoSQL 5.5 What is cloud computing and cloud databases 5.6 Types: Database as a Service (DBaaS)
- managed SQL/NoSQL 5.7 Introduction: Google Firebase
- AWS RDS, Azure SQL
Study on Android App:
