_FILE_ | Taille |
---|
1. Course Introduction/1. Introduction.mp4 | 13.70 MB |
1. Course Introduction/1. Introduction.vtt | 4.43 kB |
1. Course Introduction/2. Course Curriculum Overview.mp4 | 13.59 MB |
1. Course Introduction/2. Course Curriculum Overview.vtt | 3.36 kB |
1. Course Introduction/3. Overview of Databases.mp4 | 45.50 MB |
1. Course Introduction/3. Overview of Databases.vtt | 13.94 kB |
1. Course Introduction/4. Course FAQs.html | 2.68 kB |
1. Course Introduction/4.1 SQLNotes.pdf.pdf | 292.10 kB |
1. Course Introduction/4.2 PostgreSQL-Sample-Database.png.png | 163.60 kB |
1. Course Introduction/5. Time to get your Computer Set-Up!.html | 1.37 kB |
1. Course Introduction/6. Setup and Installation of PgAdmin, PostGreSQL, and Database.mp4 | 188.79 MB |
1. Course Introduction/6. Setup and Installation of PgAdmin, PostGreSQL, and Database.vtt | 35.86 kB |
1. Course Introduction/6.1 dvdrental.tar.tar | 644.37 kB |
1. Course Introduction/7. Installation Notes.html | 282.00 B |
10. Extra Views/1. Views.mp4 | 61.03 MB |
10. Extra Views/1. Views.vtt | 13.30 kB |
11. Extra PostGreSQL with Python/1. Overview of Python and PostgreSQL.html | 1.00 kB |
11. Extra PostGreSQL with Python/1.1 Pgsql with Python.py.py | 5.45 kB |
11. Extra PostGreSQL with Python/2. Psycopg2 Example Usage.mp4 | 70.08 MB |
11. Extra PostGreSQL with Python/2. Psycopg2 Example Usage.vtt | 16.79 kB |
11. Extra PostGreSQL with Python/2.1 Pgsql with Python.py.py | 5.45 kB |
11. Extra PostGreSQL with Python/3. Psycopg2 Resources.html | 373.00 B |
11. Extra PostGreSQL with Python/3.1 Pgsql with Python.py.py | 5.45 kB |
12. Databases and Tables/1. Databases and Tables Overview.mp4 | 5.70 MB |
12. Databases and Tables/1. Databases and Tables Overview.vtt | 2.19 kB |
12. Databases and Tables/2. Creating and Restoring a Database.mp4 | 46.00 MB |
12. Databases and Tables/2. Creating and Restoring a Database.vtt | 11.03 kB |
12. Databases and Tables/3. Challenge Restore a Database!.mp4 | 2.35 MB |
12. Databases and Tables/3. Challenge Restore a Database!.vtt | 1.40 kB |
12. Databases and Tables/4. Restoring a Table Schema.mp4 | 51.83 MB |
12. Databases and Tables/4. Restoring a Table Schema.vtt | 10.92 kB |
12. Databases and Tables/5. Challenge Restore a Table Schema!.mp4 | 2.73 MB |
12. Databases and Tables/5. Challenge Restore a Table Schema!.vtt | 1.33 kB |
12. Databases and Tables/6. Review of Section.html | 722.00 B |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/1. Mac OS X - Quick Note.html | 727.00 B |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/2. Mac OS Installation.mp4 | 51.31 MB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/2. Mac OS Installation.vtt | 9.91 kB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/2.1 dvdrental.zip.zip | 538.51 kB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/3. Mac Sample Database Download.html | 1.72 kB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/3.1 Database_Schema.png.png | 190.84 kB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/3.2 dvdrental.zip.zip | 538.51 kB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/4. Mac Database Set-up.mp4 | 108.71 MB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/4. Mac Database Set-up.vtt | 18.36 kB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/5. Review of Set-up.html | 1.22 kB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/6. Windows - Quick Note.html | 934.00 B |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/7. Windows Installation.mp4 | 37.85 MB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/7. Windows Installation.vtt | 7.25 kB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/7.1 Database_Schema.png.png | 190.84 kB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/7.2 dvdrental.zip.zip | 538.51 kB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/8. Sample Database Download.html | 916.00 B |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/8.1 dvdrental.zip.zip | 538.51 kB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/8.2 Database_Schema.png.png | 190.84 kB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/9. Windows Command Line Installation Lecture.mp4 | 169.77 MB |
13. Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)/9. Windows Command Line Installation Lecture.vtt | 32.72 kB |
14. BONUS DISCOUNT COUPONS FOR OTHER COURSES/1. Bonus Lecture Coupons.html | 5.79 kB |
2. SQL Statement Fundamentals/1. Overview of Challenges!.mp4 | 8.73 MB |
2. SQL Statement Fundamentals/1. Overview of Challenges!.vtt | 3.27 kB |
2. SQL Statement Fundamentals/10. COUNT.mp4 | 28.05 MB |
2. SQL Statement Fundamentals/10. COUNT.vtt | 8.20 kB |
2. SQL Statement Fundamentals/11. LIMIT.mp4 | 25.94 MB |
2. SQL Statement Fundamentals/11. LIMIT.vtt | 5.76 kB |
2. SQL Statement Fundamentals/12. ORDER BY.mp4 | 78.97 MB |
2. SQL Statement Fundamentals/12. ORDER BY.vtt | 17.51 kB |
2. SQL Statement Fundamentals/13. Challenge ORDER BY.mp4 | 10.08 MB |
2. SQL Statement Fundamentals/13. Challenge ORDER BY.vtt | 6.66 kB |
2. SQL Statement Fundamentals/14. BETWEEN.mp4 | 54.62 MB |
2. SQL Statement Fundamentals/14. BETWEEN.vtt | 14.34 kB |
2. SQL Statement Fundamentals/15. IN.mp4 | 55.94 MB |
2. SQL Statement Fundamentals/15. IN.vtt | 13.15 kB |
2. SQL Statement Fundamentals/16. LIKE.mp4 | 61.97 MB |
2. SQL Statement Fundamentals/16. LIKE.vtt | 16.56 kB |
2. SQL Statement Fundamentals/17. General Challenge 1.mp4 | 27.51 MB |
2. SQL Statement Fundamentals/17. General Challenge 1.vtt | 18.30 kB |
2. SQL Statement Fundamentals/17.1 general challenge 1.pptx.pptx | 53.15 kB |
2. SQL Statement Fundamentals/2. SQL Cheat Sheet.html | 440.00 B |
2. SQL Statement Fundamentals/2.1 Screen Shot 2016-04-17 at 12.22.49 PM.png.png | 1.04 MB |
2. SQL Statement Fundamentals/3. SQL Statement Fundamentals.mp4 | 3.20 MB |
2. SQL Statement Fundamentals/3. SQL Statement Fundamentals.vtt | 1.41 kB |
2. SQL Statement Fundamentals/4. SELECT Statement.mp4 | 67.40 MB |
2. SQL Statement Fundamentals/4. SELECT Statement.vtt | 20.56 kB |
2. SQL Statement Fundamentals/5. Challenge SELECT task..mp4 | 7.86 MB |
2. SQL Statement Fundamentals/5. Challenge SELECT task..vtt | 5.41 kB |
2. SQL Statement Fundamentals/6. SELECT DISTINCT.mp4 | 42.49 MB |
2. SQL Statement Fundamentals/6. SELECT DISTINCT.vtt | 9.26 kB |
2. SQL Statement Fundamentals/7. Challenge SELECT DISTINCT.mp4 | 6.38 MB |
2. SQL Statement Fundamentals/7. Challenge SELECT DISTINCT.vtt | 4.03 kB |
2. SQL Statement Fundamentals/8. SELECT WHERE.mp4 | 101.44 MB |
2. SQL Statement Fundamentals/8. SELECT WHERE.vtt | 26.43 kB |
2. SQL Statement Fundamentals/9. Challenge SELECT WHERE.mp4 | 15.58 MB |
2. SQL Statement Fundamentals/9. Challenge SELECT WHERE.vtt | 6.89 kB |
3. GROUP BY Statements/1. MIN MAX SUM and AVG.mp4 | 37.93 MB |
3. GROUP BY Statements/1. MIN MAX SUM and AVG.vtt | 14.67 kB |
3. GROUP BY Statements/2. GROUP BY.mp4 | 103.43 MB |
3. GROUP BY Statements/2. GROUP BY.vtt | 30.07 kB |
3. GROUP BY Statements/3. ChallengeGROUP BY.mp4 | 56.71 MB |
3. GROUP BY Statements/3. ChallengeGROUP BY.vtt | 24.04 kB |
3. GROUP BY Statements/4. HAVING.mp4 | 59.58 MB |
3. GROUP BY Statements/4. HAVING.vtt | 17.61 kB |
3. GROUP BY Statements/5. Quick Note.html | 313.00 B |
3. GROUP BY Statements/6. ChallengeHAVING.mp4 | 14.20 MB |
3. GROUP BY Statements/6. ChallengeHAVING.vtt | 7.00 kB |
4. Assessment Test 1/1. Overview of Assessment Test 1.mp4 | 3.86 MB |
4. Assessment Test 1/1. Overview of Assessment Test 1.vtt | 2.35 kB |
4. Assessment Test 1/2. Assessment Test 1.html | 690.00 B |
4. Assessment Test 1/3. Solutions to Assessment Test 1.html | 651.00 B |
5. JOINS/1. Overview of JOINS.html | 856.00 B |
5. JOINS/2. AS Statement.mp4 | 23.86 MB |
5. JOINS/2. AS Statement.vtt | 6.41 kB |
5. JOINS/3. Overview of Inner Join.mp4 | 158.69 MB |
5. JOINS/3. Overview of Inner Join.vtt | 34.63 kB |
5. JOINS/4. Examples of Inner Joins.mp4 | 134.89 MB |
5. JOINS/4. Examples of Inner Joins.vtt | 26.56 kB |
5. JOINS/5. Overview of Join types.mp4 | 68.82 MB |
5. JOINS/5. Overview of Join types.vtt | 23.33 kB |
5. JOINS/5.1 JOINS Overview 2.pptx.pptx | 440.89 kB |
5. JOINS/6. Example of Outer Joins.mp4 | 84.12 MB |
5. JOINS/6. Example of Outer Joins.vtt | 21.55 kB |
5. JOINS/7. Union.mp4 | 30.19 MB |
5. JOINS/7. Union.vtt | 11.69 kB |
5. JOINS/8. Join Challenges.html | 552.00 B |
6. Advanced SQL Commands/1. Overview of Advanced SQL Commands.html | 949.00 B |
6. Advanced SQL Commands/2. Timestamps and Extract.mp4 | 68.54 MB |
6. Advanced SQL Commands/2. Timestamps and Extract.vtt | 15.94 kB |
6. Advanced SQL Commands/3. Mathematical Functions.mp4 | 49.01 MB |
6. Advanced SQL Commands/3. Mathematical Functions.vtt | 12.06 kB |
6. Advanced SQL Commands/4. String Function and Operators.mp4 | 60.34 MB |
6. Advanced SQL Commands/4. String Function and Operators.vtt | 13.60 kB |
6. Advanced SQL Commands/5. SubQuery.mp4 | 98.62 MB |
6. Advanced SQL Commands/5. SubQuery.vtt | 24.82 kB |
6. Advanced SQL Commands/6. Self-Join.mp4 | 95.62 MB |
6. Advanced SQL Commands/6. Self-Join.vtt | 24.24 kB |
7. Assessment Test 2/1. Assessment Test 2 Overview.mp4 | 55.87 MB |
7. Assessment Test 2/1. Assessment Test 2 Overview.vtt | 11.25 kB |
7. Assessment Test 2/1.1 exercises.zip.zip | 26.46 kB |
7. Assessment Test 2/1.2 exercises.tar.tar | 32.89 kB |
7. Assessment Test 2/2. Assessment Test 2.html | 2.91 kB |
7. Assessment Test 2/3. Solutions to Assessment Test 2.html | 1.67 kB |
8. Creating Databases and Tables/1. Overview of Section.mp4 | 15.88 MB |
8. Creating Databases and Tables/1. Overview of Section.vtt | 6.41 kB |
8. Creating Databases and Tables/10. Update.mp4 | 59.75 MB |
8. Creating Databases and Tables/10. Update.vtt | 17.28 kB |
8. Creating Databases and Tables/11. Delete.mp4 | 24.38 MB |
8. Creating Databases and Tables/11. Delete.vtt | 8.32 kB |
8. Creating Databases and Tables/12. Alter Table.mp4 | 32.21 MB |
8. Creating Databases and Tables/12. Alter Table.vtt | 11.31 kB |
8. Creating Databases and Tables/13. Drop Table.mp4 | 26.98 MB |
8. Creating Databases and Tables/13. Drop Table.vtt | 9.29 kB |
8. Creating Databases and Tables/14. CHECK Constraint.mp4 | 55.32 MB |
8. Creating Databases and Tables/14. CHECK Constraint.vtt | 15.59 kB |
8. Creating Databases and Tables/15. NOT NULL Constraint.mp4 | 31.51 MB |
8. Creating Databases and Tables/15. NOT NULL Constraint.vtt | 12.30 kB |
8. Creating Databases and Tables/16. UNIQUE Constraint.mp4 | 26.80 MB |
8. Creating Databases and Tables/16. UNIQUE Constraint.vtt | 8.20 kB |
8. Creating Databases and Tables/2. Data Types.mp4 | 42.15 MB |
8. Creating Databases and Tables/2. Data Types.vtt | 13.18 kB |
8. Creating Databases and Tables/3. Primary Keys and Foreign Keys.mp4 | 49.72 MB |
8. Creating Databases and Tables/3. Primary Keys and Foreign Keys.vtt | 17.54 kB |
8. Creating Databases and Tables/4. Resource for Create Table Code.html | 1.42 kB |
8. Creating Databases and Tables/5. Note on Constraints.html | 571.00 B |
8. Creating Databases and Tables/6. Create Table.mp4 | 134.11 MB |
8. Creating Databases and Tables/6. Create Table.vtt | 38.23 kB |
8. Creating Databases and Tables/7. Challenge Create Table.html | 653.00 B |
8. Creating Databases and Tables/8. Challenge Create Table - SOLUTION.mp4 | 33.92 MB |
8. Creating Databases and Tables/8. Challenge Create Table - SOLUTION.vtt | 10.82 kB |
8. Creating Databases and Tables/9. Insert.mp4 | 89.52 MB |
8. Creating Databases and Tables/9. Insert.vtt | 28.70 kB |
9. Assessment Test 3/1. Assessment Test 3.html | 2.01 kB |
9. Assessment Test 3/2. Solutions to Assessment Test 3.html | 1.30 kB |
[FreeCourseLab.com].url | 126.00 B |