Get ready to take the fast pass to CVTC!  August 7  |  2 - 7 PM Learn More

Apprenticeship Requirements

Apprenticeship Requirements

Data Analyst

Apprenticeship 50-156-1

www.cvtc.edu
1-800-547-2882

Effective: August 2025

First Semester

Course # Course Title Credits Prerequisites/Comments
156-701 Introductory SQL 2 Program student The 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.
Course #: 156-701
Title: Introductory SQL
Credits: 2
Prerequisites/Comments: Program student The 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-702 Intermediate SQL 2 156-701 The 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.
Course #: 156-702
Title: Intermediate SQL
Credits: 2
Prerequisites/Comments: 156-701 The 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-703 Data Presentation 3 156-701 Introduces 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.
Course #: 156-703
Title: Data Presentation
Credits: 3
Prerequisites/Comments: 156-701 Introduces 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-704 Intro Business Analysis 1.5   Prepares 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.
Course #: 156-704
Title: Intro Business Analysis
Credits: 1.5
Prerequisites/Comments:   Prepares 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-705 Introductory ETL 1.5 156-702 Prepares 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.
Course #: 156-705
Title: Introductory ETL
Credits: 1.5
Prerequisites/Comments: 156-702 Prepares 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  
Total Credits: 10

Course Title

###-### | # Credits

Course Description

Find Upcoming Sections

Minimum Program Credits Required: 10

2.0 Minimum Program Cumulative GPA Required for Graduation
If a student does not enroll in any courses at CVTC for two or more consecutive semesters, the student will be required to reapply with Admissions. Students must abide by any changes in admission requirements and degree requirements.

Updated: 6/1/2023 8:40 a.m.  |  Printed: 8/2/2025 9:31 p.m.

Print Page

Join Us To

Experience CVTC for Yourself

Explore CampusAttend an EventSchedule a Visit
Go Back to Top Tell us who you are!
I'm a(n)
Schedule
a
visit
Apply
today
Chat
with us