SQL Server Administration On Linux Operating System

SQL Server 2017 on Ubuntu Server

Created by: Raphael Asghar
Production SQL Database Administrator

What Will I Learn?

• With the advent of SQL Server 2017 now available on a Linux platform, it is imperative that students learn how to navigate and understand SQL Server 2017 Administration on Linux server. Therefore, the student will learn how to install SQL Server 2017 on a Ubuntu Server (Linux Distro), navigate using the Ubuntu Gnome GUI for easy configuration, connect to SQL Server and Ubuntu with Putty third party software, view and manipulate both SQL Server data and log files, migrate data from SQL Server to another database with Ubuntu, use BCP to quickly import and export data, set up SQL database mail in Linux Server, use various tools and utilities to monitor SQL Server, backup and restore databases and much more.

Requirements

• To take full advantage of this course, the student is required to have the following courses: Learn – TSQL, SQL Administration part 1 and importantly Linux Commands course or at least have familiarity with these courses.

Target audience

• This course is designed with the beginner in mind for managing and configuring SQL Server 2017 on a Linux Server – with the caveat that the prerequisites of Learn – TSQL, SQL Administration part 1 and importantly Linux Commands course are fulfilled.