SQL Server 2014: Developing Databases

Learn how to develop databases with 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