Module 2

SQL for Data Science

SQL for data science — querying, aggregating, and cleaning data with the language every data platform speaks.

20 lessonsAI & MLHarinIT Academy
Module 2 · Lesson 2.1

SQL Basics

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.2

SELECT Statement

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.3

Filtering Data

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.4

Sorting

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.5

Aggregate Functions

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.6

GROUP BY

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.7

HAVING

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.8

Joins

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.9

Subqueries

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.10

Common Table Expressions (CTEs)

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.11

Window Functions

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.12

Views

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.13

Indexes

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.14

Stored Procedures

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.15

Functions

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.16

Transactions

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.17

Query Optimization

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.18

Data Cleaning

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.19

Advanced SQL Problems

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.
Module 2 · Lesson 2.20

SQL Project

Lesson focus: This lesson is part of Module 2 — SQL for Data Science. Detailed lesson content can be added here from the corresponding source material.