Database DevOps from Start to Finish

2h 40m 37s
English
Paid
October 14, 2024

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.

More

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

Learn MySQL and Solve 42 Practical Problems

Learn MySQL and Solve 42 Practical Problemsudemy

Duration 4 hours 24 minutes 35 seconds
MySQL High Performance Tuning Guide

MySQL High Performance Tuning Guideudemy

Duration 2 hours 49 minutes 22 seconds
DevOps from Start to Finish

DevOps from Start to Finishiamtimcorey.com (Tim Corey)

Duration 5 hours 43 minutes 19 seconds
Database Design & Implementation

Database Design & Implementationamigoscode (Nelson Djalo)

Duration 2 hours 7 minutes 49 seconds