IT - Data and Analytics Specialist
IT - Database and Analytics Specialist Associate of Applied Science Degree
Program Code: 10-156-3
For more information: www.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 that can be earned 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 the program. To view the recommended sequence for taking courses click on the plan of study tab(s) above. Work with your Academic Advisor to design a program plan!
View your Program Matrix to find out when each course will be offered (term and time of day).
| Code | Title | Credits |
|---|---|---|
| Core Courses | ||
| 107-119 | System Analysis Agile Methods | 3 |
Approved Substitute: 107-118 | ||
| 107-137 | IT Internship | 1 |
| 150-137 | MS Server | 3 |
| 150-190 | Network Fundamentals | 2 |
| 152-101 | Python Programming | 1 |
Approved Substitute: 150-154 | ||
| 152-112 | Intro to Programming with C# | 3 |
| 152-170 | IS Project | 4 |
| 156-102 | Advanced SQL | 3 |
| 156-103 | Database Administration | 3 |
| 156-106 | Data Warehouse Development | 4 |
| 156-107 | Data Modeling | 2 |
| 156-108 | Intro to Databases & Reporting | 1 |
Approved Substitute: 152-115 | ||
| 156-109 | Intro to SQL | 2 |
Approved Substitute: 152-115 | ||
| 156-110 | Data Visualization & Reporting | 2 |
Approved Substitute: 156-104 | ||
| 156-111 | Intro to Data Analytics | 2 |
| 156-112 | Predictive Analytics | 2 |
Approved Substitute: 156-105 | ||
| 156-113 | Python Data Manipulation | 2 |
| 156-117 | Big Data Engineering | 3 |
| General Studies | ||
| 801-136 | English Composition 1 | 3 |
Approved Substitute: 809-223 | ||
| 801-197 | Technical Reporting | 3 |
Approved Substitute: 809-243 | ||
| 804-133 | Math & Logic | 3 |
| 804-189 | Introductory Statistics | 3 |
| 809-195 | Economics | 3 |
Approved Substitutes: 809-143 OR 809-202 | ||
| 809-199 | Psychology of Human Relations | 3 |
Approved Substitute: 809-198 | ||
| 890-108 | Employment Success | 1 |
| Total Credits | 62 | |
| First Year | ||
|---|---|---|
| Fall Term 1 | Credits | |
| 152-101 | Python Programming | 1 |
| 156-108 | Intro to Databases & Reporting | 1 |
| 804-133 | Math & Logic | 3 |
| Credits | 5 | |
| Fall Term 2 | ||
| 152-112 | Intro to Programming with C# | 3 |
| 156-109 | Intro to SQL | 2 |
| 156-107 | Data Modeling | 2 |
| Credits | 7 | |
| Winter Interim | ||
| 890-108 | Employment Success | 1 |
| Credits | 1 | |
| Spring Term 1 | ||
| 156-102 | Advanced SQL This course will run 16 weeks. | 3 |
| 156-110 | Data Visualization & Reporting | 2 |
| 809-199 | Psychology of Human Relations | 3 |
| Credits | 8 | |
| Spring Term 2 | ||
| 156-113 | Python Data Manipulation | 2 |
| 801-136 | English Composition 1 | 3 |
| Credits | 5 | |
| Second Year | ||
| Summer Term | ||
| 801-197 | Technical Reporting | 3 |
| 804-189 | Introductory Statistics | 3 |
| Credits | 6 | |
| Fall Term 1 | ||
| 156-106 | Data Warehouse Development This course will run 16 weeks. | 4 |
| 156-111 | Intro to Data Analytics | 2 |
| 107-119 | System Analysis Agile Methods | 3 |
| Credits | 9 | |
| Fall Term 2 | ||
| 150-190 | Network Fundamentals | 2 |
| 156-112 | Predictive Analytics | 2 |
| Credits | 4 | |
| Spring Term 1 | ||
| 152-170 | IS Project This course runs 16 weeks. | 4 |
| 150-137 | MS Server | 3 |
| Credits | 7 | |
| Spring Term 2 | ||
| 156-103 | Database Administration | 3 |
| 156-117 | Big Data Engineering | 3 |
| Credits | 6 | |
| Third Year | ||
| Summer Term | ||
| 107-137 | IT Internship | 1 |
| 809-195 | Economics | 3 |
| Credits | 4 | |
| Total Credits | 62 | |