Our SQL DBA Course can cover Beginners or Intermediate/Advanced training, depending on your needs. So, with this SQL DBA Training, you will learn real-world skills gleaned by experienced DBAs.
It’s not about the bells and whistles because it’s about getting the basics right, again and again. We have been DBAs for many years and we share our experience with you on this SQL course.
Sequallity cover SQL Server and typical DBA tasks, therefore we show you what’s important and what’s not. Our course covers how to prioritise, expertise around indexes, statistics and correct maintenance implementation and most importantly, a deeper understanding of how SQL Server works under the hood.
For the Advanced SQL DBA training course, we cover both typical and advanced SQL topics. You want to learn the intricate nature of SQL Server and how to resolve and consider real-world DBA problems in an efficient and pragmatic fashion.
This DBA training course covers New Features of SQL Server so you can get the most out of SQL Server. Logical Query Processing, B-trees, Indexes, Access Methods plus statistics are all covered.
The course can be 1-3 days or longer if you mix more modules in or to suit your budget and needs.
We can train in any version of SQL Server up to and including SQL Server 2019.
SQL DBA Course for Beginners 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
Server Configuration
- Windows Settings
- Server Settings
- Server Advanced Settings for Performance
Databases
- There are always two files to begin with…
- 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
- Query Store
- Extended Events
- SQL Server Profiler
- 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 & Disaster Recovery
- Log Shipping Overview
- Clustering Overview
- AlwaysOn Overview
- Database Mirroring Overview
SQL DBA Course for Intermediate/Advanced 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
- Windows Settings
- Server Settings
- Server Advanced Settings for Performance
SQL Server Internals
- Logical Query Processing
- B-Trees
- Access Methods
- There are always two
Databases
- There are always two
- File Placement
- Auto Growth
- Filegroups
Indexes
- Clustered & Non-Clustered
- Primary Keys
- Heaps
- B-Tree Basics
- Index Optimisation
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
- Query Store
- Extended Events
- SQL Server Profiler
- Performance Monitor
- DMVs
- SSIS
- Performance Counters
Maintenance
- Maintenance Plans
- Scripts
- Database Mail
- Alerts
- Operators
Automation
- Fragmentation
- Updating Statistics
- Check your integrity
Blockchain is old news
- Transactions
- Isolation Levels
- Locking and Blocking
- Deadlocking
- Handling deadlocks
- Timeouts
New Features & T-SQL
- Columnstore Indexes
- Backup Encryption
- Cardinality Estimation – a brave new world
- Delayed Durability
- Memory-Optimized Tables
- Query Store – An Introduction
- Temporal Tables
- Adaptive Query Processing
- Automatic Database Tuning
- Graph Database Capabilities
- T-SQL Enhancements
High Availability
- Log Shipping Overview
- Clustering Overview
- AlwaysOn Overview
- Database Mirroring Overview
SQL DBA Training Feedback
What do our delegates like most about the SQL DBA training course?
SQL Server Administration Training for SQL Server 2017
- “Extensive examples and walkthroughs. Very approachable and well prepared.” – Rob
- “The trainer was very helpful and happy to cover topics which we found helpful. He was very knowledgeable.” – Jane
- “Presentation Style” Nicky & David
Other SQL Server Training Courses
- SQL Server Training Courses
- TSQL Training Course
“Microsoft and SQL Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.”