The Complete SQL Bootcamp | 0820E3070BDCE0D8A9DC32FEF7D876197A4DF529

The Complete SQL Bootcamp

Name	The Complete SQL Bootcamp	DOWNLOAD Copy Link
Total Size	4.3 GB
Total Files	168
Hash	0820E3070BDCE0D8A9DC32FEF7D876197A4DF529

/1. Course Introduction/
1. Introduction.mp4	14.4 MB
1. Introduction.srt	5.0 KB
2. Course Curriculum Overview.mp4	14.2 MB
2. Course Curriculum Overview.srt	3.8 KB
3. Overview of Databases.mp4	47.7 MB
3. Overview of Databases.srt	15.7 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. Installing PostGreSQL and PgAdmin with Database Setup.mp4	198.0 MB
6. Installing PostGreSQL and PgAdmin with Database Setup.srt	41.7 KB
6.1 dvdrental.tar.tar	659.8 KB
7. Installation Notes.html	0.3 KB
/10. Extra Views/
1. Views.mp4	82.1 MB
1. Views.srt	15.0 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	91.7 MB
2. Psycopg2 Example Usage.srt	18.9 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.9 MB
1. Databases and Tables Overview.srt	2.4 KB
2. Creating and Restoring a Database.mp4	64.4 MB
2. Creating and Restoring a Database.srt	12.5 KB
3. Challenge Restore a Database!.mp4	2.9 MB
3. Challenge Restore a Database!.srt	1.6 KB
4. Restoring a Table Schema.mp4	71.3 MB
4. Restoring a Table Schema.srt	12.4 KB
5. Challenge Restore a Table Schema!.mp4	3.3 MB
5. Challenge Restore a Table Schema!.srt	1.5 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.srt	11.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	183.7 MB
4. Mac Database Set-up.srt	20.8 KB
5. Review of Set-up.html	1.3 KB
6. Windows - Quick Note.html	0.9 KB
7. Windows Installation.mp4	56.4 MB
7. Windows Installation.srt	8.2 KB
7.1 dvdrental.zip.zip	551.4 KB
7.2 Database_Schema.png.png	195.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	234.3 MB
9. Windows Command Line Installation Lecture.srt	37.1 KB
/14. BONUS SECTION THANK YOU!/
1. Bonus Lecture.html	0.5 KB
/2. SQL Statement Fundamentals/
1. Overview of Challenges!.mp4	10.9 MB
1. Overview of Challenges!.srt	3.7 KB
10. COUNT.mp4	37.5 MB
10. COUNT.srt	9.2 KB
11. LIMIT.mp4	37.7 MB
11. LIMIT.srt	6.5 KB
12. ORDER BY.mp4	111.2 MB
12. ORDER BY.srt	19.9 KB
13. Challenge ORDER BY.mp4	12.0 MB
13. Challenge ORDER BY.srt	7.5 KB
14. BETWEEN.mp4	72.2 MB
14. BETWEEN.srt	16.2 KB
15. IN.mp4	75.8 MB
15. IN.srt	14.9 KB
16. LIKE.mp4	80.9 MB
16. LIKE.srt	18.7 KB
17. General Challenge 1.mp4	33.2 MB
17. General Challenge 1.srt	20.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	4.0 MB
3. SQL Statement Fundamentals.srt	1.6 KB
4. SELECT Statement.mp4	85.7 MB
4. SELECT Statement.srt	23.3 KB
5. Challenge SELECT task..mp4	9.5 MB
5. Challenge SELECT task..srt	6.1 KB
6. SELECT DISTINCT.mp4	58.9 MB
6. SELECT DISTINCT.srt	10.4 KB
7. Challenge SELECT DISTINCT.mp4	7.8 MB
7. Challenge SELECT DISTINCT.srt	4.5 KB
8. SELECT WHERE.mp4	136.5 MB
8. SELECT WHERE.srt	30.1 KB
9. Challenge SELECT WHERE.mp4	19.1 MB
9. Challenge SELECT WHERE.srt	7.7 KB
/3. GROUP BY Statements/
1. MIN MAX SUM and AVG.mp4	47.3 MB
1. MIN MAX SUM and AVG.srt	16.6 KB
2. GROUP BY.mp4	135.2 MB
2. GROUP BY.srt	34.1 KB
3. ChallengeGROUP BY.mp4	72.3 MB
3. ChallengeGROUP BY.srt	27.4 KB
4. HAVING.mp4	78.9 MB
4. HAVING.srt	20.0 KB
5. Quick Note.html	0.3 KB
6. ChallengeHAVING.mp4	17.2 MB
6. ChallengeHAVING.srt	7.9 KB
/4. Assessment Test 1/
1. Overview of Assessment Test 1.mp4	4.7 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.9 KB
2. AS Statement.mp4	31.7 MB
2. AS Statement.srt	7.2 KB
3. Overview of Inner Join.mp4	206.1 MB
3. Overview of Inner Join.srt	39.6 KB
4. Examples of Inner Joins.mp4	178.3 MB
4. Examples of Inner Joins.srt	30.1 KB
5. Overview of Join types.mp4	87.4 MB
5. Overview of Join types.srt	26.5 KB
5.1 JOINS Overview 2.pptx.pptx	451.5 KB
6. Example of Outer Joins.mp4	113.2 MB
6. Example of Outer Joins.srt	24.6 KB
7. Union.mp4	37.6 MB
7. Union.srt	13.2 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	93.3 MB
2. Timestamps and Extract.srt	18.0 KB
3. Mathematical Functions.mp4	67.7 MB
3. Mathematical Functions.srt	13.6 KB
4. String Function and Operators.mp4	83.9 MB
4. String Function and Operators.srt	15.4 KB
5. SubQuery.mp4	127.3 MB
5. SubQuery.srt	28.3 KB
6. Self-Join.mp4	125.7 MB
6. Self-Join.srt	27.5 KB
/7. Assessment Test 2/
1. Assessment Test 2 Overview.mp4	75.9 MB
1. Assessment Test 2 Overview.srt	12.7 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	19.3 MB
1. Overview of Section.srt	7.2 KB
10. Update.mp4	77.8 MB
10. Update.srt	19.6 KB
11. Delete.mp4	31.4 MB
11. Delete.srt	9.4 KB
12. Alter Table.mp4	41.5 MB
12. Alter Table.srt	12.8 KB
13. Drop Table.mp4	34.0 MB
13. Drop Table.srt	10.5 KB
14. CHECK Constraint.mp4	73.2 MB
14. CHECK Constraint.srt	17.7 KB
15. NOT NULL Constraint.mp4	40.3 MB
15. NOT NULL Constraint.srt	14.0 KB
16. UNIQUE Constraint.mp4	33.8 MB
16. UNIQUE Constraint.srt	9.2 KB
2. Data Types.mp4	52.5 MB
2. Data Types.srt	14.8 KB
3. Primary Keys and Foreign Keys.mp4	60.6 MB
3. Primary Keys and Foreign Keys.srt	19.9 KB
4. Resource for Create Table Code.html	1.5 KB
5. Note on Constraints.html	0.6 KB
6. Create Table.mp4	176.6 MB
6. Create Table.srt	43.7 KB
7. Challenge Create Table.html	0.7 KB
8. Challenge Create Table - SOLUTION.mp4	42.7 MB
8. Challenge Create Table - SOLUTION.srt	12.2 KB
9. Insert.mp4	110.8 MB
9. Insert.srt	33.0 KB
/9. Assessment Test 3/
1. Assessment Test 3.html	2.1 KB
2. Solutions to Assessment Test 3.html	1.3 KB
Total files 168