The Intermediate SQL course reviews the construction of a SQL query joining multiple tables using both INNER and OUTER joins, subqueries, scalar functions and aggregate functions. Apprentices add, modify and remove data records using DML statements; identify and create appropriate indexes to improve system query performance; and analyze the results for accuracy and completeness as well as review query performance

Conditions

Student has completed all of the following course(s): ITDATA 50156701 - Introductory SQL