Lynda - SQL Server 2014 Essential Training

seeders: 1
leechers: 0
Added on August 5, 2015 by mandeslyin Other > Tutorials
Torrent verified.



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


Description



SQL Server 2014 Essential Training | Duration: 3h51 | Video: AVC (.mp4) | Date Released: 2015-6-12
Genre: eLearning | Level: Intermediate | Language: English


Learn everything you need to know to start building databases with SQL Server. Martin Guidry reviews the major features of SQL Server 2014 and shows developers how to architect efficient, high-performance solutions for organizations of any scale. Watch and learn how to install and configure SQL Server, create databases and tables, automate common tasks like backups, and use the SQL query language to retrieve and manipulate data.

Sharing Widget


Download torrent
588.76 MB
seeders:1
leechers:0
Lynda - SQL Server 2014 Essential Training