SQL Server 2012 Querying (70-461) Part 2 [2013, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

SQL Server 2012 Querying (70-461) Part 2

Год выпуска: 2012
Производитель: Pluralsight
Автор: Christopher Harrison
Продолжительность: 3h 40m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание:
Part 2 of 2 in the SQL Server 2012 Querying (70-461) series is designed to teach students how to query and work with a SQL Server 2012 database.

Part 2 of 2 in the SQL Server 2012 Querying (70-461) series is designed to teach students how to query and work with a SQL Server 2012 database.
Skills gained will include querying a database using joins and data aggregations and query optimization.
This course includes basic management of database objects and using XML SQL Server.
[spoiler="Содержание"]
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Introduction 1.85 MB 0:01:03 ‎128kbps 387.00 1024x768 ‎15 frames/second 01.Managing Transactions
02.Transactions 9.88 MB 0:06:27 ‎128kbps 421.00 1024x768 ‎15 frames/second 01.Managing Transactions
03.Concurrency 6.95 MB 0:04:54 ‎128kbps 95.00 1024x768 ‎15 frames/second 01.Managing Transactions
04.Concurrency Issues 8.55 MB 0:05:51 ‎128kbps 114.00 1024x768 ‎15 frames/second 01.Managing Transactions
05.Read Noncommitted 4.46 MB 0:02:38 ‎128kbps 412.00 1024x768 ‎15 frames/second 01.Managing Transactions
06.Read Committed 4.44 MB 0:02:15 ‎128kbps 757.00 1024x768 ‎15 frames/second 01.Managing Transactions
07.Repeatable Read 7.81 MB 0:04:41 ‎128kbps 525.00 1024x768 ‎15 frames/second 01.Managing Transactions
08.Serializable 9.39 MB 0:05:47 ‎128kbps 179.00 1024x768 ‎15 frames/second 01.Managing Transactions
09.Snapshot 11.0 MB 0:06:17 ‎128kbps 649.00 1024x768 ‎15 frames/second 01.Managing Transactions
01.Try-Catch 14.7 MB 0:09:12 ‎128kbps 462.00 1024x768 ‎15 frames/second 02.Implementing Error Handling
02.Raising Errors 5.90 MB 0:03:41 ‎128kbps 477.00 1024x768 ‎15 frames/second 02.Implementing Error Handling
03.Using THROW 5.55 MB 0:03:13 ‎128kbps 466.00 1024x768 ‎15 frames/second 02.Implementing Error Handling
01.Introduction 1.23 MB 0:00:50 ‎128kbps 70.00 1024x768 ‎15 frames/second 03.XML Basics
02.XML Concepts 4.75 MB 0:03:24 ‎128kbps 74.00 1024x768 ‎15 frames/second 03.XML Basics
03.Well-Formed Documents 8.12 MB 0:05:34 ‎128kbps 474.00 1024x768 ‎15 frames/second 03.XML Basics
04.Validation 8.65 MB 0:05:33 ‎128kbps 472.00 1024x768 ‎15 frames/second 03.XML Basics
01.Using FOR XML 14.2 MB 0:08:16 ‎128kbps 496.00 1024x768 ‎15 frames/second 04.Retrieving XML
02.FOR XML AUTO 9.91 MB 0:05:22 ‎128kbps 546.00 1024x768 ‎15 frames/second 04.Retrieving XML
03.Controlling XML Creation 7.29 MB 0:04:17 ‎128kbps 536.00 1024x768 ‎15 frames/second 04.Retrieving XML
01.XML Datatype 8.20 MB 0:05:17 ‎128kbps 547.00 1024x768 ‎15 frames/second 05.Importing XML
02.Using OPENXML 3.98 MB 0:02:50 ‎128kbps 71.00 1024x768 ‎15 frames/second 05.Importing XML
03.OPENXML Demo 8.38 MB 0:05:03 ‎128kbps 385.00 1024x768 ‎15 frames/second 05.Importing XML
01.Designing Tables 13.9 MB 0:09:52 ‎128kbps 87.00 1024x768 ‎15 frames/second 06.Creating and Altering Tables
02.Managing Tables 5.80 MB 0:03:41 ‎128kbps 317.00 1024x768 ‎15 frames/second 06.Creating and Altering Tables
03.Altering Tables 6.04 MB 0:02:59 ‎128kbps 555.00 1024x768 ‎15 frames/second 06.Creating and Altering Tables
01.Introduction 962 KB 0:00:37 ‎128kbps 88.00 1024x768 ‎15 frames/second 07.Data Validation with Constraints
02.Data Validation Concepts 4.53 MB 0:03:15 ‎128kbps 56.00 1024x768 ‎15 frames/second 07.Data Validation with Constraints
03.Implementing Constraints 9.32 MB 0:05:27 ‎128kbps 573.00 1024x768 ‎15 frames/second 07.Data Validation with Constraints
04.Identity Columns 18.3 MB 0:10:51 ‎128kbps 613.00 1024x768 ‎15 frames/second 07.Data Validation with Constraints
05.Primary Key Constraints 6.57 MB 0:03:50 ‎128kbps 623.00 1024x768 ‎15 frames/second 07.Data Validation with Constraints
06.Foreign Key Cascade Options 2.45 MB 0:01:42 ‎128kbps 68.00 1024x768 ‎15 frames/second 07.Data Validation with Constraints
07.Foreign Key Cascade Demo 18.8 MB 0:11:28 ‎128kbps 451.00 1024x768 ‎15 frames/second 07.Data Validation with Constraints
01.Introduction 1.23 MB 0:00:47 ‎128kbps 103.00 1024x768 ‎15 frames/second 08.Creating and Modifying Triggers
02.Trigger Concepts 5.77 MB 0:03:56 ‎128kbps 84.00 1024x768 ‎15 frames/second 08.Creating and Modifying Triggers
03.Creating Triggers 3.76 MB 0:02:36 ‎128kbps 79.00 1024x768 ‎15 frames/second 08.Creating and Modifying Triggers
04.Triggers Demo 16.6 MB 0:10:41 ‎128kbps 489.00 1024x768 ‎15 frames/second 08.Creating and Modifying Triggers
01.View Concepts 9.72 MB 0:06:55 ‎128kbps 129.00 1024x768 ‎15 frames/second 09.Creating and Modifying Views
02.View Syntax 4.96 MB 0:03:33 ‎128kbps 87.00 1024x768 ‎15 frames/second 09.Creating and Modifying Views
03.View Demo 8.98 MB 0:05:15 ‎128kbps 456.00 1024x768 ‎15 frames/second 09.Creating and Modifying Views
01.Stored Procedure Concepts 5.16 MB 0:03:38 ‎128kbps 96.00 1024x768 ‎15 frames/second 10.Creating and Modifying Stored Procedures
02.Creating Stored Procedures 7.29 MB 0:05:10 ‎128kbps 82.00 1024x768 ‎15 frames/second 10.Creating and Modifying Stored Procedures
03.Stored Procedure Demo 6.66 MB 0:04:19 ‎128kbps 430.00 1024x768 ‎15 frames/second 10.Creating and Modifying Stored Procedures
01.Introduction 997 KB 0:00:38 ‎128kbps 97.00 1024x768 ‎15 frames/second 11.Creating and Modifying User Defined Functions
02.User Defined Function Concepts 2.64 MB 0:01:50 ‎128kbps 73.00 1024x768 ‎15 frames/second 11.Creating and Modifying User Defined Functions
03.Creating User Defined Functions 17.2 MB 0:10:35 ‎128kbps 595.00 1024x768 ‎15 frames/second 11.Creating and Modifying User Defined Functions
04.Apply Operators 6.75 MB 0:03:47 ‎128kbps 537.00 1024x768 ‎15 frames/second 11.Creating and Modifying User Defined Functions
[/spoiler]
Файлы примеров: отсутствуют
Формат видео: WMV
Видео: wmv3, 15 fps, 1024x768, 56~757 kbps
Аудио: wma2, 128kbps, 44.1kHz, Stereo
[spoiler="Скриншоты"]

[/spoiler]
Доп. информация: Exercise include slides only.