Filename | Size |
| 1. Introduction/1. Introduction to SQL Server and Databases.mp4 | 11.9 MB |
| 1. Introduction/1. Introduction to SQL Server and Databases.srt | 2.3 KB |
| 1. Introduction/1.1 Introduction sql server 2017.pptx | 468 KB |
| 1. Introduction/2. Download and Install SQL Server Express 2019 - Latest.mp4 | 29.5 MB |
| 1. Introduction/2. Download and Install SQL Server Express 2019 - Latest.srt | 7.1 KB |
| 1. Introduction/2.1 Download SQL Server Management Studio (SSMS).html | 166 B |
| 2. Manipulating Tables and Data/1. Connect to Database Instance and Create a Database.mp4 | 35.2 MB |
| 2. Manipulating Tables and Data/1. Connect to Database Instance and Create a Database.srt | 7.5 KB |
| 2. Manipulating Tables and Data/1.1 SSMS Shortcuts.pdf | 131.2 KB |
| 2. Manipulating Tables and Data/10. Update Data in the Table with Management Studio GUI.mp4 | 14.1 MB |
| 2. Manipulating Tables and Data/10. Update Data in the Table with Management Studio GUI.srt | 2.7 KB |
| 2. Manipulating Tables and Data/11. Delete Data from the Table with SQL Script.mp4 | 43.3 MB |
| 2. Manipulating Tables and Data/11. Delete Data from the Table with SQL Script.srt | 8.2 KB |
| 2. Manipulating Tables and Data/11.1 delete_students.sql | 341 B |
| 2. Manipulating Tables and Data/12. Delete Data from the Table with Management Studio GUI.mp4 | 8 MB |
| 2. Manipulating Tables and Data/12. Delete Data from the Table with Management Studio GUI.srt | 1.9 KB |
| 2. Manipulating Tables and Data/13. SQL Test.html | 189 B |
| 2. Manipulating Tables and Data/2. Drop or Remove Database.mp4 | 24.7 MB |
| 2. Manipulating Tables and Data/2. Drop or Remove Database.srt | 6 KB |
| 2. Manipulating Tables and Data/3. What is a Database Table.mp4 | 22.2 MB |
| 2. Manipulating Tables and Data/3. What is a Database Table.srt | 2.3 KB |
| 2. Manipulating Tables and Data/4. Create an SQL Database Table.mp4 | 208.9 MB |
| 2. Manipulating Tables and Data/4. Create an SQL Database Table.srt | 38.9 KB |
| 2. Manipulating Tables and Data/4.1 create_database_tables.sql | 741 B |
| 2. Manipulating Tables and Data/4.2 sql-data-types.pdf | 37.4 KB |
| 2. Manipulating Tables and Data/5. Insert Data into the Table with SQL Script.mp4 | 93.9 MB |
| 2. Manipulating Tables and Data/5. Insert Data into the Table with SQL Script.srt | 17.7 KB |
| 2. Manipulating Tables and Data/5.1 insert_students.sql | 753 B |
| 2. Manipulating Tables and Data/6. Insert Data into the Table with Management Studio.mp4 | 42.2 MB |
| 2. Manipulating Tables and Data/6. Insert Data into the Table with Management Studio.srt | 5.8 KB |
| 2. Manipulating Tables and Data/6.1 insert_courses.sql | 130 B |
| 2. Manipulating Tables and Data/7. Select Data from the Table with SQL Script.mp4 | 56.5 MB |
| 2. Manipulating Tables and Data/7. Select Data from the Table with SQL Script.srt | 11.9 KB |
| 2. Manipulating Tables and Data/7.1 select_students.sql | 376 B |
| 2. Manipulating Tables and Data/8. More Advanced Select Queries Part 1.mp4 | 154 MB |
| 2. Manipulating Tables and Data/8. More Advanced Select Queries Part 1.srt | 21.7 KB |
| 2. Manipulating Tables and Data/8.1 select_students_courses.sql | 1.9 KB |
| 2. Manipulating Tables and Data/9. Update Data in the Table.mp4 | 73.7 MB |
| 2. Manipulating Tables and Data/9. Update Data in the Table.srt | 12.2 KB |
| 2. Manipulating Tables and Data/9.1 update_students.sql | 730 B |
| 3. Relationships and Foreign Keys/1. What are Relationships, Foreign Keys and Normalization.mp4 | 54.9 MB |
| 3. Relationships and Foreign Keys/1. What are Relationships, Foreign Keys and Normalization.srt | 15 KB |
| 3. Relationships and Foreign Keys/2. Create a Relationship in SQL Server.mp4 | 128.7 MB |
| 3. Relationships and Foreign Keys/2. Create a Relationship in SQL Server.srt | 26.1 KB |
| 3. Relationships and Foreign Keys/3. Insert Records in Related Tables.mp4 | 82.4 MB |
| 3. Relationships and Foreign Keys/3. Insert Records in Related Tables.srt | 17.5 KB |
| 3. Relationships and Foreign Keys/3.1 insert_more_courses.sql | 236 B |
| 3. Relationships and Foreign Keys/3.2 insert_more_teachers.sql | 140 B |
| 3. Relationships and Foreign Keys/4. Run Queries on Related Tables (Inner Joins).mp4 | 256.8 MB |
| 3. Relationships and Foreign Keys/4. Run Queries on Related Tables (Inner Joins).srt | 26 KB |
| 3. Relationships and Foreign Keys/4.1 joins_enrollments.sql | 730 B |
| 3. Relationships and Foreign Keys/5. Left, Right and Full Joins.mp4 | 105.7 MB |
| 3. Relationships and Foreign Keys/5. Left, Right and Full Joins.srt | 14.4 KB |
| 3. Relationships and Foreign Keys/5.1 left_right_joins.sql | 918 B |
| 4. Group By and Aggregate Functions/1. Grouping Data using SQL GROUP BY Clause.mp4 | 88.1 MB |
| 4. Group By and Aggregate Functions/1. Grouping Data using SQL GROUP BY Clause.srt | 14.2 KB |
| 4. Group By and Aggregate Functions/1.1 group_by.sql | 1.1 KB |
| 4. Group By and Aggregate Functions/2. SQL AVG Aggregate Function.mp4 | 67.1 MB |
| 4. Group By and Aggregate Functions/2. SQL AVG Aggregate Function.srt | 13.6 KB |
| 4. Group By and Aggregate Functions/2.1 average_agg.sql | 200 B |
| 4. Group By and Aggregate Functions/3. SQL COUNT Aggregate Function.mp4 | 25.9 MB |
| 4. Group By and Aggregate Functions/3. SQL COUNT Aggregate Function.srt | 4.7 KB |
| 4. Group By and Aggregate Functions/3.1 count_agg.sql | 241 B |
| 4. Group By and Aggregate Functions/4. SQL MAX and MIN Aggregate Functions.mp4 | 24.1 MB |
| 4. Group By and Aggregate Functions/4. SQL MAX and MIN Aggregate Functions.srt | 4 KB |
| 4. Group By and Aggregate Functions/4.1 min_max_agg.sql | 169 B |
| 4. Group By and Aggregate Functions/5. SQL SUM Aggregate Function.mp4 | 32.7 MB |
| 4. Group By and Aggregate Functions/5. SQL SUM Aggregate Function.srt | 5.1 KB |
| 4. Group By and Aggregate Functions/5.1 sum_agg.sql | 325 B |
| 5. Advanced SQL Server Objects and Concepts/1. Create and Manage Views.mp4 | 160.2 MB |
| 5. Advanced SQL Server Objects and Concepts/1. Create and Manage Views.srt | 29.6 KB |
| 5. Advanced SQL Server Objects and Concepts/2. Scalar Valued Functions.mp4 | 216.6 MB |
| 5. Advanced SQL Server Objects and Concepts/2. Scalar Valued Functions.srt | 33.3 KB |
| 5. Advanced SQL Server Objects and Concepts/3. Inline Table Valued Functions.mp4 | 74.9 MB |
| 5. Advanced SQL Server Objects and Concepts/3. Inline Table Valued Functions.srt | 11 KB |
| 5. Advanced SQL Server Objects and Concepts/4. Multi Statement Table Valued Functions.mp4 | 108.7 MB |
| 5. Advanced SQL Server Objects and Concepts/4. Multi Statement Table Valued Functions.srt | 15.1 KB |
| 5. Advanced SQL Server Objects and Concepts/5. Stored Procedures.mp4 | 224.6 MB |
| 5. Advanced SQL Server Objects and Concepts/5. Stored Procedures.srt | 35.7 KB |
| 5. Advanced SQL Server Objects and Concepts/6. Table Triggers.mp4 | 159.9 MB |
| 5. Advanced SQL Server Objects and Concepts/6. Table Triggers.srt | 23 KB |
| 5. Advanced SQL Server Objects and Concepts/7. Database Scripting, Backup and Restore.mp4 | 101.8 MB |
| 5. Advanced SQL Server Objects and Concepts/7. Database Scripting, Backup and Restore.srt | 19.1 KB |
| 6. BONUS Discounts/1. Bonus Discounts.html | 1.9 KB |