ACP Oracle Database Administration

Benefits

• Benefit from the #1 provider in Oracle training in California
• Utilize Oracle certified course materials direct from Oracle
• Acquire hands-on practice in an Oracle-certified lab
• Prepare for the Oracle certification exams for database administration
• Sharpen your communication and presentation skills in the Professional Communications Seminar
• Gain a competitive edge in the global job market through an internship in a U.S. company

Certificate Requirements

In order to earn the Oracle Database Administration Certificate, students must complete all the courses listed below with a grade “C” or higher in each course.

All certificate programs at UC Irvine Extension require professional-level English language proficiency in listening and note-taking, reading comprehension and vocabulary, written expression, and oral presentation. International students who do not meet certificate program admissions requirements are invited to enroll first in one of our English language program offerings.

Admission Requirements

Internships
As an optional last course and for an additional fee, you have the opportunity to apply academic theory and gain practical experience in a variety of businesses and industries for up to three months. A research project provides additional training. Also included in the internship are the Resume Development and Interviewing Skills workshops.
Learn More

Stay Informed About
Graduate-level Professional Certificates

Schedule

Tuition: $11,900
Internship: $1,850

Curriculum

Professional Communications
Seminar (PCS)

Understand American business culture, sharpen your communication and presentation skills, learn professional etiquette, and improve your business English.

Courses

• Oracle Database 11g: Introduction to SQL
  In this course, students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retried metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database.
• Oracle Database 11g: Program with PL/SQL
  This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions. Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions. Students are introduced to the utilization of some of the Oracle-supplied packages combining Oracle Database: PL/SQL Fundamentals and Oracle Database: Develop PL/SQL Program Units courses.
• Oracle Database 11g: Administration Workshop I DBA
  This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Topics in this course include: Oracle database architecture, Oracle Net services, database storage structures, backup and recovery, data and concurrency, undo data, performance and database diagnostic.
• Oracle Database 11g: Administration Workshop II DBA
  This course takes the database administrator beyond the basic tasks covered in the first workshop. The student begins by gaining a much deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios. Also, the DBA learns how to manage memory effectively and how to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are also covered.
• Oracle Database 11g: Performance Tuning DBA
  This course starts with an unknown database that requires tuning. The lessons proceed through the steps a DBA will perform to acquire the information needed to identify problem areas, to diagnose common problems, and remedy those problems. After configuring monitoring tools, and reviewing the available reports, the student will be presented with the Oracle architecture based on the SQL statement processing of SELECT and DML. The DBA will be introduced to various methods of identifying the SQL statements that require tuning, and the diagnostic tools needed to find ways to change the performance. This will include the use of statistics, outlines, and profiles to influence the optimizer, adding and rebuilding indexes, and using the SQL Advisors. A major task of DBA's is to maintain SQL performance across changes. This course introduces the DB Replay, and SQL Performance Analyzer tools to help the DBA test and minimize the impact of change.
• Oracle Database 11g: SQL Tuning Workshop
  This course assists database developers, DBAs, and SQL developers to identify and tune inefficient SQL statement. It covers investigative methods to reveal varying levels of detail about how the Oracle database executes the SQL statement. This allows the student to determine the root causes of the inefficient SQL statements. Students learn to interpret execution plans, and the different ways in which data can be accessed. They will learn how the optimizer chooses the path and how to influence the optimizer to ensure that the best method is used. This course covers Automatic SQL Tuning tools, and resources available in the Automatic Workload Repository, in addition to taking advantage of bind variables, trace files, and different types of indexes.