London College Of Online Learning

HOME >> IT CERTIFICATIONS >> DATABASES, MICROSOFT >> Microsoft SQL Server 2019 Administration

£59.00

Duration: 6 Hours 24 Minutes

41 Course Videos

Microsoft SQL Server 2019 Administration

With this 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 2019 Admin 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.

What you will learn:

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.

Course Videos

This course contains the following modules and videos. Click the down arrow to view video details.

Module 1: Installation

Module 2: Data Storage

Module 3: Data Recover

Module 4: Monitoring

Module 5: Security

Module 6: Maintenance

Our Learning System Includes

Instructor Led Lectures

All of our IT Courses recreate a real time class experience with a highly qualified and experienced instructor delivering the course’s theories and concepts on screen. All of our lectures are pre-recorded and available to the user 24/7. They can easily be paused, repeated, rewound and fast-forwarded.

Visual Presentations

We understand that all students are different when it comes to learning, therefore different types of delivery mediums are needed in order to achieve success for students. Taking that into account, we deliver our content in a variety of different ways to ensure that students stay engaged and productive throughout their courses.

Mobile Optimisation & Progress Tracking

Our courses are optimised for all mobile devices allowing users to learn on the go whenever they have spare time and wish to do so. Users can access their courses from anywhere and their progress is completely tracked and recorded delivering peace of mind to each and every user.

Practice Quizzes and Exams

Our custom practice exams prepare students for their exams differently and more effectively than the traditional exam preps on the market. Students will have practice quizzes after each module to ensure that they are confident on the topic they are learning.

World Class Learning Management System

We provide the next generation Learning Management System (LMS) to all of our students. This is an experience that combines the feature set of traditional LMS with advanced functionality designed to make learning management easy and online learning engaging from the student’s perspective.