Courses - Microsoft SQL Server DBA



(Course PDF)

The History of SQL Server and relational databases

  Relational database history
  The evolution of SQL Server
  SQL Server and ANSI standards

Installing and configuring SQL Server

  Pre-installation steps
  Installing SQL Server
  Configuring the run-time SQL Server system
  Patching SQL Server - Service packs

SQL Server data storage management

  SQL Server file management architecture
  Creating database files
  Creating SQL Server log files
  Using SQL Server file groups

Managing data with the DTS utility

  Using DTS to export and import SQL Server table data

SQL Server Security management

  Windows authentication mode
  Windows authentication mode
  SQL Server rights and role management

SQL Server Backup & Recovery

  Overview of SQL Server backup & recovery
  Incremental backups
  Restoring a SQL Server database
  Standby database overview
  Shipping SQL Server log files to standby databases

SQL Server database Replication

  Microsoft replication architectures
  Creating a replication topology
  Configuring SQL Server replication

SQL Server Job scheduling

  Common database scheduled jobs
  Configuring SQLMail
  Setting SQL Server and server alert thresholds
  Creating customized error conditions
  Scheduling multi-step job streams

Ratio Analysis - Techniques for quickly getting a bird's eye view of performance

  Key performance ratios can quickly help a SQL Server DBA understand how well their overall system is performing. This chapter provides details on what ratios a DBA needs to monitor, along with recommendations for what to do when key performance metrics are out of line
Performance Tuning for the SQL Server DBA

  SQL Server monitoring for performance
  SQL Server startup parameter tuning
  T-SQL tuning
  SQL tuning for SQL Server
  Diagnosing storage and system problems
  Diagnosing storage and system problems