Module 1: MySQL
Module 1: MySQL Exam Structure Overview Part Topics Count New Topics Study Time Attempts Format Notes Part 1 19 ...
Rahul Chandna
MySQL 8+ Training Course Index
title: “MySQL 8+ Training Course — Complete Index” — MySQL 8+ Training Course Index Welcome to your complete MySQL training journey. This index lists every topic in the course. Check off each one...
Recursive CTEs — Traversing Hierarchies
title: “Hierarchies and Recursive CTEs” part: 3 topic_number: 1 slug: “hierarchies-recursive-cte” difficulty: “Advanced” prerequisites: “self-joins, correlated-subqueries” — Recursive CTEs — Trave...
Correlated Subqueries — Row-by-Row Subqueries
title: “Correlated Subqueries” part: 2 topic_number: 7 slug: “correlated-subqueries” difficulty: “Intermediate” prerequisites: “nested-subqueries” — Correlated Subqueries — Row-by-Row Subqueries ...
Nested Subqueries — Queries Within Queries
title: “Nested Subqueries” part: 2 topic_number: 6 slug: “nested-subqueries” difficulty: “Intermediate” prerequisites: “select-from-where, aggregate-functions” — Nested Subqueries — Queries Within...
RANK() and DENSE_RANK() — Handling Ties in Rankings
title: “RANK() and DENSE_RANK()” part: 3 topic_number: 5 slug: “rank” difficulty: “Advanced” prerequisites: “row-number” — RANK() and DENSE_RANK() — Handling Ties in Rankings What Is It? RANK() ...
COALESCE — First Non-NULL Value
title: “COALESCE (Advanced NULL Handling)” part: 2 topic_number: 5 slug: “coalesce” difficulty: “Intermediate” prerequisites: “null-handling” — COALESCE — First Non-NULL Value What Is It? COALES...
RIGHT JOIN
title: “RIGHT JOIN” part: 1 topic_number: 17 slug: “right-join” difficulty: “Beginner” prerequisites: “left-join” — RIGHT JOIN What Is It? RIGHT JOIN returns ALL rows from the right table, and m...
Week 1: Linux Fundamentals
Week 1: Linux Fundamentals Duration: 5 days (40 hours) Goal: Master essential file operations and text handling Day 1-2: File System Basics The Linux Directory Structure Before navigating, kn...
Weeks 3–4: IDE Workflows and Professional Collaboration
Weeks 3–4: IDE Workflows and Professional Collaboration Duration: 80 hours (2 weeks × 5 days × 8 hours) Level: Intermediate (Practical Focus) Prerequisites: Weeks 1–2 completion Mode: Full-time im...