 |
SQL Server Training: Introduction to Microsoft SQL Server 2000 Administration
SQL Server Training: Introduction to Microsoft SQL Server 2005 Administration
SQL Server 2005: Advanced Topics
SQL Server 2005 Reporting Services Training: Introduction to SQL Server 2005 Reporting Services
SQL Server 2005 Analysis Services Training: Introduction to SQL Server 2005 Analysis Services
SQL Server 2005 Integration Services Training: Introduction to SQL Server 2005 Integration Services
Transact-SQL Training: Introduction to T-SQL for SQL Server for Report Writing
T-SQL Training: T-SQL for SQL Server 2005 for Developers
Live Online Training
Please contact us
for GSA pricing.
Contract #
GS-35F-0307T

Complimentary SQL Server Training Seminar
Organizations in the Atlanta, Georgia area are encouraged
to contact Accelebrate® about having a complimentary, one-hour SQL Server seminar delivered for their developers. Contact
us today for more information.

Recent Training Venues
Accelebrate has recently trained for clients in the following cities:
- Huntsville, Alabama
- Montgomery / Birmingham, Alabama
- Anchorage, Alaska
- Calgary, Alberta
- Phoenix, Arizona
- Fayetteville / Little Rock, Arkansas
- Oakland / San Jose / San Francisco, California
- Oceanside / San Diego, California
- Pasadena / Orange County / Los Angeles, California
- San Bernardino / Riverside, California
- Boulder / Colorado Springs / Denver, Colorado
- Washington, DC
- Wilmington, Delaware
- Manchester / London, England
- DeLand / Orlando, Florida
- Fort Lauderdale / Miami, Florida
- Gainesville / Jacksonville, Florida
- Saint Petersburg / Tampa, Florida
- Titusville & Melbourne, Florida
- Alpharetta & Atlanta, Georgia
- Augusta & Savannah, Georgia
- Macon & Columbus, Georgia
- Bloomington, Illinois
- Chicago, Illinois
- Indianapolis, Indiana
- Cedar Rapids / Des Moines, Iowa
- Dublin, Ireland
- Kingston, Jamaica
- Wichita, Kansas
- Paducah / Lexington / Louisville, Kentucky
- Baton Rouge, Louisiana
- Valletta, Malta
- Hagerstown & Frederick, Maryland
- Greenbelt / Silver Spring / Baltimore, Maryland
- Boston / Cambridge, Massachusetts
- Hartford, Connecticut / Springfield, Massachusetts
- Taunton, Massachusetts / Providence, Rhode Island
- Ann Arbor / Farmington Hills / Detroit, Michigan
- Grand Rapids, Michigan
- Lansing, Michigan
- Saginaw / Flint / Bay City / Midland, Michigan
- Saint Paul / Minneapolis, Minnesota
- Jackson, Mississippi
- Gulfport / Biloxi, Mississippi
- Whiteman Air Force Base / Kansas City, Missouri
- Reno and Las Vegas, Nevada
- Santa Fe / Albuquerque, New Mexico
- Newark, New Jersey
- Princeton, New Jersey & Philadelphia, Pennsylvania
- White Plains / New York City, New York
- Charlotte, North Carolina
- Durham / Raleigh, North Carolina
- Bowling Green / Toledo, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- Providence, Rhode Island
- Edinburgh / Glasgow, Scotland
- Columbia & Charleston, South Carolina
- Memphis / Jackson / Nashville, Tennessee
- College Station and Houston, Texas
- El Paso, Texas / Ciudad Juarez, Mexico
- San Antonio / Austin, Texas
- Wichita Falls & Dallas, Texas
- Ogden / Salt Lake City, Utah
- Burlington, Vermont
- Fairfax / Dulles / McLean / Herndon / Reston, Virginia
- Richmond / Alexandria / Arlington, Virginia
- Virginia Beach / Norfolk, Virginia
- Tacoma / Seattle, Washington
- Madison / Milwaukee, Wisconsin
|
 |
 |
SQL Server 2005 training: Advanced Topics in SQL Server 2005 Administration and Development
|
Course Number: 660
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. To receive a customized proposal and price quote, 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/sql.htm.
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 2000, XP, or Windows 2003 Server
- SQL Server 2005
- 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
|
| |
|
 |
Accelebrate®
Comes to You! |
 |
Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.
Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.
For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.

|
 |
|
| |
| Accelebrate E-Newsletter |
 |
Get the latest Web development news delivered to your email box once a month!

|
 |
|
|
 |