Course Overview

Learn how to develop databases with SQL Server 2014.

Course Circullum

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

Ron Davis

out of 5.0

5 Star 85%

4 Star 75%

3 Star 53%

1 Star 20%

Item Reviews - 3

Submit Reviews

5 stars 4 stars 3 stars 2 stars 1 star

Name

Review

Free Trial Available

Enroll Now

This Course Include: