Docker Part 2: SQL Server Development And Testing

Name: Docker Part 2: SQL Server Development And Testing
Rating: 4.7 (23 reviews)

SQL Server and Docker Technology Integrated

Highest Rated

Created byRaphael Asghar

Last updated 11/2019

English

What you'll learn

This course is specifically designed for anyone who manages SQL Server or data. It will provide the students with the tools and experience on how to manage, create, and configure creating SQL Server containers, images, docker file, and docker compose file and much more. It provides step by step directions for creating SQL Server containers and images not in hours nor in minutes but in seconds! The great benefit of this technology is that the SQL DBA does not have to waste time, resource, and great effort in creating virtual machines, installing operating systems not installing SQL Server in a tedious and arduous fashion. He can now use docker technology to make his life easier. This docker technology is revolutionizing the way the IT industry test, develop and manage application.

Course content

1 section • 41 lectures • 6h 34m total length

INTRODUCTION TO DOCKER PART 2 SQL SERVER DEVELOPMENT AND TESTING2:37
1 SQL IS EVERY WHERE8:40
DOWNLOADABLE MATERIAL0:59
2 INSTALL SQL SERVER DEV ON DESKTOP11:30
Demonstrate installing SQL Server 2019 developer edition on a desktop across Windows, Linux, and Docker, including downloading the ISO image, selecting the developer edition, and configuring multiple instances with SSMS.
3 INSTALL SQL SERVER ON LINUX20:35
Learn to install sql server 2017 on linux by setting up a linux vm with virtualbox, ubuntu, and cli steps, then compare resources and time and preview docker deployment.
4 INSTALL SQL SERVER ON DIGITAL OCEAN CLOUD19:29
Install sql server 2017 on a DigitalOcean cloud using an Ubuntu 16.04 droplet, connect via SSH with MobaXterm, and configure a test database accessible via SSMS.
5 INSTALL SQL SERVER ON MAC WITH DOCKER9:12
Install sql server on mac with docker by installing docker desktop, pulling the sql server image, and running a container with accept eula and sa password.
6 INSTALL DOCKER IN UBUNTU DO3:30
Install docker on ubuntu and verify with docker version, testing with hello world. Learn to run Eskew server in docker for fast, resource-efficient testing on docker environments.
7 INSTALL SQL SERVER ON AZURE19:50
Install an eskew server on azure, create a resource group and a new server, configure a database, set up networking, manage costs, and connect via ssl-enabled sql tools.
8 INSTALL SQL SERVER 2017 ON DOCKER10:46
Install sql server 2017 using Docker; compare speed and resource usage across environments; configure Docker run with end-user license agreement and sa password, and map port 14 33.
9 INSTALL MULTIPLE SQL SERVER 2017 ON DOCKER23:53
Demonstrate deploying multiple SQL Server 2017 containers from a single Docker image on a DigitalOcean droplet, with memory planning and unique ports, accessible via ssms and Eskew command line.
10 SQL SERVER CONTAINERS NOT PERSISTANT12:35
11 BACKUP DATABASE IN CONTAINER5:39
12 RESTORE DATABASE19:42
13 MIGRATING DATABASES FROM DIFFERENT PLATFORMS10:45
Back up a SQL Server database on premise, migrate from Windows to Linux, then restore into a Docker container for testing.
15 SQL SERVER AND VOLUMES8:58
Learn how to persist data in docker by using volumes that decouple storage from containers, enabling sql server databases to survive container deletion during testing.
16 SQL SERVER AND VOLUMES AND PERSISTANT DATA7:14
17 USING DOCKER TO TEST PATCHING AND UPGRADE OF DATABASES8:53
Use docker to test patching and upgrading SQL Server 2017 databases by upgrading from CU13 to CU17 in a disposable container, preserving data with volumes and avoiding prod backups.
19 CUSTOMIZE BASE IMAGE OF SQL SERVER WITH STARTING SQL AGENT13:24
21 PUSH IMAGE TO HUB DOCKER15:56
Push a customized Docker image to the hub repository and verify it by deleting containers and pulling the image back. Recreate environments quickly and share production ready images with colleagues.
22 CUSTOMIZE BASE IMAGE OF SQL SERVER WITH ADDING DATABASES19:16
23 CUSTOMIZE BASE IMAGE OF SQL SERVER WITH DOCKERFILE18:39
Learn to customize a sql server base image with a dockerfile, including a database script, building a multi-layer image, and running a container with multiple databases for testing.
24 CUSTOMIZE BASE IMAGE OF SQL SERVER WITH DOCKER COMPOSE9:13
25 DOCKER COMPOSE WITH DOCKERFILE8:29
Build and run a sql server container from a predefined dockerfile with docker-compose, creating a develop database and a names table filled with sample data.
26 DOCKER ERROR LOGS8:17
Learn how to use docker logs, tail the last lines, filter by status, and identify exited containers using docker ps and container IDs.
26 SETTING UP A JOB WITH SQL AGENT11:05
Learn to enable the SQL Server agent in a Docker container using the environment variable, then create and test a backup job with scheduling and restore verification.
27 SETTING UP SNAPSHOT REPLICATION22:19
Configure snapshot replication in Docker to support high availability by setting up a publisher, distributor, and subscriber to synchronize sales data, using Docker Compose for two SQL Server instances.
30 DOCKER SECURITY AND PERMISSIONS7:21
31 QUIZ 11:27
Engage with the first quiz featuring multiple-choice questions and a hands-on mini project to practice docker commands. Review the provided answers at the bottom and reinforce learning through active execution.
32 QUIZ 1 ANSWER2:44
33 QUIZ 21:09
34 QUIZ 2 ANSWER5:58
35 QUIZ 32:42
Create a docker container, build a sales database with an id and first name table, insert data, back up, and migrate the backup from Windows to Linux.
36 QUIZ ANSWER 36:13
Execute docker-based SQL Server tasks by creating a container, connecting with SSMS, building a sales database with a names table, then back up and migrate the backup to Linux.
37 QUIZ 42:23
38 QUIZ 4 ANSWER5:16
Walks through the correct docker workflow to set up a container, create a backup directory, copy a backup into the container, and verify the backup inside the container in sequence.
39 QUIZ 52:19
40 QUIZ ANSWER 55:03
41 QUIZ 63:53
Learn to build and test a dockerized sql server setup by creating a docker file, a create dot ascii file, and a docker-compose.yaml to deploy accounts and finances.
42 QUIZ 6 ANSWER10:34
Build a custom image from a dockerfile and initialize three databases with a script. Use docker compose to run a container and map ports for testing the sql server.
43 FINISH UP5:54

Requirements

This course requires knowledge of Docker and some understating of SQL Server. As such, it is highly recommended that you take Docker part 1 course before taking this course. This course is designed with the intermediate SQL DBA in mind.

Description

This course is specifically designed for anyone who manages SQL Server or data. It will provide the students with the tools and experience on how to manage, create, and configure creating SQL Server containers, images, docker file, and docker compose file and much more. It provides step by step directions for creating SQL Server containers and images not in hours nor in minutes but in seconds! The great benefit of this technology is that the SQL DBA does not have to waste time, resource, and great effort in creating virtual machines, installing operating systems not installing SQL Server in a tedious and arduous fashion. He can now use docker technology to make his life easier. This docker technology is revolutionizing the way the IT industry test, develop and manage application.

Who this course is for:

Those students that have some knowledge of docker and some SQL Server administration course should take this course. Two prerequisite courses for this course are Docker part 1 and SQL Administration part 1