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