Welcome to ONLC Training Centers


1-800-288-8221


Search for


SCHEDULE

All Classes
Ready to Run

Registration Details

CLASS CATEGORY

Active Directory
Active Directory (AD) Implementation, Support ...

Adobe
Acrobat, Dreamweaver, Flash, Fireworks, Illustrator, InDesign, Photoshop...

Altiris
Client Management Suite (CMS), Deployment Solution, Notification System...

BizTalk Server
2010, Developer, Deep Dive, Immersion...

Business Analyst & ITIL
ITIL Foundation, Practitioner, Lifecycle, Business Analyst CBAP, Software Testing & Quality, Use Case...

Business Intelligence
Crystal Reports, PerformancePoint, Software Quality Assurance...

Cisco
CCNA Bootcamp, Routers, Network Devices, IP Communications, Security, Service Provider...

Citrix
XenApp (Presentation Server), XenServer, EdgeSight, NetScaler, Password Manager...

CompTIA Certification
A+, Network+, Security+ ...

DoD 8570.1
IAT, IAM, baseline certifications, A+, Network+, Security+, SCNP, SCNA, CISSP...

Exchange Server
2010, 2007, 2003, Updating Skills, Installation, Troubleshooting, Monitoring, High Availability...

Help Desk & Support
A+, Network+...

IIS Server
Configure, Troubleshoot...

Microsoft Dynamics
CRM, Great Plains, GP...

Microsoft Office 2010
version 2010 - Access, Excel, Outlook, Project, PowerPoint, Publisher, Visio, Word, VBA Programming...

Microsoft Office 2007/2003
Office Access, Excel, Outlook, PowerPoint, Publisher, Project, Visio, Word, VBA Programming...

Oracle
Oracle DBA, PL/SQL,
11g, Adminstration ...

Project Management
Microsoft Project, IT Principles, PMI...

Security
Forefront, Security+, CEH, SCP, CISSP, DoD 8570.1...

SharePoint 2010
Power User (Mindsharp), Administrator, Designer, Developer ...

SharePoint 2007
Windows SharePoint Services (WSS), Designer, MOSS, Development (Mindsharp), End User ...

SQL Server
SQL 2008, SQL 2005, Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS), Transact-SQL (TSQL)...

System Center, SMS, Scripting
Operations Manager (SCOM), Configuration Manager (SCCM), SMS...

Visual Studio & .NET
.NET, Visual Basic, C#, VBA, ASP ...

VMware
vSphere Desktop, Deployment, Administration, ESX...

Windows 7
Installing, Configuring, Support, Deployment, Certification, MCTS, MCITP...

Windows Server 2008
Managing, Maintaining, Upgrading, Hyper-V Clustering, PowerShell, Terminal Services, Windows Mobile...

Windows Server 2003
Managing, Maintaining, Upgrading ...

Web Basics
HTML, Cascading Style Sheets (CSS), Javascript...

GENERAL INFO
Registration
Locations/Directions
SA Vouchers
Savings Options
Invoice/Receipt
CEU/CPE Credits

OTHER
About ONLC
Our Instructors
Classroom Rentals
Privacy Policy
RCI Login
Contact Us



ONLC is a Microsoft Gold Certified Partner for Learning Solutions

 
Microsoft SQL Server classes & certification at ONLC Training Centers


Microsoft SQL Server Training Classes & Certification

SQL Server is a comprehensive data platform that provides rich services for virtually any data type—helping businesses integrate, manage, and deliver data like never before. Take full advantage of the platform's powerful new features with training at ONLC. We offer SQL Server classess for versions 2008 R2, 2008, 2005 and indepth analysis topics.

Attend hands-on, instructor-led training classes at ONLC's more than 250 delivery locations. Not near one of our locations? Attend these same live classes from the convenience of your home/office PC via our Remote Classroom Instruction (RCI™) technology.


