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
En esta página del sitio puede ver el video en línea SQL for Data Science full Tutorial de Duración hora minuto segunda en buena calidad , que subió el usuario freeCodeAcademy 01 enero 1970, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 577 veces y le gustó 11 a los espectadores. Disfruta viendo!
