Accidental DBA

2 Day Course  |  £795.00 (+VAT)

Target Audience

If you have ever found yourself at the helm of your company’s SQL Server simply because you “happen to know a little SQL” and it has now become your job to keep your SQL Server estate afloat? Then this is the course for you.

Required Knowledge

Basic understanding of relational databases
Basic T-SQL knowledge

Purpose of the Course

By the end of this course you will be able to confidently maintain and monitor SQL Server, alongside having a thorough understanding of disaster recovery, index maintenance, and baselining so that you can deal with any issues raised and remain calm and in control should a crisis ever arise. This information will be the underlying knowledge to build on when looking to improve and upgrade your career.

Topics Covered

  • Server Hardware
  • SQL Server Configuration Settings
  • Disaster Recovery
  • Security
  • Database Maintenance
  • Index and Statistics Maintenance
  • Baselining

Course Modules

Module 1: Basic Database Management
  • Hardware Overview
  • Configuration Overview
  • System Database Overview
  • Disaster Recovery Overview
  • Index Maintenance Overview
  • Baselining Overview
Module 2: Server Hardware
  • Local Disks
  • SAN Disks
  • Memory
  • CPU
Module 3: SQL Server Configuration
  • Max Server Memory
  • Max Degree of Parallelism
  • Optimise for Ad Hoc Workloads
  • Backup Compression
  • Dedicated Administrator Connection
  • Misc Settings to Consider
Module 4: Backup & Restore
  • Recovery Models
  • Backup Types
  • Restore Types
  • High Availability Overview
Module 5: High Availability
  • Strategy Planning
  • Mirroring
  • Log Shipping
  • Replication
  • Failover Clustering
  • Availability Groups
Module 6: SQL Server Security
  • Domain and SQL Authentication
  • Logins and Users
  • Database Level Permissioning
  • Object Level Permissioning
Module 7: Database Maintenance
  • System Databases
  • TempDB
  • User Databases
  • Shrinking Databases
Module 8: Index Maintenance
  • Reindex vs Reorg
  • Fill Factor
  • Unused Indexes
  • Statistics Maintenance
Module 9: Monitoring
  • Profiler
  • Extended Events
  • Live Query Monitoring
Module 10: Baselining
  • Why do we baseline?
  • Windows Performance Counters
  • SQL Server Counters
  • DMVs to Track
Would you like to discuss your training requirements with me?
I'm always happy to help so, whatever your question, simply give me a call or send me a message and I'll get back to you as quickly as possible.
Copyright © 2018 London SQL Server Training Courses @ SQL Training | Website Design From Scott Heron