SQL Server Administration On Linux Operating System
What you’ll 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.
Description
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.
Overview
Section 1: Introduction
Lecture 1 AN INTRODUCTION TO SQL SERVER 2017 ON LINUX
Lecture 2 DOWNLOAD AND INSTALL APPLICATIONS
Lecture 3 CREATE AND INSTALL WINDOWS SERVER 2016
Lecture 4 INSTALL UBUNTU SERVER
Lecture 5 INSTALL DESKTOP GUI ON DESKTOP
Lecture 6 INSTALL SQL 2017 SERVER ON WINDOWS
Lecture 7 INSTALL SQL SERVER ON UBUNTU PART 1
Lecture 8 INSTALL SQL SERVER ON UBUNTU PART 2
Lecture 9 MAKE A CLONE OF YOUR VM
Lecture 10 STARTING STOPPING ON WINDOWS SERVICE
Lecture 11 STARTING SERVICES ON LINUX SERVER
Lecture 12 CHANGE SQL DATA AND LOG FILES IN WINDOWS
Lecture 13 CHANGE SQL DATA AND LOG FILES IN LINUX
Lecture 14 DOWNLOAD RESTORE BACKUP ON WINDOWS
Lecture 15 BACKUP AND RESTORE DB ON LINUX
Lecture 16 SETTING UP ENVIRONMENT
Lecture 17 CREATING SQL FILES ON WINDOWS
Lecture 18 MORE COMPLEX EXAMPLE OF SQL FILE
Lecture 19 CREATE A SQL FILE ON LINUX
Lecture 20 ENABLE SQL SERVER AGENT IN LINUX
Lecture 21 USING BCP IN LINUX
Lecture 22 SQL DATABASE MAIL IN WINDOWS
Lecture 23 SQL SERVER 2017 DATABASE MAIL ON LINUX
Lecture 24 MIGRATING TABLES FROM SQL TO LINUX
Lecture 25 INSTALL MSSQL CLI TOOL
Lecture 26 AZURE DATA STUDIO
Lecture 27 AZURE SQL QUERY PANE
Lecture 28 MONITORING WITH HTOP
Lecture 29 MONITORING WITH GLANCES TOOL
Lecture 30 MONITORING WITH IOSTAT
Lecture 31 BACKUP AND RESTORE VMS
Lecture 32 NEXT FIVE VIDEOS
Lecture 33 ALWAYS ON WINDOWS
Lecture 34 ALWAYS ON PREREQUISITES
Lecture 35 ALWAYS ON SET UP CLUSTER
Lecture 36 ALWAYS ON LIVE DEMO
Lecture 37 BACKUP REPLICAS
Lecture 38 A VERY IMPORTANT MUST-SEE VIDEO – CREATE A SQL SERVER 2017 IN SECONDS!!!
Lecture 39 BONUS VIDEO – DON’T FORGET ME
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.
Course Information:
Udemy | English | 8h 22m | 3.80 GB
Created by: Raphael Asghar
You Can See More Courses in the Developer >> Greetings from CourseDown.com