SQL Server Database Administrators for Intermediate/Advanced Training Course – DBA Training Course

SQL Server Database Administrators for Intermediate/Advanced Training Course - DBA Training Course

You’re a DBA. You want to take it to the next level, you can with this Advanced DBA Training Course. You want to learn about the intricate nature that SQL Server works and how to resolve and consider real-world DBA problems in a pragmatic fashion.

Learning Outcomes

SQL Server, typical and advanced DBA tasks, what’s important and what’s not. New features and improvements to SQL to allow you to get the most out of SQL Server. Logical query processing, B-trees, indexes, access methods plus statistics, maintenance and a deeper understanding of how SQL Server works under the hood.

Course Requirements

DBAs, Junior DBAs or switching from a similar database wanting an intermediate/advanced course around SQL Server DBA.

Course Length

3-days

SQL Server Database Administrators for Intermediate/Advanced 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
  • 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
  • Profiler
  • Extended Events
  • 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

 

Course Price

This course costs £1,425 excluding VAT

How to Book

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

 

You Might Also Like…

New Features of SQL Course
Beginners TSQL Course
Advanced TSQL Course
Performance Tuning Course
Data Warehouse Training
SSAS Multidimensional Course
SSAS Tabular Course
SSIS Training Course
SSRS Training Course
Power BI Training Course

 

2 + 1 =

Summary
SQL Server Database Administrators for Intermediate/Advanced Training Course - DBA Training Course
Service Type
SQL Server Database Administrators for Intermediate/Advanced Training Course - DBA Training Course
Provider Name
Sequallity Ltd,
80-83 Long Lane,London,EC1A 9ET,
Telephone No.020 3507 1989
Area
UK
Description
You're a DBA. You want to take it to the next level. You want to learn about the intricate nature that SQL Server works and how to resolve and consider real-world DBA problems in a pragmatic fashion.