1 |
Introduction to Databases |
Overview of databases and database management systems (DBMS), Types of databases (relational,
NoSQL, etc.), Introduction to SQL and MySQL, Installing and configuring MySQL |
2 |
Basics of MySQL |
Understanding MySQL architecture, MySQL server and client, MySQL Workbench and other tools,
Connecting to a MySQL database |
3 |
Database Design |
Database design principles, Entity-Relationship (ER) modeling, Normalization (1NF, 2NF, 3NF,
BCNF), Primary keys, foreign keys, and indexes, Designing and creating databases and tables |
4 |
SQL Basics |
Data types in MySQL, Basic SQL syntax and commands, Creating databases and tables, Inserting,
updating, and deleting records, Retrieving data with SELECT |
5 |
Advanced SQL Queries |
Aggregate functions, Grouping data with GROUP BY, Filtering grouped data with HAVING |
6 |
Joins |
Inner join, Left join, Right join, Full outer join, Cross join |
7 |
Subqueries and nested queries |
Practical Queries on Subqueries and nested sub queries |
8 |
Functions and Stored Procedures |
MySQL built-in functions, User-defined functions, Triggers, Stored procedures |
9 |
Indexes and Performance Optimization |
Types of indexes (B-tree, hash, full-text), Creating and managing indexes, Analyzing query
performance |
10 |
Practical Project-I |
Creating a simple database application |
11 |
Practical Project-II |
Developing a complex database system with multiple tables and relationships |