MS SQL Server DBA Course Will start on 2nd week @ Chicago

MS SQL Server DBA Course content

Module 1:Introduction to RDBMS
RDBMS overview
Introduction to Microsoft SQL Server
Database Administration
Tasks of a Database Administrator

Module 2: SQL Server Installation
Introduction to SQL Server
Hardware and Software needed for a successful SQL Server installation.
Understanding SQL Server components.
Perform a successful SQL Server installation
Slipstreaming SQL Server installation with service packs
Understanding SQL Server version identifiers, installed directories and conventions

Module 3:SQL Server Administration and Development Tools
Using SQL Server Books Online
Using SQL Server Management Studio
Using SQL Server Command Line interface
Using SQL Server Configuration Manager

Module 4: SQL Server Architecture
Understanding SQL Server system databases.
Understanding the SQL Server database structure
SQL Server files and filegroups
SQL Server Transactional logs, Recovery Models
What is the difference between SQL Server instance and database
Client-Server Communication
Attaching and detaching SQL Server databases

Module 5: SQL Server Database objects
Understanding Schemas
Understanding SQL Server data types
Understanding column properties
Creating tables, altering tables and adding constraints, relationships
Understanding the filetable
Creating database diagrams

Module 6: SQL Server Backup and Recovery
Introduction to Backup and Recovery strategy for databases
Full Database backups using SIMPLE Recovery Model
Full Database and Transactional log backups with FULL Recovery Model
Backup history and maintenance
Designing Maintenance plans for Backup Tasks
SQL Server Agent for scheduling backups
Database Mail for email notifications to DBAs
Full database restore
Full database restore and recovery of transactional logs
Restoring system databases

Module 7: Database Objects
Introduction
Tables and Columns
Indexes
Packages, Stored procedures and Functions
Database links
Views and Synonyms
SQL Server Data Dictionary
Popular Data Dictionary views and accessing them

Module 8: SQL Server Data Export and Import

Partial Data export and import using the command line BCP command
Partial Data export and import using GUI tool Export and Import Wizard
Move or copy a full database

Module 9: Security
SQL Server authentication vs. Windows authentication
Auditing database logins using SQL Server Error Logging
SQL Server server wide logins and database specific users
Creating user-defined server roles
Configuring contained databases

Module 10: Performance Tuning
Understanding database indexes
Checking index fragmentation and maintaining them
Database statistics
Understanding SQL Server Profiler
Creating Traces
Running server-side traces
Understanding the Extended Events architecture