Oracle Database 12c: Using SQL to Query Your Database

• Using SQL in Oracle Database 12c
• Retrieving, Restricting and Sorting Data
• Using Single-Row Functions

Oracle Database 12c: Conversion Functions, Group Functions, and Joins

• Conversion Functions and Conditional Expressions
• Group Functions and Joins

Oracle Database 12c: Subqueries, Set Operators, and Data Manipulation

• Using Subqueries and Set Operators
• Manipulating Data

Oracle Database 12c: Using DDL, Views, Sequences, Indexes, and Synonyms

• Using DDL Statements to Create and Manage Tables
• Creating Other Schema Objects

Oracle Database 12c: Controlling User Access and Managing Schema Objects

• Controlling User Access
• Managing Schema Objects

Oracle Database 12c: Data Dictionary Views and Large Data Sets

• Managing Objects with Data Dictionary Views
• Manipulating Large Data Sets

Oracle Database 12c: Managing Data in Different Time Zones

• Using Time Zones and Datetime Functions

Oracle Database 12c: Using Subqueries and Regular Expressions

• Retrieving Data Using Subqueries
• Using Regular Expressions

Introduction

• Overview of Oracle Database 12c and related products
• Overview of relational database management concepts and terminologies
• Introduction to SQL and its development environments
• The HR schema and the tables used in this course
• Oracle Database documentation and additional resources

Retrieve Data using the SQL SELECT Statement

• List the capabilities of SQL SELECT statements
• Generate a report of data from the output of a basic SELECT statement
• Use arithmetic expressions and NULL values in the SELECT statement
• Invoke Column aliases
• Concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
• Display the table structure using the DESCRIBE command

Restricted and Sorted Data

• Write queries with a WHERE clause to limit the output retrieved
• Describe the comparison operators and logical operators
• Describe the rules of precedence for comparison and logical operators
• Usage of character string literals in the WHERE clause
• Write queries with an ORDER BY clause
• Sort the output in descending and ascending order
• Substitution Variables

Usage of Single-Row Functions to Customize Output

• List the differences between single row and multiple row functions
• Manipulate strings using character functions
• Manipulate numbers with the ROUND, TRUNC, and MOD functions
• Perform arithmetic with date data
• Manipulate dates with the DATE functions

Conversion Functions and Conditional Expressions

• Describe implicit and explicit data type conversion
• Describe the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Nesting multiple functions
• Apply the NVL, NULLIF, and COALESCE functions to data
• Usage of conditional IF THEN ELSE logic in a SELECT statement

Aggregated Data Using the Group Functions

• Usage of the aggregation functions in SELECT statements to produce meaningful reports
• Describe the AVG, SUM, MIN, and MAX function
• How to handle Null Values in a group function?
• Divide the data in groups by using the GROUP BY clause
• Exclude groups of date by using the HAVING clause

Display Data From Multiple Tables

• Write SELECT statements to access data from more than one table
• Join Tables Using SQL:1999 Syntax
• View data that does not meet a join condition by using outer joins
• Join a table to itself by using a self join
• Create Cross Joins

Usage of Subqueries to Solve Queries

• Use a Subquery to Solve a Problem
• Single-Row Subqueries
• Group Functions in a Subquery
• Multiple-Row Subqueries
• Use the ANY and ALL Operator in Multiple-Row Subqueries
• Use the EXISTS Operator

SET Operators

• Describe the SET operators
• Use a SET operator to combine multiple queries into a single query
• Describe the UNION, UNION ALL, INTERSECT, and MINUS Operators
• Use the ORDER BY Clause in Set Operations

Data Manipulation

• Add New Rows to a Table
• Change the Data in a Table
• Use the DELETE and TRUNCATE Statements
• How to save and discard changes with the COMMIT and ROLLBACK statements
• Implement Read Consistency
• Describe the FOR UPDATE Clause

DDL Statements to Create and Manage Tables

• Categorize Database Objects
• Create Tables
• Describe the data types
• Understand Constraints
• Create a table using a subquery
• How to alter a table?
• How to drop a table?

Other Schema Objects

• Create, modify, and retrieve data from a view
• Perform Data manipulation language (DML) operations on a view
• How to drop a view?
• Create, use, and modify a sequence
• Create and drop indexes
• Create and drop synonyms

Introduction to PL/SQL

• PL/SQL Overview
• List the benefits of PL/SQL Subprograms
• Overview of the Types of PL/SQL blocks
• Create a Simple Anonymous Block
• Generate the Output from a PL/SQL Block

PL/SQL Identifiers

• List the different Types of Identifiers in a PL/SQL subprogram
• Usage of the Declarative Section to Define Identifiers
• Use of variables to store data
• Scalar Data Types
• %TYPE Attribute
• Bind Variables
• Sequences in PL/SQL Expressions

Write Executable Statements

• Basic PL/SQL Block Syntax Guidelines
• How to comment code?
• SQL Functions in PL/SQL
• Data Type Conversion
• Nested Blocks
• Operators in PL/SQL

Interaction with the Oracle Server

• SELECT Statements in PL/SQL to Retrieve data
• Data Manipulation in the Server Using PL/SQL
• The SQL Cursor concept
• Learn to use SQL Cursor Attributes to Obtain Feedback on DML
• How to save and discard transactions?

Control Structures

• Conditional processing Using IF Statements
• Conditional processing Using CASE Statements
• Simple Loop Statement
• While Loop Statement
• For Loop Statement
• The Continue Statement

Usage of Composite Data Types

• PL/SQL Records
• The %ROWTYPE Attribute
• Insert and Update with PL/SQL Records
• Associative Arrays (INDEX BY Tables)
• INDEX BY Table Methods
• INDEX BY Table of Records

Explicit Cursors

• Understand Explicit Cursors
• Declare the Cursor
• How to open the Cursor?
• Fetching data from the Cursor
• How to close the Cursor?
• Cursor FOR loop
• Explicit Cursor Attributes
• FOR UPDATE Clause and WHERE CURRENT Clause

Exception Handling

• What are Exceptions?
• Handle Exceptions with PL/SQL
• Trap Predefined Oracle Server Errors
• Trap Non-Predefined Oracle Server Errors
• Trap User-Defined Exceptions
• Propagate Exceptions
• RAISE_APPLICATION_ERROR Procedure

Stored Procedures and Functions

• What are Stored Procedures and Functions?
• Differentiate between anonymous blocks and subprograms
• Create a Simple Procedure
• Create a Simple Procedure with IN parameter
• Create a Simple Function
• Execute a Simple Procedure
• Execute a Simple Function

Architecture, SQL Tuning, and Optimization

• Database Architecture and SQL Tuning
• SQL Processing and the Optimizer

Indexes, Access Paths, and Join Operations

• Table Scans, Indexes, Access Paths, and Joins

Execution Plans and Star Transformations

• Interpreting Execution Plans
• Understanding Star Transformation

Optimizer Statistics, Hints, and Cursor Sharing

• Optimizer Statistics
• Bind Variables, Cursor Sharing, and Optimizer Hints

Application Tracing and Automatic SQL Tuning

• Application Tracing, Trace Files, and the tkprof Utility
• Automatic SQL Tuning

