Home Blog Learn

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)

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

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

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

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

Combining Data from Multiple Tables

Sections

5.1 Why Combine Data?
5.2 Understanding Primary and Foreign Keys
5.3 Introduction to SQL JOINs
5.4 Using INNER JOIN
5.5 Joining Multiple Tables
5.6 Using Aliases for Tables
5.7 Hands-on Practical: Writing INNER JOIN Queries

© 2025 ApX Machine Learning

;