SQL Server Administration On Linux Operating System from Udemy

What's inside

Learning objective

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.

Syllabus

At the end of this course the student will have gained the experience, confidence and the ability to install, manage, configure, navigate and set up SQL Server 2017 on a Linux Ubuntu Server

AN INTRODUCTION TO SQL SERVER 2017 ON LINUX

DOWNLOAD AND INSTALL APPLICATIONS

CREATE AND INSTALL WINDOWS SERVER 2016

INSTALL UBUNTU SERVER

INSTALL DESKTOP GUI ON DESKTOP

INSTALL SQL 2017 SERVER ON WINDOWS

INSTALL SQL SERVER ON UBUNTU PART 1

INSTALL SQL SERVER ON UBUNTU PART 2

MAKE A CLONE OF YOUR VM

STARTING STOPPING ON WINDOWS SERVICE

STARTING SERVICES ON LINUX SERVER

CHANGE SQL DATA AND LOG FILES IN WINDOWS

CHANGE SQL DATA AND LOG FILES IN LINUX

DOWNLOAD RESTORE BACKUP ON WINDOWS

BACKUP AND RESTORE DB ON LINUX

SETTING UP ENVIRONMENT

CREATING SQL FILES ON WINDOWS

MORE COMPLEX EXAMPLE OF SQL FILE

CREATE A SQL FILE ON LINUX

ENABLE SQL SERVER AGENT IN LINUX

USING BCP IN LINUX

SQL DATABASE MAIL IN WINDOWS

SQL SERVER 2017 DATABASE MAIL ON LINUX

MIGRATING TABLES FROM SQL TO LINUX

INSTALL MSSQL CLI TOOL

AZURE DATA STUDIO

AZURE SQL QUERY PANE

MONITORING WITH HTOP

MONITORING WITH GLANCES TOOL

MONITORING WITH IOSTAT

BACKUP AND RESTORE VMS

NEXT FIVE VIDEOS

ALWAYS ON WINDOWS

ALWAYS ON PREREQUISITES

ALWAYS ON SET UP CLUSTER

ALWAYS ON LIVE DEMO

BACKUP REPLICAS

A VERY IMPORTANT MUST-SEE VIDEO – CREATE A SQL SERVER 2017 IN SECONDS!!!

BONUS VIDEO - DON'T FORGET ME

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Covers installation of SQL Server 2017 on Ubuntu, which is useful for professionals managing cross-platform database environments

Explores data migration between SQL Server and Linux, which is relevant for database administrators managing heterogeneous environments

Teaches how to use BCP for data import/export, a valuable skill for database administrators needing efficient data transfer methods

Covers setting up SQL database mail in Linux, which is essential for automated notifications and alerts in database administration

Features monitoring tools like HTOP, Glances, and IOSTAT, which are useful for performance tuning and troubleshooting SQL Server on Linux

Focuses on SQL Server 2017, which is no longer the latest version and may not reflect current industry best practices

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in SQL Server Administration On Linux Operating System with these activities:

Review Linux Command Line Basics

Show steps

Reinforce your understanding of basic Linux commands to navigate the Ubuntu server effectively. This will help you manage SQL Server on Linux more efficiently.

Browse courses on Linux Command Line

Show steps

Review common commands like ls, cd, mkdir, rm, and cp.
Practice using the command line to navigate the file system.
Familiarize yourself with basic file permissions and ownership.

Review SQL Server Fundamentals

Show steps

Brush up on your SQL Server knowledge, including database creation, querying, and basic administration tasks. This will provide a solid foundation for managing SQL Server on Linux.

Browse courses on SQL Server

Show steps

Review SQL Server database creation and management.
Practice writing basic SQL queries to retrieve and manipulate data.
Familiarize yourself with SQL Server security concepts.

Follow Tutorials on SQL Server on Linux Installation

Show steps

Follow online tutorials to gain hands-on experience with installing SQL Server on a Linux environment. This will supplement the course material and provide practical skills.

Show steps

Find a reputable online tutorial or guide on installing SQL Server on Ubuntu.
Follow the steps in the tutorial to install SQL Server on a virtual machine or test environment.
Document any issues encountered and their solutions.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Practice BCP Import/Export

Show steps

Practice using the BCP utility to import and export data between SQL Server and Linux. This will reinforce your understanding of data migration techniques.

Show steps

Create a sample SQL Server table with data.
Use BCP to export the data to a file on the Linux server.
Modify the data in the file and use BCP to import it back into SQL Server.

SQL Server 2017 Administration Inside Out

Show steps

Read this book to gain a deeper understanding of SQL Server administration concepts and best practices. This will enhance your ability to manage SQL Server on Linux effectively.

View SQL Server 2022 Administration Inside Out on Amazon

Show steps

Read the chapters related to backup and recovery, security, and performance tuning.
Experiment with the techniques described in the book in a test environment.
Take notes on key concepts and best practices.

Document SQL Server Monitoring Tools on Linux

Show steps

