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
In questa pagina del sito puoi guardare il video online SQL for Data Science full Tutorial della durata di ore minuti seconda in buona qualità , che l'utente ha caricato freeCodeAcademy 01 gennaio 1970, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 577 volte e gli è piaciuto 11 spettatori. Buona visione!
