MySQL – Roadmap

📅 Study Plan Calculator





👉 Course Duration: -- days (~ -- weeks)

✅ Expected Completion Date: --

⏱ Total Course Duration: 0 Hours

🔒 Login to track hours & progress

Interview Focus

  • No interview topics

Level 1
SQL Introduction & Installation

-

▶ Play Course
⏱ 1.2 Hours

Assignments

Interview Focus

  • No interview topics

Level 2
SQL Commands

This section covers all core SQL command types, including DDL for creating database structures, DML for inserting and modifying data, DQL for querying data, TCL for managing transactions, and DCL for controlling user access and security.

▶ Play Course
⏱ 2.0 Hours

Assignments

Interview Focus

  • No interview topics

Level 3
Keys And Constraints

This section explains different types of keys and constraints in SQL, including Primary, Unique, Composite, Candidate, and Foreign Keys, and how constraints help maintain data integrity, relationships, and consistency in a database.

▶ Play Course
⏱ 2.0 Hours

Assignments

Interview Focus

  • No interview topics

Level 4
SQL Joins

This section covers SQL Joins, explaining how to combine data from multiple tables using INNER, LEFT, RIGHT, and FULL OUTER joins to retrieve meaningful and related information.

▶ Play Course
⏱ 1.0 Hours

Assignments

Interview Focus

  • No interview topics

Level 5
SQL Sub Queries

-

▶ Play Course
⏱ 0.45 Hours

Assignments

Interview Focus

  • No interview topics

Level 6
SQL Common Table Expression (CTE)

.

▶ Play Course
⏱ 0.1 Hours

Assignments

  • No assignments

Interview Focus

  • No interview topics

Level 7
Groupy By & Windows

ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(n), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE()

▶ Play Course
⏱ 1.4 Hours

Assignments

  • No assignments

Interview Focus

  • No interview topics

Level 8
SQL Views vs Stored Procedures vs Functions

.

▶ Play Course
⏱ 1.0 Hours

Assignments

  • No assignments