IT 110 – Introduction to Business Technology (3)
Description: Explores many of the more common technologies that business executives and technology professionals alike need to understand. Labs and team projects include CRM, SCM, HTML and building a simple website that can generate revenue and collect customer analytics to help you make better business decisions. This course will give students confidence in their abilities to use different technologies to help their businesses or job functions.
IT 125 – Windows Client (3)
Description: Focuses on installing, configuring and administering Windows Desktop systems across peer-to-peer configurations as well as domain environments. Develops the skills required to be a consultant, full-time desktop support technician, or IT generalist who administers Windows-based computers and devices as a portion of their broader technical responsibilities.
IT 130 – Introduction to Windows Server Administration (3)
Prerequisites: IT 110
Description: Introduces the student to the critical concepts of security, access control, correct addressing, and proper configuration of a Windows server. This course is the first of three courses that are required to become certified as a Microsoft Certified Solutions Associate (MCSA). After the completion of this course, a student should be prepared to sit for the MCSA Exam #70-410 which is the first of three certification exams that must be passed to qualify as an MCSA.
IT 143 – Structured Query Language (SQL) (3)
Prerequisite: BAP 201
Description: Introduces the Structured Query Language (SQL). This course is the first of three database courses which will lead to the Microsoft MCSA Database Professional certification and a career as a Database Administrator (DBA). Students will learn how to program Database Object Queries, create Database Objects and manage system efficiencies. After the completion of this course, the student should be prepared to sit for exam #70-461 which is the first of three MCSA DB Professional exams.
IT 150 – Introduction to Networking (3)
Description: Introduces the student to basic networking concepts including the ISO Model, TCP/IP, networking services and an exploration of Wide Area Networks. Explores network security concepts including authentication, authorization, and security layers.
IT 199 – IT Internship (2)
Description: This course requires the student to find an internship opportunity within a local company that will help to apply the skills learned in class. This internship will need to be approved by the Program Director and the daily tasks need to be in line with the particular degree emphasis chosen by the student.
IT 210 – Linux Administration (3)
Prerequisite: IT 130
Description: Introduces the student to the world of Linux. Explores how Linux servers are configured, including addressing, access control, and services. Shows both the command-line power of Linux as well as the way a graphical user interface has been incorporated into the environment. With Linux becoming a sizeable part of any IT environment, this class will complement the student’s understanding of IT environments and prepare the student for a career as a systems administrator.
IT 212 – Internet Security (3)
Prerequisite: IT 150
Description: Explores how hackers are able to find their way into our networks. Reviews regulatory requirements, and laws that IT professionals need to be familiar with to secure corporate assets. Some of the lab and group projects will include scanning systems for vulnerabilities and attacking lab servers to attempt to compromise them. At the completion of this course, a student should be able to develop a strong security plan for any company network.
IT 214 – Systems Analysis & Design (3)
Prerequisite: PM 140 (for AAS programs); None (for Certificate programs)
Description: Introduces various processes and methods of gathering system requirements and designing new technologies. Emphasizes effective communication skills in analyzing, designing, and documenting technical requirements and design specifications. Lab and projects for this course will provide opportunities to design and document system plans and specifications that could ultimately be used by software engineers to build end solutions.
IT 230 – Intermediate Windows Server Administration (3)
Prerequisites: IT 130
Description: Prepares the student to prove mastery of core services such as user and group management, network access, and data security. This course is the second of three which are required to receive the Microsoft MCSA certification and work as a Windows Systems Administrator. By the completion of this course, the student should be prepared to sit for the second of three MCSA certification exams (Exam #70-411).
IT 232 – Advanced Windows Server Administration (3)
Prerequisite: IT 130, IT 230
Description: Validates the knowledge and skills developed from prior courses that are necessary to administer a Windows Server 2012 Infrastructure in an enterprise environment. These skills include for example fault tolerance, Dynamic Access control, failover clustering and Disaster Recovery. This course is the third and final course necessary to earn the Microsoft MCSA Server Administrator certification exam. At the completion of this course, the student should be prepared to sit for exam #70-412. If the student has already passed exams #70-410, and #70-411, when they sit and pass this final exam they will have earned the Microsoft MCSA Server Administrator certification.
IT 240 – Administering Microsoft SQL Server (3)
Prerequisite: IT 130, IT 143 (Concurrent)
Description: Prepares the student to install, configure and maintain a Microsoft SQL 2012 Server. This course is the second of three database classes required to earn the MCSA Database Professional certification. By the completion of this course, the student should be prepared to sit for exam #70-462 which is the second of three MCSA Database Professional exams.
IT 243 – Data Warehousing (3)
Prerequisite: IT 130, IT 143, IT 240
Description: Focuses on data management and storage strategies for companies with large amounts of data. This course is the third of three courses necessary to be prepared to earn the Database Professional MCSA certification. At the completion of this course the student should be prepared to sit for the third of three exams: Exam #70-463. If the previous two exams have been passed, then the completion of this final exam will qualify the student to officially be a Microsoft Certified Database Professional.
IT 250 – Intermediate Networking (ICND 1) (3)
Prerequisite: IT 150
Description: Introduces the student to Cisco Networks networking solutions. About 30 percent of the world’s businesses use Cisco which is almost twice as much as any other vendor. This course is the first of two courses required for a student to earn the Cisco CCNA certification. Topics in this course include building a simple network, designing Ethernet LANs and wireless LANs (WLANs), and managing network infrastructures. Upon completion of this course, the student should be prepared to sit for the ICND1 exam (#640-822).
IT 252 – Advanced Networking (ICND 2) (3)
Prerequisite: IT 150, IT 250
Description: Explores topics including VLANs, OSPF & EIGRP, Routing protocol theory, IP Access Control Lists (ACLs), Virtual Private Networks (VPNs) as well as many other advanced networking concepts. This is the second of two courses needed for the Cisco CCNA certification. Upon completion of this course, the student should be prepared to sit for the ICND2 exam (#640-816). If the student has already passed the ICND1 exam, the completion of this exam will qualify the student to officially be a Cisco Certified Networking Associate.
IT 295 – Information Technology Capstone Project (4)
Prerequisite: Concurrent enrollment in IT 232, IT 243, or IT 252
Description: Validates the knowledge and skills developed from previous Information Technology courses. This project class is mostly student-driven and provides the student with the opportunity to identify, plan, document, implement, and present a final report on the project selected. During this course, the student will document a complete set of system requirements as well as a complete project management plan and proposed system design. The student will be expected to present the plan to an Executive Committee who will determine whether the plan is sufficient. Once the plan has been approved, the student will be expected to implement the plan to completion and document the results. A final report will be given to the Executive Committee for final signoff.