At Lawrence Livermore National Laboratory
Microsoft & Data

Microsoft SQL Server 2019 Administration

Duration6 Hours
LevelProfessional development
Access12 months online access
Course content6 modules
One-time payment Get complete course access

Original price was: £119.00.Current price is: £71.00. inc VAT

Save£48.00
  • Instant online access
  • Study at your own pace
  • Secure checkout
About this course

What the Microsoft SQL Server 2019 Administration course covers

This is an online microsoft & data course you work through in your own time, on a phone, tablet or laptop. The material comes as 6 modules and takes about 6 hours end to end. Your login lasts 12 months, which is long enough to come back to a section when the subject turns up at work.

Nothing is required to enrol, and the content is aimed at the job rather than at a syllabus. We list 18 Microsoft & Data courses, of which 12 sit at Professional development. At this length it is one of the quicker ones in the subject. Take it as professional training, not a graded award - what it shows is that you have done the learning.

What this course is not: The provider has not stated what the certificate looks like for this one, so ask us first if the certificate is the reason you are buying.

Full course details from the training provider

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.

  • 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 Video Content: 6 Hours 24 Minutes
Test Questions: 75

Microsoft SQL Server 2019 Administration course content

Module 1: Installation

  • SQL Admin Intro
  • Installation

Module 2: Data Storage

  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databases
  • Moving Database Files

Module 3: Data Recover

  • Intro to Data Recovery
  • Understanding SQL Server Recovery Models
  • Planning a Backup Strategy
  • Backing up Databases and Transaction Logs
  • Using SSMS For Backup
  • Understanding the Restore Process
  • How to Restore a Database
  • Using SSMS For Restore
  • T-SQL Backup and Restore
  • Advanced Restore Scenarios
  • Introduction to Transferring Data
  • Importing and Exporting Table Data
  • Copying or Moving a Database

Module 4: Monitoring

  • Introduction to Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Server Reports
  • System Performance Monitor
  • Tracing SQL Server Workload Activity
  • Extended Events
  • Database Tuning Advisor

Module 5: Security

  • Introduction to SQL Server Security
  • Managing Server-Level Security
  • Managing Database-Level Security
  • Row Level Security (RLS) Using Policies
  • Database Security Tools
  • Contained Database
  • Auditing Data Access in SQL Server
  • Implementing Transparent Data Encryption

Module 6: Maintenance

  • Introduction to Maintenance
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
  • Automating SQL Server Management
  • Monitoring SQL Server Errors
  • Configuring Database Mai

 

Ready when you are

Get instant access and start learning today.

Enrol now
women's black sleeveless dress
Better value

SQL Server Master Training Bundle

£144.00 £576.00 Save 75%

That works out at about £9.00 per course.

Includes 16 courses
Grab this bundle instead

Continue your learning