Master in MySQL Database from beginner to advance Level (Part-1)
Lecture Outline:
Beginner Level:
1. Introduction of database
2. Types of databases
3. What is DBMS? And What is RDBMS?
4. What is table?
5. What are Rows and Columns?
6. DDL (create, drop, alter, truncate table commands)
7. SQL queries (insert row, update row, delete row)
8. DQL(data query Language) (Where clause, group by, order by)
9. Aggregate functions (count, Max and min, avg, sum)
10. Operators( Like, between, In)
Intermediate Level:
1.Table constrains (not null, unique, foreign key, primary key, default, check)
2. Types of keys (primary key, foreign key, composite key, candidate key, super key, alternate key/secondary key, unique key)
3. Relational Database design (Entity Relationship Diagram)
4. Normalization (1st,2nd ,3rd ,bcnf 4th , 5th)
5. Joins( natural joins, inner join, outer join, left join, right join)
6. Important Terms (DDL,DML, DCL, DTL, TCL)
7. Sub queries
8. Database Import and export Methods
Advance Level:
1. Views
2. Indexes
...........................Lecture Part-2 also upload seperately................................
Hands-on Exercises:
Throughout the lecture, we will incorporate hands-on exercises to reinforce learning and provide practical experience. Participants will practice SQL queries, database design, and advanced techniques using MySQL.