ONLC Training Centers


1-800-288-8221


Search for


SCHEDULE

All Classes
Ready to Run

Registration Details

CLASS CATEGORY

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

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

Altiris
Client Mgmt Suite, Deployment...

BizTalk Server
Developer, Deep Dive, Immersion...

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

Business Intelligence
Crystal Reports 2011, SQL BI, SharePoint BI...

Cisco
CCNA Bootcamp, Network Devices, Switched Networks, Communications...

Citrix
XenApp, XenServer, XenDesktop, NetScaler, Virtualization...

CompTIA
A+, Network+, Security+ certification...

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

Dynamics CRM, GP
CRM Sales, Marketing, Reporting, Great Plains, GP General Ledger, Payables Receivables...

Exchange Server 2013
2013, Core Solutions, MCSE Messaging...

Exchange Server 2010
2010, Installation, Troubleshooting, Monitoring, High Availability...

Java Programming
Java Programming, Spring, Hibernate, MySQL...

Lync Server
Unified Communications, Core Solutions...

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

Open Source Programming
Programming Java, Perl, Python, Spring, Hibernate, MySQL...

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

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

Security
Forefront, Security+, CEH Ethical Hacking, CISSP, DoD 8570.1...

SharePoint 2013
SharePoint 2013, Core Solutions, MCSE...

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

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

SQL Server 2012
SQL 2012, Querying, Administering, Developing, Implementing, Data Warehouse...

SQL Server 2008 & 2005
SQL 2008 R2, SQL 2005, Quiers, Data Warehouse, Implementation, Reporting Services, Transact-SQL (TSQL)...

System Center
System Center 2012, Operations Manager (SCOM), Configuration Manager (SCCM), Deployment...

Visual Studio 2012
Visual Studio 2012, MCSD, Windows Store Apps, Web Apps, HTML5, C#, ASP.NET, TFS...

Visual Studio, .NET & Programming
Visual Studio 2012 2010 2008, TFS, .NET, C#, VBA, ASP, Silverlight, Azure, XAML, Expression Blend...

VMware
vSphere, Deployment, Administration, Management...

Windows 8
Configuring, Managing, Maintaining, MCSA...

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

Windows Server 2012
Installing, Configuring, Administering, Maintaining, Designing, Server Infrastructure, Desktop...

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

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

GENERAL INFO
Registration
Locations/Directions
SA Vouchers
Savings Options
Invoice/Receipt
CEU, CPE, PDU 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 2008 and 2005 classes & certification at ONLC Training Centers


Microsoft SQL Server Training Classes & Certification

SQL Server 2008 and SQL Server 2005 authorized computer training classes are at ONLC Training Centers—a Microsoft Gold Learning Partner. 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.

(Microsoft has released SQL Server 2012. For those classes see SQL Server 2012.)

Attend hands-on, instructor-led training classes at ONLC's more than 300 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 $1595
6158: Updating Your SQL Server 2005 Skills to SQL Server 2008 3 $1595    
6231: Maintaining a Microsoft SQL Server 2008 R2 Database 5 $2995
6232: Implementing a Microsoft SQL Server 2008 R2 Database 5 $2995
6234: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services 3 $1595
6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services 3 $1595
6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services 3 $1595
6317: Upgrading Your SQL Server 2000 Database Administration (DBA) Skills to Microsoft SQL Server 2008 DBA Skills 3 $1595    
10337: Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2 3 $1595
50400: Designing, Optimizing, and Maintaining a Database Administrative Solution for Microsoft SQL Server 2008 5 $2995    
50402: Implementing Forefront Unified Access Gateway 2010 3 $1795
SQL Server 2005
2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL 3 $1595
SQL Analysis, Integration & Reporting Services
SQL Azure
50592: Advanced SQL Azure 4 $2195

SQL Server 2012
ONLC also offers authorized training for Microsoft SQL Server 2012. See SQL Server 2012 classes & certification.

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.

Version 2008

 

SQL SERVER 2008 (new to certification)
For this
Microsoft
Technology
Version

Microsoft Certified Technology Specialist
Microsoft Certified Solutions Expert
Version 2008
Based on
Microsoft
Technology

Microsoft Certified Technology Specialist
Microsoft Certified IT Professional
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

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 and the upgrade exams from version 2005 to 2008 as of July 31, 2012.

 

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 Intelligence Development and Maintenance

Authorized Courses
(click course title for outline & dates)

50399: Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008 (5 days)
This five-day instructor-led course provides in-depth knowledge on designing a Business Intelligence solution by using Microsoft SQL Server 2008. View outline & dates

 

Top of page Top of page

 

NEWS & OFFERS


SQL Server 2012
Microsoft has released SQL Server 2012 (previously code named Denali) and with it new certification credentials of MCSA and MCSE. ONLC offers the Microsoft authorized classes for you to learn this technology and if desired, help prepare you for the certification exams. See SQL Server 2012 classes & certification details.

SQL Server 2008 & 2005 Exams
Microsoft certification exams for SQL Server 2005 were retired on June 30, 2011. The upgrade exams from version 2005 to version 2008 were retired as of July 31, 2012. Students pursuing a SQL Server 2008 certification will be able to earn a MCITP or MCTS for SQL Server 2008 until July 2013.

 

ONLC Training Centers is a Microsoft Gold Learning PartnerAuthorized Microsoft Classes at ONLC Training Centers
ONLC is a Microsoft Gold Learning Partner. Microsoft technical and Dynamics classes on our schedule 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? ONLC can help. 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 300 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)
Payment & 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 Early
Certification Programs
Savings Plans
Money Back Guarantee
About Us
Employment Opportunities
Partnering Opportunities

Other Class Info
For Government Other Information

Our Training Sites
Our Instructors
Class Credits (CEU/CPE/PDU)

Federal, State, Local & Military
GSA
DoD 8570.1
Certification Exams
Computer Classroom Rentals
Contact Us
 


U.S. Locations Click to view listings by state
  Over 300 sites across North America...

U.S. Locations by City Click to view listings
  Attend hands on, instructor-led computer classes at our more than 300 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...