Expanded

Developing SQL Server Databases with Docker

As our infrastructure world moves to containers, our databases should be no exception. This course will teach you how to work with SQL Server in a Docker container context.
Course info
Rating
(12)
Level
Intermediate
Updated
Feb 24, 2021
Duration
1h 51m
Table of contents
Description
Course info
Rating
(12)
Level
Intermediate
Updated
Feb 24, 2021
Duration
1h 51m
Description

As our infrastructure world moves to containers, you need to understand how to move our databases to them as well. In this course, Developing SQL Server Databases with Docker, you’ll learn to create SQL Server Docker images. First, you’ll explore working with both Windows and Linux images. Next, you’ll discover how to resolve the tension between databases and container persistence. Finally, you’ll learn how to continually upgrade and manage your database schema. When you’re finished with this course, you’ll have the skills and knowledge of working with SQL Server images needed to containerize your database solutions.

About the author
About the author

Chris B. Behrens is a writer, speaker and software developer, specializing in DevOps. He has been a developer and architect for more than twenty years focusing on small to medium size companies and the development changes they face.

More from the author
Getting Started with Octopus Deploy
Intermediate
2h 5m
Apr 8, 2021
jQuery: The Big Picture
Beginner
1h 14m
Mar 10, 2021
More courses by Chris Behrens
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi, everyone. My name is Chris B. Behrens, and welcome to my course, Developing SQL Server Databases with Docker. SQL Server is one of the most widely used database platforms in the world, and the shift to containers is changing the way we work with them. At the root of this is the tension between stateless containers and very much stateful databases, and we'll tackle this paradox head on. Some of the major topics that we will cover include Windows versus Linux as the container host, solving that tricky state question, and a first‑class solution to upgrading your schema and data over time. By the end of this course, you will have the skills and knowledge of how to construct SQL Server instances in Docker, upgrade and maintain the schemas, and you'll learn a few tricks that will make your testing easier. Before beginning the course, you should be comfortable with Docker and SQL Server. From here, you should feel comfortable diving into advanced Docker and SQL Server courses on Big Data and Deploying SQL Containers to Azure. I hope you'll join me on this journey to learn how to work with SQL Servers in Docker with the Developing SQL Server Databases with Docker course at Pluralsight.