Download LYNDA SQL SERVER 2014 ESSENTIAL TRAINING TUTORIAL torrent

LYNDA SQL SERVER 2014 ESSENTIAL TRAINING TUTORIAL

Torrent:	LYNDA SQL SERVER 2014 ESSENTIAL TRAINING TUTORIAL
Description:	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 Topics include: * Comparing SQL Server editions * Installing SQL Server 2014 * Creating a database * Creating tables and relationships between tables * Writing SQL statements * Creating views * Using stored procedures and functions * Working with XML * Backing up and restoring a SQL Server database * Monitoring SQL Server * Authenticating users * Importing and exporting data * Indexing a database
Downloads:	3347
Category:	Other /Tutorials
Size:	588.8 MB
Show Files »	01. Introduction 01_01-Welcome.mp4 (4.1 MB) 01_02-What you should know before starting.mp4 (1.5 MB) 01_03-Using the exercise files.mp4 (1.1 MB) 02. Overview of SQL Server 2014 02_02-SQL Server principal editions.mp4 (14.1 MB) 02_03-SQL Server additional editions.mp4 (6.8 MB) 02_01-Understanding the core concepts of SQL Server 2014.mp4 (5.6 MB) 03. Installing SQL Server 2014 03_01-Installation prerequisites.mp4 (9.9 MB) 03_02-Basic installation.mp4 (9.9 MB) 03_03-Advanced installation options.mp4 (7.3 MB) 04. PostInstall 04_03-More about SQL Server Management Studio.mp4 (17.3 MB) 04_02-Basics of SQL Server Management Studio.mp4 (16.7 MB) 04_01-Using SQL Server Configuration Manager.mp4 (13.3 MB) 05. Creating and Configuring Databases 05_02-Advanced options of database configuration.mp4 (16.0 MB) 05_01-Creating a database.mp4 (8.4 MB) 05_03-Installing sample database.mp4 (7.9 MB) 06. Creating Tables in a Database 06_04-Creating relationships between tables.mp4 (12.4 MB) 06_02-Understanding data column options.mp4 (8.9 MB) 06_01-Creating a table using Managment Studio.mp4 (8.1 MB) 06_05-In memory tables.mp4 (7.2 MB) 06_03-Creating a table using TSQL.mp4 (6.5 MB) 07. Working with SQL 07_05-Sorting results with ORDER BY.mp4 (14.6 MB) 07_06-INSERT statements.mp4 (12.2 MB) 07_02-Basic SELECT statement.mp4 (10.5 MB) 07_03-Filtering results with a WHERE clause.mp4 (9.8 MB) 07_07-UPDATE statements.mp4 (8.7 MB) 07_01-What is SQL.mp4 (8.1 MB) 07_04-Using wildcards in a WHERE clause.mp4 (7.5 MB) 07_08-DELETE statements.mp4 (7.4 MB) 08. Creating Views in Databases 08_01-Creating a view.mp4 (17.5 MB) 08_02-Understanding advanced options of views.mp4 (8.0 MB) 09. Understanding Programmability 09_04-Scalar functions.mp4 (13.7 MB) 09_02-Parameterized stored procedures.mp4 (8.4 MB) 09_01-Stored procedures.mp4 (8.2 MB) 09_03-Builtin functions.mp4 (5.1 MB) 10. Working with XML 10_05-Storing XML.mp4 (16.3 MB) 10_03-Shredding XML.mp4 (14.5 MB) 10_04-Working with XML schemas.mp4 (10.7 MB) 10_02-Writing queries to return XML.mp4 (10.1 MB) 10_01-Intro to XML.mp4 (4.4 MB) 11. Backup and Restore 11_05-Creating maintenance plans to automate backups.mp4 (10.0 MB) 11_01-Overview of backups in SQL Server.mp4 (9.2 MB) 11_06-Adding a cleanup task to a maintenance plan.mp4 (7.7 MB) 11_02-Basic backups.mp4 (7.3 MB) 11_04-Differential backup and restore.mp4 (7.0 MB) 11_03-Basic restore.mp4 (5.7 MB) 12. Monitoring SQL Server 12_04-Understanding dynamic management views.mp4 (14.7 MB) 12_01-Review logs in SQL Server 2014.mp4 (13.8 MB) 12_02-Auditing logins.mp4 (13.5 MB) 12_05-Using DBCC.mp4 (12.3 MB) 12_03-Using Performance Monitor.mp4 (11.4 MB) 13. Security 13_04-Encrypting data.mp4 (18.3 MB) 13_03-Databaselevel users.mp4 (7.3 MB) 13_01-Overview of authentication in SQL Server.mp4 (5.2 MB) 13_02-Instancelevel logins.mp4 (4.1 MB) 14. Importing and Exporting Data 14_02-Importing data.mp4 (11.5 MB) 14_01-Exporting data.mp4 (10.6 MB) 14_03-Importing and exporting Unicode data.mp4 (10.5 MB) 15. Performance 15_03-Exploring execution plans.mp4 (11.1 MB) 15_01-Basics of indexes.mp4 (9.4 MB) 15_02-Creating an index.mp4 (6.5 MB) 16. Conclusion 16_01-Next steps.mp4 (2.8 MB) Exercise Files Ch05 05_03 05_03_CreateTableTSQL.txt (0.4 KB) 05_05 05_05_InMemory.txt (0.5 KB) Ch08 08_01 08_01_Procedure.txt (0.1 KB) 08_02 08_02_Parameters.txt (0.2 KB) 08_02_Paramaters.txt (0.2 KB) 08_03 08_03_BuiltInFunctions.txt (0.1 KB) 08_04 08_04_ScalarFunction.txt (0.3 KB) Ch09 09_03 09_03_XMLshred.txt (0.3 KB) 09_04 09_04_XMLschema.txt (0.5 KB) 09_05 09_05_storingXML.txt (0.3 KB) Ch13 13_02 13_02_Import.txt (0.3 KB) Ch14 14_03 14_03_ExecutionPlans.txt (0.1 KB) files
Added:	2015-06-21 13:25:12
Language:	English
Peers:	Seeders : 3 , Leechers : 0
Release name:	LYNDA SQL SERVER 2014 ESSENTIAL TRAINING TUTORIAL
Trackers:	udp://tracker.openbittorrent.com:80 udp://open.demonii.com:1337/announce udp://coppersurfer.tk:6969 udp://tracker.openbittorrent.com:80/announce udp://coppersurfer.tk:6969/announce udp://9.rarbg.me:2710/announce udp://tracker.coppersurfer.tk:6969/announce udp://9.rarbg.com:2710/announce udp://tracker4.piratux.com:6969/announce udp://eddie4.nl:6969/announce udp://tracker.pomf.se/announce udp://tracker.leechers-paradise.org:6969 udp://glotorrents.pw:6969/announce http://tracker.aletorrenty.pl:2710/announce udp://9.rarbg.to:2710/announce