Learn real-world DBA skills. It’s not about the bells and whistles, it’s about getting the basics right again and again. We have been DBAs for many years and we share our experience with you.

Learning Outcomes

SQL Server, typical DBA tasks, what’s important and what’s not. How to prioritise, technical skills around indexes, statistics, maintenance and a deeper understanding of how SQL Server works under the hood.

Course Requirements

Beginner DBAs, Developer DBAs or switching from a similar database.

Course Length

3-days

• RDBMS
• Client-Server
• Editions & Versions
• SQL Server Management Studio
• SQL Server Configuration Manager

• The problem is choice
• Disk Set-up
• System Databases
• Upgrading SQL Server Joins

• Windows Settings
• Server Settings
• Server Advanced Settings for Performance

• There are always two
• File Placement
• Auto Growth
• Filegroups

• Clustered & Non-Clustered
• Primary Keys
• Heaps
• B-Tree Basics

• Stored Procedures
• Triggers
• Error Handling

• Auto Update Statistics
• Criticality of Statistics

• Backup & Restore
• Attach/Detach
• Import/Export
• SELECT INTO
• BULK INSERT
• SSIS

• Profiler
• Extended Events
• Performance Monitor
• DMVs
• SSIS

• Maintenance Plans
• Scripts
• Database Mail
• Alerts
• Operators

• Fragmentation
• Updating Statistics
• Check your integrity

• Recovery Model, Full or Simple
• Transaction Logs
• What to do in a disaster?
• Tail of the Log

• Logins & Server Roles
• Database Users
• Database Objects

• Log Shipping Overview
• Clustering Overview
• AlwaysOn Overview
• Database Mirroring  Overview

Course Price

This course costs £1,350 excluding VAT

How to Book

Call us or email us on the form below, any questions, ask us!