Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SQL Server 2014: Developing Databases

via LinkedIn Learning

Overview

Syllabus

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

Taught by

Ron Davis

Reviews

Start your review of SQL Server 2014: Developing Databases

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.