Advanced Query Techniques in Microsoft SQL Server 2005

Element K
Rochester, New York, United States

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

Course Description:

'' In this 2-hour premium course, you will learn how to harness advanced query capabilities within your SQL Serverâ„?2005 Database solutions. Topics range from CTEs and Pivot Queries to working with XML Data. In the lab, you will write different kinds of queries and evaluate their execution plans.

Using these advanced query techniques will enable you to build more scaleable and responsive databases.

This course will also prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 and 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005.

Objectives:
Evaluate CTEs
Describe types of CTEs
Create Nonrecursive and Recursive CTE Queries
Create Multi-Parent Hierarchy CTE Queries
Evaluate Pivot Queries
Describe syntax of a Pivot Query
Describe a Pivot Query on an Open Schema
Describe an Unpivot Query
Evaluate Ranking Queries
Define Types of Ranking Queries
Explain Syntax of a Ranking Query
Use Ranking Queries
Work with XQuery
Write Queries Using XQuery
Create Parameterizing XQueries
Use Path Expressions
Use XQuery in the WHERE Clause of a DML Statement
Overview of Strategies for Converting Data Between XML and Relational Forms
Create a Data Conversion Strategy
Convert Relational Data into XML Data
Convert XML Data into a Rowset
...''

Elements of this syllabus are subject to change.

Phone:1.800.434.3466

School Address:

Corporate Headquarters
500 Canal View Boulevard
Rochester, NY 14623 USA

Element K (UK) Limited
12-50 Kingsgate Road
Kingston-Upon-Thames
Surrey KT2 5AA
Phone: +44 (0) 20 8547 4146

157 Adelaide Street W.
Suite 614
Toronto, ON M5H 4E7
Phone: 1-800-897-9131

Element K India Pvt. Ltd.
RR Tower II, 4th Floor
Thiru-Vi-Ka Industrial Estate
Guindy
Chennai 600 032
INDIA
Phone: +91 44 42454000

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

Search other schools for Advanced Query Techniques in Microsoft SQL Server 2005 training resources.

ITIL Foundation Certification v3.0
Excellence in Technical Customer Service
Project Management for Technical Teams
GroupWise 7.0
Novell Nterprise Linux Services
SUSE LINUX Security
SUSE Linux Administration
NetWare 6.5
C Programming
C++ Programming
Clustering Solution Using Microsoft SQL Server 2005
Highly Available Database Storage Solution Using Microsoft SQL Server 2005
Microsoft Windows SharePoint Services 3.0
Crystal Reports 2008
IBM DB2
Java
AJAX
JavaScript
Java Web Services

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.