30000

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.

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

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.

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.

Continuation of ITS 31062 Cisco Networking Devices I.

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.

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.

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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.

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

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

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

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.

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#.

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.

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#.

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.

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.

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.

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.

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

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.

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