MySQL Syllabus
Course curriculum.
MySQL Course Syllabus
From basics to advanced database management.
- Intro: What is a database? RDBMS Concepts.
- Basics: SELECT, WHERE, AND/OR/NOT, ORDER BY.
- CRUD: INSERT, NULL Values, UPDATE, DELETE.
- Advanced Selection: LIMIT, MIN/MAX, COUNT/AVG/SUM, LIKE, Wildcards.
- Joins: INNER, LEFT, RIGHT, FULL, Self Join, UNION.
- Database Design: CREATE DB/Table, DROP, ALTER, Constraints (Not Null, Unique, Primary Key, Foreign Key).
- Advanced: Views, Dates, Functions, Data Types.