Skip to main content

DevOps for Databases

About This Course

Welcome to the DevOps for Databases course. This course is part of a series of courses from Microsoft on DevOps techniques and practices. It supplements these courses by examining the challenges and solutions of incorporating your database into a DevOps software development process. This course will help you understand the challenges of working with various data stores while developing and changing your software at a rapid pace.

You will learn how to:

  • Define DevOps
  • Identify the challenges of using databases that are separate from other software languages and platforms
  • Include your database code alongside other application code in a version control system (VCS)
  • Set up a Continuous Integration (CI) platform for your database code
  • Write and include automated unit tests for your database code
  • Develop an automated release process that deploys database changes to both on premise and cloud databases
  • Implement branching and merging for your database code
  • Instrument and monitor the database after deployment

This course will show how to include your database in a DevOps process. While we will use Microsoft SQL Server in this course (and tailor our examples for it), other relational or non-relational database platforms have similar concepts that can be applied, but we will not examine specific techniques for those other products.

Requirements

Before taking this course, you should understand:

  • basic database development
  • relational database development
  • basic version control
  • how to execute scripts against a database platform

Course Staff

Course Staff Image #2

Steve Jones

Steve Jones has 25 years of SQL Server experience as a developer, DBA, and manager. He is the founder and editor of SQLServerCentral and an evangelist for Redgate Software. He has been a Data Platform MVP for 10 years.

Course Staff Image #2

Greg Low

Greg is a long-term Data Platform MVP, a Microsoft Regional Director, and the Principal Mentor for SQL Down Under in Melbourne, Australia. Greg is best known for his SDU Tools (Developer and DBA toolkits), and for his SQL Down Under podcast. He is the author of a number of whitepapers on MSDN, articles at SQL Server Pro, and several books.

  1. Course Number

    DEVOPS200.6
  2. Course Mode

    Self-Paced
  3. Estimated Effort

    8-16 hours total
Enroll