Omschrijving
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.
Doelgroep
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.
Voorkennis
Before attending this course, students must have:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
- Some experience with database design.
In addition, it is recommended, but not required, that students have completed:
- Course MS2778, Writing Queries Using Microsoft SQL Server Transact-SQL.
- Course MS2779, Implementing a Microsoft SQL Server Database.
Bestemd voor
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.
Programma
Module 1: Installing and Configuring SQL Server 2005
This module explains how to plan for and install SQL Server 2005, how to manage a SQL Server 2005 installation, and how to use the SQL Server 2005 administrative tools.
Lessons
- Preparing to Install SQL Server
- Installing SQL Server 2005
- Managing a SQL Server 2005 Installation
Module 2: Managing Databases and Files
This module explains how to manage databases and files.
Lessons
- Planning Databases
- Creating Databases
- Managing Databases
Module 3: Disaster Recovery
This module explains how to plan and implement a backup and restore strategy.
Lessons
- Planning a Backup Strategy
- Backing Up User Databases
- Restoring User Databases
- Performing Online Restore Operations
- Recovering Data from Database Snapshots
- System Database and Disaster Recovery
Module 4: Managing Security
This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database.
Lessons
- Overview of SQL Server Security
- Protecting the Server Scope
- Protecting the Database Scope
- Managing Keys and Certificates in SQL Server
Module 5: Monitoring SQL Server
This module explains how to monitor SQL Server performance and activity.
Lessons
- Viewing Current Activity
- Using System Monitor
- Using SQL Server Profiler
- Using DDL Triggers
- Using Event Notifications
Module 6: Transferring Data
This module explains how to transfer and transform data.
Lessons
- Overview of Data Transfer
- Introduction to SQL Server Integration Services
- Using SQL Server Integration Services
- Features of SQL Server Integration Services
Module 7: Automating Administrative Tasks
This module explains how to use the SQL Server Agent to automate administrative tasks.
Lessons
- Automating Administrative Tasks in SQL Server 2005
- Configuring the SQL Server Agent
- Creating Jobs and Operators
- Creating Alerts
- Managing Multiple Servers
- Managing SQL Server Agent Security
Module 8: Implementing Replication
This module explains the purpose of replication, introduces the concepts underpinning replication, and describes how to implement replication in several common scenarios.
Lessons
- Overview of Replication
- Implementing Replication
- Configuring Replication in Some Common Scenarios
Module 9: Maintaining High Availability
This module explains how to implement high availability technologies with SQL Server 2005.
Lessons
- Introduction to High Availability
- Implementing Server Clustering
- Implementing Database Mirroring
- Implementing Log Shipping
- Implementing Peer-to-Peer Replication
Kosten
€ 1.875,00
Prijzen zijn exclusief 19% btw.
