30000

ITS 30044 ADVANCED DATABASE SYSTEMS

Covers advanced techniques of data and information.  Topics include processing and optimization of queries, transactions, backup and recovery, self-tuning database systems, and data mining.  Prerequisite: ITS 20163 Introduction to Databases.

ITS 30163 DATABASE MANAGEMENT

Examines design, development and administration of large-scale database applications on a scale appropriate to needs of business organizations.

ITS 30563 ENTERPRISE ARCHITECTURE

Explores the design, selection, implementation and management of enterprise IT solutions, focusing on applications and infrastructure and their fit within business organizations. Covers frameworks and strategies for infrastructure management, system administration, data/information architecture, content management, distributed computing, middleware, legacy system integration, system consolidation, software selection, total cost of ownership calculation, IT investment analysis, and emerging technologies. Prerequisite: ITS/MIS 13063 Foundations of Information Technology.

ITS 31062 CISCO NETWORKING DEVICES I

Course prepares students new to networking technologies to understand terms, concepts, technologies, and devices commonly used in networking. Topics include application of knowledge to the installation, configuration, and troubleshooting of Cisco switches and routers.

ITS 32062 CISCO NETWORKING DEVICES II

Continuation of ITS 31062 Cisco Networking Devices I.

ITS 32563 RAPID APPLICATIONS DEVELOPMENT

Combines software development methods, tools, and management techniques to achieve rapid application development. Emphasizes object oriented analysis and design to achieve reuse of system components. Prerequisite: ITS 16163 Computer Programming.

ITS 33470 NETWORKING

Identify basic networking concepts; Distinguish between network transmission types and connectivity devices; Undersand TCP/IP components and NT/Novell protocol suites; Demonstrate network planning for hardware, cabling and operating systems; Assess network security, wireless technologies and secure remote connectivity; Perform network troubleshooting. Prerequisites: None.

ITS 33474 JAVA PROGRAMMER

The Java platform is based on the idea that the same software should run on many different kinds of computers, consumer products, and other devices. This course is desinged to give students an understanding of current Java programming languages. It provides the knowledge needed to compile, run and distribute simple Java applications. Prerequisite: ITS 16163 Computer Programming or consent of instructor.

ITS 33475 ORACLE SQL

Introduction to Oracle relational database concepts; Use of SQL for storing, retrieving, and manipulating data in relational database; Access data from more than one table using joins; Aggregate data using group functions, writing sub-queries, and create and populate Oracle database tables; Define, maintain, and modify other database objects; Use SQL's Data Manipulation Language and transaction controls; Control both user and object level security in an Oracle database; Use basic PL/SQL. Prerequisite: ITS 30163 Database Management, ITS 33470 Networking, or consent of instructor

ITS 33476 ORACLE ARCHITECTURE AND ADMIN

Introduction to concepts and procedures associated with Oracle architectural components. Topics include database administration strategies and procedures provided in Oracle8i, managing Oracle instance and use database tools, storage structure components and tables, methods for loading and reorganizing data, and concepts and tasks associated with managing security. Prerequisite: ITS 33475 Oracle SQL and PL/SQL.

ITS 33477 ORACLE PERFORMANCE AND TUNING

Introduction to tools and techniques to improve performance of currently accepted Oracle server platforms; Files and events supporting tuning process; Application tuning issues impacting database performance; Tuning components and functions of shared pool and buffer cache. Monitor contents and usage of Redo Log buffer. Identify: Database configuration and I/O issues; SQL operations requiring sorts. Use: Direct writes for large sorts and allocate temporary space appropriately; Oracle tools to diagnose and resolve contention. Create tuning session; Gather, view and edit input data. Prerequisite: ITS 33476 Oracle Architecture and Administration.

ITS 33478 ORACLE BACKUP AND RECOVERY

Introduction to backup and recovery goals and functions,archive processing and maintaining recovery catalog,identify concepts associated with performing physical backups with or without Recovery Manager (RMAN), planning and implementing database recovery strategies,identifying and handling different types of failures, diagnosing errors, detecting corruption, recovering from loss of Recovery Catalog and Control File, and mananging standby database. Prerequisite: ITS 33477 Oracle Performance Tuning.

ITS 33479 ORACLE NETWORK ADMINISTRATION

