Microsoft SQL Server Administration – 2019

Overview

This sql server administration course offers students a comprehensive understanding of how to maintain and optimize a Microsoft SQL Server 2019 database. It is specifically tailored towards individuals who want to gain knowledge on the newest features in SQL server 2016, 2017, and 2019 as well as learn about essential capabilities throughout the entire data platform. Students will emerge from this training with an extensive set of skills for managing their own MS SQL Server environment along with its databases! This sql server administration course offers students a comprehensive understanding of how to maintain and optimize a Microsoft SQL Server 2019 database. It is specifically tailored towards individuals who want to gain knowledge on the newest features in SQL server 2016, 2017, and 2019 as well as learn about essential capabilities throughout the entire data platform. Students will emerge from this training with an extensive set of skills for managing their own MS SQL Server environment along with its databases! Showcase your indispensable abilities and ingenious insights in creating and managing the upcoming generation of mission-critical environments with our Microsoft MCSA: SQL Server Solutions Associate online course. This Learn HTML course is designed for beginner level individuals who are interested in learning how to build a page for a website. Our comprehensive training course dives into all areas of HTML writing & editing so that by the end, you will be an expert in coding with HTML! NO CREDIT CARD REQUIRED In this course you will learn how to start building enterprise web applications. This course will provide you with training in web development, C Sharp, HTML and CSS, SQL Server, JavaScript, Object Based JavaScript, Model View and Controller, and jQuery. Elevate your web development programming skills in this HTML5 and CSS3 training course. HTML5 and CSS3 are key web technologies that allow you to build up content for the internet. This training program showcases how to use innovative HTML5 multimedia features such as video, audio, and animation. With this course, you can unlock more creative possibilities with your digital media!

Your Training Instructor

James Ring-Howell

Microsoft Certified Trainer | Microsoft Certified Developer | Database Expert

James is a full-stack developer with over 40 years of experience. He has developed applications across all major industries and for Fortune 100 companies as well as local small businesses. James has also been teaching technology courses for over 20 years. In addition to his extensive background in technology, he has also worked as a professional opera singer.

6 Traning Hours

41 Videos

6 Topics

75 Practice Questions

COURSE DESCRIPTION
COURSE OUTLINE

COURSE DESCRIPTION

Self-paced training online training program

Taking our SQL server administration course course, students can learn about SQL Server installation, data storage, data recovery, monitoring, security, and maintenance. Instructor James Ring-Howell brings with him over 40 years of applicable IT experience and has taught technical courses for over two decades.

This Microsoft SQL Server Administration course is specifically for obtaining working IT skills and is not certification-specific training.

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility or work in environments where databases play a key role in their primary job. The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.

Install and Configure SQL Server 2019
Work with Databases and Storage
Plan and Implement a Backup Strategy
Restore SQL Server 2019 Databases
Import and Export Data
Monitor SQL Server 2019
Manage SQL Server Security
Audit Data Access and Encrypt Data
Perform Ongoing Database Maintenance
Automate SQL Server 2019 Management
Monitor SQL Server 2019 by Using Alerts and Notifications

Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence, and analytics applications in corporate IT environments. Microsoft SQL Server is one of the three market-leading database technologies, along with Oracle Database and IBM’s DB2.

Like other RDBMS software, Microsoft SQL Server is built on top of SQL, a standardized programming language that database administrators (DBAs) and other IT professionals use to manage databases and query the data they contain. SQL Server is tied to Transact-SQL (T-SQL), an implementation of SQL from Microsoft that adds a set of proprietary programming extensions to the standard language.

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2019 database. The training focuses on teaching individuals how to use SQL Server 2019 product features and tools related to maintaining the server environment and the databases it contains and is designed for customers who are interested in learning SQL Server 2016, SQL 2017, or SQL Server 2019. It covers the new features in SQL Server 2019, but also the important capabilities across the SQL Server data platform.

Topics include Installation, Data Storage, Data Maintenance and Recovery, Monitoring, Security, and Server Maintenance. This course requires that you meet the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases. Some experience with database design is recommended.