Course 3182: Applying Advanced Query Techniques in Microsoft SQL Server 2005
Description
Introduction 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 At the end of the course, students will be able to:
- Evaluate CTEs
- …
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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 At the end of the course, students will be able to:
- 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
- A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
- Microsoft® Windows® 2000 or higher
- Microsoft Internet Explorer 6.0 or higher
- Adobe Flash 7.0 or higher (1MB disk space needed to install)
- Microsoft Silverlight 4.0 or higher
- Microsoft Windows Media Player 7.0 or higher
- Microsoft XML Core Services 3.0 or higher
- A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
- A sound card, and either speakers or headphones (for multi-media audio).
- Internet bandwidth of 56K or faster. Broadband internet access is recommended.
- Microsoft Virtual Server ActiveX control (1MB disk space needed to install)
- Microsoft Internet Explorer 6.0 or higher
- Window-Eyes from GW Micro
- JAWS from Freedom Scientific
- MSAA enabled
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.