Introduction

• Course objectives
• Course agenda
• Tables and data used for this course
• Overview of the development environments: SQL Developer, SQL Plus

PL/SQL Programming Concepts Review

• Identify PL/SQL block structure
• Create procedures
• Create functions
• List restrictions and guidelines on calling functions from SQL expressions
• Create packages
• Review of implicit and explicit cursors
• List exception syntax
• Identify the Oracle supplied packages

Designing PL/SQL Code

• Describe the predefined data types
• Create subtypes based on existing types for an application
• List the different guidelines for cursor design
• Cursor variables

Using Collections

• Overview of collections
• Use Associative arrays
• Use Nested tables
• Use VARRAYs
• Compare nested tables and VARRAYs
• Write PL/SQL programs that use collections
• Use Collections effectively

Manipulating Large Objects

• Describe a LOB object
• Use BFILEs
• Use DBMS_LOB.READ and DBMS_LOB.WRITE to manipulate LOBs
• Create a temporary LOB programmatically with the DBMS_LOB package
• Introduction to SecureFile LOBs
• Use SecureFile LOBs to store documents
• Convert BasicFile LOBs to SecureFile LOB format
• Enable reduplication and compression

Using Advanced Interface Methods

• Calling External Procedures from PL/SQL
• Benefits of External Procedures
• C advanced interface methods
• Java advanced interface methods

Performance and Tuning

• Understand and influence the compiler
• Tune PL/SQL code
• Enable intra unit inlining
• Identify and tune memory issues
• Recognize network issues

Improving Performance with Caching

• Describe result caching
• Use SQL query result cache
• PL/SQL function cache
• Review PL/SQL function cache considerations

Analyzing PL/SQL Code

• Finding Coding Information
• Using DBMS_DESCRIBE
• Using ALL_ARGUMENTS
• Using DBMS_UTILITY.FORMAT_CALL_STACK
• Collecting PL/Scope Data
• The USER/ALL/DBA_IDENTIFIERS Catalog View
• DBMS_METADATA Package

Profiling and Tracing PL/SQL Code

• Tracing PL/SQL Execution
• Tracing PL/SQL: Steps

Implementing VPD with Fine-Grained Access Control

• Understand how fine-grained access control works overall
• Describe the features of fine-grained access control
• Describe an application context
• Create an application context
• Set an application context
• List the DBMS_RLS procedures
• Implement a policy
• Query the dictionary views holding information on fine-grained access

Safeguarding Your Code Against SQL Injection Attacks

• SQL Injection Overview
• Reducing the Attack Surface
• Avoiding Dynamic SQL
• Using Bind Arguments
• Filtering Input with DBMS_ASSERT
• Designing Code Immune to SQL Injections
• Testing Code for SQL Injection Flaws

Architecture, SQL Tuning, and Optimization

• Database Architecture and SQL Tuning
• SQL Processing and the Optimizer

Indexes, Access Paths, and Join Operations

• Table Scans, Indexes, Access Paths, and Joins

Execution Plans and Star Transformations

• Interpreting Execution Plans
• Understanding Star Transformation

Optimizer Statistics, Hints, and Cursor Sharing

• Optimizer Statistics
• Bind Variables, Cursor Sharing, and Optimizer Hints

Application Tracing and Automatic SQL Tuning

• Application Tracing, Trace Files, and the tkprof Utility
• Automatic SQL Tuning

Introduction

• Course Objectives, Course Agenda and Appendixes Used in this Course
• Audience and Prerequisites
• Sample Schemas Used in the Course
• Class Account Information
• SQL Environments Available in the Course
• Workshops, Demo Scripts, and Code Example Scripts
• Appendices in the Course

Introduction to SQL Tuning

• SQL Tuning Session
• SQL Tuning Strategies
• Development Environments: Overview
• SQLTXPLAIN (SQLT) Diagnostic Tool

Using Application Tracing Tools

• Using the SQL Trace Facility: Overview
• Steps Needed Before Tracing
• Available Tracing Tools: Overview
• The trcsess Utility
• Formatting SQL Trace Files: Overview

Understanding Basic Tuning Techniques

• Developing Efficient SQL statement
• Scripts Used in This Lesson
• Table Design
• Index Usage
• Transformed Index
• Data Type Mismatch
• NULL usage
• Tune the ORDER BY Clause

Optimizer Fundamentals

• SQL Statement Representation
• SQL Statement Processing
• Why Do You Need an Optimizer?
• Components of the Optimizer
• Query Transformer
• Cost-Based Optimizer
• Adaptive Query Optimization
• Optimizer Features and Oracle Database Releases

Generating and Displaying Execution Plans

• Execution Plan?
• The EXPLAIN PLAN Command
• Plan Table
• AUTOTRACE
• V$SQL_PLAN View
• Automatic Workload Repository
• SQL Monitoring

Interpreting Execution Plans and Enhancements

• Interpreting a Serial Execution Plan
• Adaptive Optimizations

Optimizer: Table and Index Access Paths

• Row Source Operations
• Main Structures and Access Paths
• Full Table Scan
• Indexes
• Common Observations

Optimizer Join Operations

• Join Methods
• Join Types

Other Optimizer Operators

• SQL operators
• Other N-Array Operations
• Result Cache operators

Introduction to Optimizer Statistics Concepts

• Optimizer Statistics
• Types of Optimizer Statistics
• Gather and Manage Optimizer Statistics: Overview

Using Bind Variables

• Cursor Sharing and Different Literal Values
• Cursor Sharing and Bind Variables

SQL Plan Management

• Maintaining SQL Performance
• SQL Plan Management

Workshops

• Workshop 1
• Workshop 2
• Workshop 3
• Workshop 4
• Workshop 5
• Workshop 6 & 7
• Workshop 8
• Workshop 9

Introduction

• Overview of Oracle Database 12c and related products
• Overview of relational database management concepts and terminologies
• Introduction to SQL and its development environments
• The HR schema and the tables used in this course
• Oracle Database documentation and additional resources

Retrieve Data using the SQL SELECT Statement

• List the capabilities of SQL SELECT statements
• Generate a report of data from the output of a basic SELECT statement
• Use arithmetic expressions and NULL values in the SELECT statement
• Invoke Column aliases
• Concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
• Display the table structure using the DESCRIBE command

Restricted and Sorted Data

• Write queries with a WHERE clause to limit the output retrieved
• Describe the comparison operators and logical operators
• Describe the rules of precedence for comparison and logical operators
• Usage of character string literals in the WHERE clause
• Write queries with an ORDER BY clause
• Sort the output in descending and ascending order
• Substitution Variables

Usage of Single-Row Functions to Customize Output

• List the differences between single row and multiple row functions
• Manipulate strings using character functions
• Manipulate numbers with the ROUND, TRUNC, and MOD functions
• Perform arithmetic with date data
• Manipulate dates with the DATE functions

Conversion Functions and Conditional Expressions

• Describe implicit and explicit data type conversion
• Describe the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Nesting multiple functions
• Apply the NVL, NULLIF, and COALESCE functions to data
• Usage of conditional IF THEN ELSE logic in a SELECT statement