Click the title of the classes marked with the green flag () to see specific locations and dates of "Ready to Run" classes.  Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information
Click Title for Dates & Outlines Days Fee
SQL Server 2008
2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL 3 $1495
6158: Updating Your SQL Server 2005 Skills to SQL Server 2008 3 $1495
6231: Maintaining a Microsoft SQL Server 2008 Database 5 $2495
6232: Implementing a Microsoft SQL Server 2008 Database 5 $2495
6234: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services 3 $1495    
6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services 3 $1495
6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services 3 $1495
6317: Upgrading Your SQL Server 2000 Database Administration (DBA) Skills to Microsoft SQL Server 2008 DBA Skills 3 $1495    
10337: Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2 3 $1495    
50399: Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008 5 $2495    
50400: Designing, Optimizing, and Maintaining a Database Administrative Solution for Microsoft SQL Server 2008 5 $2495
50401: Designing and Optimizing Database Solutions with Microsoft SQL Server 2008 5 $2495    
50402: Implementing Forefront Unified Access Gateway 2010 3 $1495
SQL & SQL Server 2005
2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL 3 $1495
2733: Updating Your Database Administration Skills to Microsoft SQL Server 2005 3 $1495    
2734: Updating Your Database Development Skills to Microsoft SQL Server 2005 3 $1495    
2779: Implementing SQL Server 2005 Database 5 $2495    
2780: Maintaining SQL Server 2005 Database 5 $2495    
2796: Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services 3 $1495    
SQL Analysis, Integration & Reporting Services
2791: Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services 3 $1495    
2792: Implementing and Maintaining Microsoft SQL Server 2005 Integration Services 3 $1495    
2793: Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services 3 $1795

Top of page Top of page

 

CERTIFICATIONS

Use these charts to see how certifications relate.
Click on a certification title within the table or scroll down to view
the associated courses and required exams.

STANDARD PATHS
Based on
Microsoft
Technology

Microsoft Certified Technology Specialist
Microsoft Certified IT Professional
Version 2008
SQL Server 2008 classes at ONLC Training Centers MCTS: SQL Server 2008 Implementation & Maintenance MCITP: Database Administrator 2008
SQL Server 2008 classes at ONLC Training Centers MCTS: SQL Server 2008 Database Development MCITP: Database Developer 2008
SQL Server 2008 classes at ONLC Training Centers MCTS: SQL Server 2008 Business Intelligence Development and Maintenance MCITP: Business Intelligence
Developer 2008

 

UPGRADE PATHS
For this
Microsoft
Technology

If You Have
this Certification

Microsoft Certified IT Professional
Version 2008
MCITP: Database Administrator 2005

MCITP: Database Administrator 2008

MCITP: Database Developer 2005

MCITP: Database Developer 2008

MCITP: Business Intelligence Developer 2005

MCITP: Business Intelligence
Developer 2008

Though you may see some SQL Server 2005 courses on our schedule, please note that Microsoft retired the SQL Server 2005 exams as of June 30, 2011.

 

Version 2008 Certifications

 

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 Implementation and Maintenance
(First series certification)

MCTS: SQL Server 2008 Implementation & Maintenance

To achieve this certification you must pass the designated exam. You can prepare for the exam by attending the courses listed below.

Certification Exam

70-432: TS: Microsoft SQL Server 2008 Implementation and Maintenance

Authorized Courses
(click course title for outline & dates)

6231: Maintaining a Microsoft SQL Server 2008 Database (5 days)
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database. View outline & dates

2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (3 days)
This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008. View outline & dates

6232: Implementing a Microsoft SQL Server 2008 Database (5 days)
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database. View outline & dates

 


Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 Database Development
(First series certification)

MCTS: SQL Server 2008 Database Development

To achieve this certification you must pass the designated exam. You can prepare for the exam by attending the courses listed below.

Certification Exam

70-433: TS: Microsoft SQL Server 2008 Database Development

Authorized Courses
(click course title for outline & dates)

6232: Implementing a Microsoft SQL Server 2008 Database (5 days)
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.View outline & dates

2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (3 days)
This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008. View outline & dates

6231: Maintaining a Microsoft SQL Server 2008 Database (5 days)
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database. View outline & dates


Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 Business Intelligence Development and Maintenance
(First series certification)

MCTS: SQL Server 2008 Business Intelligence Development & Maintenance

