1. Introduction to Databases
1.1 Anatomy of Database System
1.2 Applications of Database System
1.3 StakeHolders, Users and Administrators
1.4 Client/Server concepts
1.5 Distributed Databases concepts
1.6 History
2. File Systems
2.1 Organisation of FileSystem
2.2 Database System v/s File System
3. Types of Database System Models
3.1 Hierarchical Model
3.2 Network Model
3.3 Relational Model
4. ER Models
4.1 Elements of ER
4.2 Design Issues
4.3 Application of ER
5. Relational Model
5.1 Anatomy of Relational Model
5.2 Relational Algebra
5.3 Design Issues
5.4 Applying Relational Model
6. Principles of DataStorage and Querying
6.1 Storage and FileStructure
6.2 Indexing and Hashing
6.3 Query Processing
6.4 Query Optimization
7. SQL
7.1 Introduction to SQL
7.2 Data Definition using SQL
7.3 Datatypes
7.4 Creating, Manipulating and Dropping Database
7.5 Creating, Manipulating and Dropping Tables
7.6 Creating, Manipulating and Dropping Views
7.7 Working with Constraints and Indexes.
8. Data Manipulation
8.1 Recurring SQL constructs
8.1.1 SELECT
8.1.2 UPDATE
8.1.3 INSERT
8.1.2 DELETE
8.2 Expressions
8.3 Grouping and Aggregate Functions
8.4 Joining Tables
8.5 Subqueries
9. Prepared Statements
9.1 Benefits
9.2 Using Prepared Statements
9.3 Executing and deallocating Prepared Statements
10. Stored Routines
10.1 Benefits
10.2 Procedures and functions
10.3 Namespace
10.4 Defining, Creating, Altering, Dropping and Invoking Stored Routines
10.5 Privileges and Security
10.6 Metadata
11. Triggers
11.1 Benefits
11.2 Creating, Restrictions and Destroying Triggers
11.3 Privileges
12. Transaction Management
12.1 Transactions
12.2 Concurrency Control
12.3 Recovery System
13. Database Connectors
13.1 JDBC
13.2 ODBC
13.3 Native
14. Advanced Topics
14.1 Object Oriented Databases
14.2 XML
14.3 Distributed Databases
14.4 Parallel Databases
14.5 Advanced Transaction Processing
14.6 Web Enabled Database Applications
14.7 Security
14.8 Case Study: Oracle,SQLServer,MySql
15. Project Work