• Module-1: Introduction to DBMS
• Introduction to Database
• Terminologies in Database
• Introduction to File Management System
• Drawbacks for File Management System
• Advantages of Database Management System(DBMS)
• Importance of Structured Query Language(SQL)
• Module-2: Environmental Setup
• Downloading Oracle Database Software
• Installing the Oracle Database Software
• Interacting with Database Using Command Line Interface tool.
• Interacting with Database using Graphical User Interface(GUI) Tools.
• Downloading & Installing MySQL Database Software
• Module-3: Database Commands
• Introduction to Database Commands
• DDL Commands

o CREATE o DROP o TRUNCATE o RENAME

• DML Commands

o INSERT o UPDATE o DELETE

• DQL / DRL Commands (SELECT)
• TCL Commands

o COMMIT o ROLLBACK

• Importing Some Sample Databases
• Module-4: Integrity Constraints
• Introduction to Data Integrity
• Primary Key
• Foreign Key
• Unique Key
• Composite key
• Not Null
• Check
• Module-5: SQL Clauses
• Where
• Group by
• Having
• Order by
• Module-6: SQL Operators
• Union
• Union All
• Intersect
• Minus
• Special Operators

– IN, NOT IN – BETWEEN, NOT BETWEEN – LIKE, NOT LIKE – ISNULL, ISNOT NULL

• Module-7: SQL Functions
• Arithmetic Functions
• Character Functions
• Date Functions
• Aggregate Functions
• Module-8: Sub Queries
• Introduction to Sub Queries
• Single Row Sub Query
• Multiple Row Sub Query
• Correlated Sub Query
• Module-9: SQL Joins
• Introduction to Joins
• Types of SQL Joins
• Cartesian join/product
• Equi Join / Inner Join / Simple Join
• Outer Joins
• Self-Joins
• Module-10: Other Discussions
• Database Sequences
• Database Views
• Database Indexing
• Creation and execution of DB Stored procedures
• Creation and execution of DB Stored Functions
• Stored Procedure (Vs) Stored Functions
• Interview Questions