The Oracle Certified Associate (OCA): SQL Fundamentals course introduces you to the fundamentals of SQL using Oracle Database 11g database technology. In this course you learn the concepts of relational databases and the powerful SQL programming language. 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.

The participants also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts.

In this course, you use Oracle SQL Developer as the main tool and SQL*Plus is introduced as an optional tool.

Students and working professionals wishing to gain expertise in SQL

After the completion of this course, you will be able to:

• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data in the Oracle Database 11g
• Run data definition language (DDL) statements to create and manage schema objects
• Identify the major structural components of the Oracle Database 11g

The Oracle Certified Associate (OCA): Oracle 11 G Administrator certification is designed to give you a firm foundation in basic administration of Oracle Database 11g. In this class, participants 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. You will 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. The lesson topics are reinforced with structured hands-on practices.

Students and working professionals who wish to gain expertise in Database Administration.

After the completion of this course, you will be able to:

• Describe Oracle Database Architecture
• Install and configure Oracle Database 11g
• Configure Oracle Net services
• Manage the database storage structures
• Create and administer user accounts
• Perform basic backup and recovery of a database
• Manage users and schemas
• Manage data and concurrency
• Monitor and administer undo data
• Backup and recover a database
• Monitor performance
• Use the database diagnostic monitor

The Oracle Certified Associate (OCA): Oracle Database 11 G Administration certification is designed to provide you with the concepts and architecture that support backup and recovery. It provides hands-on experience to define and test your own backup and recovery scenarios.

Also, the participants learn to manage memory effectively and 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 covered. Topics are reinforced with hands-on practices.

Students and working professionals who wish to gain expertise in Oracle Database Administration

After the completion of this course, the student will be able to:

• Describe the Oracle Architecture
• Identify the features of the Oracle Universal Installer
• Start-up and Shutdown of an Oracle instance
• Describe the process of Database Creation
• Build Data Dictionary and Dynamic Performance Views
• Use Control File and Redo Log Files
• Manage Table Spaces and Data Files
• Create and use different types of Indexes
• Manage Resources and Privileges
• Build Auditing Functions
• Describe and use Globalization support in Oracle

This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 2 for Oracle Real Application Clusters (RAC). Students learn how to install and administer OracleClusterware, Real Application Clusters, and Automatic Storage Management. Students also learn how to administer their Database in a Real Application Clusters environment using Enterprise Manager Grid Control. Increase your efficiency by learning how to configure and use database services as well as the Load Balancing Advisory in a RAC environment. Learn how to add and remove nodes in clusters and how to patch both Oracle Clusterware and Real Application Clusters software in a rolling fashion.
This course counts toward the Hands-on course requirement for the following certifications

• Oracle Database 10g Administrator Certification
• Oracle Database 10g: Real Application Clusters Administrator Certified Expert

• Data Warehouse Administrator
• Database Designers
• Database Administrators
• System Analysts
• Project Manager
• Technical Administrator
• Support Engineer
• Technical Consultant

After the completion of this course, you will be able to:

• Identify common data structures
• Gather requirements
• Create a baseline project
• Prepare reusable metadata
• Model for predictable results
• Create calculations and filters
• Implement a time dimension
• Create the presentation view
• Create analysis objects
• Manage OLAP data sources
• Set Security
• Manage packages
• Basic model maintenance and extensibility
• Working with different query subject types
• Identify generated SQL and complex queries
• Optimize and tune Framework Manager model
• Work in a multi-modeler environment
• Use advanced parameterization techniques
• Manage MUNs and model for drill-through
• Employ additional modeling techniques

The Oracle Certified Associate (OCA): SQL Fundamentals course introduces you to the fundamentals of SQL using Oracle Database 11g database technology. In this course you learn the concepts of relational databases and the powerful SQL programming language. 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.

The participants also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts.

In this course, you use Oracle SQL Developer as the main tool and SQL*Plus is introduced as an optional tool.

Students and working professionals wishing to gain expertise in SQL

After the completion of this course, you will be able to:

• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Create reports of aggregated data
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data in the Oracle Database 11g
• Run data definition language (DDL) statements to create and manage schema objects
• Identify the major structural components of the Oracle Database 11g

The Oracle Certified Associate (OCA): Oracle Database 11 G PL/SQL Developer certification course enables participants to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Participants learn to create anonymous PL/SQL blocks as well as stored procedures and functions.

Participants learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. You will also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions.

This course is a combination of Oracle Database 11 G: PL/SQL Fundamentals and Oracle Database 11 G: Develop PL/SQL Program Units courses. This is appropriate for a 10g audience too. There are few minor changes between 10g and 11g features.

Participants use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools.

Students and working professionals who wish to gain expertise in PL /SQL programming.

After the completion of this course, you will be able to:

• Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
• Create and use stored procedures and functions
• Design and use PL/SQL packages to group and contain related constructs
• Create overloaded package subprograms for more flexibility
• Use the Oracle supplied PL/SQL packages to generate screen output, file output, and mail output
• Write dynamic SQL for more coding flexibility
• Describe the features and syntax of PL/SQL
• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
• Manage dependencies between PL/SQL subprograms
• Handle runtime errors
• Describe stored procedures and functions
• Design PL/SQL code for predefined data types, local subprograms, additional pragmas and standardized constants and exceptions
• Create triggers to solve business challenges
• Design PL/SQL anonymous block that execute efficiently

Oracle Forms Developer 10g is used to build high performance applications for the Internet. Forms Developer is a web based application development tool that helps in quickly constructing database forms and business logic with minimal of effort.

In this course students build, test, debug, and deploy interactive Internet applications. Working in a graphical user interface (GUI) environment, they develop an order entry application from the ground up. This application incorporates several advanced features that provide a rich user experience while implementing business rules.
This course counts towards the Hands-on course requirement for the Oracle Forms Developer Certified Professional Certification. Only instructor-led in class or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.

• Forms Developer
• Support Engineer
• Developer
• Technical Consultant
• Application Developers
• PL/SQL Developer

At the end of the course, you will be able to:

• Customize forms with user input items such as check boxes, list items, radio groups, and Pluggable Java Components
• Integrate Java into Forms applications by using JavaBeans
• Control navigation, data access, validation, and transactions by creating event-related triggers
• Enable Forms applications running on the Web to access files and applications on the client computer
• Display Forms elements and data in multiple canvases and windows
• Deploy Forms applications to the Web
• Identify when to handle exceptions programmatically.

In this course, participants learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Developer (9.0.4.0.1). Working in the declarative environment of Reports Builder, participants learn how to retrieve, display, and format data from any data source in numerous reporting styles and publish the output to any destination.
Participants learn how to add dynamic content to a static Web page and publish reports to the Web. In addition, participants learn how to customize more complex reports, embed graphical charts, and use Oracle AS Reports Services to deploy the reports.

Working professionals who wish to gain expertise in Reports.

After the completion of this course, you will be able to:

• Use report parameters and customize a runtime parameter form
• Enhance reports using graphs and PL/SQL trigger code
• Maximize report performance using Oracle AS Reports Services and tune reports
• Publish a report on the Web and build reports to run in various languages
• Manage report templates, create mailing labels and letters
• Identify the main components in a report document and how they are related
• Identify the differences between Web and paper reports
• Identify standard report design styles and run existing reports to various output destinations
• Create and modify basic tabular reports and high quality Web reports
• Create other report styles such as break reports and matrix reports
• Create reports by accessing data from various data sources
• Add dynamic data to an existing HTML page