Overview
-
Learn how to develop databases with SQL Server 2014.
Syllabus
-
Introduction
- Welcome
- What you should know before watching this course
- Using SQL Server Management Studio
- Managing projects with SSMS
- Using SQL Server data tools
- Creating database diagrams
- Understanding the SQL Server services
- Reviewing database normalization
- Introduction to designing tables
- Designing tables
- Utilizing schemas with tables
- Exploring SQL Server data types
- Altering tables
- Using constraints to enforce integrity
- More on using constraints to enforce integrity
- Implementing check constraints
- Implementing entity constraints
- Implementing referential integrity
- Understanding the SQL file structure
- How SQL stores data
- How SQL locates data
- Implementing nonclustered indexes
- Introducing views
- Creating and managing views
- Understanding stored procedures
- Using parameters with stored procedures
- Understanding triggers
- Utilizing triggers
- What is in-memory?
- In-memory: More details
- Creating in-memory tables
- In-memory stored procedures
- Migrating
- Next steps
