FreeCourseSite com Udemy Master SQL For Data Science | C1883E3B86A167B019833904D7832AAA4FC2E889

FreeCourseSite com Udemy Master SQL For Data Science

Name	[FreeCourseSite.com] Udemy - Master SQL For Data Science	DOWNLOAD Copy Link
Total Size	1.4 GB
Total Files	90
Hash	C1883E3B86A167B019833904D7832AAA4FC2E889

/0. Websites you may like/
[CourseClub.ME].url	0.1 KB
[FCS Forum].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
/1. Chapter 1/
1. Course Overview.mp4	55.4 MB
1. Course Overview.vtt	6.5 KB
/10. Window Functions for Analytics/
1. Window Functions using the OVER() Clause.mp4	31.3 MB
1. Window Functions using the OVER() Clause.vtt	24.2 KB
2. Ordering Data in Window Frames.mp4	36.5 MB
2. Ordering Data in Window Frames.vtt	25.9 KB
3. RANK, FIRST_VALUE and NTILE Functions.mp4	116.6 MB
3. RANK, FIRST_VALUE and NTILE Functions.vtt	15.5 KB
4. LEAD and LAG Functions.mp4	66.2 MB
4. LEAD and LAG Functions.vtt	9.9 KB
5. Working with Rollups and Cubes.mp4	117.4 MB
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
2. Get Access to All of my current and future courses!.html	1.0 KB
/2. Database Basics/
1. What is a Database.mp4	16.2 MB
1. What is a Database.vtt	11.8 KB
2. Install Postgres Database on Mac.mp4	13.2 MB
2. Install Postgres Database on Mac.vtt	9.5 KB
3. Troubleshoot Connection.html	1.2 KB
4. Install Postgres on Windows.mp4	75.1 MB
4. Install Postgres on Windows.vtt	10.4 KB
5. Create Table and Insert Statements.mp4	45.4 MB
5. Create Table and Insert Statements.vtt	26.2 KB
6. Data file that will be used in the course (IMPORTANT).html	0.4 KB
7. Prepare the Database.mp4	41.9 MB
7. Prepare the Database.vtt	17.5 KB
7.1 mock_data.sql.sql	122.4 KB
8. Create More Tables and Populate Data.html	0.1 KB
/3. SQL Query Basics/
1. Introducing the SELECT Statement.mp4	34.4 MB
1. Introducing the SELECT Statement.vtt	21.7 KB
2. Filter Data Using the WHERE Clause + AND & OR.mp4	42.4 MB
2. Filter Data Using the WHERE Clause + AND & OR.vtt	29.1 KB
3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.mp4	31.6 MB
3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.vtt	19.0 KB
4. [EXERCISES] WHERE Clause and Operators.mp4	20.2 MB
4. [EXERCISES] WHERE Clause and Operators.vtt	13.9 KB
5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.mp4	22.3 MB
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.mp4	26.2 MB
1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.vtt	20.1 KB
2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().mp4	25.0 MB
2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().vtt	20.7 KB
3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().mp4	16.3 MB
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.mp4	9.3 MB
1. Understanding Grouping.vtt	7.6 KB
2. GROUP BY & HAVING Clauses.mp4	27.1 MB
2. GROUP BY & HAVING Clauses.vtt	21.4 KB
3. [EXERCISES] Using GROUP BY and HAVING Clauses.mp4	27.2 MB
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.mp4	9.9 MB
1. Aliasing Sources of Data.vtt	8.1 KB
2. Introducing Subqueries.mp4	25.0 MB
2. Introducing Subqueries.vtt	17.2 KB
3. Subqueries Continued + [EXERCISES].mp4	31.2 MB
3. Subqueries Continued + [EXERCISES].vtt	22.6 KB
4. Subqueries with ANY and ALL Operators + [EXERCISES].mp4	34.6 MB
4. Subqueries with ANY and ALL Operators + [EXERCISES].vtt	23.6 KB
5. [EXERCISES] More Practice with Subqueries.mp4	23.6 MB
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].mp4	34.7 MB
1. Conditional Expressions Using CASE Clause + [EXERCISES].vtt	24.8 KB
2. Transposing Data using the CASE Clause + [EXERCISES].mp4	31.7 MB
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.mp4	33.6 MB
1. Understanding Correlated Subqueries.vtt	25.5 KB
2. [EXERCISES] Correlated Subqueries Continued.mp4	27.4 MB
2. [EXERCISES] Correlated Subqueries Continued.vtt	19.3 KB
/9. Working with Multiple Tables/
1. Introducing Table Joins.mp4	26.9 MB
1. Introducing Table Joins.vtt	19.9 KB
2. INNER and OUTER Joins + [EXERCISES].mp4	42.7 MB
2. INNER and OUTER Joins + [EXERCISES].vtt	31.7 KB
3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].mp4	22.0 MB
3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].vtt	18.9 KB
4. Cartesian Product with the CROSS JOIN.mp4	12.1 MB
4. Cartesian Product with the CROSS JOIN.vtt	8.3 KB
5. [EXERCISES] Joins and Subqueries Continued.mp4	28.7 MB
5. [EXERCISES] Joins and Subqueries Continued.vtt	20.8 KB
6. Creating Views vs. Inline Views.mp4	84.3 MB
6. Creating Views vs. Inline Views.vtt	12.0 KB
7. ADVANCED Problems using Joins, Grouping and Subqueries.html	0.1 KB
Total files 90