DevOps for Databases, Certificate

  • Application Deadline
  • 1 month
    Duration
  • English
    Language
EdX is an online learning platform trusted by over 12 million users offering the DevOps for Databases Certificate in collaboration with MicrosoftX. Learn about the challenges and uncover the solutions for incorporating your database into a DevOps software development process.

About

This DevOps for Databases Certificate is part of the Microsoft Professional Program in DevOps Professional Certificate, offered by EdX in partnership with MicrosoftX.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.

What you'll learn
  • Define DevOps and understand DevOps in relation to Databases
  • 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

Detailed Programme Facts

  • Deadline and start date Application deadline and start date were not specified by the programme.
  • Programme intensity Part-time
    • Average part-time duration 1 months
    • Intensity 2 hrs/week
    • Duration description

      4 weeks, 2 to 4 hours per week

  • Languages
    • English
  • Delivery mode
    Online
    • Time flexibility
      Self-paced
  • More information Go to the programme website

Programme Structure

Courses Included:
  • 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

Lecturers

  • Steve Jones - Developer, DBA and Manager, Redgate Software

  • Greg Low - MVP, a Microsoft Regional Director, and Principal Mentor, SQL Down Under

English Language Requirements

This programme requires students to demonstrate proficiency in English.

Schedule IELTS

Academic Requirements

Prerequisites

  • Understand basic database development
  • Understand relational database development
  • Knowledge and experience using basic version control
  • Knowledge how to execute scripts against a database platform

Tuition Fee

  • International Applies to you

    99 USD/full
    Tuition Fee
    Based on the original amount of 99 USD for the full programme and a duration of 1 months.
  • National Applies to you

    99 USD/full
    Tuition Fee
    Based on the original amount of 99 USD for the full programme and a duration of 1 months.
We've labeled the tuition fee that applies to you because we think you are from and prefer over other currencies.
5% discount coupon: Z7LZNQ4TN3B2JTWU valid for any free course + certificate upgrade

Funding

Check the programme website for information about funding options.

StudyPortals Tip: Students can search online for independent or external scholarships that can help fund their studies. Check the scholarships to see whether you are eligible to apply. Many scholarships are either merit-based or needs-based.

The Global Study Awards: get funded with up to £10,000 to study abroad

Together with the ISIC Association and British Council IELTS, StudyPortals offers you the chance to receive up to £10000 to expand your horizon and study abroad. We want to ultimately encourage you to study abroad in order to experience and explore new countries, cultures and languages.