Home sep Onsite Computer Training

Onsite Microsoft SQL Server 2005 Training Classes

onsite computer training

CBT Planet's onsite Microsoft SQL 2005 training is a cost-effective alternative to traditional IT training classes if you have at least six employees enrolled.

We'll send a certified instructor to hold the Microsoft SQL Server 2005 class at your facility. Instead of paying individual tuition and travel costs, fly in a CBT Planet instructor who will conduct the onsite SQL 2005 training right at your location.

Not only will your team members learn from a highly-qualified instructor, they will get real, hands-on experience. They'll learn SQL concepts and be able to start using them immediately after attending the Microsoft SQL Server 2005 course. Having the course onsite means less disruption for your organization.

In addition, we can schedule the Microsoft SQL 2005 class to accommodate your team's needs. Your employees will be close by and will enjoy the convenience - and results - that the onsite SQL 2005 training provides.

Common Questions:
   
Maximum number of student allowed: 15
Number of hours: 8 hours per level. We start from 9 am to 5 pm.
Books Included: Yes. Each student will receive their own course manual.
Online Training Included: Optional. Receive 50% off the list price when bundled.
Computers Included: No - Customer must provide computers and software.
Instructor Background: Minimum 6 years experience in the field.
Price: Call 1-866-718-7246
 
Microsoft SQL Server 2005 Outline:
 

MCTS 70-431: Implementing and Maintaining SQL Server 2005 - 5 days

Table Of Contents:
Unit 1: SQL Server 2005 installation
Topic A: SQL Server features
Topic B: SQL Server installation
Topic C: Alternative installations

Unit 2: SQL Server management tools
Topic A: SQL Server 2005 services
Topic B: Management tools
Topic C: SQL Server settings
Topic D: Database Mail

Unit 3: Database management
Topic A: SQL Server data storage
Topic B: Database management
Topic C: Capacity planning and management

Unit 4: Data design
Topic A: The data design process
Topic B: Table and data design
Topic C: Data normalization
Topic D: Data types

Unit 5: Tables, constraints, and indexes
Topic A: Objects
Topic B: Tables and constraints
Topic C: Indexes

Unit 6: Data retrieval
Topic A: Queries
Topic B: Transact-SQL functions
Topic C: Data organization
Topic D: Multiple table queries
Topic E: Data modification
Topic F: Query Designer

Unit 7: Programmable objects
Topic A: Programming fundamentals
Topic B: User views
Topic C: Stored procedures
Topic D: User-defined functions

Unit 8: Data management
Topic A: Multiple language support
Topic B: Full-text search
Topic C: Partitions
Topic D: Error handling
Topic E: Transactions and locking
Topic F: Triggers

Unit 9: XML support
Topic A: XML fundamentals
Topic B: The XML data type
Topic C: XML methods and indexes
Topic D: XML and relational data integration

Unit 10: Data transfers
Topic A: Bulk transfers
Topic B: SQL Server 2005 Integration Services
Topic C: XML import and export

Unit 11: SQL Server security
Topic A: Principles
Topic B: Server securables
Topic C: Database and schema securables
Topic D: SQL auditing
Topic E: Encryption
Topic F: CLR security

Unit 12: Management and maintenance
Topic A: SQL Server Agent
Topic B: Distributed queries
Topic C: Replication

Unit 13: SQL Server optimization
Topic A: Monitoring and optimization
Topic B: Database optimization
Topic C: Database tune-ups
Topic D: Query optimization concepts

Unit 14: Reliability and availability
Topic A: Database backup
Topic B: Database restore
Topic C: Log shipping
Topic D: Database snapshots
Topic E: Mirrored databases

Unit 15: Applications
Topic A: Service Broker
Topic B: HTTP endpoints

Unit 16: Troubleshooting and repair
Topic A: Blocks and deadlocks
Topic B: SQL Server errors
Topic C: Recovery
 

If your city is not listed, please contact us and we can try to accomodate your onsite corporate training needs.

  • Abilene, TX
  • Albany, NY
  • Albany, GA
  • Albuquerque, NM
  • Alexandria, LA
  • Allentown, PA
  • Altoona, PA
  • Amarillo, TX
  • Anchorage, AK
  • Anniston, AL
  • Appleton, WI
  • Asheville, NC
  • Athens, GA
  • Atlanta, GA
  • Atlantic City, NJ
  • Auburn, AL
  • Augusta, GA
  • Austin, TX
  • Bakersfield, CA
  • Baltimore, MD
  • Bangor, ME
  • Barnstable, MA
  • Baton Rouge, LA
  • Beaumont, TX
  • Bellingham, WA
  • Benton Harbor, MI
  • Billings, MT
  • Biloxi, MS
  • Binghamton, NY
  • Birmingham, AL
  • Bismarck, ND
  • Bloomington, IL
  • Bloomington, IN
  • Boise, RI
  • Boise City, ID
  • Boston, MA
  • Brownsville, TX
  • Bryan, TX
  • Buffalo, NY
  • Burlington, VT
  • Canton, OH
  • Casper, WY
  • Cedar Rapids, IA
  • Champaign, IL
  • Charleston, SC
  • Charlotte, NC
  • Charlottesville, VA
  • Chattanooga, TN
  • Cheyenne, WY
  • Chicago, IL
  • Chico, CA
  • Cincinnati, OH
  • Clarksville, TN
  • Clayton, NC
  • Cleveland, OH
  • Colorado Springs, CO
  • Columbia, MO
  • Columbia, SC
  • Columbus, GA
  • Columbus, OH
  • Corpus Christi, TX
  • Corvallis, OR
  • Cumberland, MD
  • Dallas, TX
  • Danville, VA
  • Davenport, IA
  • Dayton, OH
  • Daytona Beach, FL
  • Decatur, AL
  • Decatur, IL
  • Denver, CO
  • Des Moines, IA
  • Detroit, MI
  • Dothan, AL
  • Dover, DE
  • Dubuque, IA
  • Duluth, MN
  • Eau Claire, WI
  • El Paso, TX
  • Elkhart, IN
  • Elmira, NY
  • El Paso, TX
  • Enid, OK
  • Erie, PA
  • Eugene, OR
  • Evansville, IN
  • Fairbanks, AK
  • Fargo, ND
  • Fayetteville, AR
  • Fayetteville, NC
  • Flagstaff, AZ
  • Florence, AL
  • Florence, SC
  • Fort Collins, CO
  • Fort Myers, FL
  • Fort Pierce, FL
  • Fort Smith, AR
  • Fort Walton Beach, FL
  • Fort Wayne, IN
  • Fresno, CA
  • Gadsden, AL
  • Gainesville, FL
  • Galveston, TX
  • Glens Falls, NY
  • Goldsboro, NC
  • Grand Forks, ND
  • Grand Junction, CO
  • Grand Rapids, MI
  • Great Falls, MT
  • Green Bay, WI
  • Greensboro, NC
  • Greenville, NC
  • Greenville, SC
  • Harrisburg, PA
  • Hartford, CT
  • Hattiesburg, MS
  • Hickory, NC
  • Honolulu, HI
  • Houma, LA
  • Houston, TX
  • Huntington, WV
  • Huntsville, AL
  • Indianapolis, IN
  • Iowa City, IA
  • Jackson, MI
  • Jackson, MS
  • Jackson, TN
  • Jacksonville, FL
  • Jamestown, NY
  • Janesville, WI
  • Johnson City, TN
  • Johnstown, PA
  • Jonesboro, AR
  • Joplin, MO
  • Kalamazoo, MI
  • Kansas City, MO
  • Key West, FL
  • Killeen, TX
  • Knoxville, TN
  • Kokomo, IN
  • La Crosse, WI
  • Lafayette, IN
  • Lafayette, LA
  • Lake Charles, LA
  • Lakeland, FL
  • Lancaster, PA
  • Lansing, MI
  • Laredo, TX
  • Las Cruces, NM
  • Las Vegas, NV
  • Lawrence, KS
  • Lawton, OK
  • Lewiston, ME
  • Lexington, KY
  • Lima, OH
  • Lincoln, NE
  • Little Rock, AR
  • Longview, TX
  • Los Angeles, CA
  • Louisville, KY
  • Lubbock, TX
  • Lynchburg, VA
  • Macon, GA
  • Madison, WI
  • Mansfield, OH
  • McAllen, TX
  • Medford, OR
  • Melbourne, FL
  • Memphis, TN
  • Merced, CA
  • Miami, FL
  • Milwaukee, WI
  • Minneapolis, MN
  • Missoula, MT
  • Mobile, AL
  • Modesto, CA
  • Monroe, LA
  • Montgomery, AL
  • Muncie, IN
  • Myrtle Beach, SC
  • Naples, FL
  • Nashville, TN
  • New London, CT
  • New Orleans, LA
  • New York, NY
  • Newark, NJ
  • Norfolk, VA
  • Ocala, FL
  • Odessa, TX
  • Oklahoma City, OK
  • Olympia, WA
  • Omaha, NE
  • Orlando, FL
  • Owensboro, KY
  • Panama City, FL
  • Parkersburg, WV
  • Pensacola, FL
  • Peoria, IL
  • Philadelphia, PA
  • Phoenix, AZ
  • Pine Bluff, AR
  • Pittsburgh, PA
  • Pittsfield, MA
  • Pocatello, ID
  • Portland, ME
  • Providence, RI
  • Provo, UT
  • Pueblo, CO
  • Punta Gorda, FL
  • Raleigh, NC
  • Rapid City, SD
  • Reading, PA
  • Redding, CA
  • Reno, NV
  • Richland, WA
  • Richmond, VA
  • Roanoke, VA
  • Rochester, MN
  • Rockford, IL
  • Rocky Mount, NC
  • Roswell, NM
  • Sacramento, CA
  • Saginaw, MI
  • Salem, OR
  • Salinas, CA
  • Salt Lake City, UT
  • San Angelo, TX
  • San Antonio, TX
  • San Diego, CA
  • San Francisco, CA
  • San Luis Obispo, CA
  • Santa Barbara, CA
  • Santa Fe, NM
  • Sarasota, FL
  • Savannah, GA
  • Scranton, PA
  • Seattle, WA
  • Sharon, PA
  • Sheboygan, WI
  • Sherman, TX
  • Shreveport, LA
  • Sioux City, IA
  • Sioux Falls, SD
  • South Bend, IN
  • Spokane, WA
  • Springfield, IL
  • St. Cloud, MN
  • St. Joseph, MO
  • St. Louis, MO
  • State College, PA
  • Steubenville, OH
  • Stockton, CA
  • Sumter, SC
  • Syracuse, NY
  • Tallahassee, FL
  • Tampa, FL
  • Terre Haute, IN
  • Texarkana, TX
  • Toledo, OH
  • Topeka, KS
  • Tucson, AZ
  • Tulsa, OK
  • Tuscaloosa, AL
  • Tyler, TX
  • Utica, NY
  • Vero Beach, FL
  • Victoria, TX
  • Visalia, CA
  • Waco, TX
  • Washington, DC
  • Waterloo, IA
  • Wausau, WI
  • West Palm Beach, FL
  • Wheeling, WV
  • Wichita, KS
  • Wichita Falls, TX
  • Williamsport, PA
  • Wilmington, NC
  • Yakima, WA
  • York, PA
  • Youngstown, OH
  • Yuba City, CA
  • Yuma, AZ

We have put together a comprehensive MCTS: SQL Server 2005 onsite training program that has proven to be popular with business owners, large corporations, and individual students alike. Not only does this course thorough prepare learners for passing the exam 70-431 and earning their MCTS: SQL Server 2005 credential, it also does so in one of the most convenient ways possible.

For example, what's more convenient than going to work as normal and attending onsite SQL Server 2005 training classes? Your employees will love this option! After all, catching airplanes, staying in hotels, and missing work and family in order to prepare for certification exams takes its toll on IT professionals who must engage in continuing education courses throughout their careers. By holding the classes at your work site, employees get the benefits of training without the hassles.

In addition, our MCTS: SQL Server 2005 onsite class provides you with significant cost advantages. With a single flat fee, you pay the same price regardless of how many students participate. In fact, the more students enrolled, the more you save. Why pay person when you can play one flat fee? Plus, travel-related expenses, which can quickly add up and take a big bite out of your training budget, are completely eliminated.   

Convenience and cost advantages make the MCTS: SQL Server 2005 onsite training attractive to students and management; however, the most important factor involves the quality of the training and we hold quality in high regard. That's why we hire only the best certified instructors in the industry and present a solid, focused curriculum. These onsite SQL Server 2005 training classes cover all skills that the exam measures as well as explores how SQL Server is used in the “real” world. Our instructors work with SQL Server 2005, not just talk about it. This distinction ensures that your team is learning from someone who is intimately involved in the technology and who will understand the questions that your employees have.

Onsite training is one of the best training investments you can make, offering numerous advantages over traditional training options.