SQL Server Training – Advanced Administration

This advanced SQL Server training course will build your skills allowing you to plan, implement and manage a SQL Server relational database infrastructure to an advanced level.

This course is instructor led, and involves working on a number of practical, hands on examples and exercises in a workshop environment. Led by highly experienced SQL Server trainers with many years of experience our hands-on courses mean that you will leave with lots of practical SQL experience as well as useful tips and tricks.

It is recommended that students have good experience of windows and  understanding of SQL and relational database principals.

  • Performance Monitoring and Tuning Methodology
  • Tools for Monitoring SQL Server
  • Advanced performance management techniques and strategies
  • Tools for Transferring Data in SQL Server
  • Introduction to Data Transformation Services
  • Using Clustering with SQL Server
  • SQL Server Log Shipping
  • Introducing Replication
  • Introduction to Distributed Data
  • SQL Server Replication Agents and types
  • Physical Replication Models
  • Maintaining High Availability
  • Planning and Using Multi-Instances