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.
Database DevOps from Start to Finish
2h 40m 37s
English
Paid
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.
About the Author: iamtimcorey.com (Tim Corey)
Tim learned software development the hard way - confusing tutorials, the uncertainty of what he was missing, and overall not understanding how to put the pieces together into a "real" application. Now, he teaches you in a way that avoids all of that unnecessary pain and struggle.
Watch Online 16 lessons
0:00
/ #1: Course Overview
All Course Lessons (16)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 1 | Course Overview Demo | 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 |
Unlock unlimited learning
Get instant access to all 15 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.
Learn more about subscription