Aggregated Data Using the Group Functions

• Usage of the aggregation functions in SELECT statements to produce meaningful reports
• Describe the AVG, SUM, MIN, and MAX function
• How to handle Null Values in a group function?
• Divide the data in groups by using the GROUP BY clause
• Exclude groups of date by using the HAVING clause

Display Data From Multiple Tables

• Write SELECT statements to access data from more than one table
• Join Tables Using SQL:1999 Syntax
• View data that does not meet a join condition by using outer joins
• Join a table to itself by using a self join
• Create Cross Joins

Usage of Subqueries to Solve Queries

• Use a Subquery to Solve a Problem
• Single-Row Subqueries
• Group Functions in a Subquery
• Multiple-Row Subqueries
• Use the ANY and ALL Operator in Multiple-Row Subqueries
• Use the EXISTS Operator

SET Operators

• Describe the SET operators
• Use a SET operator to combine multiple queries into a single query
• Describe the UNION, UNION ALL, INTERSECT, and MINUS Operators
• Use the ORDER BY Clause in Set Operations

Data Manipulation

• Add New Rows to a Table
• Change the Data in a Table
• Use the DELETE and TRUNCATE Statements
• How to save and discard changes with the COMMIT and ROLLBACK statements
• Implement Read Consistency
• Describe the FOR UPDATE Clause

DDL Statements to Create and Manage Tables

• Categorize Database Objects
• Create Tables
• Describe the data types
• Understand Constraints
• Create a table using a subquery
• How to alter a table?
• How to drop a table?

Other Schema Objects

• Create, modify, and retrieve data from a view
• Perform Data manipulation language (DML) operations on a view
• How to drop a view?
• Create, use, and modify a sequence
• Create and drop indexes
• Create and drop synonyms

Introduction to PL/SQL

• PL/SQL Overview
• List the benefits of PL/SQL Subprograms
• Overview of the Types of PL/SQL blocks
• Create a Simple Anonymous Block
• Generate the Output from a PL/SQL Block

PL/SQL Identifiers

• List the different Types of Identifiers in a PL/SQL subprogram
• Usage of the Declarative Section to Define Identifiers
• Use of variables to store data
• Scalar Data Types
• %TYPE Attribute
• Bind Variables
• Sequences in PL/SQL Expressions

Write Executable Statements

• Basic PL/SQL Block Syntax Guidelines
• How to comment code?
• SQL Functions in PL/SQL
• Data Type Conversion
• Nested Blocks
• Operators in PL/SQL

Interaction with the Oracle Server

• SELECT Statements in PL/SQL to Retrieve data
• Data Manipulation in the Server Using PL/SQL
• The SQL Cursor concept
• Learn to use SQL Cursor Attributes to Obtain Feedback on DML
• How to save and discard transactions?

Control Structures

• Conditional processing Using IF Statements
• Conditional processing Using CASE Statements
• Simple Loop Statement
• While Loop Statement
• For Loop Statement
• The Continue Statement

Usage of Composite Data Types

• PL/SQL Records
• The %ROWTYPE Attribute
• Insert and Update with PL/SQL Records
• Associative Arrays (INDEX BY Tables)
• INDEX BY Table Methods
• INDEX BY Table of Records

Explicit Cursors

• Understand Explicit Cursors
• Declare the Cursor
• How to open the Cursor?
• Fetching data from the Cursor
• How to close the Cursor?
• Cursor FOR loop
• Explicit Cursor Attributes
• FOR UPDATE Clause and WHERE CURRENT Clause

Exception Handling

• What are Exceptions?
• Handle Exceptions with PL/SQL
• Trap Predefined Oracle Server Errors
• Trap Non-Predefined Oracle Server Errors
• Trap User-Defined Exceptions
• Propagate Exceptions
• RAISE_APPLICATION_ERROR Procedure

Stored Procedures and Functions

• What are Stored Procedures and Functions?
• Differentiate between anonymous blocks and subprograms
• Create a Simple Procedure
• Create a Simple Procedure with IN parameter
• Create a Simple Function
• Execute a Simple Procedure
• Execute a Simple Function

Introduction

• Course Objectives
• Course Agenda
• Describe the Human Resources (HR) Schema
• PL/SQL development environments available in this course
• Introduction to SQL Developer

Introduction to PL/SQL

• Overview of PL/SQL
• Identify the benefits of PL/SQL Subprograms
• Overview of the types of PL/SQL blocks
• Create a Simple Anonymous Block
• How to generate output from a PL/SQL Block?

Declare PL/SQL Identifiers

• List the different Types of Identifiers in a PL/SQL subprogram
• Usage of the Declarative Section to Define Identifiers
• Use variables to store data
• Identify Scalar Data Types
• The %TYPE Attribute
• What are Bind Variables?
• Sequences in PL/SQL Expressions

Write Executable Statements

• Describe Basic PL/SQL Block Syntax Guidelines
• Learn to Comment the Code
• Deployment of SQL Functions in PL/SQL
• How to convert Data Types?
• Describe Nested Blocks
• Identify the Operators in PL/SQL

Interaction with the Oracle Server

• Invoke SELECT Statements in PL/SQL
• Retrieve Data in PL/SQL
• SQL Cursor concept
• Avoid Errors by using Naming Conventions when using Retrieval and DML Statements
• Data Manipulation in the Server using PL/SQL
• Understand the SQL Cursor concept
• Use SQL Cursor Attributes to Obtain Feedback on DML
• Save and Discard Transactions

Control Structures

• Conditional processing using IF Statements
• Conditional processing using CASE Statements
• Describe simple Loop Statement
• Describe While Loop Statement
• Describe For Loop Statement
• Use the Continue Statement

Composite Data Types

• Use PL/SQL Records
• The %ROWTYPE Attribute
• Insert and Update with PL/SQL Records
• INDEX BY Tables
• Examine INDEX BY Table Methods
• Use INDEX BY Table of Records

Explicit Cursors

• What are Explicit Cursors?
• Declare the Cursor
• Open the Cursor
• Fetch data from the Cursor
• Close the Cursor
• Cursor FOR loop
• The %NOTFOUND and %ROWCOUNT Attributes
• Describe the FOR UPDATE Clause and WHERE CURRENT Clause

Exception Handling

• Understand Exceptions
• Handle Exceptions with PL/SQL
• Trap Predefined Oracle Server Errors
• Trap Non-Predefined Oracle Server Errors
• Trap User-Defined Exceptions
• Propagate Exceptions
• RAISE_APPLICATION_ERROR Procedure

Stored Procedures

• Create a Modularized and Layered Subprogram Design
• Modularize Development With PL/SQL Blocks
• Understand the PL/SQL Execution Environment
• List the benefits of using PL/SQL Subprograms
• List the differences between Anonymous Blocks and Subprograms
• Create, Call, and Remove Stored Procedures
• Implement Procedures Parameters and Parameters Modes
• View Procedure Information

Stored Functions and Debugging Subprograms

• Create, Call, and Remove a Stored Function
• Identify the advantages of using Stored Functions
• Identify the steps to create a stored function
• Invoke User-Defined Functions in SQL Statements
• Restrictions when calling Functions
• Control side effects when calling Functions
• View Functions Information
• How to debug Functions and Procedures?

