IT - Data and Analytics Specialist
IT - Database and Analytics Specialist Associate of Applied Science Degree
Program Code: 10-156-3
For more information: wctc.edu/data-spec
Prepare for a variety of careers in the rapidly-growing field of data. Gain skills in data modeling, database development, report development, and data warehouse design and development. Explore the basics of programming, data visualization, statistical data analysis and data analytics.
The minimum required course grades and program grade point average (GPA) for students under this catalog are:
Core Courses = C
General Studies Courses = C
Program GPA = 2.0
Related Certificates you can earn along the way:
Program Outcomes
- Create complex SQL queries.
- Develop data driven reports.
- Analyze data.
- Develop database driven applications.
- Design a database.
- Develop ETL processes.
- Manage database servers.
- Model Real-World Processes as Data.
Critical Life Skills
To help our students prepare for success in a workplace and society that is increasingly global, multi-cultural, and collaborative, all students are given opportunities to develop and demonstrate Critical Life Skills, both in and out of the classroom. The following Critical Life Skills are learning outcomes for WCTC students.
- Communication: Demonstrate appropriate communication.
- Critical Thinking/Problem Solving: Demonstrate critical thinking skills to analyze situations and solve problems.
- Relationships: Demonstrate effective interpersonal skills.
- Self-management: Demonstrate responsible and respectful behavior.
Listed below are the required courses for this program. An Academic Advisor can help you develop your program plan and select the term and course schedule that works best for you.
| Code | Title | Credits |
|---|---|---|
| Core Courses | ||
| 156-119 | Data Concepts | 2 |
Approved Substitute: 156-108 | ||
| 152-150 | Intro to Prog in Python | 2 |
| 156-109 | Intro to SQL | 2 |
| 156-107 | Data Modeling | 2 |
| 156-113 | Python Data Manipulation | 2 |
| 156-102 | Advanced SQL | 3 |
| 156-110 | Data Visualization | 2 |
Approved Substitute: 156-104 | ||
| 156-111 | Intro to Data Analytics | 2 |
| 156-106 | Data Warehouse Development | 4 |
| 156-120 | Data Analytics with Python | 2 |
| 107-119 | System Analysis Agile Methods | 3 |
Approved Substitute: 107-118 | ||
| 156-112 | Predictive Analytics | 2 |
Approved Substitute: 156-105 | ||
| 156-118 | AI/Data Capstone | 4 |
| 150-190 | Network Fundamentals | 2 |
| 156-117 | Big Data Engineering | 3 |
| 156-103 | Database Administration | 3 |
| 107-123 | Internship IT | 2 |
| General Studies | ||
| 804-133 | Mathematics and Logic | 3 |
| 804-189 | Introductory Statistics | 3 |
| 801-136 | English Composition I | 3 |
Approved Substitute: 801-223 | ||
| 809-195 | Economics | 3 |
| 801-197 | Technical Reporting | 3 |
Approved Substitute: 801-243 | ||
| 809-199 | Psychology of Human Relations | 3 |
Approved Substitute: 809-198 | ||
| 890-108 | Employment Success | 1 |
| Total Credits | 61 | |