Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
Microsoft SQL Server 2005: Additional Topics
with Joshua Gins and Frank Tillinghast


View the Course Outline

Developing a database, getting the database to work with your applications, and getting it to production is just the beginning, but can often be where the story ends. This course examines other SQL Server 2005 essential application, support, and maintenance topics—features you can use for high-availability, stability, reliability, and scalability of databases, plus enhancements for processing large amounts of data, handling complex data structures, implementing asynchronous messaging, and working with XML.

Course includes 48+ hours of total training time...

  • 12 modules of training
  • Over 16 hours of media run time
  • Over 600 pages of printable courseware
  • Step-by-step hands-on-labs
  • Sample code
Format Sessions Retail Price
SQL Server 2005: Additional Topics
CD-ROM

 12 CD-ROMs

$695.00  
CD-ROM & Books

 12 CD-ROMs + Printed Books

$839.00  
DVD-ROM

 1 DVD-ROM

$695.00  
DVD-ROM & Books

 1DVD-ROM + Printed Books

$839.00  
Read about Joshua Gins and Frank Tillinghast. .
Course Outline (Outlines are subject to change.)
Microsoft SQL Server 2005: Additional Topics

Sessions Run Time Pages
12 16 hours 600

Developing a database, getting the database to work with your applications, and getting it to production is just the beginning, but can often be where the story ends. This course examines other SQL Server 2005 essential application, support, and maintenance topics—features you can use for high-availability, stability, reliability, and scalability of databases, plus enhancements for processing large amounts of data, handling complex data structures, implementing asynchronous messaging, and working with XML.

In this course you will learn...
  • Learn about disaster recovery options
  • Understand high availability concepts
  • See how to implement SQL Server high-availability features: failover clustering, database mirroring, log shipping, and peer-to-peer replication
  • Explore new techniques for monitoring and troubleshooting SQL Server
  • Learn how to implement asynchronous messaging with the new Service Broker
  • Discover partitioning with SQL Server
  • Examine new RANKing functions, Common Table Expressions, and learn techniques for dealing with complex queries
  • Explore advanced techniques for working with complex data structures
  • Learn how to use source control with SQL Server Management Studio
  • Discover new XML capabilities in SQL Server 2005
Prerequisites:

This course assumes that students have a basic understanding of Windows operating systems, security, networking technologies, SQL Server, T-SQL, Visual Studio.NET, and XML.

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

back to top


Your Instructor

Joshua Gins and Frank Tillinghast are both Senior Consultants with MTOW Software Solutions. They are both Microsoft Certified Solution Developers and have been developing applications together for almost fifteen years. Most of their time is spent consulting for companies nationwide. When they are not developing software or mentoring clients, Frank and Joshua are teaching other developers. They have taught over 3,500 application developers to create business solutions with Visual Studio.NET, VB.NET, ASP.NET, C#, and SQL Server.

back to top


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy