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

Focused View

Brian Greco

1:57:42

13 View

1. Introduction

1. Introduction video.mp4

01:27

2. What is SQL.mp4

05:13

3. Additional Ways to Practice SQL.html

2. SELECT - gathering data

1. SELECT FROM table;.mp4

02:54

2. Quiz.html

3. Coding exercise preview.mp4

03:32

4. courses table.html

5. instructors table.html

6. Coding Exercise Solution.mp4

01:20

7. PRAGMA table info().mp4

01:22

8. Quiz.html

9. PRAGMA table info().html

10. Coding Exercise Solution.mp4

02:09

3. SELECT - only certain rows or columns

1. LIMIT.mp4

01:23

2. Quiz.html

3. enrollments table.html

4. Coding exercise solution.mp4

01:57

5. SELECT columns FROM table;.mp4

01:02

6. SELECT columns.html

7. Coding Exercise Solution.mp4

01:24

4. ORDER BY

1. ORDER BY.mp4

00:59

2. ORDER BY.html

3. Coding exercise solution.mp4

02:24

4. ORDER BY DESC.mp4

00:55

5. Quiz.html

6. ORDER BY DESC.html

7. Coding Exercise Solution.mp4

01:13

8. ORDER BY column1, column2.mp4

00:38

9. ORDER BY multiple columns.html

10. Coding Exercise Solution.mp4

01:28

5. DISTINCT

1. SELECT DISTINCT.mp4

00:49

2. SELECT DISTINCT.html

3. Coding Exercise Solution.mp4

01:03

4. SELECT DISTINCT, multiple columns.mp4

01:23

5. SELECT DISTINCT, multiple columns.html

6. Coding Exercise Solution.mp4

01:14

6. ALIAS - creating and renaming columns

1. AS (aliasing).mp4

01:35

2. Quiz.html

3. SELECT columns with alias.html

4. Coding Exercise Solution.mp4

01:04

5. ALIAS with math operations - creating a new column.mp4

00:33

6. ALIAS with math operations - creating a new column.html

7. Coding Exercise Solution.mp4

00:53

7. UNION and UNION ALL

1. UNION and UNION ALL - 3 min.mp4

02:14

2. Quiz.html

3. UNION.html

4. Coding Exercise Solution.mp4

01:41

8. WHERE

1. WHERE.mp4

00:42

2. Quiz.html

3. WHERE =.html

4. Coding Exercise Solution.mp4

00:54

5. Comparison operators (, , =, =, etc).mp4

01:03

6. WHERE .html

7. Coding Exercise Solution.mp4

01:11

8. Logical operators (AND, OR, NOT).mp4

01:32

9. WHERE !=.html

10. Quiz.html

11. CASE 1.html

12. Coding Exercise Solution.mp4

01:21

13. Extract day.html

9. BETWEEN and IN

1. Using BETWEEN for range filtering.mp4

00:58

2. Extract month.html

3. WHERE BETWEEN.html

4. Modify dates.html

5. Coding Exercise Solution.mp4

01:46

6. IN (list matching).mp4

01:31

7. WHERE IN.html

8. Coding Exercise Solution.mp4

01:13

10. NULL values

1. IS NULL IS NOT NULL.mp4

01:24

2. WHERE IS NULL.html

3. Coding Exercise Solution.mp4

01:24

4. WHERE IS NOT NULL.html

5. Coding Exercise Solution.mp4

00:57

11. Text

1. Using LIKE for pattern matching.mp4

02:13

2. Quiz.html

3. WHERE LIKE.html

4. Coding Exercise Solution.mp4

02:01

12. Aggregation

1. Aggregate functions.mp4

02:12

2. SUM.html

3. Coding Exercise Solution.mp4

01:58

4. AVG.html

5. COUNT() vs COUNT(column name) considerations.html

6. Coding Exercise Solution.mp4

00:57

7. MIN.html

8. Coding Exercise Solution.mp4

00:43

9. COUNT.html

10. Coding Exercise Solution.mp4

00:54

11. Quiz.html

12. COUNT WHERE.html

13. Coding Exercise Solution.mp4

01:09

13. Aggregation with GROUP BY

1. Aggregation with GROUP BY.mp4

01:43

2. COUNT, GROUP BY.html

3. Coding Exercise Solution.mp4

01:37

4. SUM(), GROUP BY.html

5. Quiz.html

6. Coding Exercise Solution.mp4

01:14

7. MAX(), GROUP BY.html

8. Coding Exercise Solution.mp4

00:54

14. HAVING

1. HAVING.mp4

01:36

2. Quiz.html

3. HAVING.html

4. Coding Exercise Solution.mp4

01:25

5. Quiz.html

6. HAVING 2.html

7. Coding Exercise Solution.mp4

01:27

15. INNER JOIN

1. CUME DIST().html

2. INNER JOIN.mp4

04:44

3. FIRST VALUE().html

4. Quiz.html

5. INNER JOIN 1.html

6. Coding Exercise Solution.mp4

02:21

7. RANK vs DENSE RANK vs ROW NUMBER, cume dist and percent rank.html

8. INNER JOIN 2.html

9. Coding Exercise Solution.mp4

02:03

10. JOIN with Filtering.html

11. Exercise 2.html

12. Coding Exercise Solution.mp4

01:28

16. LEFT JOIN

1. LEFT JOIN.mp4

02:37

2. Quiz.html

3. LEFT JOIN.html

4. RANK.html

5. Coding Exercise Solution.mp4

02:19

6. Full outer join.mp4

01:18

7. LEAD.html

17. Window functions

1. Window Functions.mp4

02:48

2. FIRST VALUE.html

3. Quiz.html

4. AVG() window function.html

5. Coding Exercise Solution.mp4

02:00

6. SUM() window function.html

7. Step 1.html

8. Coding Exercise Solution.mp4

02:24

18. Window Functions with ORDER BY

1. Step 2.html

2. Window functions with ORDER BY - RANK().mp4

01:23

3. RANK().html

4. Step 3.html

5. Coding Exercise Solution.mp4

02:15

19. LAG and LEAD

1. LAG and LEAD.mp4

02:36

2. Self join step 1.html

3. LAG.html

4. Step 1.html

5. Coding Exercise Solution.mp4

02:09

20. Window Functions with Partitions

1. PARTITION BY.mp4

01:23

2. Step 2.html

3. Quiz.html

4. Step 3.html

5. AVG with partition by.html

6. Coding Exercise Solution.mp4

02:06

Description

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

Who is this 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!

What You Need to Know?

No SQL or programming experience is needed

More details

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!

User Reviews

Rating

average 0

Total votes0

Focused display

I am a statistician, data scientist, and teacher. I've worked as a data scientist at Google, where I analyzed data from over 1 billion users, and I've created new methods for analyzing genetic sequencing data. But most importantly, I love helping others learn statistics and have been teaching at top universities and online for over ten years. My goal is to help you obtain a deep understanding of statistics and to make it as easy as possible!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.