DevOps for Databases

DevOps for Databases

LaaS bundle

Microsoft DEVOPS200.6x-LAAS

From For free

To USD 397.00

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.

Course 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

What you will 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
Write Your Own Review

Only registered users can write reviews. Please Sign in or create an account

E-Learning

Official Microsoft Course

DevOps for Databases

DevOps for Databases

Microsoft DEVOPS200.6x
Microsoft
Open edX
90 days
Microsoft Certificate of Completion

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.

Official Microsoft Certificate

Microsoft Certificate of Completion

Microsoft Certificate of Completion

Microsoft A85-04383
USD 99.00
Microsoft
Microsoft Certificate of Completion

Original Microsoft Certificate of Completion


Get your Original Microsoft Certificate of Completion that certifies the successful passing of a Microsoft Massive Open Online Course (MOOC).

Learning-as-a-Service (Optional)

1:1 Coaching - 1 hour

Microsoft 1:1 Coaching

Microsoft 1:1 Coaching

MS-COACH
USD 199.00
Don’t waste time searching for answers when being stuck with a problem. Schedule an individual virtual meeting with a dedicated subject-matter expert and explore more difficult topics interactively using screen sharing capabilities.

Learning-as-a-Service

Q&A Support

Microsoft Q&A Support

Microsoft Q&A Support

MS-QA-SUPPORT
USD 99.00
Ask questions, get opinions and explore ideas with a dedicated subject-matter expert..

* Required Fields

DevOps for Databases

LaaS bundle Microsoft DEVOPS200.6x-LAAS

For free