Tutorialsplanet NET Udemy The Complete SQL Bootcamp 2020 Go from Zero to Hero

Tutorialsplanet NET Udemy The Complete SQL Bootcamp 2020 Go from Zero to Hero

Name	[Tutorialsplanet.NET] Udemy - The Complete SQL Bootcamp 2020 Go from Zero to Hero	DOWNLOAD Copy Link
Total Size	3.1 GB
Total Files	169
Hash	E7A1DE94B627C1B523CB2C2CE0CC754740077C99

/1. Course Introduction/
1. Welcome Message.html	1.3 KB
2. Introduction.mp4	14.4 MB
2. Introduction.srt	5.0 KB
3. Course Curriculum Overview.mp4	14.2 MB
3. Course Curriculum Overview.srt	3.8 KB
4. Overview of Databases.mp4	47.7 MB
4. Overview of Databases.srt	15.7 KB
5. Course FAQs.html	2.5 KB
5.1 PostgreSQL-Sample-Database.png	167.5 KB
5.2 SQLNotes.pdf	299.1 KB
6. Time to get your Computer Set-Up!.html	1.1 KB
7. Windows Installation - PostGreSQL and PgAdmin with Database Setup.mp4	155.3 MB
7. Windows Installation - PostGreSQL and PgAdmin with Database Setup.srt	33.3 KB
7.1 Backup dvdrental.tar on Google Drive (preview for .tar is not possible, just click Download button).html	0.1 KB
8. MacOS Installation - PostgreSQL and PgAdmin with First Query.mp4	180.3 MB
8. MacOS Installation - PostgreSQL and PgAdmin with First Query.srt	38.5 KB
8.1 Backup dvdrental.tar on Google Drive (preview for .tar is not possible, just click Download button).html	0.1 KB
9. pgAdmin Overview.mp4	72.0 MB
9. pgAdmin Overview.srt	15.3 KB
/10. Conditional Expressions and Procedures/
1. Conditional Expressions and Procedures Introduction.mp4	3.2 MB
1. Conditional Expressions and Procedures Introduction.srt	1.0 KB
2. CASE.mp4	115.6 MB
2. CASE.srt	29.8 KB
3. CASE - Challenge Task.mp4	18.1 MB
3. CASE - Challenge Task.srt	3.9 KB
4. COALESCE.mp4	19.1 MB
4. COALESCE.srt	7.8 KB
5. CAST.mp4	40.6 MB
5. CAST.srt	10.1 KB
6. NULLIF.mp4	57.4 MB
6. NULLIF.srt	14.0 KB
7. Views.mp4	43.8 MB
7. Views.srt	9.5 KB
8. Import and Export.mp4	87.3 MB
8. Import and Export.srt	19.8 KB
8.1 Importing CSV file.html	0.2 KB
8.2 Other options to attempt to create table automatically.html	0.2 KB
8.3 EnterpriseDB Guide on CSV Files.html	0.2 KB
/11. Extra PostGreSQL with Python/
1. Overview of Python and PostgreSQL.html	1.0 KB
1.1 Pgsql with Python.py	5.6 KB
2. Psycopg2 Example Usage.mp4	73.5 MB
2. Psycopg2 Example Usage.srt	18.9 KB
2.1 Pgsql with Python.py	5.6 KB
3. Psycopg2 Resources.html	0.4 KB
3.1 Pgsql with Python.py	5.6 KB
/12. BONUS SECTION THANK YOU!/
1. Bonus Lecture.html	0.5 KB
/2. SQL Statement Fundamentals/
1. Overview of Challenges!.mp4	9.2 MB
1. Overview of Challenges!.srt	3.7 KB
10. SELECT WHERE - Part Two.mp4	50.1 MB
10. SELECT WHERE - Part Two.srt	9.8 KB
11. Challenge SELECT WHERE.mp4	24.1 MB
11. Challenge SELECT WHERE.srt	8.7 KB
12. ORDER BY.mp4	51.1 MB
12. ORDER BY.srt	12.0 KB
13. LIMIT.mp4	34.6 MB
13. LIMIT.srt	7.6 KB
14. Challenge ORDER BY.mp4	20.8 MB
14. Challenge ORDER BY.srt	7.5 KB
15. BETWEEN.mp4	38.0 MB
15. BETWEEN.srt	9.7 KB
16. IN.mp4	24.1 MB
16. IN.srt	6.9 KB
17. LIKE and ILIKE.mp4	53.4 MB
17. LIKE and ILIKE.srt	13.8 KB
18. General Challenge 1.mp4	28.9 MB
18. General Challenge 1.srt	20.7 KB
18.1 general challenge 1.pptx	54.4 KB
2. SQL Cheat Sheet.html	0.4 KB
2.1 Screen Shot 2016-04-17 at 12.22.49 PM.png	1.1 MB
3. SQL Statement Fundamentals.mp4	3.4 MB
3. SQL Statement Fundamentals.srt	1.6 KB
4. SELECT Statement.mp4	46.6 MB
4. SELECT Statement.srt	12.7 KB
5. Challenge SELECT.mp4	21.4 MB
5. Challenge SELECT.srt	7.4 KB
6. SELECT DISTINCT.mp4	31.8 MB
6. SELECT DISTINCT.srt	8.1 KB
7. Challenge SELECT DISTINCT.mp4	7.5 MB
7. Challenge SELECT DISTINCT.srt	2.6 KB
8. COUNT.mp4	39.3 MB
8. COUNT.srt	10.9 KB
9. SELECT WHERE - Part One.mp4	16.0 MB
9. SELECT WHERE - Part One.srt	6.6 KB
/3. GROUP BY Statements/
1. Introduction to GROUP BY.mp4	5.3 MB
1. Introduction to GROUP BY.srt	1.3 KB
2. Aggregation Functions.mp4	51.2 MB
2. Aggregation Functions.srt	12.2 KB
3. GROUP BY - Part One.mp4	34.4 MB
3. GROUP BY - Part One.srt	11.3 KB
4. GROUP BY - Part Two.mp4	68.9 MB
4. GROUP BY - Part Two.srt	14.7 KB
5. GROUP BY - Challenge.mp4	16.8 MB
5. GROUP BY - Challenge.srt	5.9 KB
6. HAVING.mp4	38.3 MB
6. HAVING.srt	8.6 KB
7. HAVING - Challenge Tasks.mp4	11.6 MB
7. HAVING - Challenge Tasks.srt	4.4 KB
/4. Assessment Test 1/
1. Overview of Assessment Test 1.mp4	4.0 MB
1. Overview of Assessment Test 1.srt	2.6 KB
2. Assessment Test 1.html	0.7 KB
3. Solutions to Assessment Test 1.html	0.7 KB
/5. JOINS/
1. Overview of JOINS.html	0.8 KB
2. Introduction to JOINs.mp4	5.9 MB
2. Introduction to JOINs.srt	2.0 KB
3. AS Statement.mp4	39.2 MB
3. AS Statement.srt	10.9 KB
4. Inner Joins.mp4	79.3 MB
4. Inner Joins.srt	21.6 KB
5. Full Outer Joins.mp4	72.0 MB
5. Full Outer Joins.srt	20.2 KB
6. Left Outer Join.mp4	63.4 MB
6. Left Outer Join.srt	14.6 KB
7. Right Joins.mp4	21.8 MB
7. Right Joins.srt	6.4 KB
8. UNION.mp4	9.6 MB
8. UNION.srt	3.2 KB
9. JOIN Challenge Tasks.mp4	75.3 MB
9. JOIN Challenge Tasks.srt	17.5 KB
/6. Advanced SQL Commands/
1. Overview of Advanced SQL Commands.mp4	3.3 MB
1. Overview of Advanced SQL Commands.srt	1.2 KB
2. Timestamps and Extract - Part One.mp4	46.8 MB
2. Timestamps and Extract - Part One.srt	11.4 KB
3. Timestamps and Extract - Part Two.mp4	65.2 MB
3. Timestamps and Extract - Part Two.srt	14.8 KB
4. Quick Note on TO_CHAR.html	0.6 KB
5. Timestamps and Extract - Challenge Tasks.mp4	12.4 MB
5. Timestamps and Extract - Challenge Tasks.srt	4.9 KB
6. Mathematical Functions and Operators.mp4	40.1 MB
6. Mathematical Functions and Operators.srt	7.6 KB
7. String Functions and Operators.mp4	63.5 MB
7. String Functions and Operators.srt	12.7 KB
8. SubQuery.mp4	87.0 MB
8. SubQuery.srt	19.8 KB
9. Self-Join.mp4	53.8 MB
9. Self-Join.srt	14.8 KB
/7. Assessment Test 2/
1. READ ME FIRST PLEASE.html	3.5 KB
1.1 Alternative .sql file for users who have issues with pgsql 12.html	0.1 KB
2. Setting up New Database for Assessment Exercises.mp4	51.1 MB
2. Setting up New Database for Assessment Exercises.srt	12.7 KB
2.1 Backup exercise.tar file on Google Drive.html	0.1 KB
2.2 exercises.tar	33.1 KB
3. Assessment Test 2.html	1.0 KB
4. Solutions to Assessment Test 2.mp4	175.5 MB
4. Solutions to Assessment Test 2.srt	32.7 KB
/8. Creating Databases and Tables/
1. Introduction to Section.mp4	6.1 MB
1. Introduction to Section.srt	1.7 KB
10. DROP Table.mp4	16.0 MB
10. DROP Table.srt	4.6 KB
11. CHECK Constraint.mp4	34.6 MB
11. CHECK Constraint.srt	9.0 KB
2. Data Types.mp4	35.9 MB
2. Data Types.srt	9.7 KB
3. Primary Keys and Foreign Keys.mp4	52.6 MB
3. Primary Keys and Foreign Keys.srt	12.7 KB
4. Constraints.mp4	25.0 MB
4. Constraints.srt	8.6 KB
5. CREATE Table.mp4	111.8 MB
5. CREATE Table.srt	28.4 KB
6. INSERT.mp4	50.0 MB
6. INSERT.srt	11.8 KB
7. UPDATE.mp4	39.6 MB
7. UPDATE.srt	10.2 KB
8. DELETE.mp4	15.2 MB
8. DELETE.srt	4.5 KB
9. ALTER Table.mp4	38.3 MB
9. ALTER Table.srt	9.4 KB
/9. Assessment Test 3/
1. Assessment Test 3.html	2.1 KB
2. Solutions to Assessment Test 3.html	1.3 KB
/
[Tutorialsplanet.NET].url	0.1 KB
Total files 169