Home >> IT Training >> Microsoft Classes

Introduction to SQL Server 2008

How is our Introduction to SQL Server 2008 training class different from others you can find on the web? We hire only qualified, full-time IT consultants with years of experience and a talent for teaching. Because we teach our IT training classes in real-time, you can get your workplace questions answered and put those answers to work right away. This class is taught in nine labs over three days so that you leave confident in your new abilities.

In our course, you will update your skills from SQL Server 2005 to SQL Server 2008. We begin with a review of SQL Server Books Online, and then move on to teach you to manage and optimize SQL Server 2008. You will learn to develop a database and maintain high availability by configuring peer-to-peer replication. We end our course by teaching you to use SQL Server 2008 Reporting Services and Analysis Services. This course is for those professionals who are experiences with SQL Server 2005. We use materials from the Official Microsoft Learning Products so that you are learning the best and latest information available.

Our onsite Introduction to SQL Server 2008 training class is perfect for those companies who have six or more employees that need this kind of training. Not only does bringing the classroom to you save valuable commute time for your employees, but we can save you 30% off the cost of a course taught in a traditional classroom setting. All you need to provide is the training room and the employees and we'll bring the rest.

If you are an IT professional who is ready to take the next step in your career, enroll in our Introduction to SQL Server 2008 training class today. Click the blue button to get started now.

Enrollment Fee: $2,095.00 USD
Number of Class Days: 3

 

Training Class Outline:

1. Introduction to SQL Server 2008

* The Evolution to SQL Server
* Preparing for SQL Server 2008

2. SQL Server 2008 Manageability Enhancements

* Configuration Servers
* Policy-Based Management

3. SQL Server 2008 Performance Enhancements

* Managing Workloads with Resource Governor
* Monitoring Performance with the Data Collector
* Managing Performance with Plan Freezing

4. SQL Server 2008 Security Enhancements

* Encrypting Databases
* Auditing All Actions

5. SQL Server 2008 Database Development Enhancements

* Developer Tool Enhancements
* Data Type Enhancements
* Working with Spatial Data

6. SQL Server 2008 Availability Enhancements

* Always On Technologies
* Transactional Peer-to-Peer Replication

7. SQL Server 2008 Data Warehousing Enhancements

* ETL Enhancements
* Using Partitioned Tables
* Optimizing Data Storage

8. SQL Server 2008 Reporting Services Enhancement

* Reporting Services Architecture and Management
* Authoring Reports
* Report Processing and Rendering

9. SQL Server 2008 Analysis Services Enhancements

* Multidimensional Analysis with SQL Server Analysis Services
* Data Mining with SQL Server Analysis Services