Program Level: Advanced

This advanced course goes beyond the basics of creating a query. Designed for those who want to build on their foundational knowledge of business activity queries (BAQs), you first explore Intercept and Except queries that display differences between two sets of data. Then see how to create Inner subqueries with calculated fields that total results in a TopLevel subquery. You will also create a BAQ that displays results in a PIVOT table. Then by examining Common Table Expression (CTE) and recursion, you create a query that displays hierarchical data. The course ends by showing how you create updatable BAQs that change records in the database.

Cost: There is an additional $350 fee to attend this session.

Objectives:

• Create an Except business activity query
• Create an Intercept business activity query
• Create Inner subqueries that display calculated results in a TopLevel query
• Use the Common Table Expression to display hierarchal data
• Design a business activity query that displays results in a PIVOT table
• Create an updateable query

Audience: System Administrator IT/Technical Staff

Prerequisites: Business Activity Queries (BAQs) (Basic Understanding)