Microsoft SQL Server 2019 Administration

(8 customer reviews)
Sale!

Leading the way

Microsoft SQL Server 2019 Administration

(8 customer reviews)

| Total Course Video Hours: 6 Hrs 24 Min
|  Videos: 41
|  Course Access: 12 Months Unlimited Access
|  Study Method: Online Video Lessons
|  Course Type: Certificate Course
|  Award: Cyber Studies Institute

Course Fee:

R1600,00

Current Special Ends in:

Days
Hours
Minutes
Seconds

Overview 

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.

 

Exams

This course includes an exam and certification by the Cyber Studies Institute.

Curriculum

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

8 reviews for Microsoft SQL Server 2019 Administration

  1. Wandile

    The course was flexible, allowing me to access the materials anytime and from any device.

  2. Lila

    I appreciated the regular feedback and guidance provided by the course instructors.

  3. Kwame

    I got my dream job thanks to you

  4. Noluthando

    I can’t thank you enough for providing such a phenomenal course.

  5. Isabella

    I can confidently say that this course was worth every penny.

  6. Xoliswa

    Thank you for helping me get my dream job

  7. Abigail

    You’ve helped me secure my dream job. Thank you from the bottom of my heart!

  8. Siyanda

    The course boosted my confidence and gave me the skills I needed to excel in my field.

Add a review

Your email address will not be published. Required fields are marked *

Excited to Study Enroll Qualify

If you are ready to take the next step, click on the “Enroll Now” button below or “Contact us now” on this course for a detailed course outline or if you have any questions. An expert course adviser is standing by to assist you.

CompTIA Authorized Partner

Cyber Studies Institute (Pty) Ltd is proud to be an Official CompTIA Authorized Partner. Ensuring that you receive the best training in the world.

CompTIA Authorized Partner

How does studying with CSI work?

Click here to read how the process of studying at CSI work.