Udemy Master SQL For Data Science 2020 | D29CDF6FEB17934F704948B6631CE971394E9B30

Udemy Master SQL For Data Science 2020

Name	[Udemy] Master SQL For Data Science (2020)	DOWNLOAD Copy Link
Total Size	1.4 GB
Total Files	124
Last Seen	2024-11-06 02:37
Hash	D29CDF6FEB17934F704948B6631CE971394E9B30

/
lesson37.mp4	117.4 MB
lesson1.vtt	6.5 KB
lesson2.mp4	16.2 MB
lesson2.vtt	11.8 KB
lesson3.mp4	13.2 MB
lesson3.vtt	9.5 KB
lesson4.mp4	75.1 MB
lesson4.vtt	10.4 KB
lesson5.mp4	45.3 MB
lesson5.vtt	26.2 KB
lesson6.mp4	41.9 MB
lesson6.vtt	17.5 KB
lesson7.mp4	34.4 MB
lesson7.vtt	21.7 KB
lesson8.mp4	42.4 MB
lesson8.vtt	29.1 KB
lesson9.mp4	31.6 MB
lesson9.vtt	19.0 KB
lesson10.mp4	20.2 MB
lesson10.vtt	13.9 KB
lesson11.mp4	22.3 MB
lesson11.vtt	14.2 KB
lesson12.mp4	26.2 MB
lesson12.vtt	20.1 KB
lesson13.mp4	25.0 MB
lesson13.vtt	20.7 KB
lesson14.mp4	16.3 MB
lesson14.vtt	12.9 KB
lesson15.mp4	9.3 MB
lesson15.vtt	7.6 KB
lesson16.mp4	27.1 MB
lesson16.vtt	21.4 KB
lesson17.mp4	27.2 MB
lesson17.vtt	21.5 KB
lesson18.mp4	9.8 MB
lesson18.vtt	8.1 KB
lesson19.mp4	25.0 MB
lesson19.vtt	17.2 KB
lesson20.mp4	31.2 MB
lesson20.vtt	22.6 KB
lesson21.mp4	34.6 MB
lesson21.vtt	23.6 KB
lesson22.mp4	23.6 MB
lesson22.vtt	18.8 KB
lesson23.mp4	34.7 MB
lesson23.vtt	24.8 KB
lesson24.mp4	31.7 MB
lesson24.vtt	21.3 KB
lesson25.mp4	33.6 MB
lesson25.vtt	25.5 KB
lesson26.mp4	27.4 MB
lesson26.vtt	19.3 KB
lesson27.mp4	26.9 MB
lesson27.vtt	19.9 KB
lesson28.mp4	42.6 MB
lesson28.vtt	31.7 KB
lesson29.mp4	22.0 MB
lesson29.vtt	18.9 KB
lesson30.mp4	12.1 MB
lesson30.vtt	8.3 KB
lesson31.mp4	28.7 MB
lesson31.vtt	20.8 KB
lesson32.mp4	84.3 MB
lesson32.vtt	12.0 KB
lesson33.mp4	31.3 MB
lesson33.vtt	24.2 KB
lesson34.mp4	36.5 MB
lesson34.vtt	25.9 KB
lesson35.mp4	116.7 MB
lesson35.vtt	15.5 KB
lesson36.mp4	66.2 MB
lesson36.vtt	9.9 KB
lesson1.mp4	55.4 MB
lesson37.vtt	14.7 KB
Master SQL For Data Science.txt	1.5 KB
SQL for Data Science Learn SQL through Interactive Exercises Udemy.URL	0.2 KB
/1. Chapter 1/
1. Course Overview.vtt	6.5 KB
/2. Database Basics/
1. What is a Database.vtt	11.8 KB
2. Install Postgres Database on Mac.vtt	9.5 KB
3. Troubleshoot Connection.html	1.2 KB
4. Install Postgres on Windows.vtt	10.4 KB
5. Create Table and Insert Statements.vtt	26.2 KB
6. Prepare the Database.vtt	17.5 KB
6.1 mock_data.sql.sql	122.4 KB
7. Create More Tables and Populate Data.html	0.1 KB
/3. SQL Query Basics/
1. Introducing the SELECT Statement.vtt	21.7 KB
2. Filter Data Using the WHERE Clause + AND & OR.vtt	29.1 KB
3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.vtt	19.0 KB
4. [EXERCISES] WHERE Clause and Operators.vtt	13.9 KB
5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.vtt	14.2 KB
6. Practice Writing Basic Queries (5 Problems).html	0.1 KB
/4. Using Functions/
1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.vtt	20.1 KB
2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().vtt	20.7 KB
3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().vtt	12.9 KB
4. Practice with Functions, Conditional Expressions and Concatenation.html	0.1 KB
/5. Grouping Data and Computing Aggregates/
1. Understanding Grouping.vtt	7.6 KB
2. GROUP BY & HAVING Clauses.vtt	21.4 KB
3. [EXERCISES] Using GROUP BY and HAVING Clauses.vtt	21.5 KB
4. Practice Aggregation Queries.html	0.1 KB
/6. Using Subqueries/
1. Aliasing Sources of Data.vtt	8.1 KB
2. Introducing Subqueries.vtt	17.2 KB
3. Subqueries Continued + [EXERCISES].vtt	22.6 KB
4. Subqueries with ANY and ALL Operators + [EXERCISES].vtt	23.6 KB
5. [EXERCISES] More Practice with Subqueries.vtt	18.8 KB
6. Practice with Subqueries.html	0.1 KB
/7. Using the CASE Clause in Interesting Ways/
1. Conditional Expressions Using CASE Clause + [EXERCISES].vtt	24.8 KB
2. Transposing Data using the CASE Clause + [EXERCISES].vtt	21.3 KB
3. Practice Using Case and Transposing Data.html	0.1 KB
/8. Advanced Query Techniques using Correlated Subqueries/
1. Understanding Correlated Subqueries.vtt	25.5 KB
2. [EXERCISES] Correlated Subqueries Continued.vtt	19.3 KB
/9. Working with Multiple Tables/
1. Introducing Table Joins.vtt	19.9 KB
2. INNER and OUTER Joins + [EXERCISES].vtt	31.7 KB
3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].vtt	18.9 KB
4. Cartesian Product with the CROSS JOIN.vtt	8.3 KB
5. [EXERCISES] Joins and Subqueries Continued.vtt	20.8 KB
6. Creating Views vs. Inline Views.vtt	12.0 KB
7. ADVANCED Problems using Joins, Grouping and Subqueries.html	0.1 KB
/10. Window Functions for Analytics/
1. Window Functions using the OVER() Clause.vtt	24.2 KB
2. Ordering Data in Window Frames.vtt	25.9 KB
3. RANK, FIRST_VALUE and NTILE Functions.vtt	15.5 KB
4. LEAD and LAG Functions.vtt	9.9 KB
5. Working with Rollups and Cubes.vtt	14.7 KB
5.1 sales_tbl.txt.txt	0.7 KB
/11. Difficult Query Challenges/
1. Challenging Puzzles For the Brave.html	0.1 KB
Total files 124