Packages

• Listing the advantages of Packages
• Describe Packages
• What are the components of a Package?
• Develop a Package
• How to enable visibility of a Package’s Components?
• Create the Package Specification and Body using the SQL CREATE Statement and SQL Developer
• Invoke the Package Constructs
• View the PL/SQL Source Code using the Data Dictionary

Deploying Packages

• Overloading Subprograms in PL/SQL
• Use the STANDARD Package
• Use Forward Declarations to solve Illegal Procedure Reference
• Implement Package Functions in SQL and Restrictions
• Persistent State of Packages
• Persistent State of a Package Cursor
• Control side effects of PL/SQL Subprograms
• Invoke PL/SQL Tables of Records in Packages

Implement Oracle-Supplied Packages in Application Development

• What are Oracle-Supplied Packages?
• Examples of some of the Oracle-Supplied Packages
• How does the DBMS_OUTPUT Package work?
• Use the UTL_FILE Package to Interact with Operating System Files
• Invoke the UTL_MAIL Package
• Write UTL_MAIL Subprograms

Dynamic SQL

• The Execution Flow of SQL
• What is Dynamic SQL?
• Declare Cursor Variables
• Dynamically Executing a PL/SQL Block
• Configure Native Dynamic SQL to Compile PL/SQL Code
• How to invoke DBMS_SQL Package?
• Implement DBMS_SQL with a Parameterized DML Statement
• Dynamic SQL Functional Completeness

Design Considerations for PL/SQL Code

• Standardize Constants and Exceptions
• Understand Local Subprograms
• Write Autonomous Transactions
• Implement the NOCOPY Compiler Hint
• Invoke the PARALLEL_ENABLE Hint
• The Cross-Session PL/SQL Function Result Cache
• The DETERMINISTIC Clause with Functions
• Usage of Bulk Binding to Improve Performance

Triggers

• Describe Triggers
• Identify the Trigger Event Types and Body
• Business Application Scenarios for Implementing Triggers
• Create DML Triggers using the CREATE TRIGGER Statement and SQL Developer
• Identify the Trigger Event Types, Body, and Firing (Timing)
• Differences between Statement Level Triggers and Row Level Triggers
• Create Instead of and Disabled Triggers
• How to Manage, Test and Remove Triggers?

Creating Compound, DDL, and Event Database Triggers

• What are Compound Triggers?
• Identify the Timing-Point Sections of a Table Compound Trigger
• Understand the Compound Trigger Structure for Tables and Views
• Implement a Compound Trigger to Resolve the Mutating Table Error
• Comparison of Database Triggers to Stored Procedures
• Create Triggers on DDL Statements
• Create Database-Event and System-Events Triggers
• System Privileges Required to Manage Triggers

PL/SQL Compiler

• What is the PL/SQL Compiler?
• Describe the Initialization Parameters for PL/SQL Compilation
• List the new PL/SQL Compile Time Warnings
• Overview of PL/SQL Compile Time Warnings for Subprograms
• List the benefits of Compiler Warnings
• List the PL/SQL Compile Time Warning Messages Categories
• Setting the Warning Messages Levels: Using SQL Developer, PLSQL_WARNINGS Initialization Parameter, and the DBMS_WARNING Package Subprograms
• View Compiler Warnings: Using SQL Developer, SQL*Plus, or the Data Dictionary Views

Manage Dependencies

• Overview of Schema Object Dependencies
• Query Direct Object Dependencies using the USER_DEPENDENCIES View
• Query an Object’s Status
• Invalidation of Dependent Objects
• Display the Direct and Indirect Dependencies
• Fine-Grained Dependency Management in Oracle Database 12c
• Understand Remote Dependencies
• Recompile a PL/SQL Program Unit

Introducing the Java Technology

• Relating Java with other languages
• Showing how to download, install, and configure the Java environment on a Windows system.
• Describing the various Java technologies such as Java EE, JavaME, Embedded Java SE
• Describing key features of the technology and the advantages of using Java
• Using an Integrated Development Environment (IDE)

Thinking in Objects

• Defining the problem domain
• Identifying objects and recognizing the criteria for defining objects

Introducing the Java Language

• Defining classes
• Identifying the components of a class
• Creating and using a test class
• Compiling and executing a test program

Working with Primitive Variables

• Declaring and initializing field variables
• Describing primitive data types such as integral, floating point, textual, and logical
• Declaring variables and assigning values
• Using constants
• Using arithmetic operators to modify values

Working with Objects

• Declaring and initializing objects
• Storing objects in memory
• Using object references to manipulate data
• Using JSE javadocs to look up the methods of a class
• Working with String and StringBuilder objects

Using operators and decision constructs

• Using relational and conditional operators
• Testing equality between strings
• Evaluating different conditions in a program and determining the algorithm
• Creating if and if/else constructs
• Nesting and chaining conditional statements
• Using a switch statement

Creating and Using Arrays

• Declaring, instantiating, and initializing a one-dimensional Array
• Declaring, instantiating, and initializing a two-dimensional Array
• Using a for loop to process an Array
• Creating and initializing an ArrayList
• Using the import statement to work with existing Java APIs
• Accessing a value in an Array or and ArrayList
• Using the args Array

Using Loop Constructs

• Creating while loops and nested while loops
• Developing a for loop
• Using ArrayLists with for loops
• Developing a do while loop
• Understanding variable scope

Working with Methods and Method Overloading

• Creating and Invoking a Method
• Passing arguments and returning values
• Creating static methods and variables
• Using modifiers
• Overloading a method

Using Encapsulation and Constructors

• Creating constructors
• Implementing encapsulation

Introducing Advanced Object Oriented Concepts

• Using inheritance
• Using types of polymorphism such as overloading, overriding, and dynamic binding
• Working with superclasses and subclasses
• Adding abstraction to your analysis and design
• Understanding the purpose of Java interfaces
• Creating and implementing a Java interface

Handling Errors

• Understanding the different kinds of errors that can occur and how they are handled in Java
• Understanding the different kinds of Exceptions in Java
• Using Javadocs to research the Exceptions thrown by the methods of foundation classes
• Writing code to handle Exceptions

The Big Picture

• Creating packages and JAR files for deployment using java
• Two and three tier architectures
• Looking at some Java applications examples

Java Platform Overview

• Introductions
• Course Schedule
• Java Overview
• Java Platforms
• OpenJDK
• Licensing
• Java in Server Environments
• The Java Community Process

Java Syntax and Class Review

• Simple Java classes
• Java fields, constructors and methods
• Model objects using Java classes
• Package and import statements

Encapsulation and Polymorphism

• Encapsulation in Java class design
• Model business problems with Java classes
• Immutability
• Subclassing
• Overloading methods
• Variable argument methods

Java Class Design

• Access modifiers: private, protected and public
• Method overriding
• Constructor overloading
• The instanceof operator
• Virtual method invocation
• Polymorphism
• Casting object references
• Overriding Object methods

Advanced Class Design

• Abstract classes and type generalization
• The static and final modifiers
• Field modifier best practices
• The Singleton design pattern
• Designing abstract classes
• Nested classes
• Enumerated types

