ITA40019 Administering SQL Server 2019

700€

If you want to transform your business with a unified data platform, here you are: Microsoft SQL Server 2019. SQL Server 2019 makes data integration, management and intelligence easier and more intuitive than ever before. The database administrators (DBAs) could be either in Development or in Production, in the process of planning, design or troubleshooting. Following professionals can enroll for this course:

  • Fresher’s
  • Software /Hardware Experts
  • DBA Developers

The tasks undertaken with SQL Database Administration are the following ones: capacity planning, configuration, installation, migration, database design, security, troubleshooting and data recovery.

At course completion, database administrators will know how to:

  • Install and upgrade the database server and tools used for applications.
  • Allocate system storage space and plan for future storage requirements.
  • Modify the database structure
  • Enrol users and maintain system security
  • Control and monitor user access
  • Optimise performance of database
  • Plan for backup
  • Maintain data

 

Detalii curs

  • Durata 32 ore
  • Nivel Mediu-Avansat
  • Limba curs Engleza/Romana
  • Limba suport Engleza/Romana
  • Cursanti/grupa 10
  • Examen Microsoft
  • Certificare Microsoft

Course Agenda

Day 1

MODULE 00 – CLASS INTRODUCTION

Module 00

Class Introduction

9.00 – 9.15

MODULE 01 – ARCHITECTURE

9.15 – 10.30

  • SQL server architecture
  • Protocols
  • Storage structure
  • Database Architecture
  • Transactional Architecture
  • Memory Architecture

Coffee break: 10.30 -10.45

MODULE 02 – INSTALLATION

10.45 – 12.30

  • Requirements
  • Installation steps

Lunch: 12.30 – 13.30

MODULE 03 – CONFIGURATION SETTINGS

13.30 – 17.00

(Coffee break: 15.00 – 15.15)

  • Memory setting
  • Processor
  • Connections
  • Database Settings

DAY 2

MODULE 04 – SYSTEM DATABASES

09.00– 10.30

  • Creating user databases
  • Database options

 

 

Coffee Break : 10.30-10.45

MODULE 05 – BACKUPS

10.45 – 15.30

Coffee break: 12.00 – 12.15

Lunch : 13.30 – 14.30

  • Recovery Models
  • Backup Types
  • Backup Strategy
  • Backup destination
  • Backup Options
  • Enhancements
  • Permissions and History

MODULE 06 – RESTORATIONS

15.30 – 17.00

  • Types of Restorations
  • Restoration Options
  • Point in Time Restorations
  • Recovery Process
  • Recovery Options

DAY 3

MODULE 07 – AUTOMATION

09.00 – 11.00

  • Creating Jobs
  • Schedules
  • Viewing Job History

Coffee break: 11.00 – 11.15

MODULE 08 – SECURITY

11.15 – 15.30

Lunch: 13.30 – 14.30

  • Types of Logins
  • Authentication
  • Creating Logins
  • Server Roles · Database Roles
  • Encryption
  • Schema
  • Creating new role
  • Digital Certificate
  • Orphaned Users

MODULE 09 – MIGRATION

15.30 -17.00

  • Situations
  • Steps in Migrations
  • Migrating System Databases
  • Migrating to other RDBMS

DAY 3

MODULE 10 – UPGRADATION

09.00 – 10.30

  • Types of Up gradation
  • Planning for upgradation
  • Upgrade Advisor

Cofee break: 10.30 – 10.45

MODULE 11 – HIGH AVAILABILITY

10.45 – 17.00

Lunch: 13.30 -14.30

  • Configuring log shipping
  • Failover Process
  • Database mirroring
  • Steps in Mirroring
  • Types of Mirroring
  • Configuring Mirroring
  • Failover Steps

Day 4

MODULE 12 – REPLICATION and CLUSTERING

09.00 – 12.30

(Coffee break: 10.30 -10.45)

REPLICATION

  • Types of Replication
  • Configuring Replication

CLUSTERING

  • Concepts of clustering
  • Types of Clustering
  • Requirements
  • Configuring clustering

Lunch: 12.30 -13.30

MODULE 13 – PERFORMANCE TUNING

13.30 – 17.00

(Coffee break: 15.00 -15.15)

  • Locks
  • Isolations levels
  • Blocking
  • Deadlocks
  • Performance Monitor
  • Profiler
  • Execution plans
  • Indexes
  • DBCC And DMV’s