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-101 | .Net Database Programming | 3 |
| 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 Analysis | 2 |
| 156-112 | Predictive Analytics | 2 |
Approved Substitute: 156-105 | ||
| 156-113 | Python Data Manipulation | 2 |
| General Studies | ||
| 801-136 | English Composition 1 | 3 |
Approved Substitute: 801-223 | ||
| 801-197 | Technical Reporting | 3 |
Approved Substitute: 801-243 | ||
| 804-133 | Math & Logic | 3 |
| 804-189 | Introductory Statistics | 3 |
| 809-195 | Economics | 3 |
| 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-112 | Intro to Programming with C# | 3 |
| 156-108 | Intro to Databases & Reporting | 1 |
| 804-133 | Math & Logic | 3 |
| Credits | 7 | |
| Fall Term 2 | ||
| 156-107 | Data Modeling | 2 |
| 156-109 | Intro to SQL | 2 |
| 801-136 | English Composition 1 | 3 |
| Credits | 7 | |
| Spring Term 1 | ||
| 156-101 | .Net Database Programming This course will run 16 weeks. | 3 |
| 156-102 | Advanced SQL This course will run 16 weeks. | 3 |
| 804-189 | Introductory Statistics | 3 |
| Credits | 9 | |
| Spring Term 2 | ||
| 152-101 | Python Programming | 1 |
| 156-110 | Data Visualization & Reporting | 2 |
| 156-113 | Python Data Manipulation | 2 |
| Credits | 5 | |
| Second Year | ||
| Summer Term | ||
| 801-197 | Technical Reporting | 3 |
| Credits | 3 | |
| Fall Term 1 | ||
| 156-106 | Data Warehouse Development This course will run 16 weeks. | 4 |
| 156-111 | Intro to Data Analysis | 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 | |
| Winter Interim | ||
| 890-108 | Employment Success | 1 |
| Credits | 1 | |
| Spring Term 1 | ||
| 152-170 | IS Project This course runs 16 weeks. | 4 |
| 150-137 | MS Server | 3 |
| 809-199 | Psychology of Human Relations | 3 |
| Credits | 10 | |
| Spring Term 2 | ||
| 156-103 | Database Administration | 3 |
| Credits | 3 | |
| Third Year | ||
| Summer Term | ||
| 107-137 | IT Internship | 1 |
| 809-195 | Economics | 3 |
| Credits | 4 | |
| Total Credits | 62 | |
| First Year | ||
|---|---|---|
| Spring Term 1 | Credits | |
| 156-108 | Intro to Databases & Reporting | 1 |
| 801-136 | English Composition 1 | 3 |
| 804-133 | Math & Logic | 3 |
| Credits | 7 | |
| Spring Term 2 | ||
| 156-107 | Data Modeling | 2 |
| 801-197 | Technical Reporting | 3 |
| 156-113 | Python Data Manipulation | 2 |
| Credits | 7 | |
| Fall Term 1 | ||
| 152-112 | Intro to Programming with C# | 3 |
| 809-199 | Psychology of Human Relations | 3 |
| Credits | 6 | |
| Fall Term 2 | ||
| 156-109 | Intro to SQL | 2 |
| 804-189 | Introductory Statistics | 3 |
| Credits | 5 | |
| Second Year | ||
| Spring Term 1 | ||
| 156-101 | .Net Database Programming This course will run 16 weeks. | 3 |
| 156-102 | Advanced SQL This course will run 16 weeks. | 3 |
| 809-195 | Economics | 3 |
| Credits | 9 | |
| Spring Term 2 | ||
| 152-101 | Python Programming | 1 |
| 156-110 | Data Visualization & Reporting | 2 |
| Credits | 3 | |
| Fall Term 1 | ||
| 156-106 | Data Warehouse Development This course will run 16 weeks. | 4 |
| 107-119 | System Analysis Agile Methods | 3 |
| 156-111 | Intro to Data Analysis | 2 |
| Credits | 9 | |
| Fall Term 2 | ||
| 150-190 | Network Fundamentals | 2 |
| 156-112 | Predictive Analytics | 2 |
| Credits | 4 | |
| Third Year | ||
| Winter Interim | ||
| 890-108 | Employment Success | 1 |
| Credits | 1 | |
| Spring Term 1 | ||
| 152-170 | IS Project This course will run 16 weeks. | 4 |
| 150-137 | MS Server | 3 |
| Credits | 7 | |
| Spring Term 2 | ||
| 156-103 | Database Administration | 3 |
| 107-137 | IT Internship | 1 |
| Credits | 4 | |
| Total Credits | 62 | |