Inheritance with Java Interfaces

• Java Interfaces
• Types of Inheritance
• Object composition and method delegation
• Implementing multiple interfaces
• The DAO design pattern

Generics and Collections

• Generic classes and type parameters
• Type inference (diamond)
• Collections and generics
• List, set and Map
• Stack and Deque

String processing

• String manipulation with StringBuilder and StringBuffer
• Essential String methods
• Text parsing in Java
• Input processing with Scanner
• Text output and formatting
• Regular expressions with the Pattern and Matcher classes

Exceptions and Assertions

• Exceptions categories
• Standard Java Exception classes
• Creating your own Exception classes
• Using try-catch and the finally clause
• Using try-with-resources and the AutoCloseable interface
• The multi-catch feature
• Best practices using exceptions
• Assertions

I/O Fundamentals

• I/O using Java
• Reading the console input stream
• Writing to the console
• Using I/O Streams
• Chaining I/O Streams
• Channel I/O
• Reading and writing objects using Serialization

File I/O with NIO 2

• The Path interface
• The Files class
• Directory and File operations
• Managing file system attributes
• Reading, writing, and creating files
• Watching for file system changes

Threading

• Operating system task scheduling
• Recognizing multithreaded environments
• Creating multi-threaded solutions
• Sharing data across threads
• Synchronization and Deadlock
• Immutable objects

Concurrency

• Creating Atomic variables
• Using Read-Write Locks
• Thread-safe collections
• Concurrenct synchronizers (Semaphore, Phaser, and others)
• Executors and ThreadPools to concurrently schedule tasks
• Parallelism and the Fork-Join framework

Database Application with JDBC

• Layout of the JDBC API
• JDBC divers
• Queries and results
• PreparedStatement and CallableStatement
• Transactions
• RowSet 1.1 RowSetProvider and RowSetFactory
• The DAO Pattern and JDBC

Localization

• Advantages of localization
• Defining locale
• Read and set locale using the Locale object
• Resource bundles
• Format messages, dates and numbers

Survey of Java EE Technologies

• Describe the different Java platforms and versions
• Describe the needs of enterprise applications
• Introduce the Java EE APIs and services
• Certifications Paths
• Introducing Applications Servers
• Enterprise Modules

Enterprise Application Architecture

• Design Patterns
• Model View Controller
• Synchronous and Asynchronous communication
• Network Topologies and Clustering
• Layering (client,presentation,service,integration,persistence)

Web Technology Overview

• Describe the role of web components in a Java EE application
• Define the HTTP request-response model
• Compare Java servlets, JSP, and JSF
• Brief introduction to technologies not covered in detail

Developing Servlets

• Describe the servlet API
• Servlet configuration through annotations and deployment descriptors
• Use the request and response APIs
• Servlets as controllers

Developing With JavaServer Pages Technology

• Evaluate the role of JSP technology as a presentation mechanism
• Author JSP pages
• Process data received from servlets in a JSP page
• Brief introduction to the JSTL and EL

JavaServer Faces

• The JSF model explained
• Adding JSF support to web applications
• Using the JSF tag libraries
• Configuring JSF page navigation
• JSF Managed beans
• JSF Conversion, Validation, and Error Handling

EJB Overview

• EJB types: Session Beans
• EJB types:Message Driven beans
• Java Persistence API as a replacement for Entity EJBs
• Describe the role of EJBs in a Java EE application
• EJB lite

Implementing EJB 3.0 Session Beans

• Compare stateless and stateful behavior
• Describe the operational characteristics of a stateless session bean
• Describe the operational characteristics of a stateful session bean
• Describe the operational characteristics of a singleton session bean
• Create session beans
• Package and deploy session beans
• Create session bean clients

The Java Persistence API

• The role of the Java Persistence API in a Java EE application
• Object Relational Mapping
• Entity class creation
• Using the EntityManager API
• The life cycle and operational characteristics of Entity components
• Persistent Units and Packaging

Implementing a Transaction Policy

• Describe transaction semantics
• Compare programmatic and declarative transaction scoping
• Use the Java Transaction API (JTA) to scope transactions programmatically
• Implement a container-managed transaction policy
• Support optimistic locking with the versioning of entity components
• Support pessimistic locking of entity components
• Using transactions with the web profile

Developing Asynchronous Java EE Applications and Messaging

• The need for asynchronous execution
• JMS technology introduction
• List the capabilities and limitations of Java EE components as messaging producers and consumers
• JMS and transactions
• JMS administration

Developing Message-Driven Beans

• Describe the properties and life cycle of message-driven beans
• Create a JMS message-driven bean

Web Service Model

• Describe the role of web services
• Web service models
• List the specifications used to make web services platform independent
• Describe the Java APIs used for XML processing and web services

Implementing Java EE Web Services with JAX-WS and JAX-RS

• Describe endpoints supported by the Java EE 6 platform
• Developing Web Services with Java
• Creating Web Service Clients with Java

Implementing a Security Policy

• Exploit container-managed security
• Define user roles and responsibilities
• Create a role-based security policy
• Use the security API
• Configure authentication in the web tier

Examining Object-Oriented Concepts and Terminology

• Describe the important object-oriented (OO) concepts
• Describe the fundamental OO terminology

Introducing Modeling and the Software Development Process

• Describe the Object-Oriented Software Development (OOSD) process
• Describe how modeling supports the OOSD process
• Describe the benefits of modeling software
• Explain the purpose, activities, and artifacts of the following OOSD workflows (disciplines): Requirements Gathering, Requirements Analysis, Architecture, Design, Implementation, Testing & Deployment

Creating Use Case Diagrams

• Justify the need for a Use Case diagram
• Identify and describe the essential elements in a UML Use Case diagram
• Develop a Use Case diagram for a software system based on the goals of the business owner
• Develop elaborated Use Case diagrams based on the goals of all the stakeholders
• Recognize and document use case dependencies using UML notation for extends, includes, and generalization
• Describe how to manage the complexity of Use Case diagrams by creating UML packaged views

Creating Use Case Scenarios and Forms

• Identify and document scenarios for a use case
• Create a Use Case form describing a summary of the scenarios in the main and alternate flows
• Describe how to reference included and extending use cases.
• Identify and document non-functional requirements (NFRs), business rules, risks, and priorities for a use case
• Identify the purpose of a Supplementary Specification Document

Creating Activity Diagrams

• Identify the essential elements in an Activity diagram
• Model a Use Case flow of events using an Activity diagram

Determining the Key Abstractions

• Identify a set of candidate key abstractions
• Identify the key abstractions using CRC analysis

Constructing the Problem Domain Model

• Identify the essential elements in a UML Class diagram
• Construct a Domain model using a Class diagram
• Identify the essential elements in a UML Object diagram
• Validate the Domain model with one or more Object diagrams

Transitioning from Analysis to Design using Interaction Diagrams

• Explain the purpose and elements of the Design model
• Identify the essential elements of a UML Communication diagram
• Create a Communication diagram view of the Design model
• Identify the essential elements of a UML Sequence diagram
• Create a Sequence diagram view of the Design model

Modeling Object State Using State Machine Diagrams

