MySQL Database

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)