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 explore several examples, include an Except query that displays differences between two sets of data and an Inner subquery with calculated fields that total results in a TopLevel subquery. You then go further by building a query using a SQL statement. 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 Inner subqueries that display calculated results in a TopLevel query
• Build a query using a SQL Statement
• 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)