Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Server Administration On Linux Operating System
Rating: 4.5 out of 5(104 ratings)
1,141 students
Created byRaphael Asghar
Last updated 3/2019
English

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.

Course content

1 section • 39 lectures • 8h 21m total length

  • AN INTRODUCTION TO SQL SERVER 2017 ON LINUX1:54

    Learn to install and manage sql server 2017 on linux, create databases and tables, insert and view data with t-sql, and configure imports, exports, and alerts on ubuntu.

  • DOWNLOAD AND INSTALL APPLICATIONS7:20
  • CREATE AND INSTALL WINDOWS SERVER 201618:07
  • INSTALL UBUNTU SERVER11:39
  • INSTALL DESKTOP GUI ON DESKTOP7:40
  • INSTALL SQL 2017 SERVER ON WINDOWS19:22
  • INSTALL SQL SERVER ON UBUNTU PART 115:00

    Learn to install SQL Server 2017 on Ubuntu via the command line, including repository setup, installation steps, and configuring a complex password with the evaluation edition.

  • INSTALL SQL SERVER ON UBUNTU PART 216:07

    Learn how to install and configure SQL Server on Ubuntu, troubleshoot memory errors, install SQL Server tools, create a test database and inventory table, and run basic queries.

  • MAKE A CLONE OF YOUR VM11:24

    Create a full clone of your Ubuntu virtual machine to safeguard configurations, enable quick recovery, and verify SQL Server access on Linux.

  • STARTING STOPPING ON WINDOWS SERVICE7:37
  • STARTING SERVICES ON LINUX SERVER9:36
  • CHANGE SQL DATA AND LOG FILES IN WINDOWS7:02
  • CHANGE SQL DATA AND LOG FILES IN LINUX14:20
  • DOWNLOAD RESTORE BACKUP ON WINDOWS12:41
  • BACKUP AND RESTORE DB ON LINUX13:02

    Learn how to download, move, and restore the Adventure Works 2017 database on Linux using SQL Server, verify results with a select, and reverse the process for repeatable practice.

  • SETTING UP ENVIRONMENT13:47
  • CREATING SQL FILES ON WINDOWS7:04
  • MORE COMPLEX EXAMPLE OF SQL FILE7:44

    Learn to script a full backup of the Adventure Works 2017 database, create a SQL Server Agent job, and share or execute the script on Linux environments.

  • CREATE A SQL FILE ON LINUX11:41

    Discover how to prepare a Linux environment for SQL Server by creating a scripts directory, a SQL file, and setting ownership and permissions to enable an Eskil agent job.

  • ENABLE SQL SERVER AGENT IN LINUX16:12
  • USING BCP IN LINUX15:24
  • SQL DATABASE MAIL IN WINDOWS17:21

    Set up database mail in Windows using GUI or stored procedures, configure server options, create mail accounts and profiles, and test sending via SMTP with Gmail.

  • SQL SERVER 2017 DATABASE MAIL ON LINUX11:01
  • MIGRATING TABLES FROM SQL TO LINUX10:00
  • INSTALL MSSQL CLI TOOL17:15
  • AZURE DATA STUDIO10:07

    Install and use Azure Data Studio on Linux to visually connect to SQL servers, manage databases, run queries, and explore docker-based setups from a cross-platform GUI.

  • AZURE SQL QUERY PANE16:16
  • MONITORING WITH HTOP20:27
  • MONITORING WITH GLANCES TOOL12:25
  • MONITORING WITH IOSTAT14:34
  • BACKUP AND RESTORE VMS12:48
  • NEXT FIVE VIDEOS3:04
  • ALWAYS ON WINDOWS17:19
  • ALWAYS ON PREREQUISITES22:09
  • ALWAYS ON SET UP CLUSTER14:40

    Learn how to set up a SQL Server Always On cluster by validating configuration, adding three servers, running tests, creating the cluster, and enabling Always On.

  • ALWAYS ON LIVE DEMO33:05

    Learn to set up Always On availability groups for SQL Server, migrating databases as a group to a secondary, with synchronous or asynchronous modes and read-only replicas.

  • BACKUP REPLICAS13:23

    discover backing up on secondary replicas in an always on availability group, where only copy-only full backups and transactional log backups are supported with synchronous, readable secondaries.

  • A VERY IMPORTANT MUST-SEE VIDEO – CREATE A SQL SERVER 2017 IN SECONDS!!!10:24
  • BONUS VIDEO - DON'T FORGET ME0:37

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.

Who this course is for:

  • 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.

Report abuse