Management of Microsoft SQL Server Databases Training

Management of Microsoft SQL Server Databases Training

Get Information

SQL language is one of the most sought-after features of today’s popular professions. In Indeed’s 2022 report, SQL comes first with 45% of the data-related features sought, followed by Python and other platforms.

However, SQL is the lingua franca of all databases and has few commands, so it is an easy language to learn.

In this course, participants will learn the skills required to maintain Microsoft SQL Server databases, focusing on data storage, backup, restore, importing and exporting data, security, database maintenance, and SQL Server Agent.

About Education

The objectives of this training:

  • Database management tasks and tools
  • Installing and configuring SQL Server
  • Configure SQL Server databases and storage
  • Backup strategy planning and implementation
  • Restoring databases from backups
  • Import and export data
  • Monitoring SQL Server
  • Monitor SQL Server activities
  • Managing SQL Server security
  • Control data access and encrypt data
  • Running database maintenance jobs without interruption
  • Automate SQL Server maintenance with SQL Server Agent jobs
  • Configure database email, alerts and notifications

The envisaged content of this training:

  • Introduction to SQL Server Database Administration

Database Management Overview

Introduction to SQL Server Platform

Database Management Tools and Techniques

  • Installing and Configuring SQL Server

Planning a SQL Server Installation

Installing SQL Server and Post-Installation Configuration

  • Working with Databases and Storage

Introduction to Data Storage with SQL Server

Managing Storage for System Databases and User Databases

Move Database Files

Configure the Buffer Pool Extension

  • Planning and Implementing a Backup Strategy

SQL Server Recovery Models

Planning a Backup Strategy

Backup Databases and Transaction Logs

Backup Options and Backup Reliability

  • Restoring SQL Server Databases

Restore Process and Restoring Databases

Advanced Restore Scenarios

Instant Rescue

  • Import and Export Data

Data Transfer

Import and Export Table Data

Copy or Move a Database

  • Monitoring SQL Server

Introduction to Monitoring SQL Server

Dynamic Management Views and Functions

Performance display

  • Monitor SQL Server Activity

Monitor SQL Server Workload Activity and Use Traces

  • Managing SQL Server Security

Introduction to SQL Server Security

Managing Server-Level Security and Database-Level Custodians

Manage Database Permissions

  • Controlling Data Access and Encrypting Data

Controlling Data Access in SQL Server

SQL Server Auditing Implementation

Encrypting Databases

  • Performing Ongoing Database Maintenance

Ensuring Database Integrity

Protecting Directories

Automating Routine Database Maintenance

  • Automating SQL Server Administration

Implementing and Managing SQL Server Agent Jobs

Managing Workstep Security Contexts

Manage Work on Multiple Servers

  • Monitor SQL Server Using Alerts and Notifications

Monitoring SQL Server Errors

Configure Database Mail

Configure Operators, Alerts and Notifications

Participants at the end of the training;

  • Will be able to query data from a database on SQL Server and write SQL sentences required for reports.
  • They will learn to use the functions and procedures needed on the TSQL side.

Who Should Receive the Training?

This course is suitable for people who want to write queries, perform development, prepare reports and design high-performance databases on Microsoft SQL Server.

Plan this training institutionally!

This training can be planned in different durations and content specific to your organization. Please contact us for detailed rich content and planning to realize your training objectives.

Get in touch

Additional information

Lokasyon

Online

Kontenjan

20

Eğitmen

Academy Club