Create a document that details how to use various Linux monitoring tools (htop, glances, iostat) to monitor SQL Server performance. This will deepen your understanding of system-level monitoring.

Show steps

Research how to use htop, glances, and iostat to monitor system resources.
Monitor SQL Server performance using these tools and document your findings.
Create a guide that explains how to interpret the output of these tools in relation to SQL Server performance.

Automated Backup Script

Show steps

Develop a shell script to automate SQL Server database backups on Linux. This will provide practical experience with scripting and database administration.

Show steps

Research how to use the sqlcmd utility to connect to SQL Server from a shell script.
Write a script that connects to SQL Server, backs up a database, and stores the backup file in a designated location.
Schedule the script to run automatically using cron.

Career center

Learners who complete SQL Server Administration On Linux Operating System will develop knowledge and skills that may be useful to these careers:

Database Administrator

A database administrator is responsible for the maintenance, performance, and reliability of an organization's databases. This course directly helps a database administrator by providing hands-on experience with installing, configuring, and managing SQL Server on a Linux platform. The course offers training in essential tasks like backing up and restoring databases, using utilities for monitoring SQL Server, and migrating data. The practical skills gained in this course can help set a strong foundation for a database administrator's success by exposing them to command-line interfaces and tools, which many organizations use for their Linux-based infrastructure. This course is particularly useful for those who want to transition to or enhance their skills in managing SQL Server environments on Linux, making them well-prepared for the challenges of the job.

See salaries and explore the career path for Database Administrator

System Administrator

A system administrator manages the computer systems and servers of an organization, a role that requires a strong proficiency in Linux systems and database technologies. This course will help a system administrator by providing specific skills in installing and managing SQL Server on a Linux server. The course teaches how to use tools for monitoring system performance and how to manipulate database files. System administrators who want to effectively manage environments that use SQL Server on Linux can take this course to learn the necessary skills, such as using command line tools, managing database files, and ensuring the smooth operation of the systems within an organization. The focus on installing, navigating, and troubleshooting SQL Server on Linux provides practical skills that are directly applicable to the work of a system administrator.

See salaries and explore the career path for System Administrator

Cloud Database Engineer

Cloud database engineers design, build, and maintain database systems in cloud environments. This course helps prepare a cloud database engineer by providing a deep understanding of how to install, manage, and configure SQL Server on Linux, a common cloud operating system. The course teaches specific skills such as setting up SQL database mail, using tools to monitor server performance, and backing up and restoring databases. Understanding how to navigate and administer SQL server on Linux is increasingly important as many organizations are migrating to the cloud. Cloud database engineers can benefit from the course's focus on practical skills like migrating tables and importing/exporting data using BCP, which are crucial in cloud environments.

See salaries and explore the career path for Cloud Database Engineer

Technical Support Specialist

A technical support specialist provides assistance and troubleshooting for technical issues, and this course can assist them by providing hands-on understanding of SQL Server on Linux environments. This course helps a technical support specialist by providing practical skills in installing, configuring, and navigating SQL Server on Linux. This course teaches tasks such as connecting with third-party software and setting up SQL database mail, which are valuable for diagnosing and fixing user issues. The course also covers how to monitor SQL Server using various tools and utilities, important for proactively avoiding problems. A technical support specialist can benefit from gaining practical skills with a widely used database system within the Linux operating system.

See salaries and explore the career path for Technical Support Specialist

Database Consultant

A database consultant helps businesses optimize their database systems, and this course provides valuable expertise in managing SQL Server on Linux, a growing trend. The course will help a database consultant through its focus on installing, configuring, and monitoring SQL Server on Linux. It provides practical skills in migrating data and using tools for backups and restores, which a consultant would need to advise a company. The course's focus on Linux environments, where many modern database systems operate, positions a database consultant with up to date knowledge. The course’s training on tools and utilities for managing and troubleshooting SQL Server makes it useful for consultants.

See salaries and explore the career path for Database Consultant

Application Support Analyst

An application support analyst provides support for software applications, which often includes working with databases. This course helps an application support analyst by teaching them how to install, manage, and configure SQL Server on a Linux environment. The course provides training on how to view and manipulate SQL data and log files, and how to use tools for backup and restore. Application support analysts often require an understanding of the system they support. This course provides practical knowledge of a popular database system within the Linux operating system. The skills gained will enable the analyst to more effectively troubleshoot issues that arise during the normal course of operations.

See salaries and explore the career path for Application Support Analyst

DevOps Engineer

A DevOps engineer works to bridge the gap between development and operations, and this course helps a DevOps engineer through its hands-on approach to managing SQL Server on Linux. This course teaches how to install and configure SQL Server, set up database mail, and use monitoring tools. Modern systems rely on data, therefore understanding and managing SQL Server systems is very valuable for a DevOps engineer. The course provides a practical understanding of how to administer databases on Linux, essential for building and maintaining robust software applications. The focus on Linux command-line tools and utilities is particularly relevant for DevOps environments.

