Oracle Certified Associate Boot Camp
(five days to full certification)
The goal of this five-day accelerated course is to provide IT professionals with the advanced knowledge and skills necessary to administer the world's leading database systems and applications. This is a performance-based course designed upon the job-related tasks an advanced professional must perform using new or modified features in the Oracle® systems.
Our program for Oracle 10g DBA Certified Professional Associate affords students the ability to live, learn, and take the vendor exams on-site at our education centers throughout the US and Europe. The competition for jobs is intense. Individuals, experienced or new to the profession, need to know what skills make them attractive to employers. Employers look for ways to distinguish employees and prospective employees that have the solid foundation of skills needed for effective performance.
(Note: All students will receive catered breakfast and lunch each day as part of this special event.)
- Prove your ability to perform foundation level Oracle tasks.
- Carry the Oracle-approved mark of your skill level.
- Help you and your employers improve productivity.
- 1Z0-051:Oracle Database 11g: SQL Fundamentals I
- 1Z0-042:Oracle Database 10g: Administration I
- OCA: Oracle Certified Associate
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Reporting Aggregated Data Using the Group Functions
- Displaying Data from Multiple Tables
- Using Subqueries to Solve Queries
- Using the Set Operators
- Manipulating Data
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
- Basic Oracle Concepts
- Installing Oracle Database 10g
- Creating an Oracle Database
- Interfacing with the Oracle Database
- Managing Oracle Processes
- Managing Oracle Storage Structures
- Administering Users
- Managing Database Objects
- Manipulating Database Data
- Programming Oracle with PL/SQL
- Securing the Database
- Configuring Oracle Networking
- Managing Shared Servers
- Managing Database Performance
- Monitoring Oracle
- Managing Undo
- Dealing with Locking
- Configuring the Database for Backup and Recovery
- Backing Up Oracle Databases
- Recovering Oracle Databases
- Recovering from User Errors
- Tools for Oracle Database 10g Tuning
- Managing Globalization in Oracle Databases
- Configuring Security for the Listener
In order for a class to be successful, all students should share the same general level
of knowledge and experience. If a participant does not demonstrate these, the instructor will take
the necessary steps either to prepare the participant or place him/her in a more appropriate course.
This policy is intended to maintain the high level of quality control that you have come to expect.