Filename | Size |
| 01. Introduction/01_01-Welcome.mp4 | 19.7 MB |
| 01. Introduction/01_02-What you should know before starting.mp4 | 1.1 MB |
| 01. Introduction/01_03-Using the exercise files.mp4 | 933.4 KB |
| 02. Overview of SQL Server 2016/02_01-Understanding core concepts of SQL Server 2016.mp4 | 3 MB |
| 02. Overview of SQL Server 2016/02_02-SQL Server editions.mp4 | 3.6 MB |
| 03. Installing SQL Server 2016/03_01-Basic installation.mp4 | 16.2 MB |
| 03. Installing SQL Server 2016/03_02-Advanced installation options.mp4 | 15 MB |
| 03. Installing SQL Server 2016/03_03-Install SQL Management Studio.mp4 | 4.8 MB |
| 04. Working with Tools/04_01-Using SQL Server Configuration Manager.mp4 | 10.9 MB |
| 04. Working with Tools/04_02-Basics SQL Server Management Studio.mp4 | 17.4 MB |
| 04. Working with Tools/04_03-More about SQL Server Management Studio.mp4 | 13.2 MB |
| 04. Working with Tools/04_04-Activity Monitor.mp4 | 9.4 MB |
| 04. Working with Tools/04_05-Profiler.mp4 | 13.7 MB |
| 05. Creating and Configuring Databases/05_01-Create a database.mp4 | 8.7 MB |
| 05. Creating and Configuring Databases/05_02-Advanced database configuration options.mp4 | 9.2 MB |
| 05. Creating and Configuring Databases/05_03-Install a sample database.mp4 | 8.9 MB |
| 06. Creating Tables in a Database/06_01-Create a table using Management Studio.mp4 | 8.5 MB |
| 06. Creating Tables in a Database/06_02-Understanding data column options.mp4 | 7.5 MB |
| 06. Creating Tables in a Database/06_03-Create a table using TSQL.mp4 | 4.6 MB |
| 06. Creating Tables in a Database/06_04-Create relationships between tables.mp4 | 10.8 MB |
| 06. Creating Tables in a Database/06_05-Inmemory tables.mp4 | 7.3 MB |
| 06. Creating Tables in a Database/06_06-Temporal tables.mp4 | 15 MB |
| 07. Creating Views in Databases/07_01-Create a view.mp4 | 10.6 MB |
| 07. Creating Views in Databases/07_02-Understanding the advanced options of views.mp4 | 10.7 MB |
| 08. Understanding Programmability/08_01-Stored procedures.mp4 | 10.2 MB |
| 08. Understanding Programmability/08_02-Parameterized stored procedures.mp4 | 12.3 MB |
| 08. Understanding Programmability/08_03-Builtinfunctions.mp4 | 4.3 MB |
| 08. Understanding Programmability/08_04-Scalar functions.mp4 | 6.3 MB |
| 09. Working with XML/09_01-Introduction to XML.mp4 | 2.2 MB |
| 09. Working with XML/09_02-Write queries toreturnXML.mp4 | 9 MB |
| 09. Working with XML/09_03-Shred XML.mp4 | 6.5 MB |
| 09. Working with XML/09_04-Working with XML schemas.mp4 | 5 MB |
| 09. Working with XML/09_05-Storing XML.mp4 | 10 MB |
| 10. Working with JSON/10_01-Working with JSON.mp4 | 6.5 MB |
| 10. Working with JSON/10_02-Converting JSON to tabular data.mp4 | 4.2 MB |
| 10. Working with JSON/10_03-Storing JSON.mp4 | 6.2 MB |
| 11. Backup and Restore/11_01-Overviewof backup and restore in SQL Server.mp4 | 8 MB |
| 11. Backup and Restore/11_02-Basic backups.mp4 | 7.4 MB |
| 11. Backup and Restore/11_03-Basic restore.mp4 | 8.9 MB |
| 11. Backup and Restore/11_04-Create maintenance plans to automate backups.mp4 | 11.4 MB |
| 11. Backup and Restore/11_05-Add a cleanup task to a maintenance plan.mp4 | 8.9 MB |
| 12. Monitoring and Management/12_01-Review logs in SQL Server 2016.mp4 | 9.2 MB |
| 12. Monitoring and Management/12_02-Audit logins.mp4 | 8.8 MB |
| 12. Monitoring and Management/12_03-Understanding dynamic management views.mp4 | 10.1 MB |
| 12. Monitoring and Management/12_04-Using database console commands DBCC.mp4 | 8.2 MB |
| 12. Monitoring and Management/12_05-Overview of high availability in SQL Server 2016.mp4 | 12.9 MB |
| 13. Security/13_01-Overview of authentication in SQL Server.mp4 | 6.4 MB |
| 13. Security/13_02-Instancelevel logins.mp4 | 7 MB |
| 13. Security/13_03-Databaselevel users.mp4 | 6.2 MB |
| 13. Security/13_04-Encrypt data.mp4 | 15.3 MB |
| 13. Security/13_05-Dynamic masking.mp4 | 8.3 MB |
| 14. Performance/14_01-Basics of indexes.mp4 | 4.7 MB |
| 14. Performance/14_02-Create an index.mp4 | 17.9 MB |
| 14. Performance/14_03-Columnstore index.mp4 | 9.6 MB |
| 14. Performance/14_04-Explore execution plans.mp4 | 14.4 MB |
| 14. Performance/14_05-Overview of Query Store.mp4 | 9.7 MB |
| 15. Cloud/15_01-Back up to Azure.mp4 | 8.2 MB |
| 15. Cloud/15_02-Set up Stretch Database.mp4 | 13.1 MB |
| 15. Cloud/15_03-Monitor Stretch Database.mp4 | 4.2 MB |
| 16. Conclusion/16_01-Next steps.mp4 | 1.4 MB |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/12_04_EncryptData.txt | 344 B |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/12_05_DynamicMasking.txt | 399 B |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/13_02_CreateIndex.txt | 520 B |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/13_03_CreateColumnStore.txt | 237 B |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/5_5_InMemory.txt | 459 B |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/5_6_Temporal.txt | 547 B |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/7_1_StoredProc.txt | 158 B |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/7_2_ParamaterProc.txt | 384 B |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/7_3_Functions.txt | 143 B |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/7_4_ScalarFunctions.txt | 260 B |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/8_3_XMLShred.txt | 403 B |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/8_4_XMLSchema.txt | 502 B |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/8_5_storingXML.txt | 321 B |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/9_2_JSONparse.txt | 292 B |
| Exercice Files/Ex_Files_SQL_Server2016_EssT/Exercise Files/9_3_JSONstore.txt | 366 B |