Skip to content
Home Tutorials Roadmaps Courses
Log in Join free

MySQL Complete

Master relational databases from the ground up - tables, queries, joins, indexes and real-world SQL.

SU Taught by Sukhwinder Singh 0 enrolled Beginner

What you will learn

Learn MySQL from scratch - the world's most popular open-source relational database.

Covers database fundamentals, table design, CRUD operations, advanced queries, joins, subqueries, functions, indexes, views, and stored procedures. Build real database projects.

Who this is for:
- Beginners wanting to learn database design and SQL
- Web developers needing backend database skills
- Anyone pursuing data analytics or backend development careers

Course Syllabus

0 lessons · 10 modules
1. Database Fundamentals 4 lessons
  1. Lesson content for "What is a database and why MySQL".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Relational database concepts".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Installing MySQL and MySQL Workbench".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Creating your first database".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
2. Tables & Data Types 5 lessons
  1. Lesson content for "CREATE TABLE syntax and data types".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "VARCHAR, INT, DATE and ENUM types".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "PRIMARY KEY, FOREIGN KEY and constraints".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "ALTER TABLE and schema modifications".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "Normalizing data - 1NF, 2NF, 3NF".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
3. CRUD Operations 5 lessons
  1. Lesson content for "INSERT - adding records to tables".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "SELECT - retrieving your data".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "UPDATE - modifying existing records".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "DELETE - removing records safely".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "Batch operations and transactions".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
4. SELECT Queries Deep Dive 5 lessons
  1. Lesson content for "SELECT columns and AS aliases".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "DISTINCT, LIMIT and OFFSET".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "WHERE clause and comparison operators".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "ORDER BY and sorting results".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "LIKE, IN, BETWEEN and NULL checks".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
5. JOINs & Relationships 5 lessons
  1. Lesson content for "INNER JOIN - matching records".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "LEFT JOIN and RIGHT JOIN".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "FULL JOIN and CROSS JOIN".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Self-joins and multi-table queries".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "Designing relationships - one-to-many, many-to-many".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
6. Subqueries & Advanced Queries 5 lessons
  1. Lesson content for "Subqueries in WHERE clause".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Subqueries in FROM and SELECT".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Correlated subqueries".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "UNION and UNION ALL".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "CASE WHEN for conditional logic".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
7. Aggregate Functions & GROUP BY 5 lessons
  1. Lesson content for "COUNT, SUM, AVG, MIN, MAX".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "GROUP BY for categorized summaries".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "HAVING clause for filtered groups".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Date functions and time-based analysis".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "Window functions - ROW_NUMBER, RANK".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
8. Indexes & Performance 4 lessons
  1. Lesson content for "What are indexes and how they work".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "CREATE INDEX and composite indexes".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "EXPLAIN query plan analysis".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Query optimization techniques".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
9. Views & Stored Procedures 4 lessons
  1. Lesson content for "CREATE VIEW and materialized views".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Stored procedures - syntax and parameters".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Functions vs procedures".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Triggers for automatic actions".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
10. Real-World Projects 4 lessons
  1. Lesson content for "E-commerce database design project".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Student management system".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Data migration and backup strategies".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Connecting MySQL to a web application".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon

Student reviews

No reviews yet - be the first after you complete the course!

Related courses