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