By you, For you, With you – Access it all at your ease. From Minor to Vital our courses range will never be a disappointment.

Scroll to choose from a swarm of courses.

By you, For you, With you – Access it all at your ease. From Minor to Vital our courses range will never be a disappointment. Scroll to choose from a swarm of courses.

Microsoft SQL Server

Microsoft SQL Server 2019 Administration Course Outline

  •    SQL Admin Intro
  •    Installation
  •    Introduction to Data Storage with SQL Server
  •    Managing Storage for System Databases
  •    Managing Storage for User Databases
  •    Moving Database Files
  •    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
  •    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
 

  •    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

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