School of Undergraduate Studies

Important Links:

• School of Undergraduate Studies Home Page

• Undergraduate Degree Programs

• Undergraduate Certificates

• Index to Course Descriptions Home Page

Course Descriptions — Computer Information Technology (CMIT)

CMIT 261 Introduction to Oracle (3)

(Formerly CMIT 261O.) An introduction to Oracle and Structured Query Language (SQL) The syntax and function of the American National Standards Institute’s standard SQL are examined. SQL’s data definition language is used to create tables, including constraints, and SQL’s data manipulation language is used to insert, update, and delete data. Emphasis is on learning queries, ranging from the simple to the complex. Additional database objects (such as views, sequences, synonyms, aliases, and indexes) and SQL built-in functions are explored. Topics also include using the Oracle SQL command editor and the local system editor and creating simple reports with SQL Loader and SQL Plus. Students may receive credit for only one of the following courses: CMIT 261 or CMIT 261O.

CMIT 265 Networking Essentials (3)

An introduction to networking technologies for individual workstations, local area networks, wide area networks, and the Internet, with emphasis on the OSI (open system connectivity) model, security, and networking protocols. A general review of several industry-standard network operating systems is provided. Topics covered should be useful in preparing for the Network+ certification exam. Students may receive credit for only one of the following courses: CMIT 265 or CMIT 265M.

CMIT 320 Network Security (3)

Prerequisite: CMIT 265 with grade of C or better or CompTIA Network+ certification. A study of the fundamental concepts of computer network security and their implementation. Topics include authentication, remote access, Web security, intrusion detection, basic cryptography, physical security, and disaster recovery. Opportunities for hands-on exercises are provided. Course material relates to topics covered on the vendor-neutral CompTIA Security+ Certification examination, which is recognized worldwide as the standard of competency for entry-level network security professionals.

CMIT 331 Wireless Network Administration (3)

(Formerly CMIT 499W.) Prerequisite: CMIT 265. A comprehensive review of available options in transmissions over wireless technologies. Emphasis is on design and implementation of wireless networks. Topics include FDMA, TDMA, and CDMA (frequency-, time-, and code-division multiple access) and other third generation (3G) concepts. The benefits of wireless technologies and wireless security are explored using real-world challenges and solutions. Students may receive credit for only one of the following courses: CMIT 331 and CMIT 499W.

CMIT 350 Interconnecting Cisco Devices (3)

(Designed to help students prepare for the Cisco Certified Network Associate Examination 640-802.) Prerequisite or corequisite: CMIT 265. Presentation of and practice in the concepts and commands required to configure Cisco switches and routers in multiprotocol internetworks. Routing and switching concepts (Layer 2 and Layer 3 technologies) using Cisco switches and Cisco routers are covered. Focus is on developing the skills necessary to install, configure, and operate Cisco routers and switches within LAN and WAN environments including VoIP and wireless networks. Projects include configuring various protocols including IP, RIP, IGRP, EIGRP, OSPF, RSTP and Frame Relay. Students may receive credit for only one of the following courses: CAPP 498E, CMIT 350, or CMIT 499D.

CMIT 361 Developing PL/SQL Applications (3)

Prerequisite: CMIT 261. An in-depth study of the use of PL/SQL to develop enterprise-level database applications in industry. Topics include application programs and standard third-generation language (3GL) programming constructs (such as if-then-else statements, loops, record-at-a-time processing, and error handling). Students may receive credit for only one of the following courses: CMIT 361 or IFSM 498O.

CMIT 364 Windows XP Professional (3)

Prerequisite: CMIT 265. An introduction to Windows XP Professional. Focus is on developing the skills necessary to install, configure, and support Windows XP Professional as a desktop operating system in a generic operating environment. Topics include review of operating systems, administration, security, transmission control protocol/Internet protocol, and troubleshooting Windows XP Professional. Hands-on exercises are included. Students may receive credit for only one of the following courses: CMIT 364 or CMIT 499X.

CMIT 368 Windows Server 2003 (3)

Prerequisite: CMIT 265. A study of Windows Server 2003 installation and administration. Focus is on developing the skills necessary to install and configure Windows Server 2003. Topics include support, connectivity, creation and management of user accounts, management of access to resources, the NT file system, and configuration and management of disks. Hands-on exercises are included.

CMIT 374 Exchange Server (3)

(Formerly CMIT 499M.) Prerequisite: CMIT 368. Development of the knowledge and skills needed to update and support a reliable, secure infrastructure for creating, storing, and sharing information using Microsoft Exchange Server in a medium to large (250 to 5000 seats) electronic messaging environment. Hands-on practice is provided. Students may receive credit for only one of the following: CMIT 374 or CMIT 499M.

CMIT 376 Windows Network Infrastructure (3)

