|
|
01. The Reason Databases Exist.mp4
|
MP4
|
32.2 MB
|
|
|
01. The Reason Databases Exist.vtt
|
VTT
|
6.6 KB
|
|
|
02. The Evolution of Relational Database Management Systems.mp4
|
MP4
|
18.6 MB
|
|
|
02. The Evolution of Relational Database Management Systems.vtt
|
VTT
|
3.6 KB
|
|
|
03. The Point of Every Database.mp4
|
MP4
|
12.7 MB
|
|
|
03. The Point of Every Database.vtt
|
VTT
|
2.6 KB
|
|
|
04. Entities and Tables.mp4
|
MP4
|
33.9 MB
|
|
|
04. Entities and Tables.vtt
|
VTT
|
5.5 KB
|
|
|
05. Rows and Columns.mp4
|
MP4
|
22 MB
|
|
|
05. Rows and Columns.vtt
|
VTT
|
4.2 KB
|
|
|
06. The Importance of Data Types.mp4
|
MP4
|
24.8 MB
|
|
|
06. The Importance of Data Types.vtt
|
VTT
|
7.2 KB
|
|
|
07. Dealing with NULL Values.mp4
|
MP4
|
9.3 MB
|
|
|
07. Dealing with NULL Values.vtt
|
VTT
|
2.1 KB
|
|
|
08. Primary Keys.mp4
|
MP4
|
15.2 MB
|
|
|
08. Primary Keys.vtt
|
VTT
|
3.7 KB
|
|
|
09. Foreign Keys and Relationships.mp4
|
MP4
|
10 MB
|
|
|
09. Foreign Keys and Relationships.vtt
|
VTT
|
3.1 KB
|
|
|
1. Creating a Subquery.mp4
|
MP4
|
16.8 MB
|
|
|
1. Creating a Subquery.vtt
|
VTT
|
5.2 KB
|
|
|
1. How to INSERT New Data.mp4
|
MP4
|
13.9 MB
|
|
|
1. How to INSERT New Data.vtt
|
VTT
|
4.1 KB
|
|
|
1. How to JOIN Tables in a Query.mp4
|
MP4
|
29.4 MB
|
|
|
1. How to JOIN Tables in a Query.vtt
|
VTT
|
8.7 KB
|
|
|
1. Introduction.mp4
|
MP4
|
42.7 MB
|
|
|
1. Introduction.vtt
|
VTT
|
6.8 KB
|
|
|
1. Sorting Results with ORDER BY.mp4
|
MP4
|
6.8 MB
|
|
|
1. Sorting Results with ORDER BY.vtt
|
VTT
|
2.3 KB
|
|
|
1. The SQL SELECT Statement.mp4
|
MP4
|
14.7 MB
|
|
|
1. The SQL SELECT Statement.vtt
|
VTT
|
4.2 KB
|
|
|
1. Understanding DML, DDL, and DCL.mp4
|
MP4
|
52.5 MB
|
|
|
1. Understanding DML, DDL, and DCL.vtt
|
VTT
|
9.7 KB
|
|
|
10. Database Naming Conventions.mp4
|
MP4
|
23.9 MB
|
|
|
10. Database Naming Conventions.vtt
|
VTT
|
4.8 KB
|
|
|
2. Before You Write Any SQL.mp4
|
MP4
|
28.9 MB
|
|
|
2. Before You Write Any SQL.vtt
|
VTT
|
5.3 KB
|
|
|
2. How to UPDATE Data.mp4
|
MP4
|
9 MB
|
|
|
2. How to UPDATE Data.vtt
|
VTT
|
2.8 KB
|
|
|
2. SQL and Generative AI.mp4
|
MP4
|
32.5 MB
|
|
|
2. SQL and Generative AI.vtt
|
VTT
|
6.7 KB
|
|
|
2. Sidebar - Where Do You Write SQL.mp4
|
MP4
|
36.6 MB
|
|
|
2. Sidebar - Where Do You Write SQL.vtt
|
VTT
|
6.8 KB
|
|
|
2. The Power of Aggregate Functions.mp4
|
MP4
|
29.1 MB
|
|
|
2. The Power of Aggregate Functions.vtt
|
VTT
|
7.4 KB
|
|
|
2. Using Column Aliases with AS.mp4
|
MP4
|
12.1 MB
|
|
|
2. Using Column Aliases with AS.vtt
|
VTT
|
3.8 KB
|
|
|
2. Using OUTER JOINs β LEFT, RIGHT, and FULL.mp4
|
MP4
|
21 MB
|
|
|
2. Using OUTER JOINs β LEFT, RIGHT, and FULL.vtt
|
VTT
|
6.6 KB
|
|
|
3. Combining Data with UNION and UNION ALL.mp4
|
MP4
|
20.7 MB
|
|
|
3. Combining Data with UNION and UNION ALL.vtt
|
VTT
|
5.3 KB
|
|
|
3. Filtering Data Using WHERE.mp4
|
MP4
|
24.7 MB
|
|
|
3. Filtering Data Using WHERE.vtt
|
VTT
|
6.5 KB
|
|
|
3. How to Delete Rows from a Table.mp4
|
MP4
|
12 MB
|
|
|
3. How to Delete Rows from a Table.vtt
|
VTT
|
3.1 KB
|
|
|
3. Sidebar - SQL vs. [Sequel].mp4
|
MP4
|
17.2 MB
|
|
|
3. Sidebar - SQL vs. [Sequel].vtt
|
VTT
|
2.9 KB
|
|
|
3. Summarizing Data with GROUP BY.mp4
|
MP4
|
23.3 MB
|
|
|
3. Summarizing Data with GROUP BY.vtt
|
VTT
|
5.4 KB
|
|
|
3. Using NATURAL JOIN.mp4
|
MP4
|
17.1 MB
|
|
|
3. Using NATURAL JOIN.vtt
|
VTT
|
4.1 KB
|
|
|
3. Where to Go from Here.mp4
|
MP4
|
21 MB
|
|
|
3. Where to Go from Here.vtt
|
VTT
|
3.9 KB
|
|
|
4. Creating More Complex WHERE Conditions.mp4
|
MP4
|
23.8 MB
|
|
|
4. Creating More Complex WHERE Conditions.vtt
|
VTT
|
7.2 KB
|
|
|
4. Sidebar - UNION vs. JOIN.mp4
|
MP4
|
8.7 MB
|
|
|
4. Sidebar - UNION vs. JOIN.vtt
|
VTT
|
2.1 KB
|
|
|
4. Table Aliases in SQL.mp4
|
MP4
|
12.6 MB
|
|
|
4. Table Aliases in SQL.vtt
|
VTT
|
4.1 KB
|
|
|
4. Using GROUP BY and HAVING.mp4
|
MP4
|
16.5 MB
|
|
|
4. Using GROUP BY and HAVING.vtt
|
VTT
|
4.1 KB
|
|
|
5. Ignoring Duplicate Values with DISTINCT.mp4
|
MP4
|
13.4 MB
|
|
|
5. Ignoring Duplicate Values with DISTINCT.vtt
|
VTT
|
3 KB
|
|
|
5. Searching Multiple Values with BETWEEN and IN.mp4
|
MP4
|
17.1 MB
|
|
|
5. Searching Multiple Values with BETWEEN and IN.vtt
|
VTT
|
5.5 KB
|
|
|
6. Improving Your SQL Thinking.mp4
|
MP4
|
34.5 MB
|
|
|
6. Improving Your SQL Thinking.vtt
|
VTT
|
6.7 KB
|
|
|
6. Sidebar - Is SQL Case Sensitive.mp4
|
MP4
|
18.1 MB
|
|
|
6. Sidebar - Is SQL Case Sensitive.vtt
|
VTT
|
5 KB
|
|
|
7. Sidebar - SQL and Whitespace.mp4
|
MP4
|
11.3 MB
|
|
|
7. Sidebar - SQL and Whitespace.vtt
|
VTT
|
2.8 KB
|
|
|
8. Using LIKE to Match Patterns.mp4
|
MP4
|
18.4 MB
|
|
|
8. Using LIKE to Match Patterns.vtt
|
VTT
|
5.3 KB
|
|
|
9. Using NULL in a SELECT Statement.mp4
|
MP4
|
8 MB
|
|
|
9. Using NULL in a SELECT Statement.vtt
|
VTT
|
2.2 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
adding-updating-and-deleting-data-slides.pdf
|
PDF
|
1.6 MB
|
|
|
additional-topics-slides.pdf
|
PDF
|
5.7 MB
|
|
|
database-fundamentals-slides.pdf
|
PDF
|
18.9 MB
|
|
|
how-to-join-tables-slides.pdf
|
PDF
|
4 MB
|
|
|
ordering-grouping-and-aggregate-functions-slides.pdf
|
PDF
|
5.9 MB
|
|
|
playlist.m3u
|
M3U
|
2.6 KB
|
|
|
subqueries-and-sets-slides.pdf
|
PDF
|
5.6 MB
|
|
|
writing-sql-queries-slides.pdf
|
PDF
|
17.5 MB
|