Lynda Microsoft SQL Server 2016 Essential Training | 6409F80FE29D5F59F382E635491558696630DDAC

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	75
Hash	6409F80FE29D5F59F382E635491558696630DDAC

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