DevOps for Databases

Learn about the challenges and uncover the solutions for incorporating your database into a DevOps software development process.

( 0 Reviews )

Created by: Greg Low

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 0 / 100

Course Description

This course examines 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 where and how databases can fit into DevOps processes.
The course will cover: Committing database code to a version control system (VCS), Continuous Integration and unit testing database code.
Release management for databases, in areas such as release gates, deploying releases to multiple environments, validating deployments with smoke tests and rolling back deployments.
Monitoring database code, branching and merging database code, cross databases dependencies, upgrading multiple databases, federated databases, dark launching, error handling and cleaning up technical debt with databases.
Finally, while the course will primarily use Microsoft SQL Server (and tailor our examples for it), other relational or non-relational database platforms have similar concepts that can be applied.
Module 0 | Welcome to DevOps for Databases
Course Overview
Microsoft Learning
Pre-Course Survey
Module 1 | Overview of DevOps
Module 1 Overview
Overview of DevOps
Database Development Issues in a DevOps Process
Database Development Paradigms
Collaboration
Module 1 Labs
Module 1 Review Questions
Database Development
Module 2 | Overview
Overview of DevOps for Databases
Committing Database Code to a VCS
Continuous Integration for Databases
Unit Testing Database Code
Module 2 Labs
Module 2 Review Questions
Module 3 | Releasing Database Changes
Module 3 Overview
Overview of Release Management
Deploying Releases
Release Gates
Release Details
Rollbacks
Module 3 Labs
Module 3 Review Questions
Module 4 | Advanced Topics
Module 4 Overview
Monitoring Your Systems
Branching and Merging Database Code
Provisioning
Best Practices
Advanced Customer Scenarios current Section
Module 4 Labs
Module 4 Review Questions
Final Exam
Final Exam(Graded)
Post-Course Survey

Advanced Level

Time: 4 Weeks - 2-4 hours per week

Instructor Details

Greg Low

0.0 Rating
0 Reviews

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.