Begninners DBA Training Course

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

SQL Server Database Administrators for Beginners Training Course – DBA Training Course Agenda

SQL Server
  • RDBMS
  • Client-Server
  • Editions & Versions
  • SQL Server Management Studio
  • SQL Server Configuration Manager
Installing SQL Server
  • The problem is choice
  • Disk Set-up
  • System Databases
  • Upgrading SQL Server Joins
Server Configuration
  • Windows Settings
  • Server Settings
  • Server Advanced Settings for Performance
Databases
  • There are always two
  • File Placement
  • Auto Growth
  • Filegroups
Indexes
  • Clustered & Non-Clustered
  • Primary Keys
  • Heaps
  • B-Tree Basics
The Database Objects!
  • Stored Procedures
  • Triggers
  • Error Handling
Statistics
  • Auto Update Statistics
  • Criticality of Statistics
Data Movement
  • Backup & Restore
  • Attach/Detach
  • Import/Export
  • SELECT INTO
  • BULK INSERT
  • SSIS
Monitoring SQL Server
  • Profiler
  • Extended Events
  • Performance Monitor
  • DMVs
  • SSIS
Maintenance
  • Maintenance Plans
  • Scripts
  • Database Mail
  • Alerts
  • Operators
Automation
  • Fragmentation
  • Updating Statistics
  • Check your integrity
Backup and Restore
  • Recovery Model, Full or Simple
  • Transaction Logs
  • What to do in a disaster?
  • Tail of the Log
Security
  • Logins & Server Roles
  • Database Users
  • Database Objects
High Availability
  • Log Shipping Overview
  • Clustering Overview
  • AlwaysOn Overview
  • Database Mirroring Overview

 

Course Price

This Course costs £1,350 excluding VAT

How to Book

Call us on 020 3507 1989 or fill in the form below

 

4 + 5 =