All Courses

SQL for Data Science Fundamentals

Chapter 1: Introduction to Databases and SQL

What is a Relational Database?

Tables, Columns, and Rows

Understanding Data Types

What is SQL (Structured Query Language)?

Setting Up Your Environment (Optional)

Quiz for Chapter 1

Chapter 2: Retrieving Data with SELECT

The Basic SELECT Statement

Selecting Specific Columns

Selecting All Columns

Using Aliases for Columns

Limiting Query Results

Hands-on Practical: Writing Basic SELECT Queries

Quiz for Chapter 2

Chapter 3: Filtering and Sorting Data

Introduction to Filtering with WHERE

Comparison Operators (=, <>, <, >, <=, >=)

Filtering with AND, OR, NOT

Filtering with IN and BETWEEN

Handling NULL Values

Pattern Matching with LIKE

Sorting Results with ORDER BY

Hands-on Practical: Filtering and Sorting Queries

Quiz for Chapter 3

Chapter 4: Aggregating Data

Introduction to Aggregate Functions

Counting Rows with COUNT

Calculating Sums with SUM

Calculating Averages with AVG

Finding Minimum and Maximum Values with MIN/MAX

Grouping Data with GROUP BY

Filtering Groups with HAVING

Hands-on Practical: Aggregation and Grouping

Quiz for Chapter 4

Chapter 5: Combining Data from Multiple Tables

Why Combine Data?

Understanding Primary and Foreign Keys

Introduction to SQL JOINs

Using INNER JOIN

Joining Multiple Tables

Using Aliases for Tables

Hands-on Practical: Writing INNER JOIN Queries

Quiz for Chapter 5