Worth Corner, Crawley, RH10 7SL

Support Hours - Mon-Sat, 8.00-18.00

Accidental / Junior DBA

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 & Statistics Maintenance
  • Baselining

Course Modules

Module 1: Basic Database Management

  • Hardware Overview
  • Configuration Overview
  • System Databases Overview
  • Disaster Recovery Overview
  • Index Maintenance Overview
  • Baselining Overview

Module 6: SQL Server Security

  • Domain and SQL Authentication
  • Logins and Users
  • Database Level Permissioning
  • Object Level Permissioning

Module 2: Server Hardware

  • Local Disks
  • SAN Disks
  • Memory
  • CPU

Module 7: Database Maintenance

  • System Databases
  • TempDB
  • User Databases
  • Shrinking Databases

Module 3: SQL Server Configuration

  • Max Server Memory
  • Max Degree of Parallelism
  • Optimize for Ad Hoc Workloads
  • Backup Compression
  • Dedicated Admin Connection
  • Misc Settings to Consider

Module 8: Index Maintenance

  • Reindex vs Reorg
  • Fill Factor
  • Unused Indexes
  • Statistics Maintenance

Module 4: Backup & Restore

  • Recovery Models
  • Backup Types
  • Restore Types
  • High Availability Overview

Module 9: Monitoring

  • Profiler
  • Extended Events
  • Live Query Monitoring

Module 5: High Availability

  • Strategy Planning
  • Mirroring
  • Log Shipping
  • Replication
  • Clustering
  • Availability Groups

Module 10: Baselining

  • Why Do We Baseline?
  • Windows Performance Counters
  • SQL Server Counters
  • What are DMVs?
  • DMVs to Track

Book Course

Sign up for email alerts

Stay current with our latest insights

© Copyright 2020 SQLTraining Ltd.