SQL Server DBA TRAINING

Module 1 - SQL Server Architecture & T-SQL Queries, Tuning

• SQL Architecture & Installation
• SQL Server Database Design
• SQL Server Tables Design
• Normal Forms, Keys & Connstraints
• Views, JOINS and Sub Queries
• Views with Joins - Queries
• Indexes amd Query Tuning
• Stored Procedures & Query Tuning
• User Defined Functions (UDF) and Queries
• Triggers - Usage, Memory Limitation
• Cursors, Joins and Queries

Module 2 - Basic SQL DBA

• Transaction annd Stored Procedures
• Locks, Deadlocks & Live Locks
• Backups - Architecture and Management
• Restores - Architecture and Management
• Jobs: Architecture and Monitoring Options
• Replication - Architecture, HA & DR
• Log Shipping - Disaster Recovery(DR)
• DB Mirroring - High Availability & DR DB Mirroring
• Architecture & Use
• Security - logins, Users & Roles
• Audits For Database, Server & Queries

Module 3 - Advanced SQL DBA

• Data Imports, Exports(SSIS) and DB Mall
• SQL DBA Checklist, SLA Process
• Performance Turning - Partitions & Indexes
• Performannce Turning - Full Text Indexes
• Query Turning - Index Management & DTA
• Management - Database Maintenance Plans
• Alerts and Troubleshooting + DAC
• DB Migrations, Service Packs, Upgrades
• Introduction to SQL Server Clusters
• Active Directory and MSDTC
• SQL Cluster Configuration
• Cluster Issues & Management
• Always-On Availability Groups (AAG)