Introduction

Learn to plan, implement and manage a SQL Server relational database infrastructure to an advanced level.

This is a hands-on course. It includes plenty of time to experiment with what you are being taught and try things out for yourself.

By the time you finish, you’ll be a highly technically capable SQL database administrator.

✔ An advanced SQL database administration course taking your skills to the next level.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with issues you have after the course.

What Will I Learn?

By the end of this course you will understand:

  • Performance monitoring, tuning and troubleshooting.
  • Tools available for data transfer including Data Transformation Services.
  • Clustering and log shipping.
  • Data replication, multi-instances and high availability.

Am I Ready For This Course?

This course assumes that you already have an understanding of MS SQL Server, SQL and relational database principals.

The Training Day

Our courses run from 9.30am to roughly 4.15pm with refreshments throughout the day and a break for a tasty, freshly prepared lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the best instructors on the planet.

Also, you’ll receive:

✔ A full-colour A4 manual covering everything in the course so that you can recap.
✔ A USB stick for the course exercises to let you practice more in your own time.
✔ A Certificate of Attendance.

  • 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