17 OCT 2024 - Welcome Back to TorrentFunk!
Get your pirate hat back out. Streaming is dying and torrents are the new trend.
Account Registration works again and so do Torrent Uploads.
We invite you all to start uploading torrents again!

TORRENT DETAILS

[Tutorialsplanet.NET] Udemy - Master SQL For Data Science

TORRENT SUMMARY

	Status:	All the torrents in this section have been verified by our verification system
Category:	Other
Infohash	c386c3b56db58cd2e808b648454edb9c1c88f06c
Size:	1.3 GB in 87 files
Release Date(s):	Torrent Release: 09-08-2019 by user
Swarm:	0 Seeds & 0 Peers
Vote:	No votes yet.

DESCRIPTION

Udemy - Master SQL For Data Science [TP]

This course will turn you into a SQL query wizard. You’ll learn the skills you need to extract critical insight from data sitting in a database. There are over 100 puzzles scattered throughout the course with in-depth solutions providing plenty of opportunity for you to practice. After completing the course and all of it’s assignments, I promise you, you’ll never be afraid to look at a large SQL query again.

Just like my other courses, I follow the no-student-left behind principle; which means that I start from the very basics. You do not need any prerequisites to take this course. We move step by step into more advanced topics as we delve into the world of advanced querying techniques using subqueries, aggregations, joins, rollups and cubes, window functions, transposing & ranking data and using conditional expressions in very interesting ways.

As always I offer a 30 day money back guarantee but I doubt you’ll need it.

VISITOR COMMENTS (0

)

FILE LIST

