Maintaining a Microsoft SQL Server 2005 Database

KnowledgeAir
Buffalo, New York, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course provides students with product knowledge and skills needed 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.

After completing this course, students will be able to:
- Install and configure SQL Server 2005
- Manage database files. - Manage security.
- Perform administrative tasks.
- Backup databases.
- Restore databases
- Monitor SQL Server.
- Troubleshoot SQL Server
- Transfer data.
- Maintain high availability.

--------------------------------------------------------------------------------

Course Outline

--------------------------------------------------------------------------------

Lesson 1: Installing and Configuring SQL Server 2005Preparing to install SQL Server.
Installing SQL Server.
Managing a SQL Server 2005 Installation.

Lesson 2: Managing Databases and FilesPlanning databases.
Creating databases.
Managing databases.

Lesson 3: Disaster RecoveryPlanning a Backup Strategy.
Backing Up User Databases.
Restoring User Databases.
Recovering Data from Database Snapshots.
System Database and Disaster Recovery.

Lesson 4: Managing SecurityOverview of SQL Server Security
Protecting the Server Scope
Protecting the Database Scope
Managing Keys and Certificates in SQL Server

Lesson 5: Monitoring SQL ServerViewing Current Activity.
Using System Monitor.
Using SQL Server Profiler.
Using DDL Triggers.
Using Event Notifications.

Lesson 6: Transferring DataOverview of Data Transfer.
Introduction to SQL Server Integration Services (SSIS).
Using SQL Server Integration Services.
Features of SQL Server Integration Services

Lesson 7: Automating Administrative TasksAutomating Administrative Tasks in SQL Server 2005.
Configuring the SQL Server Agent.
Creating Jobs and Operators.
Create Alerts.
Managing Multiple Servers.
Managing SQL Server Agent Security

Lesson 8: Implementing ReplicationOverview of Replication.
Implementing Replication
Configuring Replication in Some Common Scenarios

Lesson 9: Maintaining High AvailabilityIntroduction to High Availability.
Implementing Server Clustering.
Implementing Database Mirroring.
Implementing Log Shipping.
Implementing Peer-to-Peer Replication

...''

Phone:866-322-3685

School Address:

KnowledgeAir Buffalo
726 Exchange St, Suite 628
Buffalo, NY 14210

KnowledgeAir Rochester
100 Allens Creek Road
Rochester, NY 14618


Jobs & Resumes: Buffalo
Houses & Roommates: Buffalo

Search other schools for Maintaining a Microsoft SQL Server 2005 Database training resources.

Excel 2003
Excel 2007
OneNote 2007
PowerPoint 2003
Word 2007
Illustrator CS3
InDesign CS3
Photoshop CS3
SQL Server 2005
Implementing a Microsoft SQL Server 2005 Database
SQL Advanced Querying
SQL
Windows 2003 Active directory
Exchange Server 2007
ACT!
CISSP
Advanced Administration of Blackberry Enterprise Server
BlackBerry Enterprise Server
BlackBerry End User

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.