SQL Server Containerization: Modern Deployment Strategies for Data-Driven Organizations
56mIntermediate2023-10-02
Authors
Ben Weissman
Course details
More and more companies are utilizing containerized applications and CI/CD approaches and pipelines. This shift, however, can never be complete without also meeting the needs of today’s data-driven world. In this course, instructor Ben Weissman shows you how to deploy Microsoft SQL Server on non-Windows platforms such as Linux, Docker containers, and Kubernetes.
Explore the fundamentals of running SQL Server on Linux, from planning and deployment to access and integration. Ben provides an overview of using Docker to work with SQL Server from both your local system as well as externally, before turning to the basics of deploying and running SQL Server on Kubernetes with a freshly installed cluster. By the end of this course, you’ll also take a peak on how to manage your data estate even more effectively using Azure Arc-enabled data services.
Explore the fundamentals of running SQL Server on Linux, from planning and deployment to access and integration. Ben provides an overview of using Docker to work with SQL Server from both your local system as well as externally, before turning to the basics of deploying and running SQL Server on Kubernetes with a freshly installed cluster. By the end of this course, you’ll also take a peak on how to manage your data estate even more effectively using Azure Arc-enabled data services.
Skills covered
SQL ServerSoftware DeploymentDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesNetwork and System AdministrationData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - SQL Server on Linux, containers, and Kubernetes
- 02 - Demo environment and prerequisites
1. SQL Server on Linux
- 03 - How to run SQL Server on Linux
- 04 - Deploying SQL Server on Linux
- 05 - Accessing a SQL Server on Linux
- 06 - Integrating SQL Server on Linux with Active Directory
2. SQL Server on Containers
- 07 - Container fundamentals and Docker installation
- 08 - Deploying and accessing SQL Server using Docker
- 09 - Working with a SQL Server using Docker
- 10 - Integrating SQL Server on containers with Active Directory
3. SQL Server on Kubernetes
- 11 - Kubernetes fundamentals
- 12 - Installing Kubernetes
- 13 - Deploying and accessing SQL Server on Kubernetes
- 14 - Working with and maintaining SQL Server on Kubernetes
- 15 - Integrating SQL Server on Kubernetes with Active Directory
- 16 - Azure Arc-enabled data services
Conclusion
- 17 - Summary