SQL Server 2016 New Features for Developers [2016, ENG] torrent

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

SQL Server 2016 New Features for Developers

Год выпуска: 2016
Производитель: Pluralsight
Автор: Leonard Lobel
Продолжительность: 3h 42m
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: This course teaches the new developer features in SQL Server 2016, including Drop If Exists (DIE), SESSION_CONTEXT, dynamic data masking (DDM), row-level security (RLS), Always Encrypted, stretch database, temporal data, and built-in JSON support.

This demo-packed course, SQL Server 2016 New Features for Developers, teaches the many powerful features for developers that have been added in SQL Server 2016. First, you'll discover new security features such as dynamic data masking (DDM), row-level security (RLS), and Always Encrypted. Next, you'll learn about the innovative capabilities, including "stretch" database (allow select tables in an on-premises database to be transparently relocated in Azure SQL Database), and temporal data (enable "time travel" to access data as it existed at any point in time). You'll also learn about the new built-in Javascript Object Notation (JSON) support which enables bi-directional manipulation of JSON data in SQL Server. By the end of this course, you'll be ready for SQL Server 2016 and its exciting new developer features.

Это демо-упакованы Конечно, SQL Server 2016 Новые возможности для разработчиков, учит множество мощных функций для разработчиков, которые были добавлены в SQL Server 2016. Во-первых, вы откроете для себя новые функции безопасности, такие как динамические маскирование данных (DDM), row- уровень безопасности (RLS), и всегда шифруется. Далее вы узнаете об инновационных возможностях, в том числе базы данных "Растягивание" (позволяют выбирать таблицы во включенном локальной базе данных, чтобы быть прозрачно переведены в Azure SQL базы данных), и временные данные (позволяют "путешествие во времени" для доступа к данным, поскольку в ней существовала в любой момент времени). Вы также узнаете о новом встроенном Javascript поддержки нотации Object (JSON), который обеспечивает двунаправленную обработку данных JSON в SQL Server. К концу этого курса, вы будете готовы к SQL Server 2016 и его новые захватывающие возможности для разработчиков.
[spoiler="Содержание"]
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
1. Course Overview 5.14 MB 00:02:35 ‎96kbps 177.00 1280x720 ‎30 frames/second 1. Course Overview
1. Introduction 10.2 MB 00:02:48 ‎83kbps 425.00 1280x720 ‎15 frames/second 2. Introduction and Overview
2. Overview of New SQL Server 2016 Developer Features 15.3 MB 00:05:23 ‎81kbps 315.00 1280x720 ‎15 frames/second 2. Introduction and Overview
3. SSMS vs. SSDT 3.79 MB 00:01:48 ‎84kbps 207.00 1280x720 ‎15 frames/second 2. Introduction and Overview
4. Just DIE (Drop if Exists) Please! 2.23 MB 00:01:11 ‎84kbps 177.00 1280x720 ‎15 frames/second 2. Introduction and Overview
5. Demo. DIE (Drop if Exists) 7.27 MB 00:02:01 ‎84kbps 416.00 1280x720 ‎15 frames/second 2. Introduction and Overview
6. Introducing SESSION_CONTEXT 5.86 MB 00:02:33 ‎85kbps 232.00 1280x720 ‎15 frames/second 2. Introduction and Overview
7. Demo. Sharing State with SESSION_CONTEXT 9.18 MB 00:02:41 ‎82kbps 393.00 1280x720 ‎15 frames/second 2. Introduction and Overview
8. Summary 1.59 MB 00:01:04 ‎82kbps 124.00 1280x720 ‎15 frames/second 2. Introduction and Overview
1. Introducing Dynamic Data Masking (DDM) 7.47 MB 00:03:03 ‎75kbps 264.00 1280x720 ‎15 frames/second 3. Dynamic Data Masking
2. Masking Table Columns and Data Types 7.30 MB 00:03:11 ‎75kbps 242.00 1280x720 ‎15 frames/second 3. Dynamic Data Masking
3. Mask Permissions 2.44 MB 00:01:15 ‎73kbps 197.00 1280x720 ‎15 frames/second 3. Dynamic Data Masking
4. Demo. Getting Started with DDM 21.0 MB 00:05:30 ‎77kbps 455.00 1280x720 ‎15 frames/second 3. Dynamic Data Masking
5. Demo. Using DDM with Different Data Types 27.1 MB 00:04:29 ‎71kbps 773.00 1280x720 ‎15 frames/second 3. Dynamic Data Masking
6. DDM Limitations and Considerations 2.84 MB 00:01:21 ‎73kbps 217.00 1280x720 ‎15 frames/second 3. Dynamic Data Masking
7. Summary 2.38 MB 00:01:29 ‎72kbps 149.00 1280x720 ‎15 frames/second 3. Dynamic Data Masking
01. Introducing Row-level Security 2.40 MB 00:01:12 ‎75kbps 201.00 1280x720 ‎15 frames/second 4. Row-level Security
02. Filter and Block Predicates 1.74 MB 00:00:55 ‎75kbps 187.00 1280x720 ‎15 frames/second 4. Row-level Security
03. Combining RLS Predicates 4.55 MB 00:02:08 ‎74kbps 221.00 1280x720 ‎15 frames/second 4. Row-level Security
04. Creating Security Predicate Functions 6.31 MB 00:02:34 ‎76kbps 264.00 1280x720 ‎15 frames/second 4. Row-level Security
05. Creating Security Policies 4.67 MB 00:02:20 ‎73kbps 203.00 1280x720 ‎15 frames/second 4. Row-level Security
06. Demo. Creating and Testing an RLS Predicate 40.5 MB 00:09:48 ‎80kbps 494.00 1280x720 ‎15 frames/second 4. Row-level Security
07. Demo. Implementing an RLS Security Policy 27.0 MB 00:07:22 ‎79kbps 431.00 1280x720 ‎15 frames/second 4. Row-level Security
08. Identifying Users for RLS 5.91 MB 00:02:12 ‎75kbps 297.00 1280x720 ‎15 frames/second 4. Row-level Security
09. Demo. Using Row-level Security in N-tier applications 44.9 MB 00:09:21 ‎77kbps 590.00 1280x720 ‎15 frames/second 4. Row-level Security
10. Summary 1.07 MB 00:00:52 ‎73kbps 97.00 1280x720 ‎15 frames/second 4. Row-level Security
01. Traditional SQL Server Encryption Features 5.71 MB 00:02:30 ‎77kbps 239.00 1280x720 ‎15 frames/second 5. Always Encrypted
02. Introducing Always Encrypted 5.07 MB 00:02:03 ‎77kbps 264.00 1280x720 ‎15 frames/second 5. Always Encrypted
03. Encryption Types 3.01 MB 00:01:31 ‎75kbps 199.00 1280x720 ‎15 frames/second 5. Always Encrypted
04. Encryption Keys 3.33 MB 00:02:03 ‎78kbps 146.00 1280x720 ‎15 frames/second 5. Always Encrypted
05. Always Encrypted Workflow 11.7 MB 00:05:06 ‎80kbps 238.00 1280x720 ‎15 frames/second 5. Always Encrypted
06. Catalog Views for Always Encrypted Metadata 1.71 MB 00:00:59 ‎74kbps 165.00 1280x720 ‎15 frames/second 5. Always Encrypted
07. Demo. Encrypting an Existing Table 28.2 MB 00:07:08 ‎80kbps 470.00 1280x720 ‎15 frames/second 5. Always Encrypted
08. Demo. Querying and Storing Encrypted Data 30.1 MB 00:06:53 ‎78kbps 530.00 1280x720 ‎15 frames/second 5. Always Encrypted
09. CMK Rotation 2.92 MB 00:01:28 ‎74kbps 201.00 1280x720 ‎15 frames/second 5. Always Encrypted
10. Demo. Rotating the Column Master Key 12.5 MB 00:03:14 ‎77kbps 463.00 1280x720 ‎15 frames/second 5. Always Encrypted
11. Limitations and Considerations 3.97 MB 00:01:55 ‎74kbps 212.00 1280x720 ‎15 frames/second 5. Always Encrypted
12. Summary 2.95 MB 00:01:34 ‎75kbps 182.00 1280x720 ‎15 frames/second 5. Always Encrypted
01. Introducing Stretch Database 4.89 MB 00:02:26 ‎73kbps 204.00 1280x720 ‎15 frames/second 6. Stretch Database
02. Demo. Running the Stretch Database Advisor 11.2 MB 00:04:27 ‎71kbps 278.00 1280x720 ‎15 frames/second 6. Stretch Database
03. Stretch Database Terminology 3.02 MB 00:01:28 ‎72kbps 212.00 1280x720 ‎15 frames/second 6. Stretch Database
04. Stretch Database Workflow 1.96 MB 00:01:26 ‎68kbps 120.00 1280x720 ‎15 frames/second 6. Stretch Database
05. Demo. Preparing Azure for Stretch 4.66 MB 00:02:24 ‎62kbps 206.00 1280x720 ‎15 frames/second 6. Stretch Database
06. Demo. Stretching a Table 47.2 MB 00:09:58 ‎69kbps 591.00 1280x720 ‎15 frames/second 6. Stretch Database
07. Stretching selected Rows 6.01 MB 00:02:38 ‎76kbps 240.00 1280x720 ‎15 frames/second 6. Stretch Database
08. Demo. Stretching Selected Rows 28.2 MB 00:05:50 ‎64kbps 609.00 1280x720 ‎15 frames/second 6. Stretch Database
09. Stretch Pricing 2.05 MB 00:01:06 ‎72kbps 185.00 1280x720 ‎15 frames/second 6. Stretch Database
10. Limitations and Considerations 4.47 MB 00:02:00 ‎73kbps 236.00 1280x720 ‎15 frames/second 6. Stretch Database
11. Summary 1.41 MB 00:00:59 ‎69kbps 129.00 1280x720 ‎15 frames/second 6. Stretch Database
01. Introducing Temporal Tables 3.49 MB 00:02:04 ‎65kbps 167.00 1280x720 ‎15 frames/second 7. Temporal Data
02. Using Temporal 8.59 MB 00:03:55 ‎72kbps 231.00 1280x720 ‎15 frames/second 7. Temporal Data
03. Demo. Creating a Temporal Table 17.9 MB 00:04:04 ‎71kbps 542.00 1280x720 ‎15 frames/second 7. Temporal Data
04. Demo. Converting an Existing Table to Temporal 4.22 MB 00:00:51 ‎57kbps 634.00 1280x720 ‎15 frames/second 7. Temporal Data
05. Demo. Querying Temporal Data 39.7 MB 00:06:38 ‎69kbps 765.00 1280x720 ‎15 frames/second 7. Temporal Data
06. Demo. Combining Temporal with Stretch 29.1 MB 00:05:26 ‎57kbps 689.00 1280x720 ‎15 frames/second 7. Temporal Data
07. Demo. Hiding Period Columns 3.59 MB 00:00:46 ‎51kbps 600.00 1280x720 ‎15 frames/second 7. Temporal Data
08. Demo. Managing Schema Changes 5.15 MB 00:01:15 ‎56kbps 517.00 1280x720 ‎15 frames/second 7. Temporal Data
09. Limitations and Considerations 5.38 MB 00:02:00 ‎78kbps 294.00 1280x720 ‎15 frames/second 7. Temporal Data
10. Summary 1.37 MB 00:01:00 ‎67kbps 121.00 1280x720 ‎15 frames/second 7. Temporal Data
01. JSON and SQL Server 6.36 MB 00:02:51 ‎75kbps 233.00 1280x720 ‎15 frames/second 8. Built-in JSON Support
02. Bidirectional JSON Transformation 3.46 MB 00:01:45 ‎74kbps 199.00 1280x720 ‎15 frames/second 8. Built-in JSON Support
03. FOR JSON clause 4.08 MB 00:02:30 ‎74kbps 151.00 1280x720 ‎15 frames/second 8. Built-in JSON Support
04. Demo. Querying with FOR JSON AUTO 22.4 MB 00:06:32 ‎77kbps 399.00 1280x720 ‎15 frames/second 8. Built-in JSON Support
05. Demo. Querying with FOR JSON PATH 15.9 MB 00:04:39 ‎73kbps 400.00 1280x720 ‎15 frames/second 8. Built-in JSON Support
06. Built-in JSON Functions 4.51 MB 00:02:05 ‎74kbps 226.00 1280x720 ‎15 frames/second 8. Built-in JSON Support
07. JSON Path Expressions 5.46 MB 00:02:49 ‎71kbps 196.00 1280x720 ‎15 frames/second 8. Built-in JSON Support
08. Demo. Storing JSON 12.8 MB 00:03:59 ‎73kbps 373.00 1280x720 ‎15 frames/second 8. Built-in JSON Support
09. Demo. Querying JSON 9.72 MB 00:02:38 ‎67kbps 445.00 1280x720 ‎15 frames/second 8. Built-in JSON Support
10. Shredding JSON 3.05 MB 00:01:20 ‎75kbps 241.00 1280x720 ‎15 frames/second 8. Built-in JSON Support
11. Demo. Getting Started with OPENJSON 12.1 MB 00:03:41 ‎67kbps 391.00 1280x720 ‎15 frames/second 8. Built-in JSON Support
12. Demo. Parsing Parent-child Objects with OPENJSON 10.7 MB 00:03:00 ‎77kbps 418.00 1280x720 ‎15 frames/second 8. Built-in JSON Support
13. Demo. Using OPENJSON with an Explicit Schema 7.83 MB 00:02:32 ‎72kbps 357.00 1280x720 ‎15 frames/second 8. Built-in JSON Support
14. Summary 1.50 MB 00:01:17 ‎73kbps 86.00 1280x720 ‎15 frames/second 8. Built-in JSON Support
[/spoiler]
Файлы примеров: отсутствуют
Формат видео: MP4
Видео: mpeg-4 AVC, 15 fps, 1280x720, ~312 kbps
Аудио: mp4a aac, 51~96kbps, 44.1kHz, Stereo
[spoiler="Скриншоты"]

[/spoiler]
Доп. информация: Course contains Slides, Code Files and Subtitles