• Model object state
• Describe the essential elements of a UML State Machine diagram

Applying Design Patterns to the Design Model

• Define the essential elements of a software pattern
• Describe the Composite pattern
• Describe the Strategy pattern
• Describe the Observer pattern
• Describe the Abstract Factory pattern

Introducing Architectural Concepts and Diagrams

• Distinguish between architecture and design
• Describe tiers, layers, and systemic qualities
• Describe the Architecture workflow
• Describe the diagrams of the key architecture views
• Select the Architecture type
• Create the Architecture workflow artifacts

Introducing the Architectural Tiers

• Describe the concepts of the Client and Presentation tiers
• Describe the concepts of the Business tier
• Describe the concepts of the Resource and Integration tiers
• Describe the concepts of the Solution model

Refining the Class Design Model

• Refine the attributes of the Domain model
• Refine the relationships of the Domain model
• Refine the methods of the Domain model
• Declare the constructors of the Domain model
• Annotate method behavior
• Create components with interfaces

Overview of Software Development Processes

• Explain the best practices for OOSD methodologies
• Describe the features of several common methodologies
• Choose a methodology that best suits your project
• Develop an iteration plan

Overview of Frameworks

• Define a framework
• Describe the advantages and disadvantages of using frameworks
• Identify several common frameworks
• Understand the concept of creating your own business domain frameworks

Course Review

• Review the key features of object orientation
• Review the key UML diagrams
• Review the Requirements Analysis (Analysis) and Design workflows

Running a Forms Application

• Running a Form
• Identifying the Data Elements
• Navigating a Forms Application
• Using the Modes of Operation
• Querying Data
• Inserting, Updating, and Deleting Records
• Saving Changes
• Displaying Errors

Working in the Forms Builder Environment

• Forms Builder Key Features
• Forms Builder Components
• Navigating the Forms Builder Interface
• Forms Builder Module Object Hierarchy
• Customizing Your Forms Builder Session
• Forms Executables and Module Types
• Defining Environment Variables
• Testing a Form with the Run Form Button

Creating a Basic Form Module

• Creating a New Form Module
• Creating a New Data Bock
• Using Template Forms
• Saving and Compiling a Form Module
• Module Types and Storage Formats
• Deploying a Form Module
• Producing Documentation

Creating a Master-Detail Form

• Creating Data Blocks with Relationships
• Running a Master-Detail Form Module
• Modifying the Structure of a Data Block
• Modifying the Layout of a Data Block

Working Data Blocks and Frames

• Managing Object Properties
• Creating Visual Attributes
• Controlling the Behavior and Appearance of Data Blocks
• Controlling Frame Properties
• Displaying Multiple Property Palettes
• Setting Properties on Multiple Objects
• Copying Properties
• Creating Control Blocks

Working with Text Items

• Creating a Text Item
• Modifying the Appearance of a Text Item
• Controlling the Data of a Text Item
• Altering the Navigational Behavior of a Text Item
• Enhancing the Relationship between Text Item and Database
• Adding Functionality to a Text Item
• Displaying Helpful Messages

Creating LOVs and Editors

• LOVs and Record Groups
• Creating an LOV Manually
• Using the LOV Wizard to Create an LOV
• Setting LOV Properties
• LOV Column Mapping
• Defining an Editor
• Setting Editor Properties
• Associating an Editor with a Text Item

Creating Additional Input Items

• Input Items Overview
• Creating a Check Box
• Creating a List Item
• Creating a Radio Group

Creating Noninput Items

• Noninput Items Overview
• Creating a Display Item
• Creating an Image Item
• Creating a Push Button
• Creating a Calculated Item
• Creating a Hierarchical Tree Item
• Creating a Bean Area Item

Creating Windows and Content Canvases

• Displaying a Form Module in Multiple Windows
• Creating a New Window
• Displaying a Form Module on Multiple Layouts
• Creating a New Content Canvas

Working with Other Canvas Types

• Overview of Canvas Types
• Creating a Stacked Canvas
• Creating a Toolbar
• Creating a Tab Canvas

Producing and Debugging Triggers

• Trigger Overview
• Creating Triggers in Forms Builde
• Specifying Execution Hierarchy
• PL/SQL Editor Features
• Using the Database Trigger Editor
• Using Variables in Triggers
• Adding Functionality with Built-in Subprograms
• Using the Forms Debugger

Adding Functionality to Items

• Coding Item Interaction Triggers
• Interacting with Noninput Items

Displaying Run-Time Messages and Alerts

• Built-Ins and Handling Errors
• Controlling System Messages
• The FORM_TRIGGER_FAILURE Exception
• Triggers for Intercepting System Messages
• Creating and Controlling Alerts
• Handling Server Errors

Using Query Triggers

• Query Processing Overview
• SELECT Statements Issued During Query Processing
• Setting WHERE and ORDER BY clauses and ONETIME_WHERE property
• Writing Query Triggers
• Query Array Processing
• Coding Triggers for Enter-Query Mode
• Overriding Default Query Processing
• Obtaining Query Information at Run Time

Validating User Input

• Validation Process
• Controlling Validation by Using Properties
• Controlling Validation by Using Triggers
• Performing Client-Side Validation with PJCs
• Tracking Validation Status
• Using Built-ins to Control When Validation Occurs

Controlling Navigation

• Using Object Properties to Control Navigation
• Writing Navigation Triggers
• Avoiding the Navigation Trap
• Using Navigation Built-Ins in Triggers

Overriding or Supplementing Transaction Processing

• Transaction Processing Overview
• Using Commit Triggers
• Testing the Results of Trigger DML
• DML Statements Issued during Commit Processing
• Overriding Default Transaction Processing
• Getting and Setting the Commit Status
• Implementing Array DML

Writing Flexible Code

• What is Flexible Code?
• Using System Variables for Flexible Coding
• Using Built-in Subprograms for Flexible Coding
• Copying and Subclassing Objects and Code
• Referencing Objects by Internal ID
• Referencing Items Indirectly

Sharing Objects and Code

• Benefits of Reusable Objects and Code
• Working with Property Classes
• Working with Object Groups
• Copying and Subclassing Objects and Code
• Working with Object Libraries
• Working with SmartClasses
• Reusing PL/SQL
• Working with PL/SQL Libraries

Using WebUtil to Interact with the Client

• Benefits of WebUtil
• Integrating WebUtil into a Form
• Interacting with the Client

Introducing Multiple Form Applications

• Multiple Form Applications Overview
• Starting Another Form Module
• Defining Multiple Form Functionality
• Sharing Data among Modules

Oracle Fusion Middleware and Oracle Forms Services Overview

• Oracle Fusion Middleware 12c Overview
• Starting and Stopping WebLogic Servers
• Components of Oracle Fusion Middleware 12c Forms Services
• Starting a Forms Application
• Installing WebLogic Server, Forms, and Reports
• Upgrading from Oracle Application Server 10g
• Upgrading from Oracle Forms 6i

Configuring the Middle Tier: The Forms Servlet

• Using Configuration Files
• Using Oracle Enterprise Manager
• Configuring the Forms Servlet
• Defining Application-Specific Configurations
• Configuring Run-time Pooling

