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
On this page of the site you can watch the video online SQL for Data Science full Tutorial with a duration of hours minute second in good quality, which was uploaded by the user freeCodeAcademy 01 January 1970, share the link with friends and acquaintances, this video has already been watched 577 times on youtube and it was liked by 11 viewers. Enjoy your viewing!
