Database Concepts
Concept of DBMS, RDBMS.
Data Models, Concept of DBA, Database Users.
ER Model & Diagram, Database Schema.
Designing Database using Normalization Rules.
Various data types Data integrity, DDL DML and DCL statements.
Enforcing Primary key and foreign key.
Adding Indices.
Queries
Concepts of Transactions
ACID Property of Transaction Constraints.
Joins and Functions
Joining of tables
Sub Queries
Functions used in query like sum, average, max, min,count etc.
Indexing and Query Optimization.
Stored Procedures, Triggers and Cursors
Introduction to Stored Procedures.
Introduction to Triggers and Cursor.
Creating Trigger
Creating Cursor
Using Cursor
