SQL, Python & Analytics Engineering Practice

SQL: Basic Select

SQL: Basic Filtering Rows

Free Dataset Analysis

Short, checked SQL exercises using the same grains and definitions as the free dataset library.

SQL: Sorting and Limiting

SQL: Aggregate Functions and GROUP BY

SQL: String Filtering and Pattern Matching

SQL: Filtering Aggregations With HAVING

SQL: Basic Joins (INNER JOIN)

SQL: LEFT JOIN

SQL: Multi-Table Joins And Complex Join Conditions

SQL: Subqueries In SELECT And FROM

SQL: Subqueries In WHERE

SQL: Conditional Expressions (CASE)

SQL: Set Operations

SQL: Date and Time Functions

SQL: String Functions

SQL: Numeric and Other Scalar Functions

SQL: Window Functions

SQL: Common Table Expressions (CTEs)

SQL: Advanced Filtering and Pattern Matching

SQL Alien Invasion Challenge: Defend Earth

Zombie Virus – Part 1: Stopping the Release

Zombie Virus – Part 2: Aftermath Of The Virus Release

Zombie Virus – Part 3: The Cure

SQL Mystery Challenge: The Case of the Vanishing Artifacts

SQL Exercise: The Volcano Eruption Emergency

SQL Survival Challenge: Last City on Earth

Python: Data Types & Variables

Python: Data Structures (Lists, Tuples, Dictionaries, Sets)

Python: Control Flow (If, Else, Loops)

Python: Comprehensions (List, Dict, Set)

Python: Error Handling And Exceptions

Python: Modules And Packages

Python – File Handling (Reading/Writing CSV, JSON)

Python: Regular Expressions

Python: Dates And Times

Python: Object Oriented Programming

Python: Pandas DataFrames

Python: Data Cleaning And Preprocessing

Python: Exploratory Data Analysis

Python: Merging And Joining Datasets

Python: Aggregations And Group Operations

Python: Writing Efficient Code (Time Complexity, Vectorization)

Python: SQL Integration With Python

SQL Quiz (200 Questions)

Python Quiz (200 Questions)

dbt Quiz (100 Questions)

Data Modeling Quiz (100 Questions)

ETL / ELT Quiz (200 Questions)