Lynda - SQL Server 2014 Essential Training
大小
588.76 MB
文件数
62
Info Hash:
873194C52FE8453CC7F6A4F94138B6B69C80A296
收录时间
2026-01-11 17:24:53
更新时间
2026-01-11 17:45:46
文件列表 (62)
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