Microsoft SQL Server 2008

Unitek Information Systems
Atlanta, Austin, Boston, Chicago, Dallas, Fremont, Portland, Sacramento, San Diego, Seattle, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Module 1: Introduction to SQL Server 2008

Lessons

The Evolution of SQL Server
Preparing for SQL Server 2008
Lab 1: Exploring SQL Server Books Online

Reviewing the SQL Server Books Online Tutorials
Reviewing SQL Server Books Online
After completing this module, students will be able to:

Describe the evolution of SQL Server.
Prepare for SQL Server 2008.
Module 2: SQL Server 2008 Manageability Enhancements

Lessons

Configuration Servers
Policy-Based Management
Lab 1: Managing SQL Server 2008

Creating a Configuration Server
Creating and Applying a Policy
After completing this module, students will be able to:

Create and use a configuration server.
Create and use policies.
Module 3: SQL Server 2008 Performance Enhancements

Lessons

Managing Workloads with Resource Governor
Monitoring Performance with the Data Collector
Managing Performance with Plan Freezing
Lab 1: Optimizing SQL Server 2008

Using Resource Governor
Using the Data Collector
After completing this module, students will be able to:

Manage workloads with Resource Governor.
Monitor performance with the Data Collector.
Manage performance with Plan Freezing.
Module 4: SQL Server 2008 Security Enhancements

Lessons

Encrypting Databases
Auditing All Actions
Lab 1: Securing a SQL Server 2008 Database

Using Transparent Data Encryption
After completing this module, students will be able to:

Encrypt databases.
Audit all actions.
Module 5: SQL Server 2008 Database Development Enhancements

Lessons

Developer Tool Enhancements
Data Type Enhancements
Working with Spatial Data
Lab 1: Developing Databases with SQL Server 2008

Using Date and Time Data Types
Using Spatial Data
After completing this module, students will be able to:

Describe the developer tool enhancements in SQL Server 2008.
Use the data type enhancements in SQL Server 2008.
Work with spatial data.
Module 6: SQL Server 2008 Availability Enhancements

Lessons

Always On Technologies
Transactional Peer-to-Peer Replication
Lab 1: Maintaining High Availability

Configuring Peer-to-Peer Replication
Adding a Replication Node
After completing this module, students will be able to:

Describe the SQL Server 2008 always on technologies.
Implement transactional peer-to-peer replication.
Module 7: SQL Server 2008 Data Warehousing Enhancements

Lessons

ETL Enhancements
Using Partitioned Tables
Optimizing Data Storage
Lab 1: Data Warehousing with SQL Server 2008

Using Change Data Capture
Using the MERGE Statement
Working with Partitioned Data
After completing this module, students will be able to:

Describe the ETL enhancements in SQL Server 2008.
Use partitioned tables.
Optimize data storage.
Module 8: SQL Server 2008 Reporting Services Enhancements

Lessons

Reporting Services Architecture and Management
Authoring Reports
Report Processing and Rendering
Lab 1: Using SQL Server 2008 Reporting Services

Creating a Report with Report Designer
Managing Reporting Services
After completing this module, students will be able to:

Describe the Reporting Services architecture and management.
Author reports.
Understand report processing and rendering.
Module 9: SQL Server 2008 Analysis Services Enhancements

Lessons

Multidimensional Analysis with SQL Server Analysis Services
Data Mining with SQL Server Analysis Services
Lab 1: Using SQL Server 2008 Analysis Services

Implementing Multidimensional Analysis
Implementing Data Mining
After completing this module, students will be able to:

Implement multidimensional analysis.
Implement data mining.
...''

Phone:888 - 825 - 6273

School Address:

4670 Auto Mall Parkway
Fremont, California 94538 USA


Jobs & Resumes: Atlanta, Austin, Boston, Chicago, Dallas, Fremont, Portland, Sacramento, San Diego, Seattle
Houses & Roommates: Atlanta, Austin, Boston, Chicago, Dallas, Fremont, Portland, Sacramento, San Diego, Seattle
Travel Agencies: Atlanta, Austin, Boston, Chicago, Dallas, Portland, San Diego, Seattle

Search other schools for Microsoft SQL Server 2008 training resources.

MCTS: SQL Server 2005 Business Intelligence Boot Camp
Core Technologies in Microsoft SQL Server 2005
Administering and Automating Microsoft SQL Server 2005 Databases and Servers
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
Tuning and Optimizing Queries using Microsoft SQL Server 2005
Implementing a Microsoft SQL Server 2005 Database
Maintaining a Microsoft SQL Server 2005 Database
SQL Server 2005 Analysis Services
SQL Server 2005 Integration Services
SQL Server 2005 Reporting Services
MCTS: Microsoft System Center Configuration Manager 2007, Configuring
MCTS: Microsoft System Center Operations Manager 2007
Managing System Center Operations Manager 2007
Implementing System Center Data Protection Manager 2007
MCPD: Web Developer Boot Camp
MCPD Windows Developer Boot Camp
MCTS: Distributed Applications Boot Camp
Distributed Application Development with Microsoft Visual Studio 2005
Foundations of Microsoft .NET 2.0 Development

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.