SQL Server 2017: Linux, Docker, and macOS
Offered By: LinkedIn Learning
Course Description
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
Taught by
Adam Wilbert
Related Courses
Introduction to LinuxLinux Foundation via edX 操作系统原理(Operating Systems)
Peking University via Coursera Internet of Things: Setting Up Your DragonBoard™ Development Platform
University of California, San Diego via Coursera Information Security-3
Indian Institute of Technology Madras via Swayam Introduction to Embedded Systems Software and Development Environments
University of Colorado Boulder via Coursera