|
 |
 |
Ready to Order? Order
online, call
1-800-578-2062
or
+44(0)1903 740 624 in Europe (UK). |
 |
|
 | Microsoft SQL Server 2005: Additional Topics with Joshua Gins and Frank Tillinghast
|
| View Course Outline | Print Course Outline (.PDF) 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
| SPECIAL OFFER: BUY 1 GET 1 FREE TRAINING! Details...
Hurry, offer ends 9/30/2010. Not valid on printed books. | | Format | Modules | Retail Price | | SQL Server 2005: Additional Topics | | CD-ROM | 12 CD-ROMs
ZSQT-CD-50 | | CD-ROM & Books | 12 CD-ROMs + Printed Books
KSQT-CD-50 | | DVD-ROM | 1 DVD-ROM
ZSQT-DV-50 | | DVD-ROM & Books | 1 DVD-ROM + Printed Books
KSQT-DV-50 | | Multi-User License | Need to train multiple users? Call 800-578-2062 to purchase additional user licenses for your AppDev Product. | | 100% Satisfaction Guaranteed. Details... |
| |
| | Course Outline (Outlines are subject to change.) |
| Microsoft SQL Server 2005: Additional Topics | | Modules | 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 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
|
|
|
