ASP.NET, VB.NET, and C# Training Classes     
Accelebrate delivers SharePoint , ASP.NET, SQL Server, Java, and other training courses in the USAAccelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Canada     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the UK     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Ireland     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the Netherlands     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses internationally  
1 877 849 1850   0808 234 2132   1 800 550 311   0 800 022 6730   +1 678 648 3113  
Microsoft and .NET TrainingSQL Server TrainingSharePoint TrainingJava TrainingAdobe TrainingDatabase and Reporting TrainingXML, JavaScript, and Other TrainingWeb/Application Server Training
HomeAboutContact Us 


Please contact us
for GSA pricing.

GSA - Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses
Contract #
GS-35F-0307T



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Edmonton & Calgary, Alberta
  • Phoenix, Arizona
  • Tucson, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Amsterdam, The Netherlands / Brussels, Belgium
  • Vancouver, British Columbia
  • Oakland / San Jose / San Francisco, California
  • Sacramento, California
  • San Diego, California
  • Orange County / Los Angeles, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida 
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Boise, Idaho
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Wichita, Kansas
  • Lexington / Louisville, Kentucky
  • Baton Rouge/New Orleans, Louisiana
  • Portland, Maine
  • Hagerstown & Frederick, Maryland
  • Annapolis / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Ann Arbor / Detroit, Michigan
  • Grand Rapids, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • St. Louis, Missouri
  • Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Fredericton / Moncton / Saint John, New Brunswick
  • Albuquerque, New Mexico
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • Albany, New York
  • Buffalo, New York
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • San Juan, Puerto Rico
  • Providence, Rhode Island
  • Saskatoon / Regina, Saskatchewan
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Spartanburg & Greenville, South Carolina
  • Knoxville, Tennessee
  • Memphis / Nashville, Tennessee
  • Houston, Texas
  • El Paso, Texas
  • San Antonio / Austin, Texas
  • Dallas, Texas
  • Salt Lake City, Utah
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Charleston, West Virginia
  • Madison / Milwaukee, Wisconsin

 

SQL Server 2005 training: Advanced Topics in SQL Server 2005 Administration and Development

Print This Outline
E-mail This Outline
Get A Quote
Course Number: SQL-114
Duration: 3 days
view class outline

Advanced SQL Server 2005 Training Overview

In this three-day course, attendees examine additional SQL Server 2005 topics such as disaster recovery, failover clustering, database mirroring, log shipping, replication, and partitioning.

Important Note: Individual units from this course can be included in other SQL Server 2005 courses we teach, if desired. Please let us know the details of your needs when you contact us.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=category&page=mssql.

Advanced SQL Server 2005 Training Prerequisites

No prior experience is presumed.

Hands-on/Lecture Ratio

This class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes.

Advanced SQL Server 2005 Training Materials

All students will receive:

  • More than 600 pages of fully-illustrated courseware
  • A copy of Apress' Pro SQL Server 2005

Software Needed on Each Student PC

  • Windows Server 2003 or Windows Server 2008
  • SQL Server 2005 full install with latest service packs applied
  • At least 2GB RAM (3GB recommended)
  • Sample databases and related tools - please contact us for a detailed setup sheet

Important Note: If you have purchased this class, please contact us for detailed setup instructions.

Advanced SQL Server 2005 Training Objectives

All attendees will learn to:

  • Implement a backup and disaster recovery strategy
  • Set up SQL Server 2005 clusters
  • Implement database mirroring
  • Configure log shipping
  • Set up SQL Server 2005 replication
  • Build and tune advanced queries, including queries that use XML

Advanced SQL Server 2005 Training Outline

  • Disaster Recovery
    • Planning a Backup Strategy
    • Backing Up Databases
    • Scheduling Your Backups
    • Verifying Backup Media
    • Restoring Databases
    • Using Database Snapshots
  • Failover Clustering
    • High Availability Overview
    • SQL Server 2005 Failover Cluster
    • Preparing a Server Cluster
    • Creating a New Cluster
    • Installing SQL Server 2005 Failover
    • Adding Additional SQL Server Nodes
  • Database Mirroring
    • Understanding Mirroring
    • Setting Up Database Mirroring
    • Monitoring Database Mirroring
  • Log Shipping
    • Overview
    • Configuring Log Shipping
    • Monitoring Log Shipping Jobs
    • Using Transact-SQL
  • Peer-to-Peer Replication
    • Overview
    • Configuring the Distributor
    • Creating the Publisher
    • Configuring Peer-to-Peer Subscribers
    • Configuring Peer-to-Peer Topology
  • Monitoring & Troubleshooting
    • Diagnosing and Resolving Database Server Errors
    • Set Up Alerts Using SQL Server Agent
    • Monitoring SQL Server Agent Job History
    • Gathering Performance Data and Optimization using DMV
  • Implementing Service Brokers
    • Understanding Service Brokers
    • Designing Service Broker Applications
    • Programming Service Broker Applications
  • Implementing SQL Server Partitions
    • Overview of Table-based Partitioning
    • Creating Partitioned Tables
    • Querying Partitions
    • Managing Partitions
  • Complex Querying
    • Working with NULL Values
    • Ranking Grouped Data
    • Writing Correlated Subqueries
    • Using Common Table Expressions
  • Advanced Techniques
    • Complex Data and Structures
    • Writing More Efficient Queries
    • Working with Complex Queries
    • Maintaining Query Files
  • Working with XML
    • The XML Data Type
    • XML Schema Collections
    • Querying XML
    • Best Practices
  • Conclusion
 

Print This OutlineE-mail This OutlineGet A Quote


Java® and all Java-based marks are registered trademarks of the Oracle Corporation in the U.S. and other countries.

 
Request Information for Group Training at Your Site   Request Information for Group Training at Your Site
 
Accelebrate®
Focuses on You!


Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.

For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.

 
The class and the instructor were very good. I would recommend this
course to anyone who wants to learn more about SQL.
 
—Shaun Gibbs
Kaplan
Alpharetta, Georgia

VB.NET, C#, ASP, & ASP.NET Training Java Training SQL Server Training
SharePoint Training  Adobe Training PHP Training XML Training Perl Training Sitemap

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | Albany, NY | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK