Home >> IT Training >> Microsoft Classes

Implementing and Maintaining SQL Server 2008 Training Classes

How is our Implementing and Maintaining SQL Server 2008 training class different from the rest? We hire full-time consultants with a talent for teaching and years of knowledge and experience. Our IT training classes are taught by experienced professionals in real-time, so you can ask about actual working scenarios and receive immediate, useful answers. Our five-day immersion sessions allow for concentrated study of the subject with others who are ready to expand their IT horizons.

In our course, you will learn how to use the features and tools of SQL Server 2008 in order to implement and maintain a database. You will also learn the basics of managing files as well as gain vital knowledge in the area of disaster recovery including backing up data and restoring the user databases after a crash. Each course contains 12 labs that break down the information into intense, but manageable sessions. Our courses use Official Microsoft Learning Products to ensure that you are getting the latest and most accurate information available.

The onsite Implementing and Maintaining SQL Server 2008 training class is convenient and effective for companies with more than six employees who need training. Not only does bringing the classroom to you save time, it will save you money. Just set aside a training room on your premises, gather your employees and start the learning process-our onsite training can save your company an average of 30% of the cost of a traditional course taught at an outside facility.

If you are an IT professional who is ready to take the next step, enroll in our Implementing and Maintaining SQL Server 2008 training class now. Simply click on the blue button to get started and make sure you stay one step ahead of the competition.

Enrollment Fee: $2,995.00 USD
Number of Class Days: 5

Implementing and Managing Windows Server 2008 Clustering Schedule::
	Feb 23 - 25, 2009	San Jose, CA

Training Class Outline:

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