- Installing, upgrading, and uninstalling SQL Server on Linux
- Connecting to SQL Server on Linux
- Issuing T-SQL commands
- Installing Docker on Windows and macOS
- Connecting to SQL Server from inside and outside a container
- Sharing data across containers
- Installing SQL tools on macOS
- Connecting to SQL Server on macOS
- Using SQL Operations Studio
- Backing up a database in Operations Studio
Skill Level Intermediate
- [Adam] Hi, my name is Adam Wilbert, and I'd like to welcome you to SQL Server 2017: Linux, Docker, and macOS. Support for Linux and Docker came with the 2017 release of SQL Server, which dramatically opens up the options for installing and working with a robust Database Engine on those platforms. SQL Server is no longer tied to the Windows OS. This new capability allows system architects and data scientists to keep costs low while maintaining the rich feature set of full-fledged SQL Server instance. In this course, I'm going to take you through the setup process to get your own server instances running on a Linux computer and in a Docker container.
I'll show you how to connect to the Database Engine to create and manage databases, as well as how to keep your instance up to date with any available software updates and security patches. While we're exploring new platforms, I thought it would also be beneficial to take a look at the state of SQL Server on macOS. While the Database Engine isn't yet available natively, Microsoft has released a few tools to help Mac users interact with the server instances running on other platforms. So we'll take a look at those as well. I think SQL Server 2017 is going to go down as one of the most important updates in the product's history simply because of the freedom that it gives to install the product anywhere.
So let's get started exploring your new-found options.