Reporting - 203: Intermediate SQL

The goal of this course is to enhance SQL Query development skills for end-users in order to provide results for more complex business information scenarios.  This course will build on Basic SQL Query skills to enable the student to create and execute more complex queries.

Target Audience


• SAP Users who need more sophisticated information from Business One



Prerequisite

• Strongly Recommended:
• Good knowledge of SAP Business One processes and flows
• Command of Basic SQL Query structures



Course Content

• Review the SQL Select Statement structure
• Review business scenarios that require more complex queries
• Review SAP Table Structures
• Calculations for Columns
• CASE Statements for Columns
• Pros and Cons of Inner Joins
• Left and Right Outer Joins
• GROUP BY function for Summary Queries
• Use of Declared Variables