Training

Information Technology

SQL Server Database Administration

Start: TBA       Type: Evening / Weekend Classes       Duration (hr): 130

COURSE DESCRIPTION:
This course will introduce Microsoft SQL Server Administration and Development to students. Students will get  theoretical knowledge and practical skills in Transact-SQL coding, debugging, performance tuning, system installation, management, and maintenance.
 
COURSE OBJECTIVES:
- Microsoft SQL Server installation / Cluster Installation / Microsoft SQL Server Analysis
- Using SQL Help/SQL Help Online; finding an answer to problematic issue
- Managing database files: Data structure, Creating and Managing databases, Performance considerations
- Managing Security
- Performing Administrative tasks
- Backup/restore and recovery
- T-SQL
- Monitoring SQL for performance
- Transferring Data (DTS)
- Replication; Disaster recovery; Log Shipping
- Data warehousing; SQL Analysis Server
 
TOPICS:
SQL Server Overview
SQL Server Installation and Configuration
Overview of Database Concepts
Normalization
T-SQL
Managing Security
Performing Administrative tasks
Monitoring Performance
Transferring data
SQL Server Analysis
SQL Server – ADO technology
SQL Programming Across Multiple Servers
XML Integration
Replication
Strategies to Maintaining High Availability
Maintaining transactions and locks
 
 
 

Related Courses