Ducat SQL Server DBA Training provide the knowledge on SQL DBA, SQL Server instances, SAN storage, and security. Our professional SQL Server DBA training also covers disaster recovery, replication, using jobs and database maintenance tasks, etc. You will also get an exposure to industry based Real-time projects in various verticals. Enroll & Become Certified

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)
COMMENCING NEW BATCHES
ENQUIRY FORM
FOLLOW US ON
SUBSCRIBE TO OUR NEWSLETTER

WE ACCEPT ONLINE PAYMENTS
PAY ONLINE