CONTENT:
- Introduction – Introduction to RDBMS, SQL Concepts
- Normalization – Normalization Basics, First Normal Form, Secnod Normal Form, Third Normal Form and BCNF
- Data Definition Language (DDL) – Create & View Database, Create and Alter Table, Truncate, Drop
- MySQL Constraints – Basics, Check, Default Keyword, Foreign Key
- Data Manipulation Language (DML) – Insert, Update & Delete
- Data Query Language – Select, Distinct, Where, Operators, Order By, Limit, Aggregate, Like, Group By, Having
- Joins in MySQL – Basic and Advanced Concepts
- Subquery in MySQL – Basics, Multi-Row Subquery
- Index – Index in MySQL
- Views – Basic and Advanced View Concepts in MySQL
- Stored Procedure in MySQL – Basics, Types of Parameters (with Example), Advanced Stored Procedure Concept, DML Operation with Stored Procedure (Practical)
- Stored Function – Stored Functions in MySQL
- Trigger in MySQL – Basics, Practicals on Before and After Insert/Update/Delete Trigger
- Cursor – Cursors in My SQL (with Examples)
