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