Course Maintaining a Microsoft SQL Server 2005 Database

Duration (days): 3
Price (CZK): 12000

Maintaining a Microsoft SQL Server 2005 Database topics:

• Installing and Configuring SQL Server 2005
• Preparing to install SQL Server
• Installing SQL Server
• Managing a SQL Server 2005 Installation
• Managing Databases and Files
• Planning databases
• Creating databases
• Managing databases
• Disaster Recovery
• Planning a Backup Strategy
• Backing Up User Databases
• Restoring User Databases
• Recovering Data from Database Snapshots
• System Database and Disaster Recovery
• Managing Security
• Overview of SQL Server Security
• Securing the Server Scope
• Securing the Database Scope
• Managing Keys and Certificates in SQL Server
• Monitoring SQL Server
• Viewing Current Activity
• Using System Monitor
• Using SQL Server Profiler
• Using DDL Triggers
• Using Event Notifications
• Overview of Data Transfer
• Introduction to SQL Server Integration Services
• Using SQL Server Integration Services
• 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
• Introduction to High Availability
• Implementing Server Clustering
• Implementing Database Mirroring
• Implementing Log Shipping
• Overview of Replication
• Replication Scenarios

All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs