SQL Server 2017: Linux, Docker, and macOS

SQL Server 2017: Linux, Docker, and macOS

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 44m | 229 MB

SQL Server has traditionally run only on Windows. New for 2017 is the ability to install server instances and work with databases on Linux and in Docker containers, which opens the possibility of running SQL Server on macOS. With the extension tools now available as native Linux and macOS applications, users can capitalize on the variety of options available for running a database instance. This course shows how to install SQL Server on new platforms, and how to connect to it from a newly diverse array of environments. Instructor Adam Wilbert also shows how to use SQL Operations Studio to perform routine SQL Server maintenance tasks, such as backups, from Windows, macOS, and Linux.

Topics include:

  • 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