Maintaining a Microsoft SQL Server 2005 Database Training
| Aanbieder | Twice IT Training |
| Kosten | €1.795,00 |
Overzicht
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. After completing this course, students will be able to: * Install and configure SQL Server 2005. * Manage database files. * Backup and restore databases. * Manage security. * Monitor SQL Server. * Transfer data into and out of SQL Server. * Automate administrative tasks. * Replicate data between SQL Server instances. * Maintain high availability.
Volledige omschrijving
Bestemd voor
This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for maintaining a database.Benodigde kennis
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 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL. * Course 2779: Implementing a Microsoft SQL Server 2005 Database. InschrijvenBeschrijving
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. * 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. * Planning Databases * Creating Databases * Managing Databases Module 3: Disaster Recovery This module explains how to plan and implement a backup and restore strategy. * 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. * 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. * 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. * 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. * 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. * 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. * Introduction to High Availability * Implementing Server Clustering * Implementing Database Mirroring * Implementing Log Shipping * Implementing Peer-to-Peer Replication