This is the second in the Query training sequence and the Query Foundations course is a prerequisite to participating in the Advanced Query Techniques class.
This instructor led class will focus on more advanced functions of the query tool and participants will build upon what they learned in Query Foundations. Participants will be expected to have a working knowledge and understanding of basic query concepts and more time will be spent on authoring, running and validating query results. The following concepts will be addressed:
– Having Criteria- Expressions- Aggregate Functions- Sub Queries- Standard Joins- Left Outer Joins- Unions
Participants are expected to pass a written examination and complete a final query activity to complete the class. It is important to register in advance. To do so, click here http://ihr.hrs.wsu.edu/skillsoft/default.aspx?c=ilt_wsu_SYST_995