An IT - Database Specialist Class

IT - Database Specialist

64-credit Associate of Applied Science Degree

Data analysis is the process of inspecting, cleaning, transforming and modeling data to make informed business decisions. As companies downsize their workforce, employers are turning their attention to an analysis of corporate data to gain an edge on the competition. The result is an increase in demand for those with database administration and data analysis knowledge.

In the Database Specialist program, learn how to support the operational database needs of small to medium businesses -- including configuration and management of database servers, user permissions on the database and troubleshooting performance issues. Become proficient in data analysis, reporting and the development of data models. Data cubes, data analytics and big data will be introduced.

  • Prepare for jobs such as database administrator, database analyst, data architect and database designer.
  • Students in IT-Computer Support Specialist, IT-Network Specialist, IT-Web and Software Developer, IT-Network Security Specialist and IT-Database Specialist take similar courses in their first semester of studies. Should a student determine after the first semester that he/she would prefer a different IT program, he/she may switch with minimal credit loss.
  • The IT Student Center provides a wealth of resources for students to practice their skills, complete group projects and work with mentors and tutors.
  • As a complement to the IT-Database Specialist program, several specialized, short-term certificates are also available.
  • Some credits within the Desktop Support Technician technical diploma program can be applied to this associate degree program.
  • Involvement in the BIT Connections Club allows members to share and expand upon IT skills through service learning projects, emerging technology exploration, aspects of global business technology and professional development opportunities.
  • Starting salaries ranging from $32.50 to $54.00 for full-time, entry-level database administrators.

Program Code 10-156-2

Required Courses

First Semester
 Course NumCourse NameCredits
 150-190 Network Fundamentals2  
 152-107 Introduction to Programming2  
 152-169 JavaScript4  
 154-135 Fundamentals of Support2  
 801-136 English Composition 13+ 
 804-133 Math & Logic3  
 
Total Semester Credits
16
  
Second Semester
 Course NumCourse NameCredits
 150-136 MS Server 2012 Install/Config3  
 150-150 Cloud Infrastructure/Services3  
 152-115 Database Concepts3  
 156-101 .Net Database Programming3  
 804-189 Introductory Statistics3  
 
Total Semester Credits
15
  
Summer Semester
 Course NumCourse NameCredits
 801-198 Speech3  
 
Total Semester Credits
3
  
Third Semester
 Course NumCourse NameCredits
 150-154 Shell Scripting2  
 156-102 Advanced SQL3  
 156-103 Database Administration3  
 156-104 Data Analysis and Reporting3  
 890-108 Employment Success1  
 809-195 Economics3+*
 
Total Semester Credits
15
  
Fourth Semester
 Course NumCourse NameCredits
 107-118 Information Systems Design4  
 107-137 IT Internship1  
 156-105 Advanced Topics in Database3  
 156-106 Data Warehouse Design4  
 809-199 Psychology of Human Relations3  
 
Total Semester Credits
15
  
+ (Proficiency Exam Available)
* (Prerequisites or substitutes may apply to this class.)

View available courses for this term

View course descriptions of all required courses

Credit Transfer Opportunities

WCTC has agreements with local high schools and various four-year colleges and universities that enable students to transition more seamlessly from high school to WCTC to four-year colleges. Transcripted credit agreements provide high school students the opportunity to take WCTC courses at their high schools. Agreements with four-year colleges enable WCTC graduates in selected programs to transfer credits, often at junior-level standing. Agreements currently in place for this program are listed below.

There are no credit transfer agreements for this program at this time. For more information, contact your academic advisor.

UW-System Credit Transfer

If you are interested in attending a UW-campus, you should contact a transfer representative at the campus you plan to attend. You may also check credit transfer agreements between WCTC and the UW System to tell you which specific courses and general education classes may be accepted.

Important Cautionary Note:
This information is intended as a general description. Please verify the availability and details of the program that interests you with the transfer coordinator at the receiving institution.

Meet your Instructor

Program instructor, Andrew Kjell

Drew Kjell

Phone: 262.691.5595

Education

  • BS, Software Engineering and Applied Math - Carroll University
  • MS, Organizational Leadership and Administration - Concordia University (Expected completion, fall 2017)

Teaching Philosophy

"Learning is a lifelong endeavor. I help students understand how technology plays a role and encourage them to explore real world application of the skills we learn in class."

Program instructor, Nicole Kowalchuk

Nicki Kowalchuk

Phone: 262.691.5542

Education

  • AAS, Programmer/Analyst - Waukesha County Technical College
  • BS, Computer Science - Carroll University
  • MBA, Concordia University

Teaching Philosophy

"It is my goal to teach students real-world application and expectations in addition to helping them learn skills to become lifelong learners."