FreeCourseLab com Udemy The Complete SQL Bootcamp | 4E8B85C509EFE042A5DA1A07A10804059F2B83B3

FreeCourseLab com Udemy The Complete SQL Bootcamp

Name	[FreeCourseLab.com] Udemy - The Complete SQL Bootcamp	DOWNLOAD Copy Link
Total Size	3.5 GB
Total Files	169
Hash	4E8B85C509EFE042A5DA1A07A10804059F2B83B3

/1. Course Introduction/
1. Introduction.mp4	14.4 MB
1. Introduction.vtt	4.5 KB
2. Course Curriculum Overview.mp4	14.3 MB
2. Course Curriculum Overview.vtt	3.4 KB
3. Overview of Databases.mp4	47.7 MB
3. Overview of Databases.vtt	14.3 KB
4. Course FAQs.html	2.7 KB
4.1 SQLNotes.pdf.pdf	299.1 KB
4.2 PostgreSQL-Sample-Database.png.png	167.5 KB
5. Time to get your Computer Set-Up!.html	1.4 KB
6. Setup and Installation of PgAdmin, PostGreSQL, and Database.mp4	198.0 MB
6. Setup and Installation of PgAdmin, PostGreSQL, and Database.vtt	36.7 KB
6.1 dvdrental.tar.tar	659.8 KB
7. Installation Notes.html	0.3 KB
/10. Extra Views/
1. Views.mp4	64.0 MB
1. Views.vtt	13.6 KB
/11. Extra PostGreSQL with Python/
1. Overview of Python and PostgreSQL.html	1.0 KB
1.1 Pgsql with Python.py.py	5.6 KB
2. Psycopg2 Example Usage.mp4	73.5 MB
2. Psycopg2 Example Usage.vtt	17.2 KB
2.1 Pgsql with Python.py.py	5.6 KB
3. Psycopg2 Resources.html	0.4 KB
3.1 Pgsql with Python.py.py	5.6 KB
/12. Databases and Tables/
1. Databases and Tables Overview.mp4	6.0 MB
1. Databases and Tables Overview.vtt	2.2 KB
2. Creating and Restoring a Database.mp4	48.2 MB
2. Creating and Restoring a Database.vtt	11.3 KB
3. Challenge Restore a Database!.mp4	2.5 MB
3. Challenge Restore a Database!.vtt	1.4 KB
4. Restoring a Table Schema.mp4	54.4 MB
4. Restoring a Table Schema.vtt	11.2 KB
5. Challenge Restore a Table Schema!.mp4	2.9 MB
5. Challenge Restore a Table Schema!.vtt	1.4 KB
6. Review of Section.html	0.7 KB
/13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/
1. Mac OS X - Quick Note.html	0.7 KB
2. Mac OS Installation.mp4	53.8 MB
2. Mac OS Installation.vtt	10.2 KB
2.1 dvdrental.zip.zip	551.4 KB
3. Mac Sample Database Download.html	1.8 KB
3.1 Database_Schema.png.png	195.4 KB
3.2 dvdrental.zip.zip	551.4 KB
4. Mac Database Set-up.mp4	114.0 MB
4. Mac Database Set-up.vtt	18.8 KB
5. Review of Set-up.html	1.3 KB
6. Windows - Quick Note.html	0.9 KB
7. Windows Installation.mp4	39.7 MB
7. Windows Installation.vtt	7.4 KB
7.1 Database_Schema.png.png	195.4 KB
7.2 dvdrental.zip.zip	551.4 KB
8. Sample Database Download.html	0.9 KB
8.1 dvdrental.zip.zip	551.4 KB
8.2 Database_Schema.png.png	195.4 KB
9. Windows Command Line Installation Lecture.mp4	178.0 MB
9. Windows Command Line Installation Lecture.vtt	33.5 KB
/14. BONUS DISCOUNT COUPONS FOR OTHER COURSES/
1. Bonus Lecture Coupons.html	5.9 KB
/2. SQL Statement Fundamentals/
1. Overview of Challenges!.mp4	9.2 MB
1. Overview of Challenges!.vtt	3.3 KB
10. COUNT.mp4	29.4 MB
10. COUNT.vtt	8.4 KB
11. LIMIT.mp4	27.2 MB
11. LIMIT.vtt	5.9 KB
12. ORDER BY.mp4	82.8 MB
12. ORDER BY.vtt	17.9 KB
13. Challenge ORDER BY.mp4	10.6 MB
13. Challenge ORDER BY.vtt	6.8 KB
14. BETWEEN.mp4	57.3 MB
14. BETWEEN.vtt	14.7 KB
15. IN.mp4	58.7 MB
15. IN.vtt	13.5 KB
16. LIKE.mp4	65.0 MB
16. LIKE.vtt	17.0 KB
17. General Challenge 1.mp4	28.9 MB
17. General Challenge 1.vtt	18.7 KB
17.1 general challenge 1.pptx.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.png	1.1 MB
3. SQL Statement Fundamentals.mp4	3.4 MB
3. SQL Statement Fundamentals.vtt	1.4 KB
4. SELECT Statement.mp4	70.7 MB
4. SELECT Statement.vtt	21.0 KB
5. Challenge SELECT task..mp4	8.2 MB
5. Challenge SELECT task..vtt	5.5 KB
6. SELECT DISTINCT.mp4	44.6 MB
6. SELECT DISTINCT.vtt	9.5 KB
7. Challenge SELECT DISTINCT.mp4	6.7 MB
7. Challenge SELECT DISTINCT.vtt	4.1 KB
8. SELECT WHERE.mp4	106.4 MB
8. SELECT WHERE.vtt	27.1 KB
9. Challenge SELECT WHERE.mp4	16.3 MB
9. Challenge SELECT WHERE.vtt	7.1 KB
/3. GROUP BY Statements/
1. MIN MAX SUM and AVG.mp4	39.8 MB
1. MIN MAX SUM and AVG.vtt	15.0 KB
2. GROUP BY.mp4	108.5 MB
2. GROUP BY.vtt	30.8 KB
3. ChallengeGROUP BY.mp4	59.5 MB
3. ChallengeGROUP BY.vtt	24.6 KB
4. HAVING.mp4	62.5 MB
4. HAVING.vtt	18.0 KB
5. Quick Note.html	0.3 KB
6. ChallengeHAVING.mp4	14.9 MB
6. ChallengeHAVING.vtt	7.2 KB
/4. Assessment Test 1/
1. Overview of Assessment Test 1.mp4	4.0 MB
1. Overview of Assessment Test 1.vtt	2.4 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.9 KB
2. AS Statement.mp4	25.0 MB
2. AS Statement.vtt	6.6 KB
3. Overview of Inner Join.mp4	166.4 MB
3. Overview of Inner Join.vtt	35.5 KB
4. Examples of Inner Joins.mp4	141.4 MB
4. Examples of Inner Joins.vtt	27.2 KB
5. Overview of Join types.mp4	72.2 MB
5. Overview of Join types.vtt	23.9 KB
5.1 JOINS Overview 2.pptx.pptx	451.5 KB
6. Example of Outer Joins.mp4	88.2 MB
6. Example of Outer Joins.vtt	22.1 KB
7. Union.mp4	31.7 MB
7. Union.vtt	12.0 KB
8. Join Challenges.html	0.6 KB
/6. Advanced SQL Commands/
1. Overview of Advanced SQL Commands.html	0.9 KB
2. Timestamps and Extract.mp4	71.9 MB
2. Timestamps and Extract.vtt	16.3 KB
3. Mathematical Functions.mp4	51.4 MB
3. Mathematical Functions.vtt	12.3 KB
4. String Function and Operators.mp4	63.3 MB
4. String Function and Operators.vtt	13.9 KB
5. SubQuery.mp4	103.4 MB
5. SubQuery.vtt	25.4 KB
6. Self-Join.mp4	100.3 MB
6. Self-Join.vtt	24.8 KB
/7. Assessment Test 2/
1. Assessment Test 2 Overview.mp4	58.6 MB
1. Assessment Test 2 Overview.vtt	11.5 KB
1.1 exercises.zip.zip	27.1 KB
1.2 exercises.tar.tar	33.7 KB
2. Assessment Test 2.html	3.0 KB
3. Solutions to Assessment Test 2.html	1.7 KB
/8. Creating Databases and Tables/
1. Overview of Section.mp4	16.7 MB
1. Overview of Section.vtt	6.6 KB
10. Update.mp4	62.7 MB
10. Update.vtt	17.7 KB
11. Delete.mp4	25.6 MB
11. Delete.vtt	8.5 KB
12. Alter Table.mp4	33.8 MB
12. Alter Table.vtt	11.6 KB
13. Drop Table.mp4	28.3 MB
13. Drop Table.vtt	9.5 KB
14. CHECK Constraint.mp4	58.0 MB
14. CHECK Constraint.vtt	16.0 KB
15. NOT NULL Constraint.mp4	33.0 MB
15. NOT NULL Constraint.vtt	12.6 KB
16. UNIQUE Constraint.mp4	28.1 MB
16. UNIQUE Constraint.vtt	8.4 KB
2. Data Types.mp4	44.2 MB
2. Data Types.vtt	13.5 KB
3. Primary Keys and Foreign Keys.mp4	52.1 MB
3. Primary Keys and Foreign Keys.vtt	18.0 KB
4. Resource for Create Table Code.html	1.5 KB
5. Note on Constraints.html	0.6 KB
6. Create Table.mp4	140.6 MB
6. Create Table.vtt	39.1 KB
7. Challenge Create Table.html	0.7 KB
8. Challenge Create Table - SOLUTION.mp4	35.6 MB
8. Challenge Create Table - SOLUTION.vtt	11.1 KB
9. Insert.mp4	93.9 MB
9. Insert.vtt	29.4 KB
/9. Assessment Test 3/
1. Assessment Test 3.html	2.1 KB
2. Solutions to Assessment Test 3.html	1.3 KB
/
[FreeCourseLab.com].url	0.1 KB
Total files 169