Overview
-
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
- Linux prerequisites for SQL Server
- Linux basics
- Installing SQL Server on Ubuntu
- Upgrading SQL Server
- Uninstalling SQL Server
- Stop and restart the server
- Installing mssql-tools
- Run sqlcmd in a Linux terminal
- Issue T-SQL commands
- Install additional services
- Connect using SSMS on Windows
- 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
- Change the SA account password
- Run multiple instances of SQL Server
- Sharing data across containers
- Perform an external backup
- Understand macOS integration
- Install Homebrew
- tap and brew mssql-tools
- Connect to a SQL Server instance
- Extract data with bcp
- What is Operations Studio?
- Get started with Operations Studio
- Write T-SQL commands
- Back up a database
- Next steps
