YoVDO

DevOps for Databases

Offered By: Microsoft via edX

Tags

DevOps Courses Databases Courses Unit Testing Courses Continuous Integration Courses Database Management Courses Release Management Courses

Course Description

Overview

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.


Syllabus

  • 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

Taught by

Steve Jones and Greg Low

Tags

Related Courses

AZ-400: Designing and Implementing Microsoft DevOps Solutions
A Cloud Guru
Building a Continuous Integration Pipeline with Travis CI
A Cloud Guru
Certified Jenkins Engineer
A Cloud Guru
CloudFormation Deep Dive
A Cloud Guru
DevOps Concepts
A Cloud Guru