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.
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.
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)
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
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)
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
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)
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
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)
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)
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)
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.
Authorized 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 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.
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.
•U.S. Locations
Over 300 sites across North America...
Alabama
Birmingham, AL
Huntsville, AL
Mobile, AL
Montgomery, AL
Arizona
Phoenix, AZ
Scottsdale, AZ
Tucson, AZ
Arkansas
Bentonville, AR
Little Rock, AR
California
Bakersfield, CA
El Segundo, CA
Fresno, CA
Glendale / Burbank, CA
Irvine, CA
Los Angeles, CA
Manhattan Beach, CA
Orange, CA
Petaluma, CA
Pleasanton, CA
Redwood City, CA
Riverside, CA
Sacramento, CA
San Diego, CA
San Francisco, CA
San Jose, CA
Walnut Creek, CA
Woodland Hills, CA
Colorado
Boulder, CO
Centennial, CO
Colorado Springs, CO
Denver, CO
Grand Junction, CO
Loveland, CO
Massachusetts
Andover, MA
Boston, MA
Braintree, MA
Danvers, MA
Mansfield, MA
Norwell, MA
Springfield, MA
Taunton, MA
Waltham, MA
Westborough, MA
Woburn, MA
Worcester, MA
Michigan
Ann Arbor, MI
Detroit, MI
Grand Rapids, MI
Kalamazoo / Portage, MI
Lansing, MI
Novi, MI
Traverse City, MI
Troy, MI
New Jersey
Bridgewater, NJ
Iselin, NJ
Jersey City, NJ
Morristown, NJ
Mt. Laurel, NJ
Paramus, NJ
Princeton, NJ
Red Bank, NJ
New Mexico
Albuquerque, NM
New York
Albany, NY
Bohemia, NY
Buffalo, NY
Harrison / Rye, NY
Henrietta, NY
Manhattan, NY
Mt. Kisco, NY
New York City, NY
Poughkeepsie, NY
Rochester, NY
Syracuse, NY
Uniondale, NY
Oregon
Beaverton, OR
Bend, OR
Eugene, OR
Medford, OR
Portland, OR
Roseburg, OR
Salem, OR
Tualatin, OR
Pennsylvania
Allentown, PA
Erie, PA
Exton, PA
Harrisburg, PA
Lancaster, PA
Malvern, PA
Mechanicsburg, PA
Monroeville, PA
Morgantown, PA
Philadelphia, PA
Pittsburgh, PA
State College, PA
Wayne, PA
Wexford, PA
Wilkes-Barre, PA
York, PA
Rhode Island
Warwick / Providence, RI
South Carolina
Columbia, SC
Greenville, SC
Mt. Pleasant / Charleston, SC
South Dakota
Sioux Falls, SD
Tennessee
Chattanooga, TN
Franklin, TN
Johnson City, TN
Knoxville, TN
Memphis, TN
Nashville, TN
Texas
Amarillo, TX
Austin, TX
Bryan / College Station, TX
Corpus Christi, TX
Dallas, TX
El Paso, TX
Fort Worth, TX
Grapevine, TX
Houston, TX
Irving / Las Colinas, TX
Katy, TX
Keller, TX
League City, TX
Midland, TX
Plano / Frisco, TX
Round Rock, TX
San Antonio, TX
Spring / The Woodlands, TX
Sugar Land, TX
Trophy Club, TX
Waco, TX
Wichita Falls, TX
Utah
Provo, UT
Salt Lake City, UT
Vermont
Burlington/Shelburne, VT
Virginia
Alexandria, VA
Arlington, VA
Charlottesville, VA
Fairfax, VA
Fredericksburg, VA
Glen Allen, VA
Lynchburg, VA
Manassas, VA
McLean, VA
Newport News, VA
Norfolk, VA
Reston, VA
Richmond, VA
Roanoke, VA
Virginia Beach, VA
Washington
Bellevue, WA
Bellingham, WA
Bothell / Redmond, WA
Kennewick / Pasco, WA
Mukilteo / Everett, WA
Olympia / Lacey, WA
Puyallup, WA
Seattle, WA
Tacoma / Federal Way, WA
Spokane, WA
West Virginia
Martinsburg, WV
Wisconsin
Brookfield, WI
Glendale, WI
Green Bay, WI
Madison, WI
Milwaukee, WI
Wyoming
Casper, WY
Cheyenne, WY
•U.S. Locations by City
Attend hands on, instructor-led computer classes at our more than 300 classroom locations in these cities...
Akron, OH
Albany, NY
Albuquerque, NM
Alexandria, VA
Allentown, PA
Alpharetta, GA
Amarillo, TX
Andover, MA
Ann Arbor, MI
Annapolis, MD
Arlington, VA
Atlanta, GA
Austin, TX
Bakersfield, CA
Baltimore, MD
Baton Rouge, LA
Beachwood, OH
Beaverton, OR
Bend, OR
Bedford, NH
Bellevue, WA
Bellingham, WA
Bentonville, AR
Bethesda, MD
Bettendorf, IA
Birmingham, AL
Bloomington, MN
Boca Raton, FL
Bohemia, NY
Boise, ID
Boston, MA
Boulder, CO
Bradenton / Sarasota, FL
Braintree, MA
Bridgewater, NJ
Brookfield, WI
Bryan / College Station, TX
Buckhead, GA
Buffalo, NY
Canton, OH
Carson City, NV
Casper, WY
Cedar Rapids, IA
Champlin, MN
Charlotte, NC
Chattanooga, TN
Centennial, CO
Cheyenne, WY
Chicago, IL
Cincinnati, OH
Cleveland, OH
Columbia, MD
Columbia, MO
Columbia, SC
Columbus, GA
Columbus, OH
Corpus Christi, TX
Dallas, TX
Danbury, CT
Danvers, MA
Dayton, OH
Des Moines, IA
District of Columbia
Dublin, OH
Duluth, GA
East Granby, CT
Edina, MN
El Paso, TX
El Segundo, CA
Elk Grove, CA
Erie, PA
Erlanger, KY
Eugene, OR
Evansville, IN
Exton, PA
Fairfax, VA
Fayetteville, NC
Fort Worth, TX
Fort Lauderdale, FL
Fort Myers, FL
Fort Wayne, IN
Franklin, TN
Frederick, MD
Fredericksburg, VA
Fresno, CA
Frisco, TX
Glendale, CA
Glendale, WI
Grand Junction, CO
Grand Forks, ND
Grand Rapids, MI
Grapevine, TX
Great Falls, MT
Green Bay, WI
Greenbelt, MD
Greensboro, NC
Greenville, SC
Gurnee, IL
Harrisburg, PA
Harrison, NY
Hartford, CT
Henderson, NV
Henrietta, NY
Hickory, NC
Houston, TX
Huntsville, AL
Independence, OH
Indianapolis, IN
Irvine, CA
Irving / Las Colinas, TX
Iselin, NJ
Jackson, MS
Jacksonville, FL
Jersey City, NJ
Johnson City, TN
Joliet, IL
Kalamazoo / Portage, MI
Kansas City, MO
Katy, TX
Keller, TX
Kennesaw, GA
Kennewick, WA
Kissimmee, FL
Knoxville, TN
Lafayette, LA
Lancaster, PA
Land O' Lakes, FL
Las Vegas, NV
League City, TX
Lee's Summit, MO
Lenexa, KS
Lexington, KY
Lincoln, NE
Little Rock, AR
Londonderry, NH
Los Angeles, CA
Louisville, KY
Loveland, CO
Lynchburg, VA
Macon, GA
Madison, WI
Manchester, NH
Mandeville, LA
Manhattan, NY
Manhattan Beach, CA
Mansfield, MA
Martinez, GA
Martinsburg, WV
McLean, VA
Medford, OR
Memphis, TN
Miami, FL
Midland, TX
Milford, CT
Milwaukee, WI
Minneapolis, MN
Miramar Beach, FL
Mobile, AL
Montgomery, AL
Monroeville, PA
Morristown, NJ
Morrisville, NC
Mount Laurel, NJ
Mount Pleasant, SC
Mukilteo, WA
Naperville, IL
Naples, FL
Nashua, NH
Nashville, TN
New Orleans, LA
New York City, NY
Newington, CT
Newport News, VA
Norfolk, VA
Norwell, MA
Novi, MI
Oakbrook Terrace, IL
Oklahoma City, OK
Olympia / Lacey, WA
Omaha, NE
Orange, CA
Orange Park, FL
Orlando, FL
Overland Park, KS
Owings Mills, MD
Palm Beach, FL
Paramus, NJ
Petaluma, CA
Peoria, IL
Philadelphia, PA
Phoenix, AZ
Pittsburgh, PA
Plano, TX
Plantation, FL
Pleasanton, CA
Portland, ME
Portland, OR
Poughkeepsie, NY
Princeton, NJ
Provo, UT
Puyallup, WA
Quad Cities, IA IL
Raleigh, NC
Red Bank, NJ
Redmond, WA
Redwood City, CA
Reno, NV
Reston, VA
Richmond, VA
Riverside, CA
Roanoke, VA
Rochester, NH
Rochester, MN
Rochester, NY
Rockford, IL
Rockville, MD
Rolling Hills, CA
Roseburg, OR
Round Rock, TX
Rye, NY
Sacramento, CA
Salem, OR
Salt Lake City, UT
San Antonio, TX
San Diego, CA
San Francisco, CA
San Jose, CA
Sarasota / Bradenton, FL
Savannah, GA
Schaumburg, IL
Scottsdale, AZ
Seattle, WA
Shelburne, VT
Shelton, CT
Sioux Falls, SD
South Bend, IN
South Burlington, VT
St. Louis, MO
St. Paul, MN
St. Petersburg, FL
Spokane, WA
Spring / The Woodlands, TX
Springfield, MA
Springfield, MO
Stamford, CT
State College, PA
Sugar Land, TX
Syracuse, NY
Tacoma / Federal Way, WA
Tallahassee, FL
Tampa, FL
Taunton, MA
Toledo, OH
Traverse City, MI
Troy, MI
Tualatin, OR
Tucson, AZ
Tulsa, OK
Uniondale, NY
Virginia Beach, VA
Wallingford, CT
Walnut Creek, CA
Waltham, MA
Warrenville, IL
Warwick / Providence, RI
Washington, DC
Waterbury / Cheshire, CT
Wayne, PA
West Chester, OH
Westborough, MA
Wexford, PA
Wichita, KS
Wichita Falls, TX
Wilkes-Barre, PA
Williston, ND
Wilmington, DE
Wilmington, NC
Woburn, MA
Woodland Hill, CA
Worcester, MA
Youngstown, OH
•Canada Locations
You can attend any ONLC class right from your PC via RCI™ including these areas in Canada...
Alberta
Calgary, AB
Edmonton, AB
Grande Prairie, AB
Lethbridge, AB
Lloydminster, AB
Medicine Hat, AB
Red Deer, AB
Wood Buffalo, AB
British Columbia
Abbotsford, BC
Burnaby, BC
Campbell River, BC
Chilliwack, BC
Clayoquot, BC
Coldstream, BC
Comox, BC
Courtenay, BC
Cranbrook, BC
Duncan, BC
East Kootenay, BC
Fort St. John, BC
Kamloops, BC
Kelowna, BC
Maple Ridge, BC
Nanaimo, BC
New Westminster
North Cowichan, BC
Okanagan, BC
Parksville, BC
Peace River, BC
Penticton, BC
Port Alberni, BC
Port Coquitlam
Prince George, BC
Qualicum Beach, BC
Richmond, BC
Saanich, BC
Strathcona, BC
Surrey, BC
Vancouver, BC
Vernon, BC
Victoria, BC
Manitoba
Brandon, MB
Winnipeg, MB
New Brunswick
Bathurst, NB
Beresford, NB
Dieppe, NB
Fredericton, NB
Miramichi, NB
Moncton, NB
North Esk, NB
Quispamsis, NB
Riverview, NB
Saint John, NB
Newfoundland & Labrador
Conception Bay, NL
Corner Brook, NL
Mount Pearl, NL
St. John's, NL
Ontario
Augusta, ON
Barrie, ON
Belleville, ON
Brampton, ON
Brant, ON
Brantford, ON
Brockville, ON
Burlington, ON
Cambridge, ON
Centre, ON
Chatham, ON
Clarington, ON
Cornwall, ON
Elizabethtown, ON
Ennismore, ON
Frontenac, ON
Georgian Bluffs, ON
Guelph, ON
Hamilton, ON
Innisfil, ON
Kawartha Lakes, ON
Kent, ON
Kingston, ON
Kingsville, ON
Kitchener, ON
Kitley, ON
Lakefield, ON
Lakeshore, ON
LaSalle, ON
Leamington, ON
London, ON
Laurentian Valley, ON
Midland, ON
Mississauga, ON
Niagara, ON
Niagara Falls, ON
Norfolk, ON
North Bay, ON
Orillia, ON
Oshawa, ON
Ottawa, ON
Owen Sound, ON
Pembroke, ON
Penetanguishene, ON
Peterborough, ON
Quinte, ON
Ramara, ON
Sarnia, ON
St. Catharines, ON
St. Clair, ON
Sault Ste. Marie, ON
Smith, ON
South Stormont, ON
Stratford, ON
Sudbury, ON
Tay, ON
Tecumseh, ON
Thunder Bay, ON
Timmins, ON
Toronto, ON
Vaughan, ON
Waterloo, ON
Welland, ON
Wellington, ON
Whitby, ON
Windsor, ON
Woodstock, ON
Prince Edward Island
Charlottetown, PE
Stratford, PE