- VSTS and SSDT overview
- Version controlling a database
- Branching and merging
- Local deployments
- Building, releasing, and testing an SQL database
- SQL Server database issues
Skill Level Intermediate
- Hello there, my name's Brian Randell and I've been working with databases for multiple decades. I don't really want to get into the number of years 'cause it just makes me older, but I love building applications that have a database as their foundation and having done this since the Dark Ages, I'll have to say that living in the modern era and having great DevOps tools has changed the way I think about building applications and how I deal with my database. Hopefully, as you go through this course, you'll get to understand why I'm so excited.
We're gonna look at Visual Studio Team Services. We're gonna look at deploying databases from a local machine to a local database server, but even better, we're gonna build a complete CICD pipeline with Visual Studio Team Services, Microsoft Azure, and Sequel Database. You'll first learn about why it's important to have good tools, we'll look at SSDT, and we'll look at the Visual Studio Team Services platform. Then we'll jump right in and look at how version control helps manage our database definitions.
We'll look at how we can have work item tracking to get great traceability. And let's be clear, I'm not gonna overload you with process and project management. I'm gonna show you why just enough traceability with work items will make your life better. Then we'll get to the really good stuff: automated builds. Defining release pipelines where we can hands-off have updates to our database be deployed to one or more environments. We'll look at how quality is something that you should bake in from the beginning and we'll see how we can have tests running locally in your devbox, or even better, as part of your release pipeline.
And finally, I'm gonna show you some real word issues that you're gonna run into when trying to automate your databases and bringing DevOps. When we do this, we're gonna look at things like stacked data loading, and more importantly I'm gonna show you in an example where you can have a website deploying automatically with a database all in a hands-off fashion from commit, to build, to release. So hopefully you're as excited as I am and are ready to get started learning about database DevOps with VSTS, Azure, and Sequel Database.
What you should know2m 28s
1. Tooling Overview
2. Version Control Your Database
3. Agents and Pipelines
4. Build Your Database
5. Release Your Database
6. Test Your Database
7. Real-World Issues
Next steps1m 11s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.