Database DevOps from Start to Finish
2h 40m 37s
English
Paid
Course description
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
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 |
Comments
0 commentsSimilar courses
DBMS
Sources: takeUforward
This course is dedicated to the study of Database Management Systems (DBMS) - technologies that allow for efficient storage, processing, and protection of data.
21 hours 30 minutes 50 seconds
The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert
Sources: udemy
If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but compreh...
36 hours 35 minutes 57 seconds
SQL - The Complete Guide (MySQL, PostgreSQL & more)
Sources: Academind Pro
SQL is THE most important query language you can learn! It's used by many popular database management systems like MySQL or PostgreSQL. But it's also used by data analysis and b...
19 hours 35 minutes 38 seconds
Node, SQL, & PostgreSQL - Mastering Backend Web Development
Sources: udemy
Become an in demand software engineer by taking this course on Node, SQL, PostgreSQL, and backend web development. As one of the most popular web development st
4 hours 59 minutes 41 seconds
Learn Database Design with MySQL
Sources: oreillymedia
Good course for starting up & covers quickly the important topics and shows for beginners what MySQL can be used for. Database design is one of the most importa
6 hours 14 minutes 51 seconds
Want to join the conversation?
Sign in to comment