Lynda - SQL Server 2014 Essential Training
File List
| File | Size |
|---|---|
| 01. Introduction/01_01-Welcome.mp4 | 4.09 MB |
| 01. Introduction/01_02-What you should know before starting.mp4 | 1.49 MB |
| 01. Introduction/01_03-Using the exercise files.mp4 | 1.14 MB |
| 02. Overview of SQL Server 2014/02_01-Understanding the core concepts of SQL Server 2014.mp4 | 5.56 MB |
| 02. Overview of SQL Server 2014/02_02-SQL Server principal editions.mp4 | 14.06 MB |
| 02. Overview of SQL Server 2014/02_03-SQL Server additional editions.mp4 | 6.85 MB |
| 03. Installing SQL Server 2014/03_01-Installation prerequisites.mp4 | 9.92 MB |
| 03. Installing SQL Server 2014/03_02-Basic installation.mp4 | 9.88 MB |
| 03. Installing SQL Server 2014/03_03-Advanced installation options.mp4 | 7.31 MB |
| 04. PostInstall/04_01-Using SQL Server Configuration Manager.mp4 | 13.32 MB |
| 04. PostInstall/04_02-Basics of SQL Server Management Studio.mp4 | 16.7 MB |
| 04. PostInstall/04_03-More about SQL Server Management Studio.mp4 | 17.33 MB |
| 05. Creating and Configuring Databases/05_01-Creating a database.mp4 | 8.36 MB |
| 05. Creating and Configuring Databases/05_02-Advanced options of database configuration.mp4 | 16.03 MB |
| 05. Creating and Configuring Databases/05_03-Installing sample database.mp4 | 7.94 MB |
| 06. Creating Tables in a Database/06_01-Creating a table using Managment Studio.mp4 | 8.09 MB |
| 06. Creating Tables in a Database/06_02-Understanding data column options.mp4 | 8.95 MB |
| 06. Creating Tables in a Database/06_03-Creating a table using TSQL.mp4 | 6.54 MB |
| 06. Creating Tables in a Database/06_04-Creating relationships between tables.mp4 | 12.37 MB |
| 06. Creating Tables in a Database/06_05-In memory tables.mp4 | 7.22 MB |
| 07. Working with SQL/07_01-What is SQL.mp4 | 8.07 MB |
| 07. Working with SQL/07_02-Basic SELECT statement.mp4 | 10.53 MB |
| 07. Working with SQL/07_03-Filtering results with a WHERE clause.mp4 | 9.84 MB |
| 07. Working with SQL/07_04-Using wildcards in a WHERE clause.mp4 | 7.51 MB |
| 07. Working with SQL/07_05-Sorting results with ORDER BY.mp4 | 14.56 MB |
| 07. Working with SQL/07_06-INSERT statements.mp4 | 12.24 MB |
| 07. Working with SQL/07_07-UPDATE statements.mp4 | 8.72 MB |
| 07. Working with SQL/07_08-DELETE statements.mp4 | 7.42 MB |
| 08. Creating Views in Databases/08_01-Creating a view.mp4 | 17.46 MB |
| 08. Creating Views in Databases/08_02-Understanding advanced options of views.mp4 | 8.04 MB |
| 09. Understanding Programmability/09_01-Stored procedures.mp4 | 8.2 MB |
| 09. Understanding Programmability/09_02-Parameterized stored procedures.mp4 | 8.37 MB |
| 09. Understanding Programmability/09_03-Builtin functions.mp4 | 5.14 MB |
| 09. Understanding Programmability/09_04-Scalar functions.mp4 | 13.72 MB |
| 10. Working with XML/10_01-Intro to XML.mp4 | 4.38 MB |
| 10. Working with XML/10_02-Writing queries to return XML.mp4 | 10.1 MB |
| 10. Working with XML/10_03-Shredding XML.mp4 | 14.46 MB |
| 10. Working with XML/10_04-Working with XML schemas.mp4 | 10.74 MB |
| 10. Working with XML/10_05-Storing XML.mp4 | 16.28 MB |
| 11. Backup and Restore/11_01-Overview of backups in SQL Server.mp4 | 9.18 MB |
| 11. Backup and Restore/11_02-Basic backups.mp4 | 7.34 MB |
| 11. Backup and Restore/11_03-Basic restore.mp4 | 5.7 MB |
| 11. Backup and Restore/11_04-Differential backup and restore.mp4 | 6.95 MB |
| 11. Backup and Restore/11_05-Creating maintenance plans to automate backups.mp4 | 10 MB |
| 11. Backup and Restore/11_06-Adding a cleanup task to a maintenance plan.mp4 | 7.75 MB |
| 12. Monitoring SQL Server/12_01-Review logs in SQL Server 2014.mp4 | 13.76 MB |
| 12. Monitoring SQL Server/12_02-Auditing logins.mp4 | 13.52 MB |
| 12. Monitoring SQL Server/12_03-Using Performance Monitor.mp4 | 11.36 MB |
| 12. Monitoring SQL Server/12_04-Understanding dynamic management views.mp4 | 14.73 MB |
| 12. Monitoring SQL Server/12_05-Using DBCC.mp4 | 12.29 MB |
| 13. Security/13_01-Overview of authentication in SQL Server.mp4 | 5.24 MB |
| 13. Security/13_02-Instancelevel logins.mp4 | 4.08 MB |
| 13. Security/13_03-Databaselevel users.mp4 | 7.3 MB |
| 13. Security/13_04-Encrypting data.mp4 | 18.29 MB |
| 14. Importing and Exporting Data/14_01-Exporting data.mp4 | 10.56 MB |
| 14. Importing and Exporting Data/14_02-Importing data.mp4 | 11.48 MB |
| 14. Importing and Exporting Data/14_03-Importing and exporting Unicode data.mp4 | 10.48 MB |
| 15. Performance/15_01-Basics of indexes.mp4 | 9.45 MB |
| 15. Performance/15_02-Creating an index.mp4 | 6.45 MB |
| 15. Performance/15_03-Exploring execution plans.mp4 | 11.07 MB |
| 16. Conclusion/16_01-Next steps.mp4 | 2.85 MB |
| Exercice Files/Ex_Files_SQL_2014_EssT.zip | 8.96 KB |
Trackers
No trackers found.