Skip to content

Lynda - SQL Server 2014 Essential Training

Unverified source. This magnet is from an unverified source. The content may be unsafe or mislabeled. Proceed with caution.
Title: Lynda - SQL ServerGroup: NOGRPYear: 2014Source: Lynda
Info Hash
873194C52FE8453CC7F6A4F94138B6B69C80A296
Source
Unverified
Total Size
588.76 MB
Total Files
62
Seeders
5
Leechers
0
Health
5.00
Score
10
Type
Bookware

File List

FileSize
01. Introduction/01_01-Welcome.mp44.09 MB
01. Introduction/01_02-What you should know before starting.mp41.49 MB
01. Introduction/01_03-Using the exercise files.mp41.14 MB
02. Overview of SQL Server 2014/02_01-Understanding the core concepts of SQL Server 2014.mp45.56 MB
02. Overview of SQL Server 2014/02_02-SQL Server principal editions.mp414.06 MB
02. Overview of SQL Server 2014/02_03-SQL Server additional editions.mp46.85 MB
03. Installing SQL Server 2014/03_01-Installation prerequisites.mp49.92 MB
03. Installing SQL Server 2014/03_02-Basic installation.mp49.88 MB
03. Installing SQL Server 2014/03_03-Advanced installation options.mp47.31 MB
04. PostInstall/04_01-Using SQL Server Configuration Manager.mp413.32 MB
04. PostInstall/04_02-Basics of SQL Server Management Studio.mp416.7 MB
04. PostInstall/04_03-More about SQL Server Management Studio.mp417.33 MB
05. Creating and Configuring Databases/05_01-Creating a database.mp48.36 MB
05. Creating and Configuring Databases/05_02-Advanced options of database configuration.mp416.03 MB
05. Creating and Configuring Databases/05_03-Installing sample database.mp47.94 MB
06. Creating Tables in a Database/06_01-Creating a table using Managment Studio.mp48.09 MB
06. Creating Tables in a Database/06_02-Understanding data column options.mp48.95 MB
06. Creating Tables in a Database/06_03-Creating a table using TSQL.mp46.54 MB
06. Creating Tables in a Database/06_04-Creating relationships between tables.mp412.37 MB
06. Creating Tables in a Database/06_05-In memory tables.mp47.22 MB
07. Working with SQL/07_01-What is SQL.mp48.07 MB
07. Working with SQL/07_02-Basic SELECT statement.mp410.53 MB
07. Working with SQL/07_03-Filtering results with a WHERE clause.mp49.84 MB
07. Working with SQL/07_04-Using wildcards in a WHERE clause.mp47.51 MB
07. Working with SQL/07_05-Sorting results with ORDER BY.mp414.56 MB
07. Working with SQL/07_06-INSERT statements.mp412.24 MB
07. Working with SQL/07_07-UPDATE statements.mp48.72 MB
07. Working with SQL/07_08-DELETE statements.mp47.42 MB
08. Creating Views in Databases/08_01-Creating a view.mp417.46 MB
08. Creating Views in Databases/08_02-Understanding advanced options of views.mp48.04 MB
09. Understanding Programmability/09_01-Stored procedures.mp48.2 MB
09. Understanding Programmability/09_02-Parameterized stored procedures.mp48.37 MB
09. Understanding Programmability/09_03-Builtin functions.mp45.14 MB
09. Understanding Programmability/09_04-Scalar functions.mp413.72 MB
10. Working with XML/10_01-Intro to XML.mp44.38 MB
10. Working with XML/10_02-Writing queries to return XML.mp410.1 MB
10. Working with XML/10_03-Shredding XML.mp414.46 MB
10. Working with XML/10_04-Working with XML schemas.mp410.74 MB
10. Working with XML/10_05-Storing XML.mp416.28 MB
11. Backup and Restore/11_01-Overview of backups in SQL Server.mp49.18 MB
11. Backup and Restore/11_02-Basic backups.mp47.34 MB
11. Backup and Restore/11_03-Basic restore.mp45.7 MB
11. Backup and Restore/11_04-Differential backup and restore.mp46.95 MB
11. Backup and Restore/11_05-Creating maintenance plans to automate backups.mp410 MB
11. Backup and Restore/11_06-Adding a cleanup task to a maintenance plan.mp47.75 MB
12. Monitoring SQL Server/12_01-Review logs in SQL Server 2014.mp413.76 MB
12. Monitoring SQL Server/12_02-Auditing logins.mp413.52 MB
12. Monitoring SQL Server/12_03-Using Performance Monitor.mp411.36 MB
12. Monitoring SQL Server/12_04-Understanding dynamic management views.mp414.73 MB
12. Monitoring SQL Server/12_05-Using DBCC.mp412.29 MB
13. Security/13_01-Overview of authentication in SQL Server.mp45.24 MB
13. Security/13_02-Instancelevel logins.mp44.08 MB
13. Security/13_03-Databaselevel users.mp47.3 MB
13. Security/13_04-Encrypting data.mp418.29 MB
14. Importing and Exporting Data/14_01-Exporting data.mp410.56 MB
14. Importing and Exporting Data/14_02-Importing data.mp411.48 MB
14. Importing and Exporting Data/14_03-Importing and exporting Unicode data.mp410.48 MB
15. Performance/15_01-Basics of indexes.mp49.45 MB
15. Performance/15_02-Creating an index.mp46.45 MB
15. Performance/15_03-Exploring execution plans.mp411.07 MB
16. Conclusion/16_01-Next steps.mp42.85 MB
Exercice Files/Ex_Files_SQL_2014_EssT.zip8.96 KB

Trackers

No trackers found.