Microsoft Training - April-September 2009 - (Page 36) New Implementing and Maintaining SQL Server 2008 Course 6182 Learn about the latest version of SQL Server 2008. Enhanced Course OMLP-based & Global Knowledge enhanced Lab 1: Installing and Configuring SQL Server Lab 2: Managing Databases and Files Lab 3: Disaster Recovery Lab 4: Managing Security Lab 5: Implementing Replication Lab 6: Maintaining High Availability Lab 7: Monitoring SQL Server Hands-On Labs Lab 8: Troubleshooting and Performance Tuning Lab 9: Creating Data Types and Tables Lab 10: Implementing Data Integrity by Using Constraints and Triggers Lab 11: Implementing Views Lab 12: Implementing Stored Procedures Course Description This instructor-led course provides you with the knowledge and skills to implement and maintain a Microsoft SQL Server 2008 database. You will learn to use SQL Server 2008 product features and tools related to implementing and maintaining a database. This course incorporates materials from the Official Microsoft Learning Products 6231: Maintaining a Microsoft SQL Server 2008 Database and 6232: Implementing a Microsoft SQL Server 2008 Database. Course Content What You’ll Learn • • • • • • • • • Install and configure SQL Server 2008 Manage database files Back up and restore databases Manage security Replicate data between SQL Server instances Maintain high availability Monitor SQL Server Create data types and tables I mplement data integrity in Microsoft SQL Server 2008 databases by using constraints • mplement data integrity in Microsoft SQL Server 2008 by using I triggers • Implement views and stored procedures 1. Installing and Configuring SQL Server • Preparing to Install SQL Server • Installing SQL Server • Configuring a SQL Server Installation 2. Managing Databases and Files • Planning Databases • Creating Databases • Using Policy-Based Management 3. Disaster Recovery • Planning a Backup Strategy • Backing Up User Databases • Restoring User Databases • Performing Online Restore Operations • Recovering Data from Database Snapshots • System Databases and Disaster Recovery 4. Managing Security • Overview of SQL Server Security • Protecting the Server Scope • Protecting the Database Scope • Protecting the Server Scope • Auditing Security 5. Implementing Replication • Overview of Replication • Managing Publications and Subscriptions • Configuring Replication in Some Common Scenarios 6. Maintaining High Availability • Introduction to High Availability • Implementing Log Shipping • Implementing Database Mirroring • Implementing Server Clustering • Using Distributed High Availability Solutions 7. Monitoring SQL Server • Viewing Current Activity • Using SQL Server Profiler • Monitoring with DDL Triggers • Using Event Notifications 8. Troubleshooting and Performance Tuning • Troubleshooting SQL Server • Performance Tuning in SQL Server • Using Resource Governor • Using Data Collector 9. Creating Data Types and Tables • Creating Data Types • Creating Tables • Creating Partitioned Tables 10. Implementing Data Integrity by Using Constraints and Triggers • Data Integrity Overview • Implementing Constraints • Implementing Triggers 11. Implementing Views • Introduction to Views • Creating and Managing Views • Optimizing Performance by Using Views 12. Implementing Stored Procedures • Implementing Stored Procedures • Creating Parameterized Stored Procedures • Working with Execution Plans • Handling Errors Who Needs To Attend Prerequisites IT professionals who administer and maintain SQL Server databases • asic knowledge of the Microsoft Windows operating system and its B core functionality • Working knowledge of Transact-SQL • Working knowledge of relational databases • Some experience with database design Your Path To Learning Whether you want to expand your skills in your current job or take a new path altogether, use our learning paths to help determine the foundational, follow-on, and certification training courses you need for job roles using Server 2008, SharePoint, and SQL Server. To discover your learning path, visit www.globalknowledge.comcom/microsoft. Classroom Learning 5 days $2,995 Classroom Learning CA San Jose Jun 8-12 CA San Jose Sep 21-25 DC Washington May 18-22 DC Washington Jul 27-31 FL GA GA IL IL Orlando Atlanta Atlanta Chicago Chicago Virtual Classroom e-Learning 5, 8-hour sessions, $2,495 May 4-8 Jun 1-5 Aug 24-28 Jun 8-12 Sep 14-18 MA MA NC NC NJ Boston Boston Raleigh Raleigh Morristown On-Site Learning Call for info. Apr 20-24 Aug 3-7 May 18-22 Sep 14-18 Apr 27-May 1 NY NY TX TX TX New York New York Dallas Dallas Houston Apr 6-10 Aug 10-14 Jun 22-26 Sep 28-Oct 2 May 11-15 TX Houston Sep 14-18 See web site for more information. 36 REGISTER NOW 1-800-COURSES www.globalknowledge.com/microsoft http://www.globalknowledge.com/microsoft http://www.globalknowledge.com/training/olm/go.asp?find=MIC6182&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.