LYNDA SQL SERVER 2014 ESSENTIAL TRAINING TUTORIAL | 64386CCED7481758D01545AF1D8AC0AF65716E27

LYNDA SQL SERVER 2014 ESSENTIAL TRAINING TUTORIAL

Name	LYNDA SQL SERVER 2014 ESSENTIAL TRAINING TUTORIAL	DOWNLOAD Copy Link
Total Size	617.4 MB
Total Files	73
Hash	64386CCED7481758D01545AF1D8AC0AF65716E27

/01. Introduction/
01_01-Welcome.mp4	4.3 MB
01_02-What you should know before starting.mp4	1.6 MB
01_03-Using the exercise files.mp4	1.2 MB
/02. Overview of SQL Server 2014/
02_02-SQL Server principal editions.mp4	14.7 MB
02_03-SQL Server additional editions.mp4	7.2 MB
02_01-Understanding the core concepts of SQL Server 2014.mp4	5.8 MB
/03. Installing SQL Server 2014/
03_01-Installation prerequisites.mp4	10.4 MB
03_02-Basic installation.mp4	10.4 MB
03_03-Advanced installation options.mp4	7.7 MB
/04. PostInstall/
04_03-More about SQL Server Management Studio.mp4	18.2 MB
04_02-Basics of SQL Server Management Studio.mp4	17.5 MB
04_01-Using SQL Server Configuration Manager.mp4	14.0 MB
/05. Creating and Configuring Databases/
05_02-Advanced options of database configuration.mp4	16.8 MB
05_01-Creating a database.mp4	8.8 MB
05_03-Installing sample database.mp4	8.3 MB
/06. Creating Tables in a Database/
06_04-Creating relationships between tables.mp4	13.0 MB
06_02-Understanding data column options.mp4	9.4 MB
06_01-Creating a table using Managment Studio.mp4	8.5 MB
06_05-In memory tables.mp4	7.6 MB
06_03-Creating a table using TSQL.mp4	6.9 MB
/07. Working with SQL/
07_05-Sorting results with ORDER BY.mp4	15.3 MB
07_06-INSERT statements.mp4	12.8 MB
07_02-Basic SELECT statement.mp4	11.0 MB
07_03-Filtering results with a WHERE clause.mp4	10.3 MB
07_07-UPDATE statements.mp4	9.1 MB
07_01-What is SQL.mp4	8.5 MB
07_04-Using wildcards in a WHERE clause.mp4	7.9 MB
07_08-DELETE statements.mp4	7.8 MB
/08. Creating Views in Databases/
08_01-Creating a view.mp4	18.3 MB
08_02-Understanding advanced options of views.mp4	8.4 MB
/09. Understanding Programmability/
09_04-Scalar functions.mp4	14.4 MB
09_02-Parameterized stored procedures.mp4	8.8 MB
09_01-Stored procedures.mp4	8.6 MB
09_03-Builtin functions.mp4	5.4 MB
/10. Working with XML/
10_05-Storing XML.mp4	17.1 MB
10_03-Shredding XML.mp4	15.2 MB
10_04-Working with XML schemas.mp4	11.3 MB
10_02-Writing queries to return XML.mp4	10.6 MB
10_01-Intro to XML.mp4	4.6 MB
/11. Backup and Restore/
11_05-Creating maintenance plans to automate backups.mp4	10.5 MB
11_01-Overview of backups in SQL Server.mp4	9.6 MB
11_06-Adding a cleanup task to a maintenance plan.mp4	8.1 MB
11_02-Basic backups.mp4	7.7 MB
11_04-Differential backup and restore.mp4	7.3 MB
11_03-Basic restore.mp4	6.0 MB
/12. Monitoring SQL Server/
12_04-Understanding dynamic management views.mp4	15.4 MB
12_01-Review logs in SQL Server 2014.mp4	14.4 MB
12_02-Auditing logins.mp4	14.2 MB
12_05-Using DBCC.mp4	12.9 MB
12_03-Using Performance Monitor.mp4	11.9 MB
/13. Security/
13_04-Encrypting data.mp4	19.2 MB
13_03-Databaselevel users.mp4	7.7 MB
13_01-Overview of authentication in SQL Server.mp4	5.5 MB
13_02-Instancelevel logins.mp4	4.3 MB
/14. Importing and Exporting Data/
14_02-Importing data.mp4	12.0 MB
14_01-Exporting data.mp4	11.1 MB
14_03-Importing and exporting Unicode data.mp4	11.0 MB
/15. Performance/
15_03-Exploring execution plans.mp4	11.6 MB
15_01-Basics of indexes.mp4	9.9 MB
15_02-Creating an index.mp4	6.8 MB
/16. Conclusion/
16_01-Next steps.mp4	3.0 MB
/Exercise Files/Ch05/05_03/
05_03_CreateTableTSQL.txt	0.4 KB
/Exercise Files/Ch05/05_05/
05_05_InMemory.txt	0.5 KB
/Exercise Files/Ch08/08_01/
08_01_Procedure.txt	0.1 KB
/Exercise Files/Ch08/08_02/
08_02_Parameters.txt	0.2 KB
08_02_Paramaters.txt	0.2 KB
/Exercise Files/Ch08/08_03/
08_03_BuiltInFunctions.txt	0.1 KB
/Exercise Files/Ch08/08_04/
08_04_ScalarFunction.txt	0.3 KB
/Exercise Files/Ch09/09_03/
09_03_XMLshred.txt	0.4 KB
/Exercise Files/Ch09/09_04/
09_04_XMLschema.txt	0.5 KB
/Exercise Files/Ch09/09_05/
09_05_storingXML.txt	0.3 KB
/Exercise Files/Ch13/13_02/
13_02_Import.txt	0.3 KB
/Exercise Files/Ch14/14_03/
14_03_ExecutionPlans.txt	0.1 KB
Total files 73