Lynda Microsoft SQL Server 2016 Essential Training | 3E9C47FE11AA2711D35AA52212F537E32D75642E

Lynda Microsoft SQL Server 2016 Essential Training

Name	Lynda - Microsoft SQL Server 2016 Essential Training	DOWNLOAD Copy Link
Total Size	559.3 MB
Total Files	61
Hash	3E9C47FE11AA2711D35AA52212F537E32D75642E

/01. Introduction/
01_01-Welcome.mp4	20.6 MB
01_02-What you should know before starting.mp4	1.2 MB
01_03-Using the exercise files.mp4	955.8 KB
/02. Overview of SQL Server 2016/
02_02-SQL Server editions.mp4	3.8 MB
02_01-Understanding core concepts of SQL Server 2016.mp4	3.1 MB
/03. Installing SQL Server 2016/
03_01-Basic installation.mp4	17.0 MB
03_02-Advanced installation options.mp4	15.8 MB
03_03-Install SQL Management Studio.mp4	5.0 MB
/04. Working with Tools/
04_02-Basics SQL Server Management Studio.mp4	18.3 MB
04_05-Profiler.mp4	14.4 MB
04_03-More about SQL Server Management Studio.mp4	13.9 MB
04_01-Using SQL Server Configuration Manager.mp4	11.4 MB
04_04-Activity Monitor.mp4	9.9 MB
/05. Creating and Configuring Databases/
05_02-Advanced database configuration options.mp4	9.6 MB
05_03-Install a sample database.mp4	9.4 MB
05_01-Create a database.mp4	9.1 MB
/06. Creating Tables in a Database/
06_06-Temporal tables.mp4	15.7 MB
06_04-Create relationships between tables.mp4	11.4 MB
06_01-Create a table using Management Studio.mp4	8.9 MB
06_02-Understanding data column options.mp4	7.9 MB
06_05-Inmemory tables.mp4	7.7 MB
06_03-Create a table using TSQL.mp4	4.8 MB
/07. Creating Views in Databases/
07_02-Understanding the advanced options of views.mp4	11.2 MB
07_01-Create a view.mp4	11.1 MB
/08. Understanding Programmability/
08_02-Parameterized stored procedures.mp4	12.9 MB
08_01-Stored procedures.mp4	10.7 MB
08_04-Scalar functions.mp4	6.6 MB
08_03-Builtinfunctions.mp4	4.5 MB
/09. Working with XML/
09_05-Storing XML.mp4	10.5 MB
09_02-Write queries toreturnXML.mp4	9.5 MB
09_03-Shred XML.mp4	6.8 MB
09_04-Working with XML schemas.mp4	5.3 MB
09_01-Introduction to XML.mp4	2.3 MB
/10. Working with JSON/
10_01-Working with JSON.mp4	6.8 MB
10_03-Storing JSON.mp4	6.5 MB
10_02-Converting JSON to tabular data.mp4	4.4 MB
/11. Backup and Restore/
11_04-Create maintenance plans to automate backups.mp4	11.9 MB
11_05-Add a cleanup task to a maintenance plan.mp4	9.4 MB
11_03-Basic restore.mp4	9.3 MB
11_01-Overviewof backup and restore in SQL Server.mp4	8.3 MB
11_02-Basic backups.mp4	7.7 MB
/12. Monitoring and Management/
12_05-Overview of high availability in SQL Server 2016.mp4	13.5 MB
12_03-Understanding dynamic management views.mp4	10.6 MB
12_01-Review logs in SQL Server 2016.mp4	9.6 MB
12_02-Audit logins.mp4	9.2 MB
12_04-Using database console commands DBCC.mp4	8.6 MB
/13. Security/
13_04-Encrypt data.mp4	16.0 MB
13_05-Dynamic masking.mp4	8.7 MB
13_02-Instancelevel logins.mp4	7.3 MB
13_01-Overview of authentication in SQL Server.mp4	6.7 MB
13_03-Databaselevel users.mp4	6.5 MB
/14. Performance/
14_02-Create an index.mp4	18.7 MB
14_04-Explore execution plans.mp4	15.1 MB
14_05-Overview of Query Store.mp4	10.2 MB
14_03-Columnstore index.mp4	10.0 MB
14_01-Basics of indexes.mp4	4.9 MB
/15. Cloud/
15_02-Set up Stretch Database.mp4	13.7 MB
15_01-Back up to Azure.mp4	8.6 MB
15_03-Monitor Stretch Database.mp4	4.4 MB
/16. Conclusion/
16_01-Next steps.mp4	1.4 MB
/Exercice Files/
Ex_Files_SQL_Server2016_EssT.zip	7.3 KB
Total files 61