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 сервер баз данных сертификационные экзамены.
Содержание
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
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}