Labs 2-4: Advanced SQL Queries - Overview

🎯 About These Labs

The original Lab 2 has been restructured into three separate labs (Labs 2, 3, and 4) to make learning easier and more manageable. Each lab covers a specific aspect of advanced SQL queries and can be completed independently.

📚 Lab Structure

Lab 2: JOINs and Multi-Table Queries

Topics Covered:

Multi-table database schemas
INNER, LEFT, and RIGHT JOINs
String functions with JOINs
Complex multi-table queries
Handling NULL values in JOINs

Database: University database (Student, Course, Enrolled)

Examples: Employee-Department relationships, Product catalogs

Start Lab 2 →

Lab 3: Aggregate Functions and GROUP BY

Topics Covered:

Aggregate functions (COUNT, SUM, AVG, MAX, MIN)
GROUP BY clause
HAVING clause for filtering grouped results
COUNT() vs COUNT(DISTINCT)
Nested aggregates and complex queries

Database: Company-Product-Purchase database

Examples: Sales analysis, Inventory management, Performance statistics

Start Lab 3 →

Lab 4: Set Operations and Advanced Queries

Topics Covered:

UNION and UNION ALL operations
Multiset operations
UPDATE and DELETE with multiple rows
SQL Division pattern
Complex nested queries and subqueries

Databases: Multiple examples including Product/Company and Student/Enrolled

Examples: Data merging, Common elements across tables, Complex filtering

Start Lab 4 →

💡 Learning Path

We recommend completing the labs in order (Lab 2 → Lab 3 → Lab 4) as each builds on concepts from the previous labs. However, Lab 3 and Lab 4 include their own database setup sections, so they can be completed independently if needed.

📋 Prerequisites

Completion of Lab 1 or equivalent knowledge
Understanding of basic SQL operations
Familiarity with primary and foreign keys

🏠 Portal | 🚀 Getting Started | 📝 SQL Cheat Sheet