|
|
1. Assessment Test 2 Overview.mp4
|
MP4
|
55.9 MB
|
|
|
1. Assessment Test 2 Overview.srt
|
SRT
|
12.4 KB
|
|
|
1. Assessment Test 3.html
|
HTML
|
2 KB
|
|
|
1. Bonus Lecture.html
|
HTML
|
512 B
|
|
|
1. Databases and Tables Overview.mp4
|
MP4
|
5.7 MB
|
|
|
1. Databases and Tables Overview.srt
|
SRT
|
2.4 KB
|
|
|
1. Introduction to GROUP BY.mp4
|
MP4
|
5 MB
|
|
|
1. Introduction to GROUP BY.srt
|
SRT
|
1.4 KB
|
|
|
1. Introduction.mp4
|
MP4
|
13.7 MB
|
|
|
1. Introduction.srt
|
SRT
|
4.9 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.srt
|
SRT
|
2.6 KB
|
|
|
1. Overview of Challenges!.mp4
|
MP4
|
8.7 MB
|
|
|
1. Overview of Challenges!.srt
|
SRT
|
3.6 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.srt
|
SRT
|
7 KB
|
|
|
1. Views.mp4
|
MP4
|
61 MB
|
|
|
1. Views.srt
|
SRT
|
14.6 KB
|
|
|
1.1 Pgsql with Python.py.py
|
PY
|
5.4 KB
|
|
|
1.1 exercises.tar.tar
|
TAR
|
32.9 KB
|
|
|
10. SELECT WHERE - Part Two.mp4
|
MP4
|
47.8 MB
|
|
|
10. SELECT WHERE - Part Two.srt
|
SRT
|
10.6 KB
|
|
|
10. Update.mp4
|
MP4
|
59.7 MB
|
|
|
10. Update.srt
|
SRT
|
19.1 KB
|
|
|
11. Challenge SELECT WHERE.mp4
|
MP4
|
23 MB
|
|
|
11. Challenge SELECT WHERE.srt
|
SRT
|
8.8 KB
|
|
|
11. Delete.mp4
|
MP4
|
24.4 MB
|
|
|
11. Delete.srt
|
SRT
|
9.2 KB
|
|
|
12. Alter Table.mp4
|
MP4
|
32.2 MB
|
|
|
12. Alter Table.srt
|
SRT
|
12.5 KB
|
|
|
12. ORDER BY.mp4
|
MP4
|
48.7 MB
|
|
|
12. ORDER BY.srt
|
SRT
|
13.3 KB
|
|
|
13. Drop Table.mp4
|
MP4
|
27 MB
|
|
|
13. Drop Table.srt
|
SRT
|
10.2 KB
|
|
|
13. LIMIT.mp4
|
MP4
|
33 MB
|
|
|
13. LIMIT.srt
|
SRT
|
8.1 KB
|
|
|
14. CHECK Constraint.mp4
|
MP4
|
55.3 MB
|
|
|
14. CHECK Constraint.srt
|
SRT
|
17.2 KB
|
|
|
14. Challenge ORDER BY.mp4
|
MP4
|
19.8 MB
|
|
|
14. Challenge ORDER BY.srt
|
SRT
|
8.2 KB
|
|
|
15. BETWEEN.mp4
|
MP4
|
36.3 MB
|
|
|
15. BETWEEN.srt
|
SRT
|
10.3 KB
|
|
|
15. NOT NULL Constraint.mp4
|
MP4
|
31.5 MB
|
|
|
15. NOT NULL Constraint.srt
|
SRT
|
13.7 KB
|
|
|
16. IN.mp4
|
MP4
|
23 MB
|
|
|
16. IN.srt
|
SRT
|
7.3 KB
|
|
|
16. UNIQUE Constraint.mp4
|
MP4
|
26.8 MB
|
|
|
16. UNIQUE Constraint.srt
|
SRT
|
9 KB
|
|
|
17. LIKE and ILIKE.mp4
|
MP4
|
50.9 MB
|
|
|
17. LIKE and ILIKE.srt
|
SRT
|
15 KB
|
|
|
18. General Challenge 1.mp4
|
MP4
|
27.5 MB
|
|
|
18. General Challenge 1.srt
|
SRT
|
20.2 KB
|
|
|
18.1 general challenge 1.pptx.pptx
|
PPTX
|
53.1 KB
|
|
|
2. AS Statement.mp4
|
MP4
|
23.9 MB
|
|
|
2. AS Statement.srt
|
SRT
|
7 KB
|
|
|
2. Aggregation Functions.mp4
|
MP4
|
48.9 MB
|
|
|
2. Aggregation Functions.srt
|
SRT
|
13.3 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.srt
|
SRT
|
3.7 KB
|
|
|
2. Creating and Restoring a Database.mp4
|
MP4
|
46 MB
|
|
|
2. Creating and Restoring a Database.srt
|
SRT
|
12.2 KB
|
|
|
2. Data Types.mp4
|
MP4
|
42.2 MB
|
|
|
2. Data Types.srt
|
SRT
|
14.5 KB
|
|
|
2. Mac OS Installation.mp4
|
MP4
|
51.3 MB
|
|
|
2. Mac OS Installation.srt
|
SRT
|
11 KB
|
|
|
2. Psycopg2 Example Usage.mp4
|
MP4
|
70.1 MB
|
|
|
2. Psycopg2 Example Usage.srt
|
SRT
|
18.5 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.srt
|
SRT
|
17.6 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!.srt
|
SRT
|
1.5 KB
|
|
|
3. GROUP BY - Part One.mp4
|
MP4
|
32.8 MB
|
|
|
3. GROUP BY - Part One.srt
|
SRT
|
12.1 KB
|
|
|
3. Mac Sample Database Download.html
|
HTML
|
1.7 KB
|
|
|
3. Mathematical Functions.mp4
|
MP4
|
49 MB
|
|
|
3. Mathematical Functions.srt
|
SRT
|
13.3 KB
|
|
|
3. Overview of Databases.mp4
|
MP4
|
45.5 MB
|
|
|
3. Overview of Databases.srt
|
SRT
|
15.4 KB
|
|
|
3. Overview of Inner Join.mp4
|
MP4
|
158.7 MB
|
|
|
3. Overview of Inner Join.srt
|
SRT
|
38.7 KB
|
|
|
3. Primary Keys and Foreign Keys.mp4
|
MP4
|
49.7 MB
|
|
|
3. Primary Keys and Foreign Keys.srt
|
SRT
|
19.4 KB
|
|
|
3. Psycopg2 Resources.html
|
HTML
|
409.6 B
|
|
|
3. SQL Statement Fundamentals.mp4
|
MP4
|
3.2 MB
|
|
|
3. SQL Statement Fundamentals.srt
|
SRT
|
1.5 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.srt
|
SRT
|
29.4 KB
|
|
|
4. GROUP BY - Part Two.mp4
|
MP4
|
65.7 MB
|
|
|
4. GROUP BY - Part Two.srt
|
SRT
|
16 KB
|
|
|
4. Mac Database Set-up.mp4
|
MP4
|
108.7 MB
|
|
|
4. Mac Database Set-up.srt
|
SRT
|
20.3 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.srt
|
SRT
|
12.1 KB
|
|
|
4. SELECT Statement.mp4
|
MP4
|
44.4 MB
|
|
|
4. SELECT Statement.srt
|
SRT
|
14 KB
|
|
|
4. String Function and Operators.mp4
|
MP4
|
60.3 MB
|
|
|
4. String Function and Operators.srt
|
SRT
|
15 KB
|
|
|
4.1 PostgreSQL-Sample-Database.png.png
|
PNG
|
163.6 KB
|
|
|
4.2 SQLNotes.pdf.pdf
|
PDF
|
292.1 KB
|
|
|
5. Challenge Restore a Table Schema!.mp4
|
MP4
|
2.7 MB
|
|
|
5. Challenge Restore a Table Schema!.srt
|
SRT
|
1.4 KB
|
|
|
5. Challenge SELECT.mp4
|
MP4
|
20.4 MB
|
|
|
5. Challenge SELECT.srt
|
SRT
|
7.9 KB
|
|
|
5. GROUP BY - Challenge.mp4
|
MP4
|
16 MB
|
|
|
5. GROUP BY - Challenge.srt
|
SRT
|
6.6 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.srt
|
SRT
|
25.9 KB
|
|
|
5. Review of Set-up.html
|
HTML
|
1.2 KB
|
|
|
5. SubQuery.mp4
|
MP4
|
98.6 MB
|
|
|
5. SubQuery.srt
|
SRT
|
27.6 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. Create Table.mp4
|
MP4
|
134.1 MB
|
|
|
6. Create Table.srt
|
SRT
|
42.6 KB
|
|
|
6. Example of Outer Joins.mp4
|
MP4
|
84.1 MB
|
|
|
6. Example of Outer Joins.srt
|
SRT
|
24 KB
|
|
|
6. HAVING.mp4
|
MP4
|
36.5 MB
|
|
|
6. HAVING.srt
|
SRT
|
9.3 KB
|
|
|
6. Review of Section.html
|
HTML
|
716.8 B
|
|
|
6. SELECT DISTINCT.mp4
|
MP4
|
30.3 MB
|
|
|
6. SELECT DISTINCT.srt
|
SRT
|
8.8 KB
|
|
|
6. Self-Join.mp4
|
MP4
|
95.6 MB
|
|
|
6. Self-Join.srt
|
SRT
|
26.9 KB
|
|
|
6. Windows - Quick Note.html
|
HTML
|
921.6 B
|
|
|
6. Windows Installation - PostGreSQL and PgAdmin with Database Setup.mp4
|
MP4
|
148.1 MB
|
|
|
6. Windows Installation - PostGreSQL and PgAdmin with Database Setup.srt
|
SRT
|
36.2 KB
|
|
|
6.1 dvdrental.tar.tar
|
TAR
|
644.4 KB
|
|
|
7. Challenge Create Table.html
|
HTML
|
614.4 B
|
|
|
7. Challenge SELECT DISTINCT.mp4
|
MP4
|
7.1 MB
|
|
|
7. Challenge SELECT DISTINCT.srt
|
SRT
|
2.8 KB
|
|
|
7. HAVING - Challenge Tasks.mp4
|
MP4
|
11.1 MB
|
|
|
7. HAVING - Challenge Tasks.srt
|
SRT
|
4.6 KB
|
|
|
7. MacOS Installation - PostgreSQL and PgAdmin with First Query.mp4
|
MP4
|
172 MB
|
|
|
7. MacOS Installation - PostgreSQL and PgAdmin with First Query.srt
|
SRT
|
41.9 KB
|
|
|
7. Union.mp4
|
MP4
|
30.2 MB
|
|
|
7. Union.srt
|
SRT
|
12.9 KB
|
|
|
7. Windows Installation.mp4
|
MP4
|
37.9 MB
|
|
|
7. Windows Installation.srt
|
SRT
|
8 KB
|
|
|
7.1 dvdrental.tar.tar
|
TAR
|
644.4 KB
|
|
|
7.1 dvdrental.zip.zip
|
ZIP
|
538.5 KB
|
|
|
7.2 Database_Schema.png.png
|
PNG
|
190.8 KB
|
|
|
8. COUNT.mp4
|
MP4
|
37.5 MB
|
|
|
8. COUNT.srt
|
SRT
|
11.8 KB
|
|
|
8. Challenge Create Table - SOLUTION.mp4
|
MP4
|
33.9 MB
|
|
|
8. Challenge Create Table - SOLUTION.srt
|
SRT
|
11.9 KB
|
|
|
8. Join Challenges.html
|
HTML
|
512 B
|
|
|
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. Insert.mp4
|
MP4
|
89.5 MB
|
|
|
9. Insert.srt
|
SRT
|
32.2 KB
|
|
|
9. SELECT WHERE - Part One.mp4
|
MP4
|
15.3 MB
|
|
|
9. SELECT WHERE - Part One.srt
|
SRT
|
7.2 KB
|
|
|
9. Windows Command Line Installation Lecture.mp4
|
MP4
|
169.8 MB
|
|
|
9. Windows Command Line Installation Lecture.srt
|
SRT
|
36.2 KB
|
|
|
[GigaCourse.com].url
|
URL
|
0 B
|