Developing Microsoft SQL Server 2014 Databases Год выпуска: 2015 Производитель: Lynda Сайт производителя: lynda.com Автор: Ron Davis Продолжительность: 3:22 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: Learn how to develop databases with the latest version of SQL Server. Ron Davis shows how to design tables and views, use constraints, and create and implement indexes. He also discusses stored procedures, and using triggers to modify data. Plus, learn about features unique to SQL Server 2014: in-memory tables and in-memory (or natively compiled) stored procedures. Научиться разрабатывать базы данных с последней версией SQL сервера. Рон Дэвис показывает, как проектировать таблицы и представления, использовать ограничения, и создать и осуществить индексов. Он также рассмотрены хранимые процедуры, триггеры и с помощью для изменения данных. Плюс, узнать об особенностях уникального для SQL Server 2014 г: таблицы в памяти и в памяти (или скомпилированы) хранимые процедуры.
Содержание
Introduction Welcome What you should know before watching this course 1. Working with SQL Server Development Tools Using SQL Server Management Studio Managing projects with SSMS Using SQL Server data tools Creating database diagrams Understanding the SQL Server services 2. Designing Data Tables Reviewing database normalization Introduction to designing tables Designing tables Utilizing schemas with tables Exploring SQL Server data types Altering tables 3. Understanding the Concept of Constraints Using constraints to enforce integrity More on using constraints to enforce integrity Implementing check constraints Implementing entity constraints Implementing referential integrity 4. Storage and Indexes Understanding the SQL file structure How SQL stores data How SQL locates data Implementing nonclustered indexes 5. Designing Views Introducing views Creating and managing views 6. Working with Stored Procedures Understanding stored procedures Using parameters with stored procedures 7. Performing Data Modification with Triggers Understanding triggers Utilizing triggers 8. In-Memory Databases What is in-memory? In-memory: More details Creating in-memory tables In-memory stored procedures Migrating Conclusion Next steps
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}