 |
SQL Server 2005 Additional Topics Training
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
|
SQL Server 2005 Additional Topics Course 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
|
|
DVD ROM'S:The DVD version of this training set will only run on DVD ROM computer players only. These DVD's WILL NOT run on entertainment DVD players that are connected to TV's. An Internet connection is also required.
|
Home ||
Shopping Cart ||
Site Map ||
Newsletter/Blog
Search HALLoGRAM ||
Request More Information
CALL TOLL FREE 1-866-340-3404
|
