SQL Server 2014 [2014, ENG] torrent

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

SQL Server 2014 (Exam 70-464)

Год выпуска: 09/2014
Производитель: VTC
Сайт производителя: vtc.com/products/sqlexam464.htm
Автор: Mark Long
Продолжительность: 8:22
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: SQL Server is the foundation of Microsoft's comprehensive data platform. SQL Server 2014, the latest version, introduces new in-memory capabilities and other improvements are gaining a lot of attention in the database world. SQL Server 2014 will continue the explosive growth in this product, create more and more opportunities for those holding certifications on the Microsoft Data Platform. In this course, Mark Long brings his 20+ years of experience with SQL Server to you as he helps you prepare for Microsoft's 70-464 Developing Microsoft SQL Server Databases certification exam.

SQL-сервер-это основа компании Microsoft комплексной платформы данных. В SQL Server 2014 г, последняя версия, вводит новые возможности памяти и другие усовершенствования набирают большое внимание в базе данных мира. В SQL Server 2014 г будет продолжаться взрывной рост в этом продукте, создать больше возможностей для лиц, имеющих сертификаты на платформы данных Microsoft. В этом, конечно, Марк Лонг приносит свои 20+ лет опыта работы с SQL Server, чтобы вы как он помогает вам готовиться к Майкрософт 70-464 развивающихся Майкрософт SQL сервер баз данных сертификационные экзамены.
[spoiler="Содержание"]
Welcome/Intro
Welcome/Intro
Course Overview
Understanding SQL
Understanding TSQL
Microsoft SQL Server Certifications

SQL Server 2014 Essentials
What\\\'s New in 2014
SQL Server 2014 Editions

Installing SQL Server
Getting SQL Server 2014
Installing SQL Server 2014 pt. 1
Installing SQL Server 2014 pt. 2
Validating a SQL Server Installation pt. 1
Validating a SQL Server Installation pt. 2
Uninstalling SQL Server 2014
SQL Books Online Goes Online
Downloading Books Online
Attaching Adventureworks Sample dB pt. 1
Attaching Adventureworks Sample dB pt. 2
Where\\\'s the TSQL Reference

SQL Server Basics
SQL Server Instances
SQL Server Configuration Manager
SQL Server Management Studio
Understanding Databases
Table Basics
Understanding Primary Keys
Understanding Data Types pt. 1
Understanding Data Types pt. 2
Understanding Normalization
Understanding Foreign Keys
Database Types
Understanding Transaction Logs
System Databases
Understanding Schemas
Four Part Naming
Understanding Synonyms Part One
Understanding Synonyms Part Two
Refreshing Intellisense

Table Basics
Table Design Basics
Creating a Database
Creating Tables Graphically
Creating Tables with TSQL
Temporary Tables
Table Variables
Temp Table vs. Table Variable

Advanced Table Functionalities
Calculated Columns
Column Collation pt. 1
Column Collation pt. 2
Understanding Filegroups
Understanding Table Partitioning
FileStream Basics
Enabling FileStream
FileTable Basics
In-Memory OLTP
In-Memory OLTP Demo
Next Steps on In-Memory OLTP

Indexes
Index Basics
Clustered Indexes
Nonclustered Indexes
Pages and Extents
Understanding Fill Factor
Creating Indexes
Checking Index Fragmentation
Reorganizing and Rebuilding Indexes
Aligning Indexes on Partitioned Tables
Identifying Index Usage pt. 1
Identifying Index Usage pt. 2
Columnstore Indexes pt. 1
Columnstore Indexes pt. 2
Columnstore Index Characteristics

Programming Objects
Stored Procedures
Natively Compiled Stored Procedures
Using Parameters With SPs pt. 1
Using Parameters with SPs pt. 2
Error Handling in SPs pt. 1
Error Handling in SPs pt. 2
OFFSET and FETCH
Creating Views
Partitioned Views
Indexed Views

Concurrency and Locking
Understanding Concurrency
Pessimistic and Optimistic Locking
Normalization and Concurrency
Transaction Isolation Levels
Snapshot Isolation
Understanding Transactions
Explicit and Implicit Transactions
Using Explicit Transactions
Design for Minimal Locking
Monitoring and Managing Locking

Optimization
SQL Server Profiler
Creating a Trace pt. 1
Creating a Trace pt. 2
Extended Events
Performance Monitor and Profiler pt. 1
Performance Monitor and Profiler pt. 2
Performance Monitor and Profiler pt. 3
Monitoring In-Memory OLTP
Execution Plans

Working With XML Data
XML in SQL Server 2014
Retrieving XML from Relational Data
FOR XML
FOR XML PATH

Course Wrap-Up
Course Wrap-Up

About the Author
About the Author
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: AVC, 1280x720, 16:9, 15fps, 90.7kbps
Аудио: AAC, 48kHz, 132kbps, mono
[spoiler="Скриншоты"]

[/spoiler]