Filename		Size
	1. Chapter 1/1. Course Overview.mp4	52.8 MB
	1. Chapter 1/1. Course Overview.vtt	6.3 KB
	10. Window Functions for Analytics/1. Window Functions using the OVER() Clause.mp4	29.9 MB
	10. Window Functions for Analytics/1. Window Functions using the OVER() Clause.vtt	23.6 KB
	10. Window Functions for Analytics/2. Ordering Data in Window Frames.mp4	34.8 MB
	10. Window Functions for Analytics/2. Ordering Data in Window Frames.vtt	25.3 KB
	10. Window Functions for Analytics/3. RANK, FIRST_VALUE and NTILE Functions.mp4	111.2 MB
	10. Window Functions for Analytics/3. RANK, FIRST_VALUE and NTILE Functions.vtt	15.1 KB
	10. Window Functions for Analytics/4. LEAD and LAG Functions.mp4	63.2 MB
	10. Window Functions for Analytics/4. LEAD and LAG Functions.vtt	9.7 KB
	10. Window Functions for Analytics/5. Working with Rollups and Cubes.mp4	111.9 MB
	10. Window Functions for Analytics/5. Working with Rollups and Cubes.vtt	14.4 KB
	10. Window Functions for Analytics/5.1 sales_tbl.txt.txt	696 B
	11. Difficult Query Challenges/1. Challenging Puzzles For the Brave.html	135 B
	11. Difficult Query Challenges/2. Get Access to All of my current and future courses!.html	1021 B
	2. Database Basics/1. What is a Database.mp4	15.5 MB
	2. Database Basics/1. What is a Database.vtt	11.5 KB
	2. Database Basics/2. Install Postgres Database on Mac.mp4	12.6 MB
	2. Database Basics/2. Install Postgres Database on Mac.vtt	9.3 KB
	2. Database Basics/3. Troubleshoot Connection.html	1.1 KB
	2. Database Basics/4. Install Postgres on Windows.mp4	71.6 MB
	2. Database Basics/4. Install Postgres on Windows.vtt	10.1 KB
	2. Database Basics/5. Create Table and Insert Statements.mp4	43.3 MB
	2. Database Basics/5. Create Table and Insert Statements.vtt	25.6 KB
	2. Database Basics/6. Data file that will be used in the course (IMPORTANT).html	444 B
	2. Database Basics/7. Prepare the Database.mp4	39.9 MB
	2. Database Basics/7. Prepare the Database.vtt	17.1 KB
	2. Database Basics/7.1 mock_data.sql.sql	119.6 KB
	2. Database Basics/8. Create More Tables and Populate Data.html	135 B
	3. SQL Query Basics/1. Introducing the SELECT Statement.mp4	32.8 MB
	3. SQL Query Basics/1. Introducing the SELECT Statement.vtt	21.2 KB
	3. SQL Query Basics/2. Filter Data Using the WHERE Clause + AND & OR.mp4	40.4 MB
	3. SQL Query Basics/2. Filter Data Using the WHERE Clause + AND & OR.vtt	28.4 KB
	3. SQL Query Basics/3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.mp4	30.1 MB
	3. SQL Query Basics/3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.vtt	18.6 KB
	3. SQL Query Basics/4. [EXERCISES] WHERE Clause and Operators.mp4	19.3 MB
	3. SQL Query Basics/4. [EXERCISES] WHERE Clause and Operators.vtt	13.6 KB
	3. SQL Query Basics/5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.mp4	21.2 MB
	3. SQL Query Basics/5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.vtt	13.8 KB
	3. SQL Query Basics/6. Practice Writing Basic Queries (5 Problems).html	135 B
	4. Using Functions/1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.mp4	25 MB
	4. Using Functions/1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.vtt	19.6 KB
	4. Using Functions/2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().mp4	23.9 MB
	4. Using Functions/2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().vtt	20.2 KB
	4. Using Functions/3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().mp4	15.6 MB
	4. Using Functions/3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().vtt	12.6 KB
	4. Using Functions/4. Practice with Functions, Conditional Expressions and Concatenation.html	135 B
	5. Grouping Data and Computing Aggregates/1. Understanding Grouping.mp4	8.9 MB
	5. Grouping Data and Computing Aggregates/1. Understanding Grouping.vtt	7.4 KB
	5. Grouping Data and Computing Aggregates/2. GROUP BY & HAVING Clauses.mp4	25.9 MB
	5. Grouping Data and Computing Aggregates/2. GROUP BY & HAVING Clauses.vtt	20.9 KB
	5. Grouping Data and Computing Aggregates/3. [EXERCISES] Using GROUP BY and HAVING Clauses.mp4	25.9 MB
	5. Grouping Data and Computing Aggregates/3. [EXERCISES] Using GROUP BY and HAVING Clauses.vtt	21 KB
	5. Grouping Data and Computing Aggregates/4. Practice Aggregation Queries.html	135 B
	6. Using Subqueries/1. Aliasing Sources of Data.mp4	9.4 MB
	6. Using Subqueries/1. Aliasing Sources of Data.vtt	7.9 KB
	6. Using Subqueries/2. Introducing Subqueries.mp4	23.9 MB
	6. Using Subqueries/2. Introducing Subqueries.vtt	16.8 KB
	6. Using Subqueries/3. Subqueries Continued + [EXERCISES].mp4	29.7 MB
	6. Using Subqueries/3. Subqueries Continued + [EXERCISES].vtt	22.1 KB
	6. Using Subqueries/4. Subqueries with ANY and ALL Operators + [EXERCISES].mp4	33 MB
	6. Using Subqueries/4. Subqueries with ANY and ALL Operators + [EXERCISES].vtt	23 KB
	6. Using Subqueries/5. [EXERCISES] More Practice with Subqueries.mp4	22.5 MB
	6. Using Subqueries/5. [EXERCISES] More Practice with Subqueries.vtt	18.3 KB
	6. Using Subqueries/6. Practice with Subqueries.html	135 B
	7. Using the CASE Clause in Interesting Ways/1. Conditional Expressions Using CASE Clause + [EXERCISES].mp4	33.1 MB
	7. Using the CASE Clause in Interesting Ways/1. Conditional Expressions Using CASE Clause + [EXERCISES].vtt	24.2 KB
	7. Using the CASE Clause in Interesting Ways/2. Transposing Data using the CASE Clause + [EXERCISES].mp4	30.2 MB
	7. Using the CASE Clause in Interesting Ways/2. Transposing Data using the CASE Clause + [EXERCISES].vtt	20.8 KB
	7. Using the CASE Clause in Interesting Ways/3. Practice Using Case and Transposing Data.html	135 B
	8. Advanced Query Techniques using Correlated Subqueries/1. Understanding Correlated Subqueries.mp4	32.1 MB
	8. Advanced Query Techniques using Correlated Subqueries/1. Understanding Correlated Subqueries.vtt	24.9 KB
	8. Advanced Query Techniques using Correlated Subqueries/2. [EXERCISES] Correlated Subqueries Continued.mp4	26.1 MB
	8. Advanced Query Techniques using Correlated Subqueries/2. [EXERCISES] Correlated Subqueries Continued.vtt	18.8 KB
	9. Working with Multiple Tables/1. Introducing Table Joins.mp4	25.6 MB
	9. Working with Multiple Tables/1. Introducing Table Joins.vtt	19.5 KB
	9. Working with Multiple Tables/2. INNER and OUTER Joins + [EXERCISES].mp4	40.7 MB
	9. Working with Multiple Tables/2. INNER and OUTER Joins + [EXERCISES].vtt	31 KB
	9. Working with Multiple Tables/3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].mp4	21 MB
	9. Working with Multiple Tables/3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].vtt	18.5 KB
	9. Working with Multiple Tables/4. Cartesian Product with the CROSS JOIN.mp4	11.6 MB
	9. Working with Multiple Tables/4. Cartesian Product with the CROSS JOIN.vtt	8.1 KB
	9. Working with Multiple Tables/5. [EXERCISES] Joins and Subqueries Continued.mp4	27.4 MB
	9. Working with Multiple Tables/5. [EXERCISES] Joins and Subqueries Continued.vtt	20.3 KB
	9. Working with Multiple Tables/6. Creating Views vs. Inline Views.mp4	80.4 MB
	9. Working with Multiple Tables/6. Creating Views vs. Inline Views.vtt	11.7 KB
	9. Working with Multiple Tables/7. ADVANCED Problems using Joins, Grouping and Subqueries.html	135 B

RELATED DOWNLOADS

Torrent Name

Added

Size

Seeds

Peers

Uploader

Health