Lynda - Microsoft SQL Server 2016 Essential Training
大小
533.4 MB
文件数
61
Info Hash:
3E9C47FE11AA2711D35AA52212F537E32D75642E
收录时间
2026-01-16 04:53:16
更新时间
2026-01-16 04:53:16
文件列表 (61)
01. Introduction/01_01-Welcome.mp4
19.66 MB
01. Introduction/01_02-What you should know before starting.mp4
1.13 MB
01. Introduction/01_03-Using the exercise files.mp4
933.41 KB
02. Overview of SQL Server 2016/02_02-SQL Server editions.mp4
3.65 MB
02. Overview of SQL Server 2016/02_01-Understanding core concepts of SQL Server 2016.mp4
2.96 MB
03. Installing SQL Server 2016/03_01-Basic installation.mp4
16.18 MB
03. Installing SQL Server 2016/03_02-Advanced installation options.mp4
15.04 MB
03. Installing SQL Server 2016/03_03-Install SQL Management Studio.mp4
4.79 MB
04. Working with Tools/04_02-Basics SQL Server Management Studio.mp4
17.44 MB
04. Working with Tools/04_05-Profiler.mp4
13.7 MB
04. Working with Tools/04_03-More about SQL Server Management Studio.mp4
13.23 MB
04. Working with Tools/04_01-Using SQL Server Configuration Manager.mp4
10.86 MB
04. Working with Tools/04_04-Activity Monitor.mp4
9.41 MB
05. Creating and Configuring Databases/05_02-Advanced database configuration options.mp4
9.17 MB
05. Creating and Configuring Databases/05_03-Install a sample database.mp4
8.93 MB
05. Creating and Configuring Databases/05_01-Create a database.mp4
8.66 MB
06. Creating Tables in a Database/06_06-Temporal tables.mp4
14.97 MB
06. Creating Tables in a Database/06_04-Create relationships between tables.mp4
10.83 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_05-Inmemory tables.mp4
7.33 MB
06. Creating Tables in a Database/06_03-Create a table using TSQL.mp4
4.59 MB
07. Creating Views in Databases/07_02-Understanding the advanced options of views.mp4
10.67 MB
07. Creating Views in Databases/07_01-Create a view.mp4
10.56 MB
08. Understanding Programmability/08_02-Parameterized stored procedures.mp4
12.31 MB
08. Understanding Programmability/08_01-Stored procedures.mp4
10.21 MB
08. Understanding Programmability/08_04-Scalar functions.mp4
6.26 MB
08. Understanding Programmability/08_03-Builtinfunctions.mp4
4.31 MB
09. Working with XML/09_05-Storing XML.mp4
10 MB
09. Working with XML/09_02-Write queries toreturnXML.mp4
9.02 MB
09. Working with XML/09_03-Shred XML.mp4
6.45 MB
09. Working with XML/09_04-Working with XML schemas.mp4
5.04 MB
09. Working with XML/09_01-Introduction to XML.mp4
2.2 MB
10. Working with JSON/10_01-Working with JSON.mp4
6.5 MB
10. Working with JSON/10_03-Storing JSON.mp4
6.17 MB
10. Working with JSON/10_02-Converting JSON to tabular data.mp4
4.22 MB
11. Backup and Restore/11_04-Create maintenance plans to automate backups.mp4
11.38 MB
11. Backup and Restore/11_05-Add a cleanup task to a maintenance plan.mp4
8.94 MB
11. Backup and Restore/11_03-Basic restore.mp4
8.87 MB
11. Backup and Restore/11_01-Overviewof backup and restore in SQL Server.mp4
7.95 MB
11. Backup and Restore/11_02-Basic backups.mp4
7.35 MB
12. Monitoring and Management/12_05-Overview of high availability in SQL Server 2016.mp4
12.92 MB
12. Monitoring and Management/12_03-Understanding dynamic management views.mp4
10.13 MB
12. Monitoring and Management/12_01-Review logs in SQL Server 2016.mp4
9.19 MB
12. Monitoring and Management/12_02-Audit logins.mp4
8.82 MB
12. Monitoring and Management/12_04-Using database console commands DBCC.mp4
8.17 MB
13. Security/13_04-Encrypt data.mp4
15.28 MB
13. Security/13_05-Dynamic masking.mp4
8.31 MB
13. Security/13_02-Instancelevel logins.mp4
7 MB
13. Security/13_01-Overview of authentication in SQL Server.mp4
6.43 MB
13. Security/13_03-Databaselevel users.mp4
6.2 MB
14. Performance/14_02-Create an index.mp4
17.87 MB
14. Performance/14_04-Explore execution plans.mp4
14.45 MB
14. Performance/14_05-Overview of Query Store.mp4
9.72 MB
14. Performance/14_03-Columnstore index.mp4
9.58 MB
14. Performance/14_01-Basics of indexes.mp4
4.68 MB
15. Cloud/15_02-Set up Stretch Database.mp4
13.08 MB
15. Cloud/15_01-Back up to Azure.mp4
8.2 MB
15. Cloud/15_03-Monitor Stretch Database.mp4
4.18 MB
16. Conclusion/16_01-Next steps.mp4
1.36 MB
Exercice Files/Ex_Files_SQL_Server2016_EssT.zip
7.09 KB