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
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQLudemy
Category: Sql, Data processing and analysis
Duration 12 hours 32 minutes 7 seconds
Course
SQL - MySQL for Data Analytics and Business Intelligenceudemy
Category: Sql
Duration 9 hours 22 minutes 55 seconds
Course
PostgreSQL Fundamentalsbigmachine.io
Category: Sql
Duration 2 hours 5 minutes 18 seconds
Course
SQL & MySQL Subqueries: Understanding the weird partsudemy
Category: Sql
Duration 8 hours 53 minutes 49 seconds
Course
DevOps from Start to Finishiamtimcorey.com (Tim Corey)
Category: C Sharp (C#), Other (Devops)
Duration 5 hours 43 minutes 19 seconds
Course
Mastery with SQLmasterywithsql.com
Category: Sql
Duration 9 hours 15 minutes 2 seconds
Course
Database Design & Implementationamigoscode (Nelson Djalo)
Category: Sql, Other (Backend)
Duration 2 hours 7 minutes 49 seconds
Course