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

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

SQL Server 2012 Querying (70-461) Part 1

Год выпуска: 2012
Производитель: Pluralsight
Автор: Christopher Harrison
Продолжительность: 5h 12m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание:
Part 1 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 1 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.Intended Audience 4.73 MB 0:03:00 ‎128kbps 406.00 1024x768 ‎15 frames/second 01.Introduction to SQL Server 2012
02.Using This Course 5.80 MB 0:03:58 ‎128kbps 84.00 1024x768 ‎15 frames/second 01.Introduction to SQL Server 2012
03.Syntax Notes 2.45 MB 0:01:42 ‎128kbps 59.00 1024x768 ‎15 frames/second 01.Introduction to SQL Server 2012
01.Introduction 1.69 MB 0:01:07 ‎128kbps 95.00 1024x768 ‎15 frames/second 02.Introduction to Relational Databases
02.Database Concepts 4.53 MB 0:03:12 ‎128kbps 88.00 1024x768 ‎15 frames/second 02.Introduction to Relational Databases
03.Table Concepts 19.8 MB 0:13:45 ‎128kbps 77.00 1024x768 ‎15 frames/second 02.Introduction to Relational Databases
04.Table Design 5.34 MB 0:03:41 ‎128kbps 90.00 1024x768 ‎15 frames/second 02.Introduction to Relational Databases
05.Design Scenario 13.2 MB 0:08:56 ‎128kbps 146.00 1024x768 ‎15 frames/second 02.Introduction to Relational Databases
06.Orders and Products Notes 5.98 MB 0:04:08 ‎128kbps 118.00 1024x768 ‎15 frames/second 02.Introduction to Relational Databases
07.Working with Data 4.58 MB 0:03:09 ‎128kbps 88.00 1024x768 ‎15 frames/second 02.Introduction to Relational Databases
01.Management Studio Basics 18.3 MB 0:11:39 ‎128kbps 609.00 1024x768 ‎15 frames/second 03.Introduction to SELECT Statements
02.Referencing Objects 7.23 MB 0:05:16 ‎128kbps 105.00 1024x768 ‎15 frames/second 03.Introduction to SELECT Statements
03.Structure of a SELECT Statement 2.80 MB 0:01:53 ‎128kbps 64.00 1024x768 ‎15 frames/second 03.Introduction to SELECT Statements
04.Using SELECT Statements 18.0 MB 0:11:32 ‎128kbps 546.00 1024x768 ‎15 frames/second 03.Introduction to SELECT Statements
05.Column Aliases 8.33 MB 0:04:28 ‎128kbps 639.00 1024x768 ‎15 frames/second 03.Introduction to SELECT Statements
01.WHERE Statements 8.58 MB 0:05:38 ‎128kbps 470.00 1024x768 ‎15 frames/second 04.Filtering Results with WHERE Statements
02.Predicate Keywords 10.6 MB 0:05:05 ‎128kbps 994.00 1024x768 ‎15 frames/second 04.Filtering Results with WHERE Statements
03.Querying Strings with LIKE 14.0 MB 0:07:54 ‎128kbps 648.00 1024x768 ‎15 frames/second 04.Filtering Results with WHERE Statements
04.Filtering NULL Data 2.32 MB 0:01:14 ‎128kbps 488.00 1024x768 ‎15 frames/second 04.Filtering Results with WHERE Statements
01.Join Basics 7.08 MB 0:04:59 ‎128kbps 102.00 1024x768 ‎15 frames/second 05.Utilizing Joins
02.Join Syntax 9.73 MB 0:06:39 ‎128kbps 487.00 1024x768 ‎15 frames/second 05.Utilizing Joins
03.Inner Joins 9.01 MB 0:05:31 ‎128kbps 647.00 1024x768 ‎15 frames/second 05.Utilizing Joins
04.Outer Joins 9.00 MB 0:06:01 ‎128kbps 438.00 1024x768 ‎15 frames/second 05.Utilizing Joins
05.Self Joins 8.56 MB 0:05:55 ‎128kbps 377.00 1024x768 ‎15 frames/second 05.Utilizing Joins
06.Cross Joins 4.70 MB 0:02:34 ‎128kbps 726.00 1024x768 ‎15 frames/second 05.Utilizing Joins
01.Subquery Concepts 3.93 MB 0:02:37 ‎128kbps 106.00 1024x768 ‎15 frames/second 06.Executing Subqueries and UNION Statements
02.Using Subqueries 13.3 MB 0:08:07 ‎128kbps 427.00 1024x768 ‎15 frames/second 06.Executing Subqueries and UNION Statements
03.Predicates Used with Subqueries 12.6 MB 0:07:20 ‎128kbps 448.00 1024x768 ‎15 frames/second 06.Executing Subqueries and UNION Statements
04.UNION Statements 1.37 MB 0:00:54 ‎128kbps 94.00 1024x768 ‎15 frames/second 06.Executing Subqueries and UNION Statements
05.UNION Requirements 8.00 MB 0:04:42 ‎128kbps 588.00 1024x768 ‎15 frames/second 06.Executing Subqueries and UNION Statements
01.Introduction 2.04 MB 0:01:24 ‎128kbps 78.00 1024x768 ‎15 frames/second 07.Aggregating Data
02.Using Aggregate Functions 11.6 MB 0:07:43 ‎128kbps 428.00 1024x768 ‎15 frames/second 07.Aggregating Data
03.Using GROUP BY 7.09 MB 0:04:25 ‎128kbps 456.00 1024x768 ‎15 frames/second 07.Aggregating Data
04.Using HAVING 4.74 MB 0:02:56 ‎128kbps 574.00 1024x768 ‎15 frames/second 07.Aggregating Data
05.HAVING vs. WHERE 5.59 MB 0:03:24 ‎128kbps 587.00 1024x768 ‎15 frames/second 07.Aggregating Data
06.Data Rollups 19.1 MB 0:11:06 ‎128kbps 535.00 1024x768 ‎15 frames/second 07.Aggregating Data
07.GROUPING SETS 4.69 MB 0:02:42 ‎128kbps 735.00 1024x768 ‎15 frames/second 07.Aggregating Data
08.GROUPING and GROUPING_ID 7.64 MB 0:03:56 ‎128kbps 576.00 1024x768 ‎15 frames/second 07.Aggregating Data
01.Common Table Expressions (CTEs) 8.01 MB 0:04:58 ‎128kbps 399.00 1024x768 ‎15 frames/second 08.Advanced Data Aggregations
02.PIVOT and UNPIVOT 17.9 MB 0:10:58 ‎128kbps 709.00 1024x768 ‎15 frames/second 08.Advanced Data Aggregations
03.Sorting Data 7.76 MB 0:04:47 ‎128kbps 528.00 1024x768 ‎15 frames/second 08.Advanced Data Aggregations
04.TOP 2.68 MB 0:01:26 ‎128kbps 543.00 1024x768 ‎15 frames/second 08.Advanced Data Aggregations
05.Ranking Functions 8.45 MB 0:05:06 ‎128kbps 479.00 1024x768 ‎15 frames/second 08.Advanced Data Aggregations
06.Paging 5.32 MB 0:03:05 ‎128kbps 701.00 1024x768 ‎15 frames/second 08.Advanced Data Aggregations
07.DISTINCT Statement 6.51 MB 0:03:42 ‎128kbps 530.00 1024x768 ‎15 frames/second 08.Advanced Data Aggregations
01.Using Functions 8.81 MB 0:05:45 ‎128kbps 435.00 1024x768 ‎15 frames/second 09.Built-In Functions
02.Date-Time Functions 11.8 MB 0:06:31 ‎128kbps 583.00 1024x768 ‎15 frames/second 09.Built-In Functions
03.String Functions 10.2 MB 0:06:19 ‎128kbps 496.00 1024x768 ‎15 frames/second 09.Built-In Functions
04.Data Type Conversions 7.66 MB 0:04:21 ‎128kbps 462.00 1024x768 ‎15 frames/second 09.Built-In Functions
05.New Logic Functions 6.18 MB 0:03:27 ‎128kbps 460.00 1024x768 ‎15 frames/second 09.Built-In Functions
01.Introduction 1.20 MB 0:00:48 ‎128kbps 80.00 1024x768 ‎15 frames/second 10.Query Optimization
02.Indexes 9.67 MB 0:06:37 ‎128kbps 89.00 1024x768 ‎15 frames/second 10.Query Optimization
03.Statistics 3.49 MB 0:02:23 ‎128kbps 67.00 1024x768 ‎15 frames/second 10.Query Optimization
04.Query Plans 14.8 MB 0:09:09 ‎128kbps 519.00 1024x768 ‎15 frames/second 10.Query Optimization
05.Query Hints 4.75 MB 0:03:16 ‎128kbps 68.00 1024x768 ‎15 frames/second 10.Query Optimization
06.Dynamic Management Objects 2.95 MB 0:01:58 ‎128kbps 81.00 1024x768 ‎15 frames/second 10.Query Optimization
07.Dynamic SQL 4.74 MB 0:02:45 ‎128kbps 407.00 1024x768 ‎15 frames/second 10.Query Optimization
01.Modifying Data 3.88 MB 0:02:39 ‎128kbps 132.00 1024x768 ‎15 frames/second 11.Modifying Data
02.INSERT Statements 9.68 MB 0:05:07 ‎128kbps 732.00 1024x768 ‎15 frames/second 11.Modifying Data
03.UPDATE Statements 9.58 MB 0:05:52 ‎128kbps 403.00 1024x768 ‎15 frames/second 11.Modifying Data
04.DELETE Statements 5.30 MB 0:03:00 ‎128kbps 500.00 1024x768 ‎15 frames/second 11.Modifying Data
01.Introduction 845 KB 0:00:32 ‎128kbps 87.00 1024x768 ‎15 frames/second 12.Advanced Data Modification
02.OUTPUT Statements 7.22 MB 0:04:40 ‎128kbps 435.00 1024x768 ‎15 frames/second 12.Advanced Data Modification
03.MERGE Statements 4.69 MB 0:03:18 ‎128kbps 87.00 1024x768 ‎15 frames/second 12.Advanced Data Modification
04.MERGE Demo 9.63 MB 0:05:49 ‎128kbps 485.00 1024x768 ‎15 frames/second 12.Advanced Data Modification
[/spoiler]
Файлы примеров: отсутствуют
Формат видео: WMV
Видео: wmv3, 15 fps, 1024x768, 59~994 kbps
Аудио: wma2, 128kbps, 44.1kHz, Stereo
[spoiler="Скриншоты"]

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