SQL for Data Science full Tutorial

Welcome to SQL for Data Science! You’re joining thousands of learners currently enrolled in the course. I'm excited to have you in the class and look forward to your contributions to the learning community.
To begin, I recommend taking a few minutes to explore the course site. Review the material we’ll cover each week, and preview the assignments you’ll need to complete to pass the course.

(1) Selecting and Retrieving Data with SQL
(00:00) Module Introduction
(01:00) What is SQL Anyway?
(8:26) Data Models, Part 1: Thinking About Your Data
(14:03) Data Models, Part 2: The Evolution of Data Models
(17:50) Data Models, Part 3: Relational vs. Transactional Models
(23:34)Retrieving Data with a SELECT Statement
(28:30) Creating Tables
(36:12) Creating Temporary Tables
(40:30) Adding Comments to SQL
( 2)Filtering, Sorting, and Calculating Data with SQL
(45:42) Basics of Filtering with SQL
(54:24) Advanced Filtering: IN, OR, and NOT
(1:01:50) Using Wildcards in SQL
(1:08:38) Sorting with ORDER BY
(1:13:15) Math Operations
(1:17;32) Aggregate Functions
(1:14:19) Grouping Data with SQL
(1:19:52) Putting it All Together
(3) Subqueries and Joins in SQL
(1:22:15) Using Subqueries
(1:29:19) Subquery Best Practices and Considerations
(1:34:54) Joining Tables: An Introduction