Database DevOps from Start to Finish

2h 40m 37s
English
Paid

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.

Read more about the course

It has tools built-in for wildcard completion, refactoring, Intellisense, and more. In this course, we will cover the following topics:

  • Creating a new database in SSDT
  • Modifying an existing database with SSDT
  • Adding a database to source control (using git)
  • Refactoring a database
  • Enacting an automated CI/CD pipeline for our database
  • 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 Online Database DevOps from Start to Finish

Join premium to watch
Go to premium
# Title Duration
1 Course Overview 03:40
2 Introduction to SQL Server Data Tools 04:53
3 Project Setup 09:13
4 Table Creation 18:48
5 View Creation 06:53
6 Stored Procedure Creation 07:49
7 Publishing the Database 15:49
8 Updating the Database 12:54
9 Importing the Database 06:59
10 Publishing Changes 04:39
11 Bring in External Changes 12:35
12 Source Control 08:02
13 Refactoring 10:44
14 Automated Deployments 23:37
15 Pre/Post Scripts 13:27
16 Conclusion 00:35

Similar courses to Database DevOps from Start to Finish

Docker for DevOps Engineers

Docker for DevOps Engineersamigoscode (Nelson Djalo)

Category: Docker, Other (Devops)
Duration 4 hours 41 minutes 11 seconds
Complete SQL Mastery

Complete SQL Masterycodewithmosh (Mosh Hamedani)

Category: Sql
Duration 10 hours 47 minutes 7 seconds
Learn MySQL and Solve 42 Practical Problems

Learn MySQL and Solve 42 Practical Problemsudemy

Category: Sql
Duration 4 hours 24 minutes 35 seconds
Effective Database Design

Effective Database DesignBen Brumm

Category: Sql, Other (Backend)
Duration 1 hour 3 minutes 56 seconds
DevOps Bootcamp: Learn Linux & Become a Linux Sysadmin

DevOps Bootcamp: Learn Linux & Become a Linux Sysadminzerotomastery.io

Category: Other (Devops)
Duration 24 hours 11 minutes 36 seconds
Ultimate Expert Guide: Mastering PostgreSQL Administration

Ultimate Expert Guide: Mastering PostgreSQL Administrationudemy

Category: Sql
Duration 10 hours 19 minutes 42 seconds
SQL & MySQL Subqueries: Understanding the weird parts

SQL & MySQL Subqueries: Understanding the weird partsudemy

Category: Sql
Duration 8 hours 53 minutes 49 seconds
Node, SQL, & PostgreSQL - Mastering Backend Web Development

Node, SQL, & PostgreSQL - Mastering Backend Web Developmentudemy

Category: Sql, Node.js, Other (Backend)
Duration 4 hours 59 minutes 41 seconds
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQLudemy

Category: Sql, Data processing and analysis
Duration 12 hours 32 minutes 7 seconds