Beginner 02 / 04 ~5 hrs 6 lessons

SQL Queries
& Joins

SQL is the language every database speaks. This module takes you from understanding what SQL is, through creating and managing databases, all the way to combining data across tables with JOINs — the foundation of every real-world database project.

// Lessons

Part 1 — Foundations

Introduction to SQL and Database Systems

What SQL is, types of SQL commands (DDL, DML, DQL), and how SQL interacts with a database.

→

Creating and Managing Databases

CREATE DATABASE, USE, SHOW DATABASES, DROP DATABASE — setting up and managing your database environment.

→

Creating Tables and Defining Structure

CREATE TABLE, data types (INT, VARCHAR, DATE), primary keys, and DESCRIBE — building well-structured tables.

→

Part 2 — Querying Data

Retrieving Data with SELECT

SELECT *, selecting specific columns, and the anatomy of a basic SQL query.

→

Filtering and Sorting Results

WHERE, comparison operators, AND, OR, ORDER BY — narrowing and organising your result sets.

→

Part 3 — Combining Tables

Introduction to SQL Joins

Table relationships, INNER JOIN, and an introduction to LEFT JOIN — querying across multiple tables.

→

SQL Queries& Joins

SQL Queries
& Joins