Comprehend and explain detailed architecture of Net8 and steps in which connections are established between peers. Implement basic connection between client and server node using various naming methods. Configure Names server, Multi-threaded Server and Connection Manager. Learn differing methods to determine network problems and security risks. Advanced Security Options (ASO) such as encryption and check summing and Utilities such as logging, tracing, and Trace Assistant. Prerequisite: ITS 33478 Oracle Backup and Recovery.

ITS 33480 MCSD DESKTOP APPLIC W/VISUAL BAS

Designing and developing custom business solutions with Microsoft development tools, technologies, and platforms. Building Web-based, distributed, and commerce applications using products such as MS SQL Server, MS Visual Studio, and MS Component Services. Prerequisites: ITS 23470 A+ Core Hardware, ITS 23471 A+ Operating System Technologies, ITS 33470 Networking.

ITS 33481 MCSD DISTRIB APP/VISUAL BASIC

Emphasizes client/server applications using network in multi-tier architecture to distribute presentation services, business logic, and data services. Applications access different data sources and COM components contained in applications typically participated in transactions. Can be shared by multiple users and multiple applications. Prerequisite: ITS 33480 MCSD Desktop Applications with/Visual Basic.

ITS 33484 MCSD WEB SOLTNS W/VISL INTERDEV

Design and implement Web solutions with Microsoft Visual InterDev 6.0. Skills involved include analyzing business requirements, defining technical architectures, conceptual & logical design, designing user interface & user services, deriving physical design, establishing development environment, creating user and data services, testing solutions, developing Web applications, and managing Website. Prerequisite: Consent of instructor.

ITS 33485 MS WINDOWS PROFESSIONAL

Identify key features of current Windows operating systems. Set up and administer user accounts; Use groups to organize user accounts and administer file and print resources; Remotely administer shared folders, monitor event logs, and backup and restore data. Prerequisites: ITS 23470 A+ Core Hardware, ITS 23471 A+ Operating System Technologies, ITS 33470 Networking or consent of instructor.

ITS 33486 MS WINDOWS SERVER

Design and implement infrastructure for business solutions based on current Windows platform and Microsoft server software. Implementation responsibilities include installing, configuring, and troubleshooting network systems. Prerequisite: ITS 33485 MS Windows Professional or ITS 23476 Configuring MS Windows Vista Client.

ITS 33487 MS NETWORK INFRASTRUCTURE ADMIN

Install, manage, monitor, configure, and troubleshoot DNS, DHCP, Remote Access, Network Protocols, IP Routing, and WINS in a current Windows network infrastructure. Test measures skills required to manage, monitor, and troubleshoot Network Address Translation and Certificate Services. Prerequisite: ITS 33486 MS Windows Server.

ITS 33488 MS DIRECTORY SERVICES ADMIN

Install, configure, and troubleshoot Windows Active Directory components, DNS for Active Directory, and Active Directory security solutions. Test measures skills required to manage, monitor, and optimize the desktop environment using Group Policy. Prerequisites: ITS 33486 MS Windows Server, ITS 33487 MS Windows Network Infrastructure Administration, and ITS 33488 MS Windows Directory Services Administration.

ITS 33489 CCNP BLDG SCAL CISCO INTERNTWKS

Exam addresses tasks that network managers and administrators perform when managing access and controlling overhead traffic in growing routed networks once basic connectivity has been established. Specifically, router capabilities used to control traffic over Local Area Networks (LANs) and Wide Area Networks (WANs), as well as connecting corporate networks to an Internet Service Provider (ISP). Prerequisite: ITS 23473 CCNA.

ITS 33490 CCNP BLDG CISCO MULTI SW NETWRKS

Exam addresses how to build campus networks using multilayer switching technologies over high-speed Ethernet. Explores how routing and switching technologies work together with such functions as network performance, security, or design. Prerequisite: ITS 33489 CCNP Scalable Cisco Internetworks.

ITS 33491 CCNP IMP SECURE CONVERGED WANS

Build remote access network to interconnect central sites to branch offices and home office/telecommuters. Focus on using one or more available WAN technologies, permanent or dial-up, to connect the enterprise to branch offices and telecommuters. Control access to central site and maximize bandwidth utilization over remote links. Software commands, configuration, and hardware related to establishing remote connections. Prerequisite: ITS 33490 CCNP Switching.

