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

سرفصل های دوره

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

1. Introduction

1. Introduction video

2. What is SQL

3. Additional Ways to Practice SQL.html

2. SELECT - gathering data

1. SELECT FROM table;

2. Quiz.html

3. Coding exercise preview

4. courses table.html

5. instructors table.html

6. Coding Exercise Solution

7. PRAGMA table info()

8. Quiz.html

9. PRAGMA table info().html

10. Coding Exercise Solution

3. SELECT - only certain rows or columns

1. LIMIT

2. Quiz.html

3. enrollments table.html

4. Coding exercise solution

5. SELECT columns FROM table;

6. SELECT columns.html

7. Coding Exercise Solution

4. ORDER BY

1. ORDER BY

2. ORDER BY.html

3. Coding exercise solution

4. ORDER BY DESC

5. Quiz.html

6. ORDER BY DESC.html

7. Coding Exercise Solution

8. ORDER BY column1, column2

9. ORDER BY multiple columns.html

10. Coding Exercise Solution

5. DISTINCT

1. SELECT DISTINCT

2. SELECT DISTINCT.html

3. Coding Exercise Solution

4. SELECT DISTINCT, multiple columns

5. SELECT DISTINCT, multiple columns.html

6. Coding Exercise Solution

6. ALIAS - creating and renaming columns

1. AS (aliasing)

2. Quiz.html

3. SELECT columns with alias.html

4. Coding Exercise Solution

5. ALIAS with math operations - creating a new column

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

7. Coding Exercise Solution

7. UNION and UNION ALL

1. UNION and UNION ALL - 3 min

2. Quiz.html

3. UNION.html

4. Coding Exercise Solution

8. WHERE

1. WHERE

2. Quiz.html

3. WHERE =.html

4. Coding Exercise Solution

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

6. WHERE .html

7. Coding Exercise Solution

8. Logical operators (AND, OR, NOT)

9. WHERE !=.html

10. Quiz.html

11. CASE 1.html

12. Coding Exercise Solution

13. Extract day.html

9. BETWEEN and IN

1. Using BETWEEN for range filtering

2. Extract month.html

3. WHERE BETWEEN.html

4. Modify dates.html

5. Coding Exercise Solution

6. IN (list matching)

7. WHERE IN.html

8. Coding Exercise Solution

10. NULL values

1. IS NULL IS NOT NULL

2. WHERE IS NULL.html

3. Coding Exercise Solution

4. WHERE IS NOT NULL.html

5. Coding Exercise Solution

11. Text

1. Using LIKE for pattern matching

2. Quiz.html

3. WHERE LIKE.html

4. Coding Exercise Solution

12. Aggregation

1. Aggregate functions

2. SUM.html

3. Coding Exercise Solution

4. AVG.html

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

6. Coding Exercise Solution

7. MIN.html

8. Coding Exercise Solution

9. COUNT.html

10. Coding Exercise Solution

11. Quiz.html

12. COUNT WHERE.html

13. Coding Exercise Solution

13. Aggregation with GROUP BY

1. Aggregation with GROUP BY

2. COUNT, GROUP BY.html

3. Coding Exercise Solution

4. SUM(), GROUP BY.html

5. Quiz.html

6. Coding Exercise Solution

7. MAX(), GROUP BY.html

8. Coding Exercise Solution

14. HAVING

1. HAVING

2. Quiz.html

3. HAVING.html

4. Coding Exercise Solution

5. Quiz.html

6. HAVING 2.html

7. Coding Exercise Solution

15. INNER JOIN

1. CUME DIST().html

2. INNER JOIN

3. FIRST VALUE().html

4. Quiz.html

5. INNER JOIN 1.html

6. Coding Exercise Solution

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

8. INNER JOIN 2.html

9. Coding Exercise Solution

10. JOIN with Filtering.html

11. Exercise 2.html

12. Coding Exercise Solution

16. LEFT JOIN

1. LEFT JOIN

2. Quiz.html

3. LEFT JOIN.html

4. RANK.html

5. Coding Exercise Solution

6. Full outer join

7. LEAD.html

17. Window functions

1. Window Functions

2. FIRST VALUE.html

3. Quiz.html

4. AVG() window function.html

5. Coding Exercise Solution

6. SUM() window function.html

7. Step 1.html

8. Coding Exercise Solution

18. Window Functions with ORDER BY

1. Step 2.html

2. Window functions with ORDER BY - RANK()

3. RANK().html

4. Step 3.html

5. Coding Exercise Solution

19. LAG and LEAD

1. LAG and LEAD

2. Self join step 1.html

3. LAG.html

4. Step 1.html

5. Coding Exercise Solution

20. Window Functions with Partitions

1. PARTITION BY

2. Step 2.html

3. Quiz.html

4. Step 3.html

5. AVG with partition by.html

6. Coding Exercise Solution

“Story Intelligence: Master the 7 Powers of Story” به سبد خرید شما اضافه شد. مشاهده سبد خرید

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy