|
|
1. Congratulations on Completing the Introduction to SQL Course.mp4
|
MP4
|
24.4 MB
|
|
|
1. Congratulations on Completing the Introduction to SQL Course.srt
|
SRT
|
1.5 KB
|
|
|
1. Create a New Database in MySQL.mp4
|
MP4
|
51.6 MB
|
|
|
1. Create a New Database in MySQL.srt
|
SRT
|
3.8 KB
|
|
|
1. Identify which Database by the USE statement.mp4
|
MP4
|
34.2 MB
|
|
|
1. Identify which Database by the USE statement.srt
|
SRT
|
2.5 KB
|
|
|
1. Installing MySQL on Windows.mp4
|
MP4
|
37.7 MB
|
|
|
1. Installing MySQL on Windows.srt
|
SRT
|
3 KB
|
|
|
1. SQL GROUP BY Syntax.mp4
|
MP4
|
18.1 MB
|
|
|
1. SQL GROUP BY Syntax.srt
|
SRT
|
4.8 KB
|
|
|
1. SQL INSERT INTO Statement Syntax.mp4
|
MP4
|
14 MB
|
|
|
1. SQL INSERT INTO Statement Syntax.srt
|
SRT
|
3.8 KB
|
|
|
1. SQL ORDER BY Keyword Syntax.mp4
|
MP4
|
9.3 MB
|
|
|
1. SQL ORDER BY Keyword Syntax.srt
|
SRT
|
2 KB
|
|
|
1. SQL Table JOIN Syntax.mp4
|
MP4
|
41.9 MB
|
|
|
1. SQL Table JOIN Syntax.srt
|
SRT
|
10.3 KB
|
|
|
1. SQL WHERE Clause Syntax.mp4
|
MP4
|
14 MB
|
|
|
1. SQL WHERE Clause Syntax.srt
|
SRT
|
3.2 KB
|
|
|
1. Welcome to the Introduction to MySQL Course.mp4
|
MP4
|
44.6 MB
|
|
|
1. Welcome to the Introduction to MySQL Course.srt
|
SRT
|
8.1 KB
|
|
|
1. What is SQL.mp4
|
MP4
|
10.7 MB
|
|
|
1. What is SQL.srt
|
SRT
|
2.6 KB
|
|
|
10. Exercise #5 - Creating a MySQL Table.html
|
HTML
|
819.2 B
|
|
|
10. Quiz #3 - SQL Where Clause Quiz.html
|
HTML
|
204.8 B
|
|
|
10.1 EX-05-COM-CREATE-TABLE-01.sql
|
SQL
|
204.8 B
|
|
|
11. Quiz #6 - Creating a SQL Database.html
|
HTML
|
204.8 B
|
|
|
2. Downloadable MySQL Course Resources.mp4
|
MP4
|
43.2 MB
|
|
|
2. Downloadable MySQL Course Resources.srt
|
SRT
|
3.2 KB
|
|
|
2. Filter Records based on Single Criteria using the WHERE Clause.mp4
|
MP4
|
46.8 MB
|
|
|
2. Filter Records based on Single Criteria using the WHERE Clause.srt
|
SRT
|
3.5 KB
|
|
|
2. Grouping SQL Data by a Column Value.mp4
|
MP4
|
40.8 MB
|
|
|
2. Grouping SQL Data by a Column Value.srt
|
SRT
|
2.9 KB
|
|
|
2. Inserting Data into Specific Columns of a Table.mp4
|
MP4
|
118.1 MB
|
|
|
2. Inserting Data into Specific Columns of a Table.srt
|
SRT
|
9.1 KB
|
|
|
2. Installing MySQL on Windows Continued.mp4
|
MP4
|
164.5 MB
|
|
|
2. Installing MySQL on Windows Continued.srt
|
SRT
|
14 KB
|
|
|
2. Introduction to Relational Database Design.mp4
|
MP4
|
43.7 MB
|
|
|
2. Introduction to Relational Database Design.srt
|
SRT
|
8.4 KB
|
|
|
2. SQL INNER JOIN.mp4
|
MP4
|
111.4 MB
|
|
|
2. SQL INNER JOIN.srt
|
SRT
|
8.1 KB
|
|
|
2. SQL SELECT Statement Syntax.mp4
|
MP4
|
10.7 MB
|
|
|
2. SQL SELECT Statement Syntax.srt
|
SRT
|
3 KB
|
|
|
2. Sort SQL Data AscendingDescending using the ORDER BY Keyword.mp4
|
MP4
|
52.6 MB
|
|
|
2. Sort SQL Data AscendingDescending using the ORDER BY Keyword.srt
|
SRT
|
4 KB
|
|
|
2. Using the DROP Statement to Delete a Database.mp4
|
MP4
|
33.9 MB
|
|
|
2. Using the DROP Statement to Delete a Database.srt
|
SRT
|
2.9 KB
|
|
|
3. Adding Tables to the Database using the CREATE TABLE Statement.mp4
|
MP4
|
113.1 MB
|
|
|
3. Adding Tables to the Database using the CREATE TABLE Statement.srt
|
SRT
|
8.4 KB
|
|
|
3. Filtering Text vs. Numeric Data.mp4
|
MP4
|
74.7 MB
|
|
|
3. Filtering Text vs. Numeric Data.srt
|
SRT
|
5.9 KB
|
|
|
3. Inserting Data into Every Column of a Table.mp4
|
MP4
|
96.3 MB
|
|
|
3. Inserting Data into Every Column of a Table.srt
|
SRT
|
7.7 KB
|
|
|
3. Introduction to MySQL Interface.mp4
|
MP4
|
130.9 MB
|
|
|
3. Introduction to MySQL Interface.srt
|
SRT
|
10.5 KB
|
|
|
3. QUICK TIP - DISTINCT VS. GROUP BY.mp4
|
MP4
|
100.5 MB
|
|
|
3. QUICK TIP - DISTINCT VS. GROUP BY.srt
|
SRT
|
7.3 KB
|
|
|
3. SQL LEFT and RIGHT JOIN.mp4
|
MP4
|
91.8 MB
|
|
|
3. SQL LEFT and RIGHT JOIN.srt
|
SRT
|
8 KB
|
|
|
3. Sort SQL Data by Multiple Columns.mp4
|
MP4
|
46.5 MB
|
|
|
3. Sort SQL Data by Multiple Columns.srt
|
SRT
|
3.6 KB
|
|
|
3. Using the SELECT Statement to Retrieve Columns from a Table.mp4
|
MP4
|
39.8 MB
|
|
|
3. Using the SELECT Statement to Retrieve Columns from a Table.srt
|
SRT
|
3.1 KB
|
|
|
3. Visit the Course QA Board.mp4
|
MP4
|
59.6 MB
|
|
|
3. Visit the Course QA Board.srt
|
SRT
|
4.9 KB
|
|
|
3. Why MySQL.mp4
|
MP4
|
6.7 MB
|
|
|
3. Why MySQL.srt
|
SRT
|
1.9 KB
|
|
|
4. CHEAT SHEET - Filter Operators used in the WHERE Clause (DOWNLOAD).html
|
HTML
|
307.2 B
|
|
|
4. Exercise #3 - SQL ORDER BY Keyword.html
|
HTML
|
819.2 B
|
|
|
4. Exercise #6 - Inserting Records.html
|
HTML
|
409.6 B
|
|
|
4. Performing Calculations within the Grouped Data.mp4
|
MP4
|
66.1 MB
|
|
|
4. Performing Calculations within the Grouped Data.srt
|
SRT
|
4.7 KB
|
|
|
4. QUICK TIP - Query All Columns from a Table.mp4
|
MP4
|
20.8 MB
|
|
|
4. QUICK TIP - Query All Columns from a Table.srt
|
SRT
|
1.7 KB
|
|
|
4. Quiz #1 - Introduction to MySQL Quiz.html
|
HTML
|
204.8 B
|
|
|
4. SQL IS NULL Value.mp4
|
MP4
|
69.6 MB
|
|
|
4. SQL IS NULL Value.srt
|
SRT
|
5.5 KB
|
|
|
4. Setting Up the MySQL Course Database.mp4
|
MP4
|
56 MB
|
|
|
4. Setting Up the MySQL Course Database.srt
|
SRT
|
4.7 KB
|
|
|
4. Using the DROP Statement to Delete a Table.mp4
|
MP4
|
27.5 MB
|
|
|
4. Using the DROP Statement to Delete a Table.srt
|
SRT
|
2.9 KB
|
|
|
4.1 EX-03-COM-ORDER-BY-01.sql
|
SQL
|
204.8 B
|
|
|
4.1 EX-06-COM-ADD-RECORDS-01.sql
|
SQL
|
307.2 B
|
|
|
4.1 Where-Operators-01.pptx
|
PPTX
|
675.7 KB
|
|
|
4.1 create_customers_db.sql
|
SQL
|
11.7 KB
|
|
|
5. CHEAT SHEET - MySQL Aggregate Functions when Grouping.mp4
|
MP4
|
29.8 MB
|
|
|
5. CHEAT SHEET - MySQL Aggregate Functions when Grouping.srt
|
SRT
|
2.3 KB
|
|
|
5. Exercise #7 - SQL Table JOIN.html
|
HTML
|
716.8 B
|
|
|
5. Filtering with SQL AND Operator.mp4
|
MP4
|
59.2 MB
|
|
|
5. Filtering with SQL AND Operator.srt
|
SRT
|
4.7 KB
|
|
|
5. Introduction to Course Database.mp4
|
MP4
|
61.8 MB
|
|
|
5. Introduction to Course Database.srt
|
SRT
|
4.8 KB
|
|
|
5. Quiz #4 - SQL ORDER BY Quiz.html
|
HTML
|
204.8 B
|
|
|
5. Quiz #7 - Inserting Records.html
|
HTML
|
204.8 B
|
|
|
5. SQL NOT NULL Constraint.mp4
|
MP4
|
29.7 MB
|
|
|
5. SQL NOT NULL Constraint.srt
|
SRT
|
2.4 KB
|
|
|
5. Using a Column Name Alias.mp4
|
MP4
|
70.9 MB
|
|
|
5. Using a Column Name Alias.srt
|
SRT
|
5.4 KB
|
|
|
6. Filtering Grouped Data with the SQL Having Clause.mp4
|
MP4
|
85.5 MB
|
|
|
6. Filtering Grouped Data with the SQL Having Clause.srt
|
SRT
|
5.9 KB
|
|
|
6. QUICK TIP - MySQL Comments.mp4
|
MP4
|
58.9 MB
|
|
|
6. QUICK TIP - MySQL Comments.srt
|
SRT
|
4.5 KB
|
|
|
6. Quiz #8 - SQL Table JOINS.html
|
HTML
|
204.8 B
|
|
|
6. Removing Duplicate Values by Using the DISTINCT Statement.mp4
|
MP4
|
43.5 MB
|
|
|
6. Removing Duplicate Values by Using the DISTINCT Statement.srt
|
SRT
|
2.9 KB
|
|
|
6. SQL AUTO_INCREMENT Column.mp4
|
MP4
|
23 MB
|
|
|
6. SQL AUTO_INCREMENT Column.srt
|
SRT
|
1.7 KB
|
|
|
7. Exercise #1 - SQL Select.html
|
HTML
|
614.4 B
|
|
|
7. Exercise #4 - SQL GROUP BY Quiz.html
|
HTML
|
819.2 B
|
|
|
7. Filtering Date Values with the Between Operator.mp4
|
MP4
|
126 MB
|
|
|
7. Filtering Date Values with the Between Operator.srt
|
SRT
|
9.9 KB
|
|
|
7. SQL PRIMARY KEY Constraint.mp4
|
MP4
|
53 MB
|
|
|
7. SQL PRIMARY KEY Constraint.srt
|
SRT
|
3.6 KB
|
|
|
7.1 EX-01-COM-SMIPLE-SELECT-01.sql
|
SQL
|
102.4 B
|
|
|
7.1 EX-04-COM-GROUP-BY-01.sql
|
SQL
|
102.4 B
|
|
|
8. Filtering with SQL OR Operator.mp4
|
MP4
|
82.9 MB
|
|
|
8. Filtering with SQL OR Operator.srt
|
SRT
|
5.9 KB
|
|
|
8. Quiz #2 - SQL SELECT Statement Quiz.html
|
HTML
|
204.8 B
|
|
|
8. Quiz #5 - SQL GROUP BY Quiz.html
|
HTML
|
204.8 B
|
|
|
8. RECAP - Table Relationships.mp4
|
MP4
|
15.5 MB
|
|
|
8. RECAP - Table Relationships.srt
|
SRT
|
4.7 KB
|
|
|
9. Exercise #2 - SQL WHERE Clause.html
|
HTML
|
819.2 B
|
|
|
9. SQL FOREIGN KEY Constraint.mp4
|
MP4
|
132.6 MB
|
|
|
9. SQL FOREIGN KEY Constraint.srt
|
SRT
|
9.1 KB
|
|
|
9.1 EX-02-COM-WHERE-CLAUSE-01.sql
|
SQL
|
512 B
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