See salaries and explore the career path for DevOps Engineer

Data Engineer

Data engineers build and maintain the infrastructure that allows organizations to collect, store, and analyze their data. This course may be useful to a data engineer due to its practical approach to managing SQL Server on a Linux operating system. The course specifically covers how to use utilities and tools to monitor SQL Server, how to migrate data, and how to backup and restore databases. A data engineer must understand how databases work and how to manage data. This course will help a data engineer build a foundation around the administration of SQL server on a Linux environment, useful for data warehousing and related tasks. The course's emphasis on Linux-based data management tools makes it a practical option for data engineers.

See salaries and explore the career path for Data Engineer

Data Warehouse Specialist

A data warehouse specialist is involved in the design, implementation, and maintenance of data warehousing solutions, and this course will help a data warehouse specialist by teaching how to manage SQL Server on Linux. This course provides direct training in installing and configuring SQL Server, as well as migrating data. Data warehouses often employ SQL Server, and therefore knowledge of its administration is essential. Data warehouse specialists who understand the underlying database system are better equipped to provide effective solutions. The course’s focus on SQL Server on Linux operating systems prepares data specialists for the most up to date technologies.

See salaries and explore the career path for Data Warehouse Specialist

Infrastructure Engineer

An infrastructure engineer designs and maintains the underlying hardware and software for computing systems, and this course provides relevant knowledge in database administration. The course helps an infrastructure engineer by teaching how to install SQL Server on Linux, manage data and log files, and set up database mail. Many applications rely on database servers such as SQL Server, so understanding the management of such systems is important. An infrastructure engineer can use the skills gained to support or develop systems that rely on SQL Server. This practical experience in setting up and maintaining SQL Server on Linux adds depth to the infrastructure planning process.

See salaries and explore the career path for Infrastructure Engineer

Linux System Engineer

A Linux system engineer is responsible for the design and implementation of Linux-based systems. This course may be useful for a Linux system engineer because it includes hands on training in running SQL Server on Linux. The course teaches how to perform important database management tasks such as backing up and restoring databases. Understanding the underlying database technology is important because many systems rely on databases. A Linux system engineer who has experience setting up a database is better equipped to build high-performance systems. The skills in this course provide an additional degree of knowledge for a Linux professional.

See salaries and explore the career path for Linux System Engineer

Solutions Architect

A solutions architect designs and oversees the implementation of complex computer systems, often requiring knowledge of databases. This course helps a solutions architect by providing insights into setting up, managing, and monitoring SQL Server on Linux, which is a common component in many modern computing environments. The course teaches how to install SQL Server on Linux, how to migrate data, and how to backup and restore databases. Solutions architects who understand underlying database technologies can design systems that take advantage of the capabilities of SQL Server. The practical skills gained with Linux and its tools position a solutions architect to build robust solutions using SQL Server.

See salaries and explore the career path for Solutions Architect

IT Specialist

An information technology (IT) specialist maintains an organization's computer systems, which often includes interacting with databases. This course may be useful for an IT specialist because it provides instructions in setting up and managing SQL Server on Linux. The course includes training in tasks such as setting up SQL database mail and migrating data, important tasks for a database environment. IT specialists need to understand the components of their infrastructure. The practical knowledge in this course can improve any IT specialist's skills, which ultimately leads to a more robust system. The hands-on experience with Linux-based tools also helps IT specialists learn to work in modern environments.

See salaries and explore the career path for IT Specialist

Information Systems Manager

An information systems manager is responsible for planning, coordinating, and directing computer-related activities within an organization. This course may be useful for an information systems manager because it exposes them to the process of setting up and managing a SQL Server on Linux. The course teaches how to install the software, set up configurations, and handle SQL data and log files, tasks that are often required when designing an information system. IT managers must have a clear view of their systems and how they operate. This course provides a degree of technical competence useful for managers to know the technologies they oversee. The course’s focus on Linux provides additional relevance in the modern technological world.

See salaries and explore the career path for Information Systems Manager

Database Analyst

A database analyst examines data to identify trends, patterns, and insights that help organizations make informed decisions. This course may be useful to a database analyst because even though they do not directly manage servers, this course provides a deeper understanding of how the underlying database works. Knowing how data is stored and managed helps an analyst better access and understand their data. The course provides hands on training in how to view and manipulate data. A database analyst benefits from an understanding of how data is stored. The course provides some of these skills.

See salaries and explore the career path for Database Analyst

Reading list

We've selected one books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in SQL Server Administration On Linux Operating System.

SQL Server 2022 Administration Inside Out

Save

Provides in-depth coverage of SQL Server 2017 administration, including topics relevant to Linux deployments. It serves as a valuable reference for advanced configuration and troubleshooting. It is useful as a reference tool for experienced database administrators. This book adds more depth to the existing course.

SQL Server 2022 Administration Inside Out

Kindle Edition

SQL Server Administration On Linux Operating System

What's inside

Learning objective

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses