Training

Database DevOps From Start to Finish

Use SQL Server Data Tools for database design, refactoring, source control, CI/CD, and more

16 lessons2.5 hoursEN & ES subtitles

What you'll work with

SQL Database creationTablesViewsStored ProceduresSource ControlRefactoringDeploymentUpdating Existing Databases

About this course

If you have only ever built a database using SQL Server Management Studio (SSMS), you are in for a treat. SQL Server Data Tools (SSDT) is designed for building databases. It has tools built-in for wildcard completion, refactoring, Intellisense, and more.

Along the way, you will become a better SQL developer and have a better grasp on how to manage and deploy a SQL database efficiently and effectively.

If that sounds like something you could benefit from, or if you are still not sure, check out the course introduction videos, which are free to view.

Watch the course intro →

What you'll be able to do

  • Build a SQL Database
  • Secure your database with source control
  • Deploy and update a database
  • Automate database management

Every lesson, in the open

16 lessons · 2.5 hours of video. Here's exactly what's inside.

BasicsLearn how to build a SQL database with SSDT
  1. 1
    Introduction 2 lessons · 7 min
    • Course Overview 3:39
    • Introduction to SQL Server Data Tools 4:52
  2. 2
    Building a New Database 6 lessons · 1h 07m
    • Project Setup 9:12
    • Table Creation 18:47
    • View Creation 6:52
    • Stored Procedure Creation 7:48
    • Publishing the Database 15:48
    • Updating the Database 12:53
AdvancedUse SSDT in the real world
  1. 3
    Modifying an Existing Database 3 lessons · 22 min
    • Importing the Database 6:58
    • Publishing Changes 4:38
    • Bring in External Changes 12:34
  2. 4
    Additional Features 4 lessons · 54 min
    • Source Control 8:01
    • Refactoring 10:43
    • Automated Deployments 23:36
    • Pre/Post Scripts 13:26
  3. 5
    Conclusion 1 lesson · 1 min
    • Conclusion 0:34
Tim Corey

Hi, I'm Tim Corey.

I learned software development the hard way, with lots of dead-ends, confusion, and knowledge gaps. I kept thinking, “It shouldn't be this hard!” Now I teach students how to think and code like professional developers. My goal is to make it easier for you to become a developer.

25+ Years experience
400,000+ Students taught
400+ Hours of training
10x Microsoft MVP

Frequently asked questions

When does this course start and finish?
The course starts now and never ends! It is a completely self-paced online course; you decide when you start and when you finish.
How long do I have to access the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like; across any and all devices you own.
What if I am unhappy with the course?
I do my best to provide the highest quality training to help you become a successful developer. But if this course isn't for you, then you can count on a no-hassle 30 Day Money Back Guarantee.

This course is part of a Learning Path

Take Database DevOps From Start to Finish on its own, or follow a path that builds around it.

Optional Back-End C# You are now a back-end C# developer!