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

SQL for Data Science Fundamentals

Prerequisites: No prerequisites

Level: Beginner

What You'll Learn

Database Concepts
Understand basic relational database concepts like tables, columns, rows, and primary keys.
Data Retrieval
Write SQL queries using the SELECT statement to retrieve specific data from database tables.
Data Filtering and Sorting
Filter data using the WHERE clause and sort results using the ORDER BY clause.
Data Aggregation
Perform basic calculations on data using aggregate functions like COUNT, SUM, AVG, MIN, and MAX.
Combining Data
Combine data from multiple tables using the INNER JOIN clause.
Basic Data Manipulation (Optional)
Understand the concepts behind inserting, updating, and deleting data (though focus is on querying).

© 2025 ApX Machine Learning

;