To achieve this certification you must pass the designated exam. You can prepare for the exam by attending the courses listed below.

Certification Exam

70-448: TS: Microsoft SQL Server 2008 Business Intelligence Development and Maintenance

Authorized Courses
(click course title for outline & dates)

6234: Implementing and Maintaining Microsoft SQL Server2008 Analysis Services (3 days)
This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course 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. View outline & dates

6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services (3 days)
This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages. View outline & dates

6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services (3 days)
This three-day instructor-led course 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. View outline & dates


Microsoft Certified IT Professional (MCITP): Database Administrator 2008
(Second series certification)

MCITP Database Administrator 2008

To achieve this certification you must first be certified as a MCTS: SQL Server Implementation & Maintenance and then pass the exam listed below. You can prepare for this exam by attending the course shown below.

Certification Exam

70-450: PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using SQL Server 2008

Authorized Courses
(click course title for outline & dates)

50400: Designing, Optimizing & Maintaining Administrative Solutions for SQL Server 2008 (5 days)
This five-day instructor-led course provides the knowledge and skills to design, optimize, and maintain a database administrative solution for Microsoft SQL Server 2008. Students taking this course are expected to have three or more years of experience working on databases for two or more of the following phases in the product lifecycle - design, development, deployment, optimization, maintenance, or support. View outline & dates

 


Microsoft Certified IT Professional (MCITP): Database Developer 2008
(Second series certification)

MCITP Database Developer 2008

To achieve this certification you must first be certified as a MCTS: SQL Server 2008, Database Development and then pass the exam listed below. You can prepare for this exam by attending the course shown below.

Certification Exam

70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

Authorized Courses
(click course title for outline & dates)

50401: Designing and Optimizing Database Solutions with SQL Server 2008 (5 days)
This five-day instructor-led course provides provides the knowledge and skills that IT Professionals need to design, optimize, and maintain SQL Server 2008 database.. View outline & dates


Microsoft Certified IT Professional (MCITP): Business Intelligence Developer 2008
(Second series certification)

MCITP Business Intelligence Developer 2008

To achieve this certification you must first be certified as a MCTS: SQL Server 2008, Business Intelligence Development and Maintenance and then pass the exam listed below. You can prepare for this exam by attending the course shown below.

Certification Exam

70-452: PRO: SQL Server 2008, Business Intelligance Development and Maintenance

Authorized Courses
(click course title for outline & dates)

50402: Designing and Optimizing Database Solutions with SQL Server 2008 (3 days)
This three-day instructor-led course prepares you to design and deploy remote access solutions using Microsoft Forefront Unified Access Gateway 2010 (UAG). Forefront UAG provides organizations with unparalleled flexibility in providing access to network resources (such as Web sites and internal applications) with granular access control, custom content protection, and endpoint validation. Forefront UAG also integrates with DirectAccess, a Windows 7 technology that provides seamless remote access to all corporate resources without connecting to a virtual private network. This course is intended for architects, consultants, network administrators, and technical sales professionals who are responsible for selling, designing, and deploying edge access solutions for enterprises. View outline & dates

 


 

Upgrade from version 2005 to 2008 Certifications

 

Upgrade from Microsoft Certified IT Professional (MCITP) Database Administrator 2005 to Microsoft Certified IT Professional (MCITP): Database Administrator 2008
(Upgrade to Second series certification)

Individuals with Microsoft Certified IT Professional (MCITP) Database Administrator 2005 certification who want to become MCITP: Database Administrator 2008 certified must pass the authorized exam below. You can prepare for the exam by attending the listed course.

MCITP Database Administrator to MCITP Database Administrator 2008

Certification Exam

70-453: UPGRADE: Transition your MCITP Database Administrator Skills to MCITP Database Administrator 2008

Authorized Courses
(click course title for outline & dates)

6158: Updating Your SQL Server 2005 Skills to SQL Server 2008 (3 Days)
This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008. View outline & date

It is possible that additional classroom training will become available to prepare for this exam. Contact our Education Advisors at 1.800.288.8221 to review the latest information.


