01483 688488 01483 688488 Request a callback Email us
Microsoft
AccessAccess
ExcelExcel
OutlookOutlook
Power BIPower BI
PowerPointPowerPoint
ProjectProject
SharePointSharePoint
VisioVisio
WordWord
Adobe
Adobe AcrobatAdobe Acrobat
Adobe After EffectsAdobe After Effects
CaptivateCaptivate
Creative CloudCreative Cloud
IllustratorIllustrator
InDesignInDesign
PhotoshopPhotoshop
Premiere ProPremiere Pro
CAD
AutoCADAutoCAD
RevitRevit
InventorInventor
SketchUpSketchUp
SolidWorksSolidWorks
Technical
Articulate StorylineArticulate Storyline
Crystal ReportsCrystal Reports
HTML5 and CSSHTML5 and CSS
MapInfoMapInfo
SQL ServerSQL Server
RR
SPSSSPSS
SQLSQL
Working With WordPressWorking With WordPress
Finance
Introduction To FinanceIntroduction To Finance
XeroXero
Soft Skills
Chairing Meetings
Deliver Confident & Impactful Presentations
Assertiveness Training
New Manager & Team Leader Skills Builder Training
Time Management
Minute Taking Training Course
SQL Server Training – Advanced Administration

SQL Server Training – Advanced Administration

4.88 / 8 reviews

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 principles.

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.

Course Details

Download full course details Download full course details
  • 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