IT Shiksha 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