SQL Server 2005 Additional Topics

Software Training Academy
Toronto, Ontario, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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.



LEARNING OBJECTIVES



· 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



Course Duration: 3 days



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.



...''

Phone:1-888-896-7852

School Address:

Toronto Star Building
1 Yonge Street, Suite 1801
Downtown Toronto
Ontario, Canada - M5E 1W7

Jobs & Resumes: Toronto
Houses & Roommates: Toronto
Travel Agencies: Toronto

Search other schools for SQL Server 2005 Additional Topics training resources.

Java Servlets
JSP
JDBC
Oracle 10g Advanced SQL
Oracle 10g Introduction to SQL
Oracle 10g PL/SQL Programming
Oracle Applications Using ADO.NET and C#
J2EE
Visual Basic for Applications (VBA)
Securing Java Web Applications
SQL Server 2005 Analysis Services (SSAS)
SQL Server 2005
SQL Server 2005 Integration Services (SSIS)
SQL Server 2005 Reporting Services (SSRS)
SQL Server 2005 Transact SQL (T-SQL)
The Java Message Service
JSP Standard Tag Library
Using and Developing JavaBeans
XML Programming Using C# and .NET

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.