(Formerly CMIT 376M.) Prerequisite: CMIT 368. The development of the knowledge and skills necessary to install, configure, manage, and support the Windows network infrastructure. Topics include automating Internet protocol address assignment using dynamic host configuration protocol, implementing name resolution using domain name service and Windows Internet naming service, setting up and supporting remote access to a network, configuring network security using public key infrastructure, integrating network services, and deploying Windows 2000 Professional using remote installation services. Hands-on exercises are included. Students may receive credit for only one of the following courses: CMIT 376 or CMIT 376M.

CMIT 377 Windows Directory Services Infrastructure (3)

Prerequisite: CMIT 368. The development of the knowledge and skills necessary to install, configure, manage, and support the Windows Active Directory service. Topics include understanding the logical and physical structure of Active Directory, configuring the domain name service to support Active Directory, creating and administering user accounts and group resources, controlling Active Directory objects, implementing and using group policy, managing replication of Active Directory, and maintaining and restoring the Active Directory database. Hands-on exercises are included. Students may receive credit for only one of the following courses: CMIT 377 or CMIT 377M.

CMIT 381 Oracle Database Administration (3)

Prerequisite: CMIT 261. A foundation in basic database administration tasks. Focus is on gaining a conceptual understanding of the Oracle9i database architecture and how the architectural structures work and interact with one another. Topics include how to create an operational database and properly manage the various structures in an effective and efficient manner. Hands-on exercises include configuring network parameters so that database clients and tools can communicate with an Oracle database server. Backup and recovery techniques are introduced, and various backup, failure, and restoration and recovery scenarios are examined. Students may receive credit for only one of the following courses: CMIT 381 or CMIT 381O.

CMIT 391 UNIX/Linux System Administration (3)

Prerequisite: CMIS 325. A study of the UNIX/Linux operating system, combining theory and lab work. Discussion covers document processing, file system administration, and the bootup/ shutdown process. Topics include disk partitioning schemes, software RAID (redundant array of independent disks), and LVM (logical volume manager) configuration. Review also covers user administration, disk quotas, group restrictions, and password aging. Process management and automation are examined through “cron” and “at” commands. Practice in configuring the X Window System and client networking is provided. Network security is addressed through the use of IP tables to construct firewall rules. Students may receive credit for only one of the following courses: CMIS 390, CMIT 391, or CMIS 398U.

CMIT 392 Designing and Implementing Databases with SQL Server (3)

(Assumes prior understanding of relational database concepts.) The development of the knowledge and skills necessary to design and implement databases with SQL Server. Topics include developing a logical data model, deriving the physical design, devising data services, creating and executing stored procedures, and constructing and maintaining a physical database. Hands-on exercises are included. Students may receive credit for only one of the following courses: CMIT 392 or CMIT 392M.

CMIT 394 Data Warehousing Using SQL Server (3)

(Assumes prior understanding of relational database concepts.) A study of design and implementation of data warehouse solutions using SQL Server. Topics include defining the technical architecture for a data warehouse solution, developing the logical design, deriving the physical design, object linking and embedding, open database connectivity, ActiveX Data Objects, file management, data integrity, online analytical processing, monitoring and optimizing performance, and backup and disaster recovery. Hands-on exercises are included. Students may receive credit for only one of the following courses: CMIT 394 or CMIT 394M.

CMIT 398E Ethical Practice of Intrusion Prevention and Detection (3)

Prerequisite: CMIT 265. Development of a structured knowledge base that enables network security professionals to discover vulnerabilities and recommend solutions for tightening network security and protecting data from potential attackers. Focus is on penetration-testing tools and techniques that security testers and ethical hackers use to protect computer networks. Course material should prove useful in preparing for the certified ethical hacker examination.

CMIT 399V Windows Vista (3)

Prerequisite: CMIT 265. An overview of Windows Vista. Focus is on developing the knowledge and skills necessary to perform troubleshooting on client computers within an organization. Topics include the operating system, hardware support, networking, security, and applications. Discussion also covers monitoring and maintaining Windows Vista client computers, as well as system image and application package deployment. Hands-on exercises are provided.

CMIT 450 Designing Cisco Networks (3)

(Designed to help students prepare for the Cisco Certified Design Associate Examination 640-863.) Prerequisite or corequisite: CMIT 350. The development of the knowledge and skills necessary for network design using Cisco Systems technologies. Fundamentals of small- and medium-size network design are introduced. Focus is on developing the skills to identify the Cisco products, Local- and wide area network (LAN and WAN) technologies, routing and bridging protocols, and Cisco IOS software features that meet a customer’s requirements for performance, capacity, and scalability in small- to medium-sized networks. Projects include designing simple routed LAN, routed WAN, switched LAN, and ATM (asynchronous transfer mode) LAN networks. Students may receive credit for only one of the following courses: CAPP 398C, CMIT 450, or CMIT 499C.

