Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SQL Server 2017: Linux, Docker, and macOS

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
SQL Server is not just for Windows anymore. Learn how to install and connect to SQL Server 2017 on Linux, from Docker containers, and from macOS.

Syllabus

Introduction
  • Welcome
  • What you should know
1. Working in Linux
  • Linux prerequisites for SQL Server
  • Linux basics
2. Install SQL Server on Ubuntu
  • Installing SQL Server on Ubuntu
  • Upgrading SQL Server
  • Uninstalling SQL Server
  • Stop and restart the server
3. Connect to SQL Server on Linux
  • Installing mssql-tools
  • Run sqlcmd in a Linux terminal
  • Issue T-SQL commands
  • Install additional services
  • Connect using SSMS on Windows
4. Get Started with Docker
  • Docker prerequisites for SQL Server
  • Install Docker on Windows
  • Install Docker on macOS
  • Pull the SQL Server image
  • Connect to SQL Server within a container
  • Connect from outside the container
5. Work in a Docker Container
  • Change the SA account password
  • Run multiple instances of SQL Server
  • Sharing data across containers
  • Perform an external backup
6. SQL Tools on macOS
  • Understand macOS integration
  • Install Homebrew
  • tap and brew mssql-tools
  • Connect to a SQL Server instance
  • Extract data with bcp
7. SQL Operations Center
  • What is Operations Studio?
  • Get started with Operations Studio
  • Write T-SQL commands
  • Back up a database
Conclusion
  • Next steps

Taught by

Adam Wilbert

Reviews

4.5 rating at LinkedIn Learning based on 10 ratings

Start your review of SQL Server 2017: Linux, Docker, and macOS

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.