ITA40019 Administering SQL Server 2019
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