Austin Community College Welcome to Austin Community College
Status: logged out [ login ] Help!  
ITNW 9024 - Oracle 11g: Certified OCP DBA Series
Earning your OCP credential will give you recognition for your foundation of knowledge using Oracle technologies and to act as a team member working with database administrators or application developers. Registration in the OCP Series guarantees you a seat in courses: ITSW 1007-Introduction to SQL, ITSW 1054-Oracle 11g Administration I and ITSW 2037-Oracle 11g Administration II. Prerequisite: General computer knowledge including database concepts.
 
ITNX 9026 - Oracle 11g PL/SQL Series
This course prepares Oracle database administrators (DBA) to create an operational database and properly manage the various structures in an effective and efficient. It introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications and how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Prerequisites: General computer knowledge including relational database concepts.
 
ITSE 1073 - Oracle 11g: Program with PL/SQL
In this course students learn how to write PL/SQL procedures, functions and packages. Working in both the Procedure Builder and the SQL*Plus environments, participants will learn how to create and manage PL/SQL program units and database triggers. Participants will also learn how to use some of the Oracle-supplied packages. Prepares students for the Oracle Certified Associate exam #1Z0-144. Prerequisite: ITSW 1007-Introduction to Oracle 11g: SQL.
 
ITSE 1079 - Oracle 11g: Java Programming
Java Programming This course teaches the concepts and essential elements of the Java language. While learning Java, you will build applications using standard Java technologies. The development environment used for this course is Oracle JDeveloper 10g. In addition to coding in Java, you will learn how to use the graphical development capabilities of JDeveloper to aid application development. Prerequisite: Knowledge of simple SQL and HTML; Experience with a structured programming language ; Basic knowledge of the principles of object orientation
 
ITSE 2070 - Program with Advanced PL/SQL
This course covers the use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, large objects, and collections, students learn to write powerful PL/SQL programs. Students also learn programming efficiency, use of external C and Java routines, fine-grained access and safeguarding code against SQL Injection attacks. Prepares students for the Oracle Certified Professional exam #1Z0-146. Prerequisites ITSE 1073 Program with Advanced PL/SQL or equivalent.
 
ITSW 1007 - Introduction to Oracle 11g: SQL
Understanding the basic concepts of relational databases ensures refined code by developers. This course helps the participants to write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Controlling privileges at the object and system level are also dealt with in detail. This course covers creating indexes and constraints, and altering existing schema objects. Additionally, participants learn how to create and query external tables in order to query and manipulate external data within the database, to use the dictionary views to retrieve metadata and create reports about their schema objects. Participants get to understand the advanced features of SQL. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL. This course prepares students for the Oracle Certified Associate exam #1Z0-051. Prerequisite: General computer knowledge including relational database concepts.
 
ITSW 1054 - Oracle 11g: Database Administration I
This course introduces students to data server technology. The class covers the concepts of both relational and object relational databases and the powerful SQL programming language. Demonstrations and hands-on practice reinforce the fundamental concepts. This course prepares students for the Oracle Certified Associate exam 1Z0-052. Prerequisite: ITSW 1007-Introduction to Oracle 11g SQL or exception granted by the instructor for prior experience.
 
ITSW 2037 - Oracle 11g: DBA Administration II
This course covers Oracle 11g flashback technology, configuring and using Recovery Manager, monitoring and managing storage, managing resources, monitoring and managing memory, dealing with database corruption, and automating the tasks with Scheduler. Demonstrations and hands-on practice reinforce the fundamental concepts to prepare the student for the Oracle Certified Professional Exam #1Z0-053. Prerequisite: ITSW 1007 Introduction to Oracle 11g SQL and ITSW 1054 Oracle DBA Administration I or exception granted by the instructor for prior experience.