|
|
1. Assessment Test 2 Overview.mp4
|
MP4
|
55.9 MB
|
|
|
1. Assessment Test 2 Overview.vtt
|
VTT
|
11.3 KB
|
|
|
1. Assessment Test 3.html
|
HTML
|
2 KB
|
|
|
1. Bonus Lecture Coupons.html
|
HTML
|
5.8 KB
|
|
|
1. Databases and Tables Overview.mp4
|
MP4
|
5.7 MB
|
|
|
1. Databases and Tables Overview.vtt
|
VTT
|
2.2 KB
|
|
|
1. Introduction.mp4
|
MP4
|
13.7 MB
|
|
|
1. Introduction.vtt
|
VTT
|
4.4 KB
|
|
|
1. MIN MAX SUM and AVG.mp4
|
MP4
|
37.9 MB
|
|
|
1. MIN MAX SUM and AVG.vtt
|
VTT
|
14.7 KB
|
|
|
1. Mac OS X - Quick Note.html
|
HTML
|
716.8 B
|
|
|
1. Overview of Advanced SQL Commands.html
|
HTML
|
921.6 B
|
|
|
1. Overview of Assessment Test 1.mp4
|
MP4
|
3.9 MB
|
|
|
1. Overview of Assessment Test 1.vtt
|
VTT
|
2.4 KB
|
|
|
1. Overview of Challenges!.mp4
|
MP4
|
8.7 MB
|
|
|
1. Overview of Challenges!.vtt
|
VTT
|
3.3 KB
|
|
|
1. Overview of JOINS.html
|
HTML
|
819.2 B
|
|
|
1. Overview of Python and PostgreSQL.html
|
HTML
|
1 KB
|
|
|
1. Overview of Section.mp4
|
MP4
|
15.9 MB
|
|
|
1. Overview of Section.vtt
|
VTT
|
6.4 KB
|
|
|
1. Views.mp4
|
MP4
|
61 MB
|
|
|
1. Views.vtt
|
VTT
|
13.3 KB
|
|
|
1.1 Pgsql with Python.py.py
|
PY
|
5.4 KB
|
|
|
1.1 exercises.zip.zip
|
ZIP
|
26.5 KB
|
|
|
1.2 exercises.tar.tar
|
TAR
|
32.9 KB
|
|
|
10. COUNT.mp4
|
MP4
|
28 MB
|
|
|
10. COUNT.vtt
|
VTT
|
8.2 KB
|
|
|
10. Update.mp4
|
MP4
|
59.8 MB
|
|
|
10. Update.vtt
|
VTT
|
17.3 KB
|
|
|
11. Delete.mp4
|
MP4
|
24.4 MB
|
|
|
11. Delete.vtt
|
VTT
|
8.3 KB
|
|
|
11. LIMIT.mp4
|
MP4
|
25.9 MB
|
|
|
11. LIMIT.vtt
|
VTT
|
5.8 KB
|
|
|
12. Alter Table.mp4
|
MP4
|
32.2 MB
|
|
|
12. Alter Table.vtt
|
VTT
|
11.3 KB
|
|
|
12. ORDER BY.mp4
|
MP4
|
79 MB
|
|
|
12. ORDER BY.vtt
|
VTT
|
17.5 KB
|
|
|
13. Challenge ORDER BY.mp4
|
MP4
|
10.1 MB
|
|
|
13. Challenge ORDER BY.vtt
|
VTT
|
6.7 KB
|
|
|
13. Drop Table.mp4
|
MP4
|
27 MB
|
|
|
13. Drop Table.vtt
|
VTT
|
9.3 KB
|
|
|
14. BETWEEN.mp4
|
MP4
|
54.6 MB
|
|
|
14. BETWEEN.vtt
|
VTT
|
14.3 KB
|
|
|
14. CHECK Constraint.mp4
|
MP4
|
55.3 MB
|
|
|
14. CHECK Constraint.vtt
|
VTT
|
15.6 KB
|
|
|
15. IN.mp4
|
MP4
|
55.9 MB
|
|
|
15. IN.vtt
|
VTT
|
13.2 KB
|
|
|
15. NOT NULL Constraint.mp4
|
MP4
|
31.5 MB
|
|
|
15. NOT NULL Constraint.vtt
|
VTT
|
12.3 KB
|
|
|
16. LIKE.mp4
|
MP4
|
62 MB
|
|
|
16. LIKE.vtt
|
VTT
|
16.6 KB
|
|
|
16. UNIQUE Constraint.mp4
|
MP4
|
26.8 MB
|
|
|
16. UNIQUE Constraint.vtt
|
VTT
|
8.2 KB
|
|
|
17. General Challenge 1.mp4
|
MP4
|
27.5 MB
|
|
|
17. General Challenge 1.vtt
|
VTT
|
18.3 KB
|
|
|
17.1 general challenge 1.pptx.pptx
|
PPTX
|
53.1 KB
|
|
|
2. AS Statement.mp4
|
MP4
|
23.9 MB
|
|
|
2. AS Statement.vtt
|
VTT
|
6.4 KB
|
|
|
2. Assessment Test 1.html
|
HTML
|
716.8 B
|
|
|
2. Assessment Test 2.html
|
HTML
|
2.9 KB
|
|
|
2. Course Curriculum Overview.mp4
|
MP4
|
13.6 MB
|
|
|
2. Course Curriculum Overview.vtt
|
VTT
|
3.4 KB
|
|
|
2. Creating and Restoring a Database.mp4
|
MP4
|
46 MB
|
|
|
2. Creating and Restoring a Database.vtt
|
VTT
|
11 KB
|
|
|
2. Data Types.mp4
|
MP4
|
42.2 MB
|
|
|
2. Data Types.vtt
|
VTT
|
13.2 KB
|
|
|
2. GROUP BY.mp4
|
MP4
|
103.4 MB
|
|
|
2. GROUP BY.vtt
|
VTT
|
30.1 KB
|
|
|
2. Mac OS Installation.mp4
|
MP4
|
51.3 MB
|
|
|
2. Mac OS Installation.vtt
|
VTT
|
9.9 KB
|
|
|
2. Psycopg2 Example Usage.mp4
|
MP4
|
70.1 MB
|
|
|
2. Psycopg2 Example Usage.vtt
|
VTT
|
16.8 KB
|
|
|
2. SQL Cheat Sheet.html
|
HTML
|
409.6 B
|
|
|
2. Solutions to Assessment Test 3.html
|
HTML
|
1.3 KB
|
|
|
2. Timestamps and Extract.mp4
|
MP4
|
68.5 MB
|
|
|
2. Timestamps and Extract.vtt
|
VTT
|
15.9 KB
|
|
|
2.1 Pgsql with Python.py.py
|
PY
|
5.4 KB
|
|
|
2.1 Screen Shot 2016-04-17 at 12.22.49 PM.png.png
|
PNG
|
1 MB
|
|
|
2.1 dvdrental.zip.zip
|
ZIP
|
538.5 KB
|
|
|
3. Challenge Restore a Database!.mp4
|
MP4
|
2.4 MB
|
|
|
3. Challenge Restore a Database!.vtt
|
VTT
|
1.4 KB
|
|
|
3. ChallengeGROUP BY.mp4
|
MP4
|
56.7 MB
|
|
|
3. ChallengeGROUP BY.vtt
|
VTT
|
24 KB
|
|
|
3. Mac Sample Database Download.html
|
HTML
|
1.7 KB
|
|
|
3. Mathematical Functions.mp4
|
MP4
|
49 MB
|
|
|
3. Mathematical Functions.vtt
|
VTT
|
12.1 KB
|
|
|
3. Overview of Databases.mp4
|
MP4
|
45.5 MB
|
|
|
3. Overview of Databases.vtt
|
VTT
|
13.9 KB
|
|
|
3. Overview of Inner Join.mp4
|
MP4
|
158.7 MB
|
|
|
3. Overview of Inner Join.vtt
|
VTT
|
34.6 KB
|
|
|
3. Primary Keys and Foreign Keys.mp4
|
MP4
|
49.7 MB
|
|
|
3. Primary Keys and Foreign Keys.vtt
|
VTT
|
17.5 KB
|
|
|
3. Psycopg2 Resources.html
|
HTML
|
409.6 B
|
|
|
3. SQL Statement Fundamentals.mp4
|
MP4
|
3.2 MB
|
|
|
3. SQL Statement Fundamentals.vtt
|
VTT
|
1.4 KB
|
|
|
3. Solutions to Assessment Test 1.html
|
HTML
|
614.4 B
|
|
|
3. Solutions to Assessment Test 2.html
|
HTML
|
1.7 KB
|
|
|
3.1 Database_Schema.png.png
|
PNG
|
190.8 KB
|
|
|
3.1 Pgsql with Python.py.py
|
PY
|
5.4 KB
|
|
|
3.2 dvdrental.zip.zip
|
ZIP
|
538.5 KB
|
|
|
4. Course FAQs.html
|
HTML
|
2.7 KB
|
|
|
4. Examples of Inner Joins.mp4
|
MP4
|
134.9 MB
|
|
|
4. Examples of Inner Joins.vtt
|
VTT
|
26.6 KB
|
|
|
4. HAVING.mp4
|
MP4
|
59.6 MB
|
|
|
4. HAVING.vtt
|
VTT
|
17.6 KB
|
|
|
4. Mac Database Set-up.mp4
|
MP4
|
108.7 MB
|
|
|
4. Mac Database Set-up.vtt
|
VTT
|
18.4 KB
|
|
|
4. Resource for Create Table Code.html
|
HTML
|
1.4 KB
|
|
|
4. Restoring a Table Schema.mp4
|
MP4
|
51.8 MB
|
|
|
4. Restoring a Table Schema.vtt
|
VTT
|
10.9 KB
|
|
|
4. SELECT Statement.mp4
|
MP4
|
67.4 MB
|
|
|
4. SELECT Statement.vtt
|
VTT
|
20.6 KB
|
|
|
4. String Function and Operators.mp4
|
MP4
|
60.3 MB
|
|
|
4. String Function and Operators.vtt
|
VTT
|
13.6 KB
|
|
|
4.1 SQLNotes.pdf.pdf
|
PDF
|
292.1 KB
|
|
|
4.2 PostgreSQL-Sample-Database.png.png
|
PNG
|
163.6 KB
|
|
|
5. Challenge Restore a Table Schema!.mp4
|
MP4
|
2.7 MB
|
|
|
5. Challenge Restore a Table Schema!.vtt
|
VTT
|
1.3 KB
|
|
|
5. Challenge SELECT task..mp4
|
MP4
|
7.9 MB
|
|
|
5. Challenge SELECT task..vtt
|
VTT
|
5.4 KB
|
|
|
5. Note on Constraints.html
|
HTML
|
614.4 B
|
|
|
5. Overview of Join types.mp4
|
MP4
|
68.8 MB
|
|
|
5. Overview of Join types.vtt
|
VTT
|
23.3 KB
|
|
|
5. Quick Note.html
|
HTML
|
307.2 B
|
|
|
5. Review of Set-up.html
|
HTML
|
1.2 KB
|
|
|
5. SubQuery.mp4
|
MP4
|
98.6 MB
|
|
|
5. SubQuery.vtt
|
VTT
|
24.8 KB
|
|
|
5. Time to get your Computer Set-Up!.html
|
HTML
|
1.4 KB
|
|
|
5.1 JOINS Overview 2.pptx.pptx
|
PPTX
|
440.9 KB
|
|
|
6. ChallengeHAVING.mp4
|
MP4
|
14.2 MB
|
|
|
6. ChallengeHAVING.vtt
|
VTT
|
7 KB
|
|
|
6. Create Table.mp4
|
MP4
|
134.1 MB
|
|
|
6. Create Table.vtt
|
VTT
|
38.2 KB
|
|
|
6. Example of Outer Joins.mp4
|
MP4
|
84.1 MB
|
|
|
6. Example of Outer Joins.vtt
|
VTT
|
21.6 KB
|
|
|
6. Review of Section.html
|
HTML
|
716.8 B
|
|
|
6. SELECT DISTINCT.mp4
|
MP4
|
42.5 MB
|
|
|
6. SELECT DISTINCT.vtt
|
VTT
|
9.3 KB
|
|
|
6. Self-Join.mp4
|
MP4
|
95.6 MB
|
|
|
6. Self-Join.vtt
|
VTT
|
24.2 KB
|
|
|
6. Setup and Installation of PgAdmin, PostGreSQL, and Database.mp4
|
MP4
|
188.8 MB
|
|
|
6. Setup and Installation of PgAdmin, PostGreSQL, and Database.vtt
|
VTT
|
35.9 KB
|
|
|
6. Windows - Quick Note.html
|
HTML
|
921.6 B
|
|
|
6.1 dvdrental.tar.tar
|
TAR
|
644.4 KB
|
|
|
7. Challenge Create Table.html
|
HTML
|
614.4 B
|
|
|
7. Challenge SELECT DISTINCT.mp4
|
MP4
|
6.4 MB
|
|
|
7. Challenge SELECT DISTINCT.vtt
|
VTT
|
4 KB
|
|
|
7. Installation Notes.html
|
HTML
|
307.2 B
|
|
|
7. Union.mp4
|
MP4
|
30.2 MB
|
|
|
7. Union.vtt
|
VTT
|
11.7 KB
|
|
|
7. Windows Installation.mp4
|
MP4
|
37.9 MB
|
|
|
7. Windows Installation.vtt
|
VTT
|
7.2 KB
|
|
|
7.1 Database_Schema.png.png
|
PNG
|
190.8 KB
|
|
|
7.2 dvdrental.zip.zip
|
ZIP
|
538.5 KB
|
|
|
8. Challenge Create Table - SOLUTION.mp4
|
MP4
|
33.9 MB
|
|
|
8. Challenge Create Table - SOLUTION.vtt
|
VTT
|
10.8 KB
|
|
|
8. Join Challenges.html
|
HTML
|
512 B
|
|
|
8. SELECT WHERE.mp4
|
MP4
|
101.4 MB
|
|
|
8. SELECT WHERE.vtt
|
VTT
|
26.4 KB
|
|
|
8. Sample Database Download.html
|
HTML
|
921.6 B
|
|
|
8.1 dvdrental.zip.zip
|
ZIP
|
538.5 KB
|
|
|
8.2 Database_Schema.png.png
|
PNG
|
190.8 KB
|
|
|
9. Challenge SELECT WHERE.mp4
|
MP4
|
15.6 MB
|
|
|
9. Challenge SELECT WHERE.vtt
|
VTT
|
6.9 KB
|
|
|
9. Insert.mp4
|
MP4
|
89.5 MB
|
|
|
9. Insert.vtt
|
VTT
|
28.7 KB
|
|
|
9. Windows Command Line Installation Lecture.mp4
|
MP4
|
169.8 MB
|
|
|
9. Windows Command Line Installation Lecture.vtt
|
VTT
|
32.7 KB
|
|
|
[FreeCourseLab.com].url
|
URL
|
102.4 B
|
