SQL: A Step-by-step Introduction for Data Science

Published 10/2023
Duration: 2h | .MP4 1280×720, 30 fps(r) | AAC, 44100 Hz, 2ch | 732 MB
Genre: eLearning | Language: English

A former Google data scientist teaches you SQL – from the basics to advanced mastery of window functions

What you’ll learn
Master the basics SQL commands like SELECT and WHERE
Learn how to use aggregate functions to transform data and calculate new values
Understand how to use JOIN to combine information from multiple tables
Learn to use advanced window functions to calculate more complex quantities
Requirements
No SQL or programming experience is needed
Description
This course offers a deep dive into SQL’s capabilities, giving you the skills to query, manipulate, and combine data sets.
Using Udemy’s built-in coding exercises, we will go from zero knowledge to advanced mastery of SQL, seeing how SQL is used in real-life data science situations. We will work together as data scientists for a fictional educational technology company and learn how to use SQL to answer questions regarding our instructors, students, and courses.
Unlike other courses, we will start coding in SQL immediately, with no software installation required.
Course Features:
Short video lectures that introduce each topic
40 hands-on coding exercises complete with solutions, ensuring you get the practical experience to master SQL
Quizzes to assess and reinforce your understanding.
What You’ll Learn:
What is SQL, and why are there dialects like SQLite, PostgreSQL, MySQL and others?
Basic SELECT statements
ORDER BY
WHERE
Joining tables with INNER JOIN and LEFT JOIN
Aggregation functions like COUNT, SUM, and AVG to derive meaningful statistics.
Advanced window functions with OVER and PARTITION BY
and more!
Who Should Enroll:
Current or aspiring data scientists and data analysts
Anybody who wants to learn SQL with interactive exercises and full video solutions with detailed explanations.
Who this course is for:
Current and aspiring data scientists and data analysts
SQL Beginners who would like to go from no knowledge to a mastery of advanced SQL commands
People who want to write SQL code immediately using Udemy Coding Exercise feature – no software required!