Microsoft Training - April-September 2009 - (Page 38) SQL Server 2005 Administration Learn to administer and tune SQL Server Databases and Servers. Course 6052 Authorized Course Official Microsoft Learning Product Redeem your SATVs on this course at www.globalknowledge.com/satv. Lab 1: Installing and Configuring SQL Server 2005 • Performing an Installation • Managing SQL Server Lab 2: Managing Databases and Files • Creating a Database • Monitoring and Managing Filegroup Usage • Viewing Database Metadata Lab 3: Disaster Recovery • Implementing a Backup Strategy • Restoring and Recovering a Database • Performing Piecemeal Backup and Restore Operations • Restoring the master Database Lab 4: Managing Security • Creating Logins and Assigning Server-Scope Permissions • Creating and Managing Users • Using a Certificate to Protect Data Lab 5: Monitoring SQL Server • Monitoring SQL Server Performance • Tracing SQL Server Activity • Implementing DDL Triggers Hands-On Labs Lab 6: Transferring Data • Creating an SSIS Package • Deploying an SSIS Package • Using SSIS to Extract Data, Perform Lookups, Sort, and Split Data Lab 7: Automating Administrative Tasks • Configuring SQL Server Agent • Creating Operators and Jobs • Creating Alerts Lab 8: Implementing Replication • Creating a Publication • Creating a Subscription • Implementing HTTP Merge Replication Lab 9: Maintaining High Availability • Configuring Database Mirroring to Support Failover • Implementing Distributed High Availability Course Description Get the knowledge and skills you need to maintain a Microsoft SQL Server 2005 database in this 5-day course. Learn how to use SQL Server 2005 product features and tools related to maintaining a database. This course incorporates material from the following Official Microsoft Learning Product (OMLP): • Course 2780: Maintaining a Microsoft® SQL Server™ 2005 Database What You’ll Learn in Class • • • • • • • • • 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 using SSIS Automate administrative tasks Replicate data between SQL Server instances Maintain high availability Course Content Who Needs To Attend IT professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database. 1. Installing and Configuring SQL Server 2005 • Preparing to Install SQL Server • Installing SQL Server 2005 • Managing a SQL Server 2005 Installation 2. Managing Databases and Files • Planning Databases • Creating Databases • Managing Databases 3. Disaster Recovery • 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 4. Managing Security • Overview of SQL Server Security • Protecting the Server Scope • Protecting the Database Scope • Managing Keys and Certificates in SQL Server 5. Monitoring SQL Server • Viewing Current Activity • Using System Monitor • Using SQL Server Profiler • Using DDL Triggers • Using Event Notifications 6. Transferring Data • Overview of Data Transfer • Introduction to SQL Server Integration Services • Using SQL Server Integration Services • Features of SQL Server Integration Services 7. Automating 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 8. Implementing Replication • Overview of Replication • Implementing Replication • Configuring Replication in Some Common Scenarios 9. Maintaining High Availability • Introduction to High Availability • Implementing Server Clustering • Implementing Database Mirroring • Implementing Log Shipping • Implementing Peer-to-Peer Replication Prerequisites • asic knowledge of the Microsoft Windows operating system and its B core functionality • orking knowledge of Transact-SQL or course 6136: SQL Server 2005 W T-SQL with Advanced Topics • Working knowledge of relational databases • Some experience with database design Follow-On Courses • Microsoft SQL Server 2005 for Business Intelligence • Microsoft SQL Server 2005 for Developers • Microsoft SQL 2005 Reporting Services Certification Microsoft Certified Technology Specialist: SQL Server 2005 Buy get one Virtual Classroom e-Learning 5, 8-hour sessions, $2,495 Buy 1 course, get 1 half off. Buy 2 courses, get 3rd free. www.globalknowledge.com/bogo Classroom Learning 5 days $2,995 Classroom Learning BC Vancouver Mar 30-Apr 3 BC Vancouver Jun 22-26 CA Los Angeles Jun 1-5 CA Sacramento Aug 10-14 CA San Francisco Jun 15-19 CA San Jose May 11-15 CA San Jose Aug 3-7 DC Washington May 4-8 DC DC FL FL GA GA IL IL IL Washington Washington Orlando Orlando Atlanta Atlanta Chicago Chicago Chicago On-Site Learning Call for info. Jul 20-24 May 18-22 Aug 3-7 Apr 20-24 Jun 22-26 Aug 24-28 Jun 1-5 Aug 17-21 Jun 1-5 ON ON ON ON TX TX TX TX TX Ottawa Toronto Toronto Toronto Dallas Dallas Dallas Houston Houston Jul 27-31 Apr 13-17 May 25-29 Aug 10-14 Apr 20-24 Jun 22-26 Aug 31-Sep 4 Jun 8-12 Sep 14-18 Virtual Classroom e-Learning Mar 30-Apr 3 Jul 27-31 May 4-8 Aug 17-21 Jun 1-5 Sep 21-25 Jul 6-10 Jul 6-10 Aug 31-Sep 4 Apr 27-May 1 Sep 14-18 Apr 27-May 1 Jul 27-31 Apr 20-24 Jun 15-19 Aug 10-14 MA NC NC NJ NJ NJ NY NY ON Boston Raleigh Raleigh Morristown Morristown Morristown New York New York Ottawa 38 REGISTER NOW 1-800-COURSES www.globalknowledge.com/microsoft http://www.globalknowledge.com/satv http://www.globalknowledge.com/bogo http://www.globalknowledge.com/training/olm/go.asp?find=MIC6052&country=United+States http://www.globalknowledge.com/microsoft
For optimal viewing of this digital publication, please enable JavaScript and then refresh the page. If you would like to try to load the digital publication without using Flash Player detection, please click here.