Oracle Database 12c Developer Track
# Course Title Hours
1 Oracle Database 12c: Introduction to SQL
2 Oracle Database 12c: Program with PL/SQL
160
3 Oracle Fusion Middleware 12c: Build Applications with Oracle Forms
4 Oracle Reports Developer 12c: Build Reports
1- Oracle Database12c: Introduction to SQL
This Oracle Database: Introduction to SQL training helps you write subqueries, combine
multiple queries into a single query using SET operators and report aggregated data using
group functions. Learn this and more through hands-on exercises.
Learn To:
Understand the basic concepts of relational databases ensure refined code by
developers.
Create reports of sorted and restricted data.
Run data manipulation statements (DML).
Control database access to specific objects.
Manage schema objects.
Manage objects with data dictionary views.
Retrieve row and column data from tables.
Control privileges at the object and system level.
Create indexes and constraints; alter existing schema objects.
Create and query external tables.
Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database
workloads, lower IT costs and deliver a higher quality of service by enabling consolidation
onto database clouds.
Learn Advanced Features of SQL
This course will help you understand the advanced features of SQL. Learning these
features will help you query and manipulate data within the database, use the dictionary
views to retrieve metadata and create reports about their schema objects. 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 through expert instruction.
Use Development Tools
The main development tool used in this training is Oracle SQL Developer. SQL*Plus is
available as an optional development tool. This is appropriate for a 10g, 11g and 12c
audience.
Course Bundle
Note: This course is a combination of Oracle Database: SQL Workshop I and Oracle
Database: SQL Workshop II courses.
Objectives
Identify the major structural components of the Oracle Database 12c
Create reports of aggregated data
Write SELECT statements that include queries
Retrieve row and column data from tables
Run data manipulation statements (DML) in Oracle Database 12c
Create tables to store data
Utilize views to display data
Control database access to specific objects
Manage schema objects
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Manage objects with data dictionary views
Write multiple-column sub-queries
Employ SQL functions to retrieve customized data
Use scalar and correlated sub-queries
Create reports of sorted and restricted data
Topics
Introduction
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 Joins
Using Subqueries to Solve Queries
Using the SET Operators
Managing Tables using DML statements
Introduction to Data Definition Language
Introduction to Data Dictionary Views
Creating Sequences, Synonyms, Indexes
Creating Views
Managing Schema Objects
Retrieving Data by Using Subqueries
Manipulating Data by Using Subqueries
Controlling User Access
Manipulating Data
Managing Data in Different Time Zones
2- Oracle Database 12c: Program with PL/SQL
This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL
and then explores the benefits of this powerful programming language. Through hands-
on instruction from expert Oracle instructors, you'll learn to develop stored procedures,
functions, packages and more.
Learn To:
Conditionally control code flow (loops, control structures).
Create stored procedures and functions.
Use PL/SQL packages to group and contain related constructs.
Create triggers to solve business challenges.
Use some of the Oracle supplied PL/SQL packages to generate screen output and
file output.
Create custom packages for applications.
Write Dynamic SQL code for applications.
Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database
workloads, lower IT costs and deliver a higher quality of service by enabling consolidation
onto database clouds.
Use Oracle SQL Developer
You will use Oracle SQL Developer to develop these program units. SQL*Plus is introduced
in this course as optional tools.
Course Bundle
Note: This course is a combination of Oracle Database: PL/SQL Fundamentals and Oracle
Database: Develop PL/SQL Program Units courses.
Prerequisites
Suggested Prerequisite
Previous programming experience
Required Prerequisite
Oracle Database: Introduction to SQL
Objectives
Use conditional compilation to customize the functionality in a PL/SQL application
without removing any source code
Design PL/SQL packages to group related constructs
Create overloaded package subprograms for more flexibility
Design PL/SQL anonymous blocks that execute efficiently
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
Create and debug stored procedures and functions
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
Create triggers to solve business challenges
Topics
Introduction
o Course Objectives
o Course Agenda
o Describe the Human Resources (HR) Schema
o PL/SQL development environments available in this course
o Introduction to SQL Developer
Introduction to PL/SQL
o Overview of PL/SQL
o Identify the benefits of PL/SQL Subprograms
o Overview of the types of PL/SQL blocks
o Create a Simple Anonymous Block
o How to generate output from a PL/SQL Block?
Declare PL/SQL Identifiers
o List the different Types of Identifiers in a PL/SQL subprogram
o Usage of the Declarative Section to Define Identifiers
o Use variables to store data
o Identify Scalar Data Types
o The %TYPE Attribute
o What are Bind Variables?
o Sequences in PL/SQL Expressions
Write Executable Statements
o Describe Basic PL/SQL Block Syntax Guidelines
o Learn to Comment the Code
o Deployment of SQL Functions in PL/SQL
o How to convert Data Types?
o Describe Nested Blocks
o Identify the Operators in PL/SQL
Interaction with the Oracle Server
o Invoke SELECT Statements in PL/SQL
o Retrieve Data in PL/SQL
o SQL Cursor concept
o Avoid Errors by using Naming Conventions when using Retrieval and DML
Statements
o Data Manipulation in the Server using PL/SQL
o Understand the SQL Cursor concept
o Use SQL Cursor Attributes to Obtain Feedback on DML
o Save and Discard Transactions
Control Structures
o Conditional processing using IF Statements
o Conditional processing using CASE Statements
o Describe simple Loop Statement
o Describe While Loop Statement
o Describe For Loop Statement
o Use the Continue Statement
Composite Data Types
o Use PL/SQL Records
o The %ROWTYPE Attribute
o Insert and Update with PL/SQL Records
o INDEX BY Tables
o Examine INDEX BY Table Methods
o Use INDEX BY Table of Records
Explicit Cursors
o What are Explicit Cursors?
o Declare the Cursor
o Open the Cursor
o Fetch data from the Cursor
o Close the Cursor
o Cursor FOR loop
o The %NOTFOUND and %ROWCOUNT Attributes
o Describe the FOR UPDATE Clause and WHERE CURRENT Clause
Exception Handling
o Understand Exceptions
o Handle Exceptions with PL/SQL
o Trap Predefined Oracle Server Errors
o Trap Non-Predefined Oracle Server Errors
o Trap User-Defined Exceptions
o Propagate Exceptions
o RAISE_APPLICATION_ERROR Procedure
Stored Procedures
o Create a Modularized and Layered Subprogram Design
o Modularize Development With PL/SQL Blocks
o Understand the PL/SQL Execution Environment
o List the benefits of using PL/SQL Subprograms
o List the differences between Anonymous Blocks and Subprograms
o Create, Call, and Remove Stored Procedures
o Implement Procedures Parameters and Parameters Modes
o View Procedure Information
Stored Functions and Debugging Subprograms
Packages
Deploying Packages
Implement Oracle-Supplied Packages in Application Development
Dynamic SQL
Design Considerations for PL/SQL Code
Triggers
Creating Compound, DDL, and Event Database Triggers
PL/SQL Compiler
Manage Dependencies
3- Oracle Fusion Middleware 11g: Build Applications with Oracle Forms
This course is also suitable for customers using Forms 12c.
This Oracle Fusion Middleware 11g: Build Applications with Oracle Forms training explores
building Oracle Forms Builder 11g. Expert instructors will teach you how to create high-
performance applications for the Web that are also scalable.
Learn To:
Use Oracle Forms Builder 11g.
Enhance applications with various GUI controls.
Add functionality to applications by writing triggers.
Use the Forms Debugger to troubleshoot applications.
Validate user input and display meaningful error messages.
Use WebUtil to interact with client computers.
Validate user input, control navigation and display meaningful messages to users.
Use WebUtil to interact with the client machine and pass values from one form to
another.
Replace or supplement default transaction processing.
Benefits to You
When you walk away from this course, you will know how to build a sample Forms
application for an order entry system using a variety of GUI controls. You'll have the
knowledge and skills to enhance the appearance and functionality of the basic form by
using PL/SQL trigger, JavaBeans, and Pluggable Java Components.
Please Note:
Emphasis is placed on designing objects and code for reuse.
Prerequisites
Suggested Prerequisite
Experience in advanced SQL & PL/SQL
Required Prerequisite
Experience with SQL and PL/SQL basics
Objectives
Link one form module to another
Create form modules, including components for database interaction and GUI
controls
Display form modules in multiple windows and use a variety of layout styles
Test form modules in a Web browser
Debug form modules in a 3-tier environment
Implement triggers to enhance form functionality
Reuse objects and code
Topics
Running a Forms Application
Working in the Forms Builder Environment
Creating a Basic Form Module
Creating a Master-Detail Form
Working Data Blocks and Frames
Working with Text Items
Creating LOVs and Editors
Creating Additional Input Items
Creating Noninput Items
Creating Windows and Content Canvases
Working with Other Canvas Types
Producing and Debugging Triggers
Adding Functionality to Items
Displaying Run-Time Messages and Alerts
Using Query Triggers
Validating User Input
Controlling Navigation
Overriding or Supplementing Transaction Processing
Writing Flexible Code
Sharing Objects and Code
Using WebUtil to Interact with the Client
Introducing Multiple Form Applications
4- Oracle Reports Developer 10g: Build Reports
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 OracleAS Reports Services to deploy the
reports.
Prerequisites
Suggested Prerequisite
XML: Introduction or equivalent familiarity with basic XML
Audience
Developer
Implementer
Objectives
Use report parameters and customize a runtime parameter form
Enhance reports using graphs and PL/SQL trigger code
Maximize report performance using OracleAS 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
Topics
Introduction to Oracle Reports Developer
Designing and Running Reports
Exploring Oracle Reports Developer
Creating a Paper Report
Enhancing a Basic Paper Report
Managing Report Templates
Creating a Web Report
Enhancing Reports Using the Data Model: Queries and Groups
Enhancing Reports Using the Data Model: Data Sources
Enhancing Reports Using the Data Model: Creating Columns
Enhancing Reports Using the Paper Layout
Controlling the Paper Layout: Common Properties
Controlling the Paper Layout: Specific Properties
Web Reporting
Extending Functionality Using XML
Creating and Using Report Parameters
Embedding a Graph in a Report
Enhancing Matrix Reports
Coding PL/SQL Triggers
Extending Functionality Using the SRW Package
Maximizing Performance Using OracleAS Reports Services
Building Reports: Efficiency Guidelines
Terms and Conditions for Public Group:
1. Training Kits: The prices include the Oracle training kits from Oracle.
2. Number of attendees: Group Max 10 attendees
3. Certificates: After completion of course, students will receive a (Certificate of
Completion) from Global academy – Oracle Approved Education Partner.
4. Prices: The prices showed in proposal are in (EGP).
5. Payment: 100% two weeks prior the course start date.
6. Cancelation:
Global academy reserves the right to cancel or reschedule any course with
prior notice due to circumstances beyond its control without any liability on
its part.
Customers will be refunded for cancelled courses which they have already
prepaid upon request.
Cancellation requests must be sent by email at least 4 weeks before the
course start date, otherwise they will not refund the payment.
No course cancellations will be accepted within the 4 weeks before the
course start date.
7. No Show: will be due for payment in full and no refund.
