Overview
This course teaches learners how to incorporate relational databases like Microsoft SQL Server into a DevOps environment. By using tools to manage database changes, track them through different environments, and automate deployment processes, students will learn to treat the database as a first-class citizen alongside source code. The course covers topics such as version control, creating update packages, and deploying to various environments. The intended audience for this course includes developers, database administrators, and DevOps professionals looking to enhance their skills in managing and automating database changes within a DevOps framework.
Syllabus
Introduction
What is DevOps
Journey not destination
People and process
Technological win
SQL Server
Model Approach
Migrations
Considerations
Demo
Visual Studio
SQL Server Database Project
Import Options
Connection Properties
Database Catalog
Database Snapshot
Properties
Publishing
Data Tools Operations
Version Control
Pipelines
Create Pipeline
Build Pipeline Options
Continuous Deployment
Taught by
NDC Conferences