Database Lifecycle Management (DLM) is a comprehensive approach to managing the database schema, data and metadata for a database application. It encompasses the established principles and practices of DevOPs and allows you, the data professional to apply them when deploying changes and code to your SQL Server databases.
Using both Redgate tools as well as Team City and Octopus Deploy we have designed this course 1 of 3 that will train you in the principles of DevOPs and DLM focusing specifically on Source Control for the Database.
This course will be run on our own hosted standardised VMs which you will use for the practical aspects of the course and are your very own area to play with and test things out. Do not worry about breaking things, that is the point, we want you to try things out during this course!!
Course Outline
Module 1: Source Control and the Database
In this module we will teach you:
- Introduction to how DevOPs can be applied to databases
- Using Redgate’s SQL Clone to provision DEV/TEST databases
- How we can represent a SQL Server Database as code
- Introduction to Source Control basics using git commands and utilities
- Using Redgate’s SQL Source Control to connect SQL Server database to version control
- Tools and techniques to fix issues when branching/merging code goes wrong
Who is this course for:
This course is for the DBA, Developer or Tester who works with making/deploying changes to SQL Server Databases. By utilising DevOPs principles in the deployment process this course will teach you how to achieve repeatable, reliable automated deployments to a production database.