Course Overview

This comprehensive course equips you with the in-depth knowledge and practical skills needed to effectively administer and optimize Microsoft SQL Server databases. Designed for aspiring database professionals and IT specialists, this training covers the essential features and capabilities across various SQL Server versions, providing a holistic understanding of the entire data platform.
MSSQL2019

Course objectives

Elevate your career learning SQL Database Administration with our comprehensive Microsoft SQL Server Administration training. This course is designed to provide you with the skills needed to manage MS SQL Databases effectively, making you proficient in SQL Server Administration. Whether you’re an SQL Administrator, SQL Server DBA, or someone who works with MS Databases, this course is your gateway to mastering Microsoft SQL DBMS.

0
Course Videos
0
Test Questions
0
E-BOOKS
0
Duration

Modules

Module 1: Installation

  •    SQL Admin Intro

  •    Installation

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 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 2: Data Storage

  •    Introduction to Data Storage with SQL Server

  •    Managing Storage for System Databases

  •    Managing Storage for User Databases

  •    Moving Database Files

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 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

Modes of Learning