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

TSQL Advanced 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 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
Advanced SQL DBA Course
Performance Tuning Course
Installing SQL Server Training
Data Warehouse Training
SSAS Multidimensional Course
SSAS Tabular Course
SSIS Training Course
SSRS Training Course
Power BI Training Course

 

Summary
SQL Server Database Administrators for Beginners Training Course
Service Type
SQL Server Database Administrators for Beginners Training Course
Provider Name
Sequallity Ltd,
80-83 Long Lane,London,EC1A 9ET,
Telephone No.020 3507 1989
Area
UK
Description
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.