2015
Lynda
Ron Davis
3:22
English
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.
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
Download File Size:485.06 MB