Udemy - The Complete SQL Bootcamp [GC]

Files:

• 1. Introduction.mp4 (13.7 MB)
• 1. Introduction.srt (4.9 KB)
• 2. Course Curriculum Overview.mp4 (13.6 MB)
• 2. Course Curriculum Overview.srt (3.7 KB)
• 3. Overview of Databases.mp4 (45.5 MB)
• 3. Overview of Databases.srt (15.4 KB)
• 4. Course FAQs.html (2.7 KB)
• 4.1 PostgreSQL-Sample-Database.png.png (163.6 KB)
• 4.2 SQLNotes.pdf.pdf (292.1 KB)
• 5. Time to get your Computer Set-Up!.html (1.4 KB)
• 6. Windows Installation - PostGreSQL and PgAdmin with Database Setup.mp4 (148.1 MB)
• 6. Windows Installation - PostGreSQL and PgAdmin with Database Setup.srt (36.2 KB)
• 6.1 dvdrental.tar.tar (644.4 KB)
• 7. MacOS Installation - PostgreSQL and PgAdmin with First Query.mp4 (172.0 MB)
• 7. MacOS Installation - PostgreSQL and PgAdmin with First Query.srt (41.9 KB)
• 7.1 dvdrental.tar.tar (644.4 KB)

• 1. Views.mp4 (61.0 MB)
• 1. Views.srt (14.6 KB)

• 1. Overview of Python and PostgreSQL.html (1.0 KB)
• 1.1 Pgsql with Python.py.py (5.4 KB)
• 2. Psycopg2 Example Usage.mp4 (70.1 MB)
• 2. Psycopg2 Example Usage.srt (18.5 KB)
• 2.1 Pgsql with Python.py.py (5.4 KB)
• 3. Psycopg2 Resources.html (0.4 KB)
• 3.1 Pgsql with Python.py.py (5.4 KB)

• 1. Databases and Tables Overview.mp4 (5.7 MB)
• 1. Databases and Tables Overview.srt (2.4 KB)
• 2. Creating and Restoring a Database.mp4 (46.0 MB)
• 2. Creating and Restoring a Database.srt (12.2 KB)
• 3. Challenge Restore a Database!.mp4 (2.4 MB)
• 3. Challenge Restore a Database!.srt (1.5 KB)
• 4. Restoring a Table Schema.mp4 (51.8 MB)
• 4. Restoring a Table Schema.srt (12.1 KB)
• 5. Challenge Restore a Table Schema!.mp4 (2.7 MB)
• 5. Challenge Restore a Table Schema!.srt (1.4 KB)
• 6. Review of Section.html (0.7 KB)

• 1. Mac OS X - Quick Note.html (0.7 KB)
• 2. Mac OS Installation.mp4 (51.3 MB)
• 2. Mac OS Installation.srt (11.0 KB)
• 2.1 dvdrental.zip.zip (538.5 KB)
• 3. Mac Sample Database Download.html (1.7 KB)
• 3.1 Database_Schema.png.png (190.8 KB)
• 3.2 dvdrental.zip.zip (538.5 KB)
• 4. Mac Database Set-up.mp4 (108.7 MB)
• 4. Mac Database Set-up.srt (20.3 KB)
• 5. Review of Set-up.html (1.2 KB)
• 6. Windows - Quick Note.html (0.9 KB)
• 7. Windows Installation.mp4 (37.9 MB)
• 7. Windows Installation.srt (8.0 KB)
• 7.1 dvdrental.zip.zip (538.5 KB)
• 7.2 Database_Schema.png.png (190.8 KB)
• 8. Sample Database Download.html (0.9 KB)
• 8.1 dvdrental.zip.zip (538.5 KB)
• 8.2 Database_Schema.png.png (190.8 KB)
• 9. Windows Command Line Installation Lecture.mp4 (169.8 MB)
• 9. Windows Command Line Installation Lecture.srt (36.2 KB)

• 1. Bonus Lecture.html (0.5 KB)

• 1. Overview of Challenges!.mp4 (8.7 MB)
• 1. Overview of Challenges!.srt (3.6 KB)
• 10. SELECT WHERE - Part Two.mp4 (47.8 MB)
• 10. SELECT WHERE - Part Two.srt (10.6 KB)
• 11. Challenge SELECT WHERE.mp4 (23.0 MB)
• 11. Challenge SELECT WHERE.srt (8.8 KB)
• 12. ORDER BY.mp4 (48.7 MB)
• 12. ORDER BY.srt (13.3 KB)
• 13. LIMIT.mp4 (33.0 MB)
• 13. LIMIT.srt (8.1 KB)
• 14. Challenge ORDER BY.mp4 (19.8 MB)
• 14. Challenge ORDER BY.srt (8.2 KB)
• 15. BETWEEN.mp4 (36.3 MB)
• 15. BETWEEN.srt (10.3 KB)
• 16. IN.mp4 (23.0 MB)
• 16. IN.srt (7.3 KB)
• 17. LIKE and ILIKE.mp4 (50.9 MB)
• 17. LIKE and ILIKE.srt (15.0 KB)
• 18. General Challenge 1.mp4 (27.5 MB)
• 18. General Challenge 1.srt (20.2 KB)
• 18.1 general challenge 1.pptx.pptx (53.1 KB)
• 2. SQL Cheat Sheet.html (0.4 KB)
• 2.1 Screen Shot 2016-04-17 at 12.22.49 PM.png.png (1.0 MB)
• 3. SQL Statement Fundamentals.mp4 (3.2 MB)
• 3. SQL Statement Fundamentals.srt (1.5 KB)
• 4. SELECT Statement.mp4 (44.4 MB)
• 4. SELECT Statement.srt (14.0 KB)
• 5. Challenge SELECT.mp4 (20.4 MB)
• 5. Challenge SELECT.srt (7.9 KB)
• 6. SELECT DISTINCT.mp4 (30.3 MB)
• 6. SELECT DISTINCT.srt (8.8 KB)
• 7. Challenge SELECT DISTINCT.mp4 (7.1 MB)
• 7. Challenge SELECT DISTINCT.srt (2.8 KB)
• 8. COUNT.mp4 (37.5 MB)
• 8. COUNT.srt (11.8 KB)
• 9. SELECT WHERE - Part One.mp4 (15.3 MB)
• 9. SELECT WHERE - Part One.srt (7.2 KB)

