Lynda SQL Server 2014 Essential Training | 873194C52FE8453CC7F6A4F94138B6B69C80A296

Lynda SQL Server 2014 Essential Training

Name	Lynda - SQL Server 2014 Essential Training	DOWNLOAD Copy Link
Total Size	617.4 MB
Total Files	62
Hash	873194C52FE8453CC7F6A4F94138B6B69C80A296

/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_01-Understanding the core concepts of SQL Server 2014.mp4	5.8 MB
02_02-SQL Server principal editions.mp4	14.7 MB
02_03-SQL Server additional editions.mp4	7.2 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_01-Using SQL Server Configuration Manager.mp4	14.0 MB
04_02-Basics of SQL Server Management Studio.mp4	17.5 MB
04_03-More about SQL Server Management Studio.mp4	18.2 MB
/05. Creating and Configuring Databases/
05_01-Creating a database.mp4	8.8 MB
05_02-Advanced options of database configuration.mp4	16.8 MB
05_03-Installing sample database.mp4	8.3 MB
/06. Creating Tables in a Database/
06_01-Creating a table using Managment Studio.mp4	8.5 MB
06_02-Understanding data column options.mp4	9.4 MB
06_03-Creating a table using TSQL.mp4	6.9 MB
06_04-Creating relationships between tables.mp4	13.0 MB
06_05-In memory tables.mp4	7.6 MB
/07. Working with SQL/
07_01-What is SQL.mp4	8.5 MB
07_02-Basic SELECT statement.mp4	11.0 MB
07_03-Filtering results with a WHERE clause.mp4	10.3 MB
07_04-Using wildcards in a WHERE clause.mp4	7.9 MB
07_05-Sorting results with ORDER BY.mp4	15.3 MB
07_06-INSERT statements.mp4	12.8 MB
07_07-UPDATE statements.mp4	9.1 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_01-Stored procedures.mp4	8.6 MB
09_02-Parameterized stored procedures.mp4	8.8 MB
09_03-Builtin functions.mp4	5.4 MB
09_04-Scalar functions.mp4	14.4 MB
/10. Working with XML/
10_01-Intro to XML.mp4	4.6 MB
10_02-Writing queries to return XML.mp4	10.6 MB
10_03-Shredding XML.mp4	15.2 MB
10_04-Working with XML schemas.mp4	11.3 MB
10_05-Storing XML.mp4	17.1 MB
/11. Backup and Restore/
11_01-Overview of backups in SQL Server.mp4	9.6 MB
11_02-Basic backups.mp4	7.7 MB
11_03-Basic restore.mp4	6.0 MB
11_04-Differential backup and restore.mp4	7.3 MB
11_05-Creating maintenance plans to automate backups.mp4	10.5 MB
11_06-Adding a cleanup task to a maintenance plan.mp4	8.1 MB
/12. Monitoring SQL Server/
12_01-Review logs in SQL Server 2014.mp4	14.4 MB
12_02-Auditing logins.mp4	14.2 MB
12_03-Using Performance Monitor.mp4	11.9 MB
12_04-Understanding dynamic management views.mp4	15.4 MB
12_05-Using DBCC.mp4	12.9 MB
/13. Security/
13_01-Overview of authentication in SQL Server.mp4	5.5 MB
13_02-Instancelevel logins.mp4	4.3 MB
13_03-Databaselevel users.mp4	7.7 MB
13_04-Encrypting data.mp4	19.2 MB
/14. Importing and Exporting Data/
14_01-Exporting data.mp4	11.1 MB
14_02-Importing data.mp4	12.0 MB
14_03-Importing and exporting Unicode data.mp4	11.0 MB
/15. Performance/
15_01-Basics of indexes.mp4	9.9 MB
15_02-Creating an index.mp4	6.8 MB
15_03-Exploring execution plans.mp4	11.6 MB
/16. Conclusion/
16_01-Next steps.mp4	3.0 MB
/Exercice Files/
Ex_Files_SQL_2014_EssT.zip	9.2 KB
Total files 62