SQL Server DBA

SQL Server DBA TRAINING

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)
Query Form
Commencing New Batch
Noida

Greater Noida

Ghaziabad

Faridabad

Gurugram



Corporate Office Noida: 0120 - 4646464

GR.Noida: 0120-4345190 Ghaziabad: 0120-4835400 Faridabad: 0129-4150605 Gurugram: 0124-4219095

Events Gallery

Icon

Ducat provides the best available programs which helps in enhancing the technical skills which seems to be beneficial for all the applicants.

© Copyright 1999-2019 Ducat Creative, All rights reserved.