SQL Server DBA Training
Course Topics:
Introduction to database
management systems and databases
- Database management system (DBMS)
- Introduction to Microsoft SQL Server and
its overall SQL Server Data
- Platform Tasks of a Database Administrator
SQL Server Installation
- Editions of SQL Server
- Hardware and Software pre-requisites for a
successful SQL Server installation.
- Understanding SQL Server components.
- Perform a successful SQL Server Installation
- Understanding SQL Server version
identifiers, installed directories and conventions.
SQL Server Administration
and Development Tools
- Using SQL Server Books Online
- Using SQL Server Management Studio (SSMS)
- Using SQL Server Configuration Manager
SQL Server Architecture
- Understanding SQL Server system databases.
- Understanding the SQL Server database
structure.
- Data files and file groups.
- SQL Server Transactional logs, Recovery
Models.
- Difference between SQL Server instance and
database.
- SQL Server Database objects
- Understanding SQL Server data types
- Understanding column properties
- Creating tables, altering tables and
adding constraints, relationships.
SQL Server Backup
- 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.
SQL Server Restore and
Recovery
- Introduction to Database Restore and
Recovery Full database restore
- Full database restores and recovery of transactional
logs Restoring system databases
SQL Server 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.
SQL Server Memory Management
- SQL Server Buffer, Worker Threads,
Checkpoint, Lazy writer PAE, AWE
- Memory allocation for Multiple Instances
Indexing In SQL Server
- Query Execution Plans , Query Optimizer
- Understanding database indexes
- Checking index fragmentation and
maintaining them
- Database statistics
Database Health Checks
- DBCC Commands
- System/ Extended procedures to check
Database Health
- Dynamic Management Views
Moving Databases
- Moving System Databases
- Moving TempDB
- Attach & Detach Databases
SQL Server Data Export and
Import (Data Movement)
- Partial Data export and import using–
Export and Import Wizard
- Move or copy a full database.