MICROSOFT SQL SERVER DBA
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
Introduction
- The History of SQL Server and relational databases
- SQL Server Overview
- Product Editions and Versions
- Relational Databases
- RDBMS concepts
Installing and configuring SQL Server
- What is Database?
- Pre-Installation checks
- SQL Server 2012 Installation
- SSMS and other SQL Server Tools
- Patching SQL Server – Service Packs
SQL Server data storage management
- SQL Server Architecture
- To create a Database
- SQL Server file management architecture
- Database Log Files
- SQL Server File groups
SQL Server Security Management
- Windows security management for the server
- Windows authentication mode
- SQL Server rights and role management
SQL Server Backup
- Types of Recovery Model
- Choosing correct DB Recovery Model
- Types of Backup
- How to take backup
Database Restore
- Data Recovery using Backups, Log Files
- Tail Log Backups & DB Recovery Options
- Checkpoint LSN and Restore Positions
- Real time scenario
SQL Server Job scheduling
- Common database scheduled jobs
- Configuring SQLMail
- Setting SQL Server and server alert thresholds Creating customized error conditions
- Scheduling multi-step job streams
- Maintenance Plan
- High Availability
- Log Shipping
- (a) Log Shipping Topology, Operation Modes
- (b) Setting up Log Shipping
- (c) Log Shipping Monitor
- (d) Manual Failover
Replication
- (a) Replication Architecture
- (b) Different Agents
- (c) PUSH n PULL Subscriptions
- (d) Different types of replication
- (e) Monitoring Replication
Mirroring
- (a) Mirroring Architecture
- (b) Configure Database Mirroring
- (c) Types of Mirroring
- (d) Monitoring Mirrored Servers
Cluster and Always On
- (a) Concept of WSFC
- (b) Node/Disk Configuration
- (c) Benefits of AAG
- (d) Concept and configuration of AAG
Performance Tunning
- Indexes
- Locks/Deadlock
- OS Performance
Course Features
- Lectures 0
- Quizzes 0
- Duration 50 hours
- Language English
- Students 0
- Assessments Yes
The curriculum is empty
