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 ...
Rahul Chandna
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...
Weeks 1–2: Git Fundamentals and Branching
Weeks 1–2: Git Fundamentals and Branching Duration: 80 hours (2 weeks × 5 days × 8 hours) Level: Graduate/Entry-level Mode: Full-time immersive training Weeks 1–2 Overview Master Git fundamental...
10 - Trainer Guide
#10 - Trainer Guide ##Session Overview Duration: 3-4 hours (with breaks) Level: Beginner to Intermediate Mode: Hands-on, terminal-based ##Learning Objectives By the end of this session, graduat...
09 - Student Worksheet (Fill-in + Exercises)
#09 - Student Worksheet (Fill-in + Exercises) Name: ________ Date: ________ Batch: ________ ##Part A - Core Concepts Fill in the blanks. Git command used to check current state: ________ A...