CMIT 480 Designing Security for a Windows Network (3)

Prerequisite: CMIT 320 or CMIT 368. The development of the knowledge and skills necessary to design a security framework for small, medium, and enterprise networks using Windows technologies. Topics include providing secure access to local network users, partners, remote users, and remote offices and between private and public networks. Students may receive credit for only one of the following courses: CMIT 480 or CMIT 480M.

CMIT 486A Internship in Computer Information Technology Through Co-op (3)

Prerequisite: Formal admission to the Co-op program (program requirements are listed on p. 246). An opportunity to combine academic theory with new, career-related experience in computer information technology. At least 12 hours per week must be devoted to new tasks for a minimum of 180 hours during the Co-op session; four new tasks must be delineated in the Learning Proposal; and the course requirements must be completed. May be repeated upon approval of a new Learning Proposal that demonstrates new tasks and objectives related to computer information technology and that continues to advance application of academic theory in the workplace. Students may earn up to 15 credits in all internship coursework through Coop toward a first bachelor’s degree and up to 9 credits toward a second bachelor’s degree. Co-op credits may not be used for general education requirements and, unless otherwise specified, no more than 6 Co-op credits may be used in the academic major and minor (combined).

CMIT 486B Internship in Computer Information Technology Through Co-op (6)

Prerequisite: Formal admission to the Co-op program (program requirements are listed on p. 246). An opportunity to combine academic theory with new, career-related experience in computer information technology. At least 20 hours per week must be devoted to new tasks for a total of 300 hours during the Co-op session; five to eight new tasks must be delineated in the Learning Proposal; and the course requirements must be completed. May be repeated upon approval of a new Learning Proposal that demonstrates new tasks and objectives related to computer information technology and that continues to advance application of academic theory in the workplace. Students may earn up to 15 credits in all internship coursework through Co-op toward a first bachelor’s degree and up to 9 credits toward a second bachelor’s degree. Co-op credits may not be used for general education requirements and, unless otherwise specified, no more than 6 Co-op credits may be used in the academic major and minor (combined).

CMIT 491 Advanced UNIX/Linux System Administration (3)

Prerequisite: CMIT 391. A review of DNS (domain name system) servers and the Apache Web server. An introduction to LDAP (lightweight directory access protocol) directory queries and authentication is provided. The administration and configuration of server-side programming tools (such as CGI, mod_perl, PHP, JSP, Jakarta Tomcat, and Java SDK) are demonstrated via extensive lab work. SAMBA, FTP, Telnet, and SQUID proxy servers are configured. SMTP (simple mail transfer protocol) theory is discussed and implemented via sendmail and postfix e-mail systems. E-mail protocols such as IMAP and POP are configured; spam filtering techniques are discussed. Students may receive credit for only one of the following courses: CMIS 490, CMIT 491, or CMIS 498U.

CMIT 499 Special Topics in Computer Technology (1–5)

An inquiry into special topics in computer information technology that reflect the changing field. May be repeated when topics differ.

CMIT 499B Administering SQL Server (3)

Recommendation: An understanding of relational database concepts. The development of the knowledge and skills necessary to install, configure, and administer a database solution with the client/server database management system Microsoft SQL Server 2000. Hands-on exercises are included.

CMIT 499E Building Scalable Cisco Networks (3)

Prerequisite: CMIT 350. A study of techniques for selecting and configuring Cisco router services in LANs and WANs typically found at medium to large network sites. Focus is on selecting and implementing appropriate Cisco services to build a scalable, routed network. Part of the recommended curriculum for the Cisco Certified Network Professional (CCNP) and Cisco Certified Design Professional (CCDP) certificates is covered.

CMIT 499F Building Cisco Switched Networks (3)

Prerequisite: CMIT 350. A study of concepts and techniques for building networks using multilayer switching technologies over high-speed Ethernet connections. Topics include both routing and switching concepts and cover both Layer 2 and Layer 3 technologies.

CMIT 499G Cisco Remote Access Networks (3)

Prerequisite: CMIT 350. The development of the knowledge and skills necessary to build, configure, and troubleshoot a remote access network to interconnect central sites to branch offices and home offices. Discussion also covers how to control access to the central site, as well as maximize bandwidth utilization over remote links.

CMIT 499S Advanced Network Security (3)

Prerequisites: CompTIA Network+ certification (or CMIT 265 or equivalent knowledge) and CompTIA Security+ certification (or CMIT 320 or equivalent knowledge). A comprehensive study of information security. Course material is based on the vendor-neutral (ISC)2 Certified Information System Security Professional (CISSP) Certification Exam, which is the capstone standard of competency for experienced security professionals.