Upgrade from Microsoft Certified IT Professional (MCITP) Database Developer 2005 to Microsoft Certified IT Professional (MCITP): Database Developer 2008
(Upgrade to Second series certification)

Individuals with Microsoft Certified IT Professional (MCITP) Database Developer 2005 certification who want to become MCITP: Database Administrator 2008 certified must pass the authorized exam below. You can help prepare for the exam by attending the listed course.

MCITP Database Developer to MCITP Database Developer 2008

Certification Exam

70-454: UPGRADE: Transition your MCITP Database Developer Skills to MCITP Database Developer 2008

Authorized Courses
(click course title for outline & dates)

6158: Updating Your SQL Server 2005 Skills to SQL Server 2008 (3 Days)
This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008. View outline & date

It is possible that additional classroom training will become available to prepare for this exam. Contact our Education Advisors at 1.800.288.8221 to review the latest information.

 


Upgrade from Microsoft Certified IT Professional (MCITP) Business Intelligence 2005 to Microsoft Certified IT Professional (MCITP): Busines2008
(Upgrade to Second series certification)

Individuals with Microsoft Certified IT Professional (MCITP) Business Intelligence Developer 2005 certification who want to become MCITP: Business Intelligence Developer 2008 certified must pass the authorized exam below. You can help prepare for the exam by attending the listed course.

MCITP Business Intelligence Developer to MCITP Business Intelligence Developer 2008

Certification Exam

70-454: UPGRADE: Transition your MCITP Database Developer Skills to MCITP Database Developer 2008

Authorized Courses
(click course title for outline & dates)

6158: Updating Your SQL Server 2005 Skills to SQL Server 2008 (3 Days)
This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008. View outline & date

It is possible that additional classroom training will become available to prepare for this exam. Contact our Education Advisors at 1.800.288.8221 to review the latest information.

 

 

Top of page Top of page

 

NEWS & OFFERS


ONLC is a Microsoft Gold Partner for LearningAuthorized Microsoft Classes at ONLC Training Centers
ONLC is a Microsoft Gold Partner for Learning. Microsoft technical and Dynamics classes are authorized, hands-on training that use official Microsoft products and are facilitated by a Microsoft Certified Trainer (MCT).

 

 

Microsoft Software Assurance vouchers accepted hereMicrosoft Software Assurance Vouchers Accepted Here
ONLC gladly accepts Microsoft Software Assurance (SA) Vouchers. These vouchers can be redeemed for any official Microsoft instructor-led training course that was created for the IT professional or developer audience. SA Vouchers can also be used for Microsoft Dynamics CRM courses. Need help with the SA Voucher process? We can also provide 1x1 activation coaching. More.

 

 

Top of page Top of page

 


Questions?
To learn more about ONLC's classes or in the event of questions contact our Education Advisors at:

1.800.288.8221

 

  ONLC TRAINING CENTERS 800-288-8221 (USA) / 302-225-4470 (Other) www.onlc.com  

ONLC Training Centers has grown to be the largest IT training company in the US with over 250 classroom training locations. Click the links below to learn why so many people are selecting us as their training provider.

Our Classes

For Companies RCI™

Course Schedule (all titles)
Ready to Run Schedule (confirmed dates)
Class Registration & Policies

Savings Options & Plans
Microsoft Office Migration
Microsoft Software Assurance Vouchers
RCI Overview
RCI from Destinations
RCI from Home/Office

Why Register with ONLC
For Professionals About ONLC
Fewest Class Cancellations
Training Company Comparison
Reasons to Register Now
Certification Programs
Savings Plans
Money Back Guarantee
About Us
Our Instructors
Employment Opportunities

Other Information
For Government  

Events & Offers
Payment Options
Course Credits

Federal, State, Local & Military
GSA
DoD 8570.1
   


U.S. Locations Click to view listings by state

U.S. Locations by City Click to view listings
  Attend hands on, instructor-led computer classes at our more than 250 classroom locations in these cities...

Canada Locations Click to view listings
  You can attend any ONLC class right from your PC via RCI™ including these areas in Canada...