ITS 33492 CCNP OPT CONVERGED CISCO NTWRKS

Advanced exploration of troubleshooting processes on Cisco routers and catalyst switches for multi-protocol client hosts and servers. Prerequisite: ITS 33491 CCNP Remote Access.

ITS 33493 MS WINDOWS NETWORK ENVRMNT MNGMT

Develop skills in planning, implementing and maintaining a network infrastructure including network security, routing and remote access strategies, and planning and maintaining high server availability utilizing current Microsoft Windows network operating systems. Prerequisite: ITS 33486 MS Windows Server and ITS 33487 MS Windows Network Infrastructure Administration.

ITS 34000 MS SQL SERVER 2005 IMP & MAINT

Provides student with the knowledge necessary to install, configure, manage, and maintain SQL Server 2005. Recommended prerequisite: ITS 23477 SQL Server Foundations

ITS 34002 INTERCONN CISCO NETWORK DEV I

Course enables students new to networking technologies to understand the terms, concepts, technologies, and devices commonly used in networking.

ITS 34003 DESIGN DBASE ADMIN SQL SERV 2005

Provides studen with the knowledge necessary to optimize and maintain database solutions. Prerequisite: ITS 34000 MS SQL Server 2005 Implementation and Maintenance.

ITS 34005 OPTIM DBASE ADMIN SQL SERV 2005

Provides student with th eknowledge necessary to optimize, maintain, secure, troubleshoot, and design SQL Server 2005 databases. Prerequisite: ITS 34003 Design Dbase Admin SQL Server 2005.

ITS 34007 MS.NET FRAMEWORK 2.0 CLIENT C#

Provides student with the knowledge necessary to implement Window-based application by using Microsoft.NET Framework 2.0. Prerequisite: ITS 23480 MS.NET Framework 2.0 Foundations Using C#.

ITS 34009 MS.NET FRAMEWORK 2.0 CLIENT VB

Provides student with the knowledge necessary to implement Window-based application by using Microsoft.NET Framework 2.0. Prerequisite: ITS 23481 MS.NET Framework 2.0 Foundations Using Visual Basic.

ITS 34011 MS.NET FRAMEWORK 2.0 WEB CL C#

Provides student with the knowledge necessary to develop and implement web-based applications with web forms, ASP.NET, and the .NET Framework. Prerequisite: ITS 23480 MS.NET Framework 2.0 Foundations Using C#.

ITS 34013 MS.NET FRAMEWORK 2.0 WEB CL VB

Provides student with the knowledge necessary to develop and implement web-based applications with web forms, ASP.NET, and the .NET Framework. Prerequisite: ITS 23481 MS.NET Framework 2.0 Foundations Using Visual Basic.

ITS 35002 INTERCONN CISCO NETWORK DEV II

Students learn to apply networking knowledge to the installation, configuration, and troubleshooting of Cisco switches and routers. Prerequisite: ITS 34002 Interconnecting Cisco Networking Devices Part I.

ITS 35003 APPLICATION SECURITY

Course explores security concepts such as authentication, authorization, integrity, confidentiality, and non-repudiation. Topics include basic security concepts, services, and technologies as well as the challenges in the application, transport, and message layers of applications. Prerequisite: ITS 16163.

ITS 35005 WIRELESS NETWORKING

Course exposes students to the full range of wireless data communications standards and technologies available today. Topics include technologies from Bluetooth to satellites, as well as Wireless Personal Area Networks (WPANs), Wireless Local Area Networks (WLANs), Wireless Metropolitan Area Networks (WMANs), and Wireless Wide Area Networks (WWANs). Security aspects of each wireless technology are also explored. Prerequisite: ITS 33470.

ITS 35500 SPEC TOPICS INFO TECH SYSTEMS

Designed around special theories, practices or interest of an individual or group of students.

ITS 36002 CERTIFIED INFO SYS SECURITY PROF

Students cover the ten security domains required to implement, design, and manage network security functions. Topics include security management, cryptography, disaster recovery planning, as well as legal and ethical issues.

ITS 37044 OPERATING SYSTEMS

Study of microcomputer and minicomputer operating systems. Topics include batch processing, concurrent processing, memory management and processor scheduling.