Configuring the Middle Tier: Environment, UI, and Deployment

• Modifying the Run-time Environment
• Enabling Query-Where Functionality
• Defining Application-Specific Environments
• Managing the User Interface Appearance
• Font Mapping
• Key Mapping
• Creating Application-Specific Registry Files
• Generating and Deploying the Forms Application

Deploying Associated Files

• Files That Your Forms Applications May Need
• Deploying Associated Files for Access from the Middle Tier
• Deploying Associated Files for Download to the Client

Configuring the Client Tier

• Client Requirements
• The Java Run-time Environment (JRE)
• Supported Browsers
• Using the Sun Java Plug-In
• Displaying the Java Console
• Configuring WebUtil for Client Interaction

Deploying Applications Globally

• Detecting Browser Language Settings
• Deploying Language-Specific Applications
• Implementing Time Zone Support

Implementing Security for Forms Applications

• Implementing Single Sign-On (SSO)
• Restricting User Privileges on the Database
• Restricting Parameters in the URL
• Using HTTPS

Integrating Forms Applications with Other Technologies

• Integrating with External Events
• Integrating Reports
• Integrating JavaScript

Managing Forms Services Instances

• Managing Forms Services with Oracle Enterprise Manager
• Configuring JVM Pooling
• Enabling Reports Calls to Use the JVM Controller for Java Method Invocation
• Managing User Sessions
• Load Balancing
• Achieving Maximum Availability

Troubleshooting Deployed Applications

• Enabling testmode
• Creating a Stack Trace File
• Using Forms Trace to Record Information about Specific Events
• Using Oracle Diagnostic Logging (ODL)
• Detecting and Diagnosing Common Errors

Tuning Deployed Applications

• Diagnosing Performance Issues
• Built-In Optimizations
• Co-locating the Forms Services and Data Server
• Minimizing the Perceived Startup Time
• Reducing the Required Network Bandwidth
• Reducing Time to Draw Initial Screen
• Using Other Tuning Techniques

Java Platform Overview

• Introductions
• Course Schedule
• Java Overview
• Java Platforms
• OpenJDK
• Licensing
• Java in Server Environments
• The Java Community Process

Java Syntax and Class Review

• Simple Java classes
• Java fields, constructors and methods
• Model objects using Java classes
• Package and import statements

Encapsulation and Polymorphism

• Encapsulation in Java class design
• Model business problems with Java classes
• Immutability
• Subclassing
• Overloading methods
• Variable argument methods

Java Class Design

• Access modifiers: private, protected and public
• Method overriding
• Constructor overloading
• The instanceof operator
• Virtual method invocation
• Polymorphism
• Casting object references
• Overriding Object methods

Advanced Class Design

• Abstract classes and type generalization
• The static and final modifiers
• Field modifier best practices
• The Singleton design pattern
• Designing abstract classes
• Nested classes
• Enumerated types

Inheritance with Java Interfaces

• Java Interfaces
• Types of Inheritance
• Object composition and method delegation
• Implementing multiple interfaces
• The DAO design pattern

Generics and Collections

• Generic classes and type parameters
• Type inference (diamond)
• Collections and generics
• List, set and Map
• Stack and Deque

String processing

• String manipulation with StringBuilder and StringBuffer
• Essential String methods
• Text parsing in Java
• Input processing with Scanner
• Text output and formatting
• Regular expressions with the Pattern and Matcher classes

Exceptions and Assertions

• Exceptions categories
• Standard Java Exception classes
• Creating your own Exception classes
• Using try-catch and the finally clause
• Using try-with-resources and the AutoCloseable interface
• The multi-catch feature
• Best practices using exceptions
• Assertions

I/O Fundamentals

• I/O using Java
• Reading the console input stream
• Writing to the console
• Using I/O Streams
• Chaining I/O Streams
• Channel I/O
• Reading and writing objects using Serialization

File I/O with NIO 2

• The Path interface
• The Files class
• Directory and File operations
• Managing file system attributes
• Reading, writing, and creating files
• Watching for file system changes

Threading

• Operating system task scheduling
• Recognizing multithreaded environments
• Creating multi-threaded solutions
• Sharing data across threads
• Synchronization and Deadlock
• Immutable objects

Concurrency

• Creating Atomic variables
• Using Read-Write Locks
• Thread-safe collections
• Concurrenct synchronizers (Semaphore, Phaser, and others)
• Executors and ThreadPools to concurrently schedule tasks
• Parallelism and the Fork-Join framework

Database Application with JDBC

• Layout of the JDBC API
• JDBC divers
• Queries and results
• PreparedStatement and CallableStatement
• Transactions
• RowSet 1.1 RowSetProvider and RowSetFactory
• The DAO Pattern and JDBC

Localization

• Advantages of localization
• Defining locale
• Read and set locale using the Locale object
• Resource bundles
• Format messages, dates and numbers

ADF Mobile Overview

• Adopting a mobile strategy
• Defining requirements for mobile applications
• Determining the best mobile type for your use case
• Examining Oracle’s mobile offerings

Designing Oracle ADF Mobile Applications

• Examining JDeveloper IDE
• Creating ADF mobile applications
• Defining features and the ways they can be implemented
• Developing the mobile process with task flows and managed beans

Developing the User Interface

• Describing the main UI content options
• Exploring ADF Mobile XML content types
• Designing mobile pages using AMX components

Working with Web Services

• Examining how data is used in a mobile application and describe the different options for managing it
• Employing a Service Pattern when accessing the Data Layer
• Using SOAP and REST web services as a means to transmit data to a remote server

Leveraging a Local Database

• Creating and deploying a local database to a mobile device
• Performing CRUD operations on the local database
• Switching between a local database or web services depending on network conductivity

Integrating Device Services

• Enhancing mobile applications by incorporating device services
• Examining device properties to determine feature functionality
• Applying different techniques to accessing device services

Securing Oracle ADF Mobile Applications

• Enabling a secure logon to an ADF application
• Authorizing access to a feature based on a role
• Enabling security on web services
• Restricting access to URLs using whitelists
• Ensuring you can trust server interactions

Deploying and Debugging Oracle ADF Mobile Applications

• Configure JDeveloper to support iOS and Android deployment
• Creating deployment profiles for both device platforms
• Using the Java debugger and logging APIs to diagnosis and fix application problems
• Deploy applications to Android and iOS platforms

Introduction to Fusion and ADF

• Describing Fusion architecture
• Explaining how ADF fits into the Fusion architecture
• Describing the ADF technology stack (MVC)

Getting Started with JDeveloper

• Listing JDeveloper benefits for application development
• Using the features of the JDeveloper IDE
• Defining IDE preferences
• Creating applications, projects, and connections in JDeveloper

Building a Data Model with ADF Business Components

• Introducing ADF Business Components
• Creating Business Components from tables
• Testing the data model

Querying and Persisting Data

• Using view objects
• Using entity objects to persist data
• Synchronizing entity objects with database table changes
• Creating associations
• Creating updateable view objects
• Creating master-detail relationships
• Refactoring

Exposing Data

• Creating application modules
• Using master-detail view objects in application modules
• Managing Business Components transactions
• Abstracting business services with ADF Model

Declaratively Customizing Data Services

• Internationalizing the data model
• Editing business components
• Modifying default behavior of entity objects
• Changing the locking behavior of an application module

Programmatically Customizing Data Services

• Generating Java classes
• Programmatically modifying the behavior of entity objects
• Programmatically modifying the behavior of view objects
• Adding service methods to an application module
• Using client APIs

Validating User Input

• Understanding validation options: Database, Data Model, or UI
• Triggering validation execution
• Handling validation errors
• Using Groovy expressions in validation
• Using programmatic validation

Troubleshooting ADF BC Applications

• Troubleshooting the business service
• Troubleshooting the UI
• Using logging and diagnostics
• Using the JDeveloper debugger

Understanding UI Technologies

• Describing the use of Web browsers and HTML
• Describing the function of Servlets and JSPs
• Defining JavaServer Faces
• Explaining the JSF component architecture and JSF component types
• Explaining the purpose of backing beans and managed beans
• Describing the JSF life cycle
• Explaining how ADF Faces augments the JSF life cycle

Binding UI Components to Data

• Creating a JSF page
• Adding UI components to a page
• Describing the ADF Model layer
• Using Expression Language in data bindings
• Using a Page Definition file
• Examining data binding objects and metadata files
• Binding existing components to data
• Running and testing the page

Planning the User Interface

• Describing the Model-View-Controller design pattern
• Differentiating between bounded and unbounded task flows
• Creating and converting task flows
• Defining control flows
• Defining global navigation
• Creating routers for conditional navigation
• Calling methods and other task flows
• Implementing validation in the user interface

Adding Functionality to Pages

• Internationalizing the user interface
• Using component facets
• Displaying tabular data in tables
• Displaying hierarchical data in trees
• Displaying text or media with icons and images
• Defining search forms and display results
• Displaying data graphically

Implementing Navigation on Pages

• Using ADF Faces navigation components
• Using buttons and links
• Using menus for navigation
• Using breadcrumbs
• Using a train component

Achieving the Required Layout

• Using complex layout components
• Explaining how to use ADF Faces skins
• Using dynamic page layout

Ensuring Reusability

• Designing for reuse
• Using task flow templates
• Creating and using page templates
• Creating and using declarative components
• Creating and using page fragments
• Deciding which type of reusable component to use

Passing Values Between UI Elements

• Defining the data model to reduce the need to pass values
• Using a managed bean to hold values
• Using page parameters
• Using task flow parameters
• Passing values from containing pages to regions

Responding to Application Events

• Using managed beans
• Coordinating JSF and ADF lifecycles
• Using phase and event listeners
• Using action listeners and methods
• Understanding additional AJAX events

Implementing Transactional Capabilities

• Handling transactions with ADF BC
• Using task flows to control transactions
• Sharing data controls
• Handling transaction exceptions
• Defining response to the Back button

Implementing Security in ADF BC Applications

• Exploring ADF Application security options
• Understanding ADF security framework
• Enabling users to access resources
• Implementing a Login page
• Understanding ADF controller authorization
• Using Expression Language to extend security capabilities

Introduction

• Course Objectives, Course Agenda and Class Account Information
• Describe the Schemas and Appendices used in the Lesson
• Overview of SQL*Plus Environment
• Overview of SQL Developer
• Overview of Analytic SQL
• Oracle Database SQL and Data Warehousing Documentation

Grouping and Aggregating Data Using SQL

• Generating Reports by Grouping Related Data
• Review of Group Functions
• Reviewing GROUP BY and HAVING Clause
• Using the ROLLUP and CUBE Operators
• Using the GROUPING Function
• Working with GROUPING SET Operators and Composite Columns
• Using Concatenated Groupings with Example

Hierarchical Retrieval

• Using Hierarchical Queries
• Sample Data from the EMPLOYEES Table
• Natural Tree Structure
• Hierarchical Queries: Syntax
• Walking the Tree: Specifying the Starting Point
• Walking the Tree: Specifying the Direction of the Query
• Using the WITH Clause
• Hierarchical Query Example: Using the CONNECT BY Clause

Working with Regular Expressions

• Introducing Regular Expressions
• Using the Regular Expressions Functions and Conditions in SQL and PL/SQL
• Introducing Metacharacters
• Using Metacharacters with Regular Expressions
• Regular Expressions Functions and Conditions: Syntax
• Performing a Basic Search Using the REGEXP_LIKE Condition
• Finding Patterns Using the REGEXP_INSTR Function
• Extracting Substrings Using the REGEXP_SUBSTR Function

Analyzing and Reporting Data Using SQL

• Overview of SQL for Analysis and Reporting Functions
• Using Analytic Functions
• Using the Ranking Functions
• Using Reporting Functions

Performing Pivoting and Unpivoting Operations

• Performing Pivoting Operations
• Using the PIVOT and UNPIVOT Clauses
• Pivoting on the QUARTER Column: Conceptual Example
• Performing Unpivoting Operations
• Using the UNPIVOT Clause Columns in an UNPIVOT Operation
• Creating a New Pivot Table: Example

Pattern Matching using SQL

• Row Pattern Navigation Operations
• Handling Empty Matches or Unmatched Rows
• Excluding Portions of the Pattern from the Output
• Expressing All Permutations
• Rules and Restrictions in Pattern Matching
• Examples of Pattern Matching

Modeling Data Using SQL

• Using the MODEL clause
• Demonstrating Cell and Range References
• Using the CV Function
• Using FOR Construct with IN List Operator, incremental values and Subqueries
• Using Analytic Functions in the SQL MODEL Clause
• Distinguishing Missing Cells from NULLs
• Using the UPDATE, UPSERT and UPSERT ALL Options
• Reference Models

Introduction

• Course Objectives, Course Agenda and Appendixes Used in this Course
• Provide an insight of the development environments
• Tables used in the Course
• Review of the SQL Concepts

Introduction to Data Dictionary Views

• Introduction to Data Dictionary
• Describe the Data Dictionary Structure
• Using the Data Dictionary Views
• Querying the Data Dictionary Views

Creating Sequences, Synonyms, Indexes

• Overview of sequences
• Overview of synonyms
• Overview of indexes

Creating Views

• Overview of views

Managing Schema Objects

• Managing constraints
• Creating and using temporary tables
• Creating and using external tables

Retrieving Data by Using Subqueries

• Retrieving Data by Using a Subquery as Source
• Working with Multiple-Column subqueries
• Using Scalar subqueries in SQL
• Correlated Subqueries
• Working with the WITH clause

Manipulating Data by Using Subqueries

• Using Subqueries to Manipulate Data
• Inserting by Using a Subquery as a Target
• Using the WITH CHECK OPTION Keyword on DML Statements
• Using Correlated Subqueries to Update and Delete rows

Controlling User Access

• System privileges
• Creating a role
• Object privileges
• Revoking object privileges

Manipulating Data

• Overview of the Explicit Default Feature
• Using multitable INSERTs
• Using the MERGE statement
• Performing flashback operations
• Tracking Changes in Data

Managing Data in Different Time Zones

• Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
• Working with INTERVAL data types
• Using Datetime functions in queries