INFO.3040 Introduction to Java Web Development
This course will introduce Java/Java Script,
Java Server Face (JSF), Java Serverlet Page
(JSP) Web development. Students will utilize a
Windows-based development platform configured
with Java JDK, JBoss Application Server and
Eclipse IDE. Fundamentals of Java and object-
oriented programming using the Model View
Controller (MVC) web application and
application server architectures, Enterprise
and XML (AJAX) programming technologies will be
examined. Students will also learn core skills
in personalizing websites using sessions,
leveraging reusable components, use of JSP tags
and development of embedded Java/Java script
code into HTML to build interactive web pages. 3 credits.
Prerequisite: INFO.2970 Intro to Java Programming
INFO.4430 Introduction to Client/Server Computing
An overview of what Client/Server is all about. The course will introduce the six leading technologies for developing Client/Server applications: database servers, TP (Transaction Processing) Monitors, middleware, groupware, distributed objects, and the Internet. 3 credits.
This course qualifies for
free MSDNA software!
INFO.4500 Database Administration I: Introduction to Oracle 11g
This course is designed to give the student an in-depth review of the Oracle DBMS architecture and physical components. The student is also introduced to common DBA skills to set up, maintain, and troubleshoot an Oracle 11g database. Students learn to leverage the 11g architecture to build and configure databases, manage database objects and logical/phsical storage, configuration of Oracle processes and memory, manage user accounts, privileges and roles, and backup recovery strategy. Students also learn database organization including a comprehensive examination of Oracle's data dictionary, space management, table and index segments, undo and rollback segments, logical and physical block sizing, and key dynamic and static parameter files. Progessive hands-on labs utilizing the latest release of Oracle 11g Enterprise Server reinforces key concepts learned. Successful comletion of this course prepares students for the Oracle Database Administration I certification exam and also qualifies as an oracle 10g DBA OCP Hands-On Approved Course. Prerequisite: None. Credits: 3.0 3 credits.
INFO.4530 Database Administration II: Advanced Oracle 11g
Building upon the skills students learned in Database Administration I, this course focuses on advanced concepts of managing enterprise-scale Oracle 11g databases. Students are introduced to advanced concepts used to analyze, troubleshoot, and resolve performance, backup and recovery, and configuration-related problems. Students closely examine Oracle 11g diagnostic, resource and data protection methodologies including interrogating dynamic and static system views, alert log, thresholds and traces, 11g flashback of critical/non-critical data, 11g automatic storage management, 11g automatic shared memory tuning, and 11g data pump import and export utilities. Students will also utilize the 11g Enterprise Manager Database and Grid Control web-based interface to perform advanced database maintenance and configuration Successful completion of this course prepares students for the Oracle Database Administration II certification exam and also qualifies as an oracle 11g DBA OCP Hands-On Approved Course. Prerequisite: 90.450 or related experience. Credits: 3.0 3 credits.
INFO.4540 Oracle 11g SQL Development
This course provides students a practical, hands-on approach to working with the SQL language. Students will learn how to create and maintain database objects such as tables and indexes as well as to store, retrieve, and manipulate data on a host server. Students are introduced to simple and complex queries using standard SQL. Instructor-led hands-on labs utilizing Oracle's 11g Enterprise Database server will reinforce concepts learned throughout the course. This course will aid students in preparation for the Oracle Database Administration I certification exam and also qualifies as an Oracle's 11g DBA OCP Hands-On Approved Course. Prerequisite: None Credits: 3.0 3 credits.
INFO.4550 Database Administration III: Oracle 11g Projects
Designed as a capstone course, students will build upon concepts learned in both Oracle Database Administration I and II. This course focuses on extensive hands- on skills building to enable students to gain practical Oracle Database Administration experience. Utilizing the latest release of Oracle 11g Enterprise Server, students hone their Oracle skills through problem analysis, troubleshooting, and performance and configuration resolutions in a variety of common 'real world' scenarios. Delivered completely via lab-based projects, primary focus is on identification and resolution of common problems involving server and database configuration, database performance, backup/recovery, and networking. This course documents student skills in preparation for employment as an Oracle Database Administrator as well as prepares students to sit for Oracle's Certified Master (OCM) hands-on lab. Prerequisite: 90.450 and 90.453, or instructor permission. Credits: 3.0 3 credits.
INFO.4590 PL/SQL I: Introduction to Oracle 11g PL/SQL
This course will introduce students to the basics of PL/SQL subprograms. Students will learn how to write and invoke PL/SQL procedures, functions and packages. Using Oracle's 11g Enterprise Database Server, students will engage in hands-on lab work in both Oracle's Procedure Builder and SQL*Plus environments. Students will learn how to create and manage PL/SQL program units, database triggers, and common Oracle-supplied packages. This course will aid students in preparation for certification as an Oracle PL/SQL Developer Certified Associate and also qualifies as an Oracle's 11g DBA OCP Hands-On Approved Course. Prerequisite: None Credits: 3.0 3 credits.
INFO.4660 Oracle 11g Data Warehousing
This course introduces students to the fundamentals of Data Warehousing. Upon completion, students should be able to guide a Data Warehousing project and avoid common pitfalls of implementation. The course provides an overview of the topic, comparing and contrasting it to other data management techniques to define how it is implemented and used. The course then drills into the topics that make up a data warehouse: Dimensions, Hierarchies, Facts/Cues, Data Marks and Summary (OLAP) techniques, and ETL. Throughout the course, attention will be given to life-cycle concerns. Case studies of several functional areas will be covered to illustrate particular patterns or techniques. Students will build models utilizing the Oracle 10g database platform. Prerequisite: None Credits: 3.0 3 credits.
INFO.4670 PL/SQL II: Advanced Oracle 11g PL/SQL
This course introduces students to advanced features of PL/SQL used to design and interface with the Oracle 11g database. Students learn the benefits of Oracle 11g powerful extended PL/SQL functionality by exploring and utilizing advanced Oracle-supplied packages, procedures, REF cursors, extended interface methods, PL/SQL block debugging, case statement flows, bulk binds, code tuning considerations, and advanced object types. Students will engage in hands-on lab work using advanced techniques learned throughout the course to design PL/SQL applications that solve today's most complex business problems. This course will aid students in preparation for certification as an Oracle PL/SQL Developer Certified Associate. Prerequisite: 90.459 Credits: 3.0 3 credits.
INFO.4690 Oracle 11gR2 High Performance and Internals
In this course, students will learn how to use Oracle Database 11g automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, SQL Monitor, Automatic Workload Repository, Automatic Database, Diagnostic Monitor, Health Monitor, and practice these tuning methods utilizing and Oracle 11gR2 Enterprise database. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement performance, and tuning the Oracle Database Instance components. Various Oracle memory internals will be examined including the discovery and usage of key high performance DBMS packages and views, use of the Automatic Diagnostics Repository (ADR) interface, Cost-based optimizer statistics, and memory management, Throughout the course, students practice the art of tuning and internals using an Oracle 11gR2 Enterprise RDBMS through a series of weekly lectures, group discussions and hands-on lab workshops. 3 credits.
Prerequisite: INFO 4500,453 Pre-reqs
INFO.4740 Relational Database Concepts
Introduces database directives, design elements of databases, architectures, and commercial databases. Students will participate in design of a large-scale database application and administration of this database. Prerequisite; 90.267 3 credits.
This course qualifies for
free MSDNA software!
INFO.4790 Oracle 12i Applications DBA
Building on the fundamentals of database technology learned in 90.450 and 90.453, this course focuses on Oracle DBA roles and responsibilities in an Oracle 12i applications environment. The course closely examines the oracle I2i database architecture focusing on Oracle I2i database software installation, capacity planning, database configuration, database tuning, and upgrade and patching maintenance. Students are exposed to I2i-specific tools such as the Concurrent Manager and Enterprise Manager Console. The course also reviews Oracle I2i application modules used in typical implementations to meet today's business requirements. Prerequisites: 90.450, 90.453 3 credits.
Prerequisite: INFO.4500, 90.453.