| CONTINUING EDUCATION |  |
ORACLE |
|---|
ORACLE learning program track is a combination of modules that sets you on a path to become an Oracle Certified Professional (OCP).
-
Oracle Database 11 G: SQL Fundamentals (expands on clicking)
OverviewThe 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.
Who will the course benefit?
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
What will you gain?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
Admission Conditions Duration Certification Prior knowledge of data processing concepts and techniques 24 hours Certificate of participation
Additionally, students can appear for Oracle Certified Associate (OCA): Oracle Database 11G: SQL Fundamentals certification (exam: 1Z0-051)
-
Oracle 11 G: Database Administration (expands on clicking)
-
Oracle Database 11 G: Administration Workshop I (expands on clicking)
OverviewThe 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.
Who will the course benefit?Students and working professionals who wish to gain expertise in Database Administration.
What skills will you gain?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
Admission Conditions Duration Certification Prior knowledge of SQL 36 hours Certificate of participation
Additionally, students can appear for Oracle Certified Associate (OCA) Oracle Database 11G Administrator certification (exam 1Z0-052)
Prerequisite:-
OCA: Oracle Database 11G: SQL Fundamentals certification (exam: 1Z0-051) is a prerequisite for attaining OCA: Oracle Database 11 G Administrator
-
Oracle Database 11 G: Administration Workshop II (expands on clicking)
OverviewThe 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.
Who will the course benefit?
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
What skills will the student gain?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
Admission Conditions Duration Certification Oracle Database 11 G: Administration Workshop I 36 hours Certificate of participation
Additionally, students can appear for Oracle Certified Professional (OCP) Oracle Database 11 G Administration certification (exam 1Z0-053)
Prerequisite:-
OCA: Oracle Database 11G: SQL Fundamentals certification (exam: 1Z0-051) and OCA: Oracle Database 11G Administrator certification (exam 1Z0-052) are a prerequisite for attaining OCP: Oracle Database 11 G Administration certification
-
-
Oracle 11G: PL / SQL Developer (expands on clicking)
-
Oracle Database 11 G: Program with PL/SQL (expands on clicking)
OverviewThe 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.
Who will the course benefit?
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.
What skills will the student gain?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
Admission Conditions Duration Certification Prior knowledge of Oracle Database 11g: Introduction to SQL 36 hours Certificate of participation
Additionally, students can appear for Oracle Certified Associate (OCA): PL/SQL Developer certification (exam: 1Z1:144)
Prerequisite:-
OCA: Oracle Database 11G: SQL Fundamentals certification (exam: 1Z0-051) is a prerequisite for attaining OCA: Oracle Database 11 G PL/SQL Developer certification
-
Oracle Database 11 G: Advanced PL/SQL (expands on clicking)
OverviewThe Oracle Certified Professional (OCP): Oracle Database 11 G Advanced PL/SQL course, you will learn 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. 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.
Who will the course benefit?Students and working professionals who wish to gain expertise in Advanced PL/SQL programming.
What skills will the student gain?After the completion of this course, you will be able to:
• Tune PL/SQL code
• Categorize and explain various types of SQL injection attacks
• Apply coding standards to eliminate SQL injection vulnerabilities
• Create subtypes based on existing types for an application
• Create and use collections
• Execute external C programs from PL/SQL
• Execute Java programs from PL/SQL
• Describe the process of fine-grained access control
• Create and maintain LOB data types
• Use the DBMS_LOB PL/SQL package to control LOBs
• Describe SecureFile LOB features
• Identify guidelines for cursor design
• Enable SecureFile LOB de-duplication, compression, and encryption
• Improve memory usage by caching SQL result sets
• Set up PL/SQL functions to use PL/SQL result caching
• Profile PL/SQL applications
Admission Conditions Duration Certification Prior knowledge of Oracle 11 G Database SQL and PL/SQL courses is essential 36 hours Certificate of participation
Additionally, students can appear for Oracle Certified Professional (OCP): Oracle Database 11 G: Advanced PL/SQL Developer certification (exam: 1Z0-146)
Prerequisite:-
OCA: Oracle Database 11G: SQL Fundamentals certification (exam: 1Z0-051) and OCA: Oracle Database 11 G PL/SQL Developer certification (exam: 1Z1: 144) is a prerequisite for attaining OCP: Oracle 11 G: Advanced PL/SQL Developer certification
-
-
Oracle Forms Developer10 G: Build Internet Applications (expands on clicking)
OverviewOracle 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.
Who will the course benefit?
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
What skills will the student gain?
• 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.
Admission Conditions Duration Certification A good familiarity with Graphical User Interface (GUI)
Working experience with the Web browser
Oracle Database 10g: Introduction to SQL
Oracle Database 10g: Program with PL/SQL
36 hours Certificate of participation
-
Oracle Reports Developer 10 G: Build Reports (click here to expand)
OverviewIn 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.
Who will the course benefit?
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.
What skills will the student gain?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
Admission Conditions Duration Certification Oracle Database 10g: SQL Fundamentals I
Oracle Database 10g: Develop PL/SQL Program Units
Oracle Database 10g: PL/SQL Fundamentals
36 hours Certificate of participation
-
Oracle Database 10g: RAC for Administrators Release 2 (click here to expand)
OverviewThis 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.
Who will the course benefit?
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
What skills will the student gain?
• 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
Admission Conditions Duration Certification • Oracle Enterprise Manager 10g Grid Control
• Oracle Database 10g: Administration Workshop I Release 2
• Oracle Database 10g: Administration Workshop II Release 2
36 hours Certificate of participation Additionally, participants can appear for the Oracle
