Apprenticeship Requirements

First Semester

Course #Course TitleCreditsPrerequisites/Comments

156-701Introductory SQL2Program studentThe introductory SQL course prepares apprentices to leverage a relational database management system to retrieve data. They will create and execute queries using SQL statements. They will read an Entity-Relationship Diagram to direct the creation of the correct query.

156-702Intermediate SQL2156-701The Intermediate SQL course reviews the construction of a SQL query joining multiple tables using both INNER and OUTER joins, sub-queries, 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 for review and optimization.

156-703Data Presentation3156-701Introduces data report creation. Apprentices learn data presentation formats and types of reports. Focus is placed on the creation of a variety of reports utilizing industry standard reporting tools. Data findings will be presented verbally and in writing, including through executive summaries.

156-704Intro Business Analysis1.5Prepares apprentices to work as liaisons among stakeholders and understand the structure, policies, and operation of an organization. Apprentices use techniques to gather and analyze business requirements using best practices and relevant technologies. Prepares apprentices to function as liaisons with IT and subject matter experts supporting the needs of businesses in a wide variety of industries.

156-705Introductory ETL1.5156-702Prepares apprentices to extract from unstructured and structured data stores, transform data for usability and readability and load data for consumption. Apprentices use applicable technology and techniques to provide reliable and accurate data for the end user or application.

TOTAL CREDITS:10