SQL Server Training

Introduction to SQL Training using SQL Server - 2 days

This SQL Server training course is designed for students new to writing SQL queries using SQL Server. The SQL learned in this course is standard to all modern databases, but SQL Server will be used in class and syntax and functionality specific to SQL Server will be pointed out.

The next class is running 2/22/2010. Register for this date or See More Dates

MOC 2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL - 3 days

This Transact-SQL training class provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

This Transact-SQL class is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

The next class is running 2/17/2010. Register for this date or See More Dates

MOC 6231 - Maintaining a Microsoft SQL Server 2008 Database - 5 days

This SQL Server training class provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The class focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

This SQL Server 2008 class is intended for IT Professionals who administer and maintain SQL Server 2008 databases.

The next class is running 2/22/2010. Register for this date or See More Dates

MOC 6232 - Implementing a Microsoft SQL Server 2008 Database - 5 days

This SQL Server training class provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The class focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.

This SQL Server 2008 class is intended for IT Professionals who administer and maintain SQL Server databases.

The next class is running 3/1/2010. Register for this date or See More Dates

MOC 6158 - Updating Your SQL Server 2005 Skills to SQL Server 2008 - 3 days

This SQL Server training class provides experienced SQL Server 2005 developers and database administrators the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.

The next class is running 3/22/2010. Register for this date or See More Dates

MOC 2780 - Maintaining a Microsoft SQL Server 2005 Database - 5 days

This SQL Server 2005 training class provides students with the knowledge and skills to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

This class is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

The next class is running 3/1/2010. Register for this date or See More Dates

MOC 2779 - Implementing a Microsoft SQL Server 2005 Database - 5 days

This SQL Server training class provides students with the knowledge and skills to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.

This training class is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database.

The next class is running 2/15/2010. Register for this date or See More Dates

Introduction to .NET for DBAs Using Visual Studio 2008 - 2 days

This .NET training class will give the working DBA sufficient skills with .NET so that they can use it effectively in all the areas supported by SQL Server. The course starts with learning Visual Basic language concepts, including Data Types, Variables, and Classes and Objects while building simple console applications. Then it moves on to handling exceptions by using try/catch blocks and other programming tools - ADO.NET will be used for connecting to data sources and related topics. You'll then learn to work with SQL 2008's features like SQL Server Management (SSMS), Object Explorer, Query Editor plus others and then the development feature SQL CLR (Common Language Runtime). Finally, there is an overview of SQL Business Intelligence for 2008.

The next class is running 3/1/2010. Register for this date or See More Dates

MOC 6236 - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services - 3 days

This SQL Server Reporting Services (SSRS) class teaches students how to implement a Reporting Services solution in an organization. The class discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

This SSRS training class is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services.

The next class is running 3/1/2010. Register for this date or See More Dates

MOC 2793 - Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services - 3 days

This SSRS training class teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

This training class is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2005 Reporting Services.

The next class is running 2/24/2010. Register for this date or See More Dates

MOC 6234 - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services - 3 days

This SSAS training class teaches students how to implement an Analysis Services solution in an organization. The class discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.

This SSAS class targets people who design and maintain business intelligence solutions for their organization. These individuals work in environments where databases play a key role in their primary job and may perform database administration and maintenance as part of their primary job responsibilities.

The secondary audience for this course is individuals who develop applications that deliver content from SQL Server Analysis Services to the organization.

The next class is running 3/8/2010. Register for this date or See More Dates

MOC 6235 - Implementing and Maintaining Microsoft SQL Server 2008 Integration Services - 3 days

In this SQL Server Integration Services (SSIS) training class, students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

This SSAS class targets information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2008 Integration Services.

The next class is running 3/1/2010. Register for this date or See More Dates

MOC 2792 - Implementing and Maintaining Microsoft SQL Server 2005 Integration Services - 3 days

This SSIS training class teaches students how to implement an Integration Services solution in an organization. The class discusses how to develop, deploy, and manage Integration Services packages.

This training class is intended for information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2005 Integration Services.

The next class is running 2/24/2010. Register for this date or See More Dates

Agile Database Techniques using Visual Studio Team System 2008 - 3 days

This Visual Studio Team System training class provides students with the knowledge and skills to properly manage the SQL Server database development lifecycle in an agile environment. The student will learn how to manage changes to the database structure, ensuring quality through T-SQL unit testing, and how to automate the building and deploying of SQL Server databases. Intended for developers and administrators already comfortable with the concepts of designing, programming, testing, and deploying SQL Server databases, this course focuses on using Visual Studio Team System 2008 Database Edition to maximize productivity while minimizing mistakes.

This VSTS course is intended for SQL Server database developers and administrators. Application developers who are involved with writing and testing T-SQL code and working with test data, will also gain value from this course.

This class is only available as a private onsite class. Contact us for a proposal.