• 1. Introduction to GROUP BY.mp4 (5.0 MB)
• 1. Introduction to GROUP BY.srt (1.4 KB)
• 2. Aggregation Functions.mp4 (48.9 MB)
• 2. Aggregation Functions.srt (13.3 KB)
• 3. GROUP BY - Part One.mp4 (32.8 MB)
• 3. GROUP BY - Part One.srt (12.1 KB)
• 4. GROUP BY - Part Two.mp4 (65.7 MB)
• 4. GROUP BY - Part Two.srt (16.0 KB)
• 5. GROUP BY - Challenge.mp4 (16.0 MB)
• 5. GROUP BY - Challenge.srt (6.6 KB)
• 6. HAVING.mp4 (36.5 MB)
• 6. HAVING.srt (9.3 KB)
• 7. HAVING - Challenge Tasks.mp4 (11.1 MB)
• 7. HAVING - Challenge Tasks.srt (4.6 KB)

• 1. Overview of Assessment Test 1.mp4 (3.9 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.6 KB)

• 1. Overview of JOINS.html (0.8 KB)
• 2. AS Statement.mp4 (23.9 MB)
• 2. AS Statement.srt (7.0 KB)
• 3. Overview of Inner Join.mp4 (158.7 MB)
• 3. Overview of Inner Join.srt (38.7 KB)
• 4. Examples of Inner Joins.mp4 (134.9 MB)
• 4. Examples of Inner Joins.srt (29.4 KB)
• 5. Overview of Join types.mp4 (68.8 MB)
• 5. Overview of Join types.srt (25.9 KB)
• 5.1 JOINS Overview 2.pptx.pptx (440.9 KB)
• 6. Example of Outer Joins.mp4 (84.1 MB)
• 6. Example of Outer Joins.srt (24.0 KB)
• 7. Union.mp4 (30.2 MB)
• 7. Union.srt (12.9 KB)
• 8. Join Challenges.html (0.5 KB)

• 1. Overview of Advanced SQL Commands.html (0.9 KB)
• 2. Timestamps and Extract.mp4 (68.5 MB)
• 2. Timestamps and Extract.srt (17.6 KB)
• 3. Mathematical Functions.mp4 (49.0 MB)
• 3. Mathematical Functions.srt (13.3 KB)
• 4. String Function and Operators.mp4 (60.3 MB)
• 4. String Function and Operators.srt (15.0 KB)
• 5. SubQuery.mp4 (98.6 MB)
• 5. SubQuery.srt (27.6 KB)
• 6. Self-Join.mp4 (95.6 MB)
• 6. Self-Join.srt (26.9 KB)

• 1. Assessment Test 2 Overview.mp4 (55.9 MB)
• 1. Assessment Test 2 Overview.srt (12.4 KB)
• 1.1 exercises.tar.tar (32.9 KB)
• 2. Assessment Test 2.html (2.9 KB)
• 3. Solutions to Assessment Test 2.html (1.7 KB)

• 1. Overview of Section.mp4 (15.9 MB)
• 1. Overview of Section.srt (7.0 KB)
• 10. Update.mp4 (59.7 MB)
• 10. Update.srt (19.1 KB)
• 11. Delete.mp4 (24.4 MB)
• 11. Delete.srt (9.2 KB)
• 12. Alter Table.mp4 (32.2 MB)
• 12. Alter Table.srt (12.5 KB)
• 13. Drop Table.mp4 (27.0 MB)
• 13. Drop Table.srt (10.2 KB)
• 14. CHECK Constraint.mp4 (55.3 MB)
• 14. CHECK Constraint.srt (17.2 KB)
• 15. NOT NULL Constraint.mp4 (31.5 MB)
• 15. NOT NULL Constraint.srt (13.7 KB)
• 16. UNIQUE Constraint.mp4 (26.8 MB)
• 16. UNIQUE Constraint.srt (9.0 KB)
• 2. Data Types.mp4 (42.2 MB)
• 2. Data Types.srt (14.5 KB)
• 3. Primary Keys and Foreign Keys.mp4 (49.7 MB)
• 3. Primary Keys and Foreign Keys.srt (19.4 KB)
• 4. Resource for Create Table Code.html (1.4 KB)
• 5. Note on Constraints.html (0.6 KB)
• 6. Create Table.mp4 (134.1 MB)
• 6. Create Table.srt (42.6 KB)
• 7. Challenge Create Table.html (0.6 KB)
• 8. Challenge Create Table - SOLUTION.mp4 (33.9 MB)
• 8. Challenge Create Table - SOLUTION.srt (11.9 KB)
• 9. Insert.mp4 (89.5 MB)
• 9. Insert.srt (32.2 KB)

• 1. Assessment Test 3.html (2.0 KB)
• 2. Solutions to Assessment Test 3.html (1.3 KB)

• [GigaCourse.com].url (0.0 KB)