Oracle Developer Certification Training
- 1Z0-061 Oracle Database 12c: SQL Fundamentals
- 1Z0-047 Oracle Database SQL Expert
- 1Z0-117 Oracle Database 11g Release 2: SQL Tuning
- 1Z0-051 Oracle Database 11g: SQL Fundamentals I
- 1Z0-147 Program with PL/SQL
- 1Z0-144 Oracle Database 11g: Program with PL/SQL
Oracle Database Administrators Certification Training
- 1Z0-062 Oracle Database 12c: Installation and Administration
- 1Z0-063 Oracle Database 12c: Advanced Administration
- 1Z0-051 Oracle Database 11g: SQL Fundamentals I
- 1Z0-052 Oracle Database 11g: Administration I
- 1Z0-053 Oracle Database 11g: Administration II
Oracle Database 10g: Real Application Clusters (RAC) Administrator Certified Expert Training
- 1Z0-048 Oracle Database 10g R2: Real Application Clusters for Administrators Oracle SQL and PLSQL
Module 1: Writing Basic SQL SELECT Statements
- Basic SELECT Statement
- Selecting All Columns
- Selecting Specific Columns
- Writing SQL Statements
- Column Heading Defaults
- Arithmetic Expressions
- Using Arithmetic Operators
- Operator Precedence
- Using Parentheses
- Defining a Null Value
- Null Values in Arithmetic Expressions
- Defining a Column Alias
- Using Column Aliases
- Concatenation Operator
- Using the Concatenation Operator
- Literal Character Strings
- Using Literal Character Strings
- Duplicate Rows
- Eliminating Duplicate Rows
Module 2: Restricting and Sorting Data
- Limiting Rows Using a Selection
- Limiting the Rows Selected
- Using the WHERE Clause
- Character Strings and Dates
- Comparison Conditions
- Using Comparison Conditions
- Other Comparison Conditions
- Using the BETWEEN Condition
- Using the IN Condition
- Using the LIKE Condition
- Using the NULL Conditions
- Logical Conditions
- Using the AND Operator
- Using the OR Operator
- Using the NOT Operator
- Rules of Precedence
- ORDER BY Clause
- Sorting in Descending Order
- Sorting by Column Alias
- Sorting by Multiple Columns
Module 3: . Single-Row Functions
- SQL Function
- Two Types of SQL Functions
- Single-Row Functions
- Single-Row Functions
- Character Functions
- Character Functions
- Case Manipulation Functions
- Using Case Manipulation Functions
- Character-Manipulation Functions
- Using the Character-Manipulation Functions
- Number Functions
- Using the ROUND Function
- Using the TRUNC Function
- Using the MOD Function
- Working with Dates
- Arithmetic with Dates
- Using Arithmetic Operators with Dates
- Date Functions
- Using Date Functions
- Practice 3, Part One:
- Conversion Functions
- Implicit Data Type Conversion
- Explicit Data Type Conversion
- Using the TO_CHAR Function with Dates
- Elements of the Date Format Model
- Using the TO_CHAR Function with Dates
- Using the TO_CHAR Function with Numbers
- Using the TO_NUMBER and TO_DATE Functions
- RR Date Format
- Example of RR Date Format
- Nesting Functions
General Functions - NVL Function
- Using the NVL Function
- Using the NVL2 Function
- Using the NULLIF Function
- Using the COALESCE Function
- Conditional Expressions
- The CASE Expression
- Using the CASE Expression
- The DECODE Function
- Using the DECODE Function
Module 4: Displaying Data from Multiple Tables
- Obtaining Data from Multiple Tables
- Cartesian Products
- Generating a Cartesian Product
- Types of Joins
- Joining Tables Using Oracle Syntax
- What is an Equijoin?
- Retrieving Records with Equijoins
- Additional Search Conditions Using the AND Operator
- Qualifying Ambiguous Column Names
- Using Table Aliases
- Joining More than Two Tables
- Non-Equijoins
- Retrieving Records with Non-Equijoins
- Outer Joins Outer Joins Syntax
- Using Outer Joins
- Self Joins
- Joining a Table to Itself
- Joining Tables Using SQL: 1999 Syntax
- Creating Cross Joins
- Creating Natural Joins
- Retrieving Records with Natural Joins
- Creating Joins with the USING Clause
- Retrieving Records with the USING Clause
- Creating Joins with the ON Clause
- Retrieving Records with the ON Clause
- Creating Three-Way Joins with the ON Clause
- INNER Versus OUTER Joins
- LEFT OUTER JOIN
- RIGHT OUTER JOIN
- FULL OUTER JOIN
- Additional Conditions
Module 5: Aggregating Data Using Group Functions
- What Are Group Functions?
- Types of Group Functions
- Group Functions Syntax
- Using the AVG and SUM Functions
- Using the MIN and MAX Functions
- Using the COUNT Function
- Using the DISTINCT Keyword
- Group Functions and Null Values
- Using the NVL Function with Group Functions
- Creating Groups of Data
- Creating Groups of Data: The GROUP BY Clause Syntax
- Using the GROUP BY Clause
- Grouping by More Than One Column
- Using the GROUP BY Clause on Multiple Columns
- Illegal Queries Using Group Functions
- Excluding Group Results
- Excluding Group Results: The HAVING Clause
- Using the HAVING Clause
- Nesting Group Functions
Module 6: Subqueries
- Objectives
- Using a Subquery to Solve a Problem
- Subquery Syntax
- Using a Subquery
- Guidelines for Using Subqueries
- Types of Subqueries
- Single-Row Subqueries
- Executing Single-Row Subqueries
- Using Group Functions in a Subquery
- The HAVING Clause with Subqueries
- What is Wrong with this Statement?
- Will this Statement Return Rows?
- Multiple-Row Subqueries
- Using the ANY Operator in Multiple-Row Subqueries
- Using the ALL Operator in Multiple-Row Subqueries
- Null Values in a Subquery
Module 7: . Manipulating Data
- Data Manipulation Language
- Adding a New Row to a Table
- The INSERT Statement Syntax 8-5
- Inserting New Rows
- Inserting Rows with Null Values
- Inserting Special Values
- Inserting Specific Date Values
- Creating a Script
- Copying Rows from Another Table
- Changing Data in a Table
- The UPDATE Statement Syntax
- Updating Rows in a Table
- Updating Two Columns with a Subquery
- Updating Rows Based on Another Table
- Updating Rows: Integrity Constraint Error
- Removing a Row from a Table
- The DELETE Statement
- Deleting Rows from a Table
- Deleting Rows Based on Another Table
- Deleting Rows: Integrity Constraint Error
- Using a Subquery in an INSERT Statement
- Using the WITH CHECK OPTION Keyword on DML Statements
- Overview of the Explicit Default Feature
- Using Explicit Default Values
- The MERGE Statement
- The MERGE Statement Syntax
- Merging Rows
- Database Transactions
- Advantages of COMMIT and ROLLBACK Statements
- Controlling Transactions
- Rolling Back Changes to a Marker
- Implicit Transaction Processing
- State of the Data Before COMMIT or ROLLBACK
- State of the Data after COMMIT
- Committing Data
- State of the Data After ROLLBACK
- Statement-Level Rollback
- Read Consistency
- Implementation of Read Consistency
- Locking
- Implicit Locking
- Read Consistency Example
Module 8: Creating and Managing Tables
- Database Objects
- Naming Rules
- The CREATE TABLE Statement
- Referencing Another User?s Tables
- The DEFAULT Option
- Creating Tables
- Tables in the Oracle Database
- Querying the Data Dictionary 9-10
- Data Types
- DateTime Data Types
- TIMESTAMP WITH TIME ZONE Data Type
- TIMESTAMP WITH LOCAL TIME Data Type
- INTERVAL YEAR TO MONTH Data Type
- INTERVAL DAY TO SECOND Data Type
- Creating a Table by Using a Subquery Syntax
- Creating a Table by Using a Subquery
- The ALTER TABLE Statement
- Adding a Column
- Modifying a Column
- Dropping a Column
- The SET UNUSED Option
- Dropping a Table
- Changing the Name of an Object
- Truncating a Table
- Adding Comments to a Table
Module 9: Including Constraints
- What are Constraints?
- Constraint Guidelines
- Defining Constraints
- The NOT NULL Constraint
- The UNIQUE Constraint
- The PRIMARY KEY Constraint
- The FOREIGN KEY Constraint
- FOREIGN KEY Constraint Keywords
- The CHECK Constraint
- Adding a Constraint Syntax
- Adding a Constraint
- Dropping a Constraint
- Disabling Constraints
- Enabling Constraints
- Cascading Constraints
- Viewing Constraints
- Viewing the Columns Associated with Constraints
Module 10: Creating Views
- Database Objects
- What is a View?
- Why use Views?
- Simple Views and Complex Views
- Creating a View
- Retrieving Data from a View
- Querying a View
- Modifying a View
- Creating a Complex View
- Rules for Performing DML Operations on a View
- Using the WITH CHECK OPTION Clause
- Denying DML Operations
Module 11: Other Database Objects
- Database Objects
- What is a Sequence?
- The CREATE SEQUENCE Statement Syntax
- Creating a Sequence
- Confirming Sequences
- NEXTVAL and CURRVAL Pseudocolumns
- Using a Sequence
- Modifying a Sequence
- Guidelines for Modifying a Sequence
- Removing a Sequence
- What is an Index?
- How Are Indexes Created?
- Creating an Index
- When to Create an Index
- When Not to Create an Index
- Confirming Indexes
- Function-Based Indexes
- Removing an Index
- Creating and Removing Synonyms
Module 12: Controlling User Access
- Objectives
- Controlling User Access
- Privileges
- System Privileges
- Creating Users
- User System Privileges
- Granting System Privileges
- What is a Role?
- Creating and Granting Privileges to a Role
- Changing Your Password
- Object Privileges
- Granting Object Privileges
- Using the WITH GRANT OPTION and PUBLIC Keywords
- Confirming Privileges Granted
- How to Revoke Object Privileges
- Revoking Object Privileges
- Database Links
Module 13: SQL Workshop
- Workshop Overview
Module 14: . Using SET Operators
- The SET Operators
- Tables Used in This Lesson
- The UNION Operator
- Using the UNION Operator
- The UNION ALL Operator
- Using the UNION ALL Operator
- The INTERSECT Operator
- Using the INTERSECT Operator
- The MINUS Operator
- SET Operator Guidelines
- The Oracle Server and SET Operators
- Matching the SELECT Statements
- Controlling the Order of Rows
Module 15: Enhancements to the GROUP BY Clause
- Review of Group Functions
- Review of the GROUP BY Clause
- Review of the HAVING Clause
- GROUP BY with ROLLUP and CUBE Operators
- ROLLUP Operator
- ROLLUP Operator Example
- CUBE Operator
- CUBE Operator: Example
- GROUPING Function
- GROUPING Function: Example
- GROUPING SETS
- GROUPING SETS: Example
- Composite Columns
- Composite Columns: Example
- Concatenated Groupings
- Concatenated Groupings Example
Module 16: Advanced Subqueries
- What Is a Subquery?
- Subqueries
- Using a Subquery
- Multiple-Column Subqueries
- Column Comparisons
- Pairwise Comparison Subquery
- Nonpairwise Comparison Subquery
- Using a Subquery in the FROM Clause
- Scalar Subquery Expressions
- Scalar Subqueries: Examples
- Correlated Subqueries
- Using Correlated Subqueries
- Using the EXISTS Operator
- Using the NOT EXISTS Operator
- Correlated UPDATE
- Correlated DELETE
- The WITH Clause
- WITH Clause: Example
- Hierarchical Retrieval
- Sample Data from the EMPLOYEES Table
- Natural Tree Structure
Module 17: Hierarchical Queries
- Walking the Tree
- Walking the Tree: From the Bottom Up
- Walking the Tree: From the Top Down
- Ranking Rows with the LEVEL Pseudocolumn
- Formatting Hierarchical Reports Using LEVEL and LPAD
- Pruning Branches
Module 18: Extensions to DML and DDL Statements
- Review of the INSERT Statement
- Review of the UPDATE Statement
- Overview of Multitable INSERT Statements
- Overview of Multitable INSERT Statements
- Types of Multitable INSERT Statements
- Multitable INSERT Statements
- Unconditional INSERT ALL
- Conditional INSERT ALL
- Conditional FIRST INSERT
- Pivoting INSERT
- External Tables
- Creating an External Table
- Example of Creating an External Table
- Querying External Tables
- CREATE INDEX with CREATE TABLE Statement
Module 19: Creating and Running PL/SQL Code
- SQL*Plus
- Performing Essential PL/SQL Tasks
- Calling PL/SQL from Other Languages
- Language Fundamentals
- PL/SQL Block Structure
- The PL/SQL Character Set
- Identifiers
- Literals
- The Semicolon Delimiter
- Comments
- The PRAGMA Keyword
- Labels
Module 20: Loop Basics
- The Simple Loop
- The WHILE Loop
- The Numeric FOR Loop
- The Cursor FOR Loop
- Loop Labels
- Tips for Iterative Processing
Module 21: Exception Handlers
- Exception-Handling Concepts and Terminology
- Defining Exceptions
- Raising Exceptions
- Handling Exceptions
- Building an Effective Error Management Architecture
- Making the Most of PL/SQL Error Management
Module 22 : Strings
- String Datatypes
- Working with Strings
- String Function Quick Reference
Module 23: Numbers
- Numeric Datatypes
- Number Conversions
- Numeric Functions
Module 24: Records
- Records in PL/SQL
Module 25: Collections
- Collections Overview
- Collection Methods (Built-Ins)
- Working with Collections
- Nested Table Multiset Operations
Module 26: Miscellaneous Datatypes
- The BOOLEAN Datatype
- The RAW Datatype
- The UROWID and ROWID Datatypes
- The LOB Datatypes
- Working with LOBs
- Predefined Object Types
Module 27: Data Retrieval
- Cursor Basics
- Working with Implicit Cursors
- Working with Explicit Cursors
- BULK COLLECT
- SELECT … FOR UPDATE
- Cursor Variables and REF CURSORs
- Cursor Expressions
Module 28: Procedures, Functions, and Parameters
- Procedures
- Functions
- Parameters
- Local Modules
- Module Overloading
- Forward Declarations
- Advanced Topics
Module 29: Packages
- Why Packages?
- Rules for Building Packages
- Rules for Calling Packaged Elements
- Working with Package Data
- When to Use Packages
- Packages and Object Types
Module 30: Triggers
- DML Triggers
- DDL Triggers
- Database Event Triggers
- INSTEAD OF Triggers
- AFTER SUSPEND Triggers
- Maintaining Triggers
Module 31: Managing PL/SQL Code
- Managing Code in the Database
- Using Native Compilation
- Using the Optimizing Compiler and Compile-Time Warnings
- Conditional Compilation
- Testing PL/SQL Programs
- Debugging PL/SQL Programs
- Tuning PL/SQL Programs
- Protecting Stored Code
Module 32: I/O and PL/SQL
- Displaying Information
- Reading and Writing Files
- Sending Email
- Working with Web-Based Data (HTTP)
- Other Types of I/O Available in PL/SQL Oracle Apps DBA
Module 1: Oracle E-Business Suite 11i, R12.1.3/12.2.3 Architecture
- Introduction to Oracle E-Business Suite 11i, R12.1.3/12.2.3
- Oracle E-Business Suite 11i, R12.1.3/12.2.3 Architecture
- Oracle E-Business Suite 11i,
- 1.3/12.2.3 Multi-Tier Architecture
- Desktop Tier
- Application Tier
- Database Tier
- Oracle Homes Architecture
- Oracle E-Business Suite Technology Layer
Module 2: Installation
- Single Node Installation (12.1 and 12.2)
- Multi-Node Installation (12.1 and 12.2).
- Context File and Interpretation.
Module 3: File System
- Oracle Applications Technology
- Oracle Applications Environment Files and Server Process Scripts
- Oracle Applications Entire File System
- The Applications and Database Context Files
Module 4: AD Utilities
- What are the AD Utilities?
- AD Administration
- Special Utilities
- Context Editing
- Reporting Utilities
- Configuration Utilities
Module 5: Concurrent Managers
- Managing Concurrent Programs and Reports and Output Post processor.
- Administering Concurrent Managers
- Managing Profile Options
- Incorporating a Custom Program
- Scheduling requests and Request Sets
Module 6: Patching
- Patch Types, Terminology, and Components
- Patch Creation and Patching Order
- Patching Utilities
- Introduction to Online Patching
- Architectural Changes to Support Online Patching
- Database Implementation
- Editioning Views and the Application Data Model
- Phases of the Online Patching Cycle
Module 7: Running the AD Online Patching Utility
- AD Online Patching Utility
- Running the adop Utility
- adop Commands
- Executing the Patching Cycle
- Status of a Patching Cycle
- Patching in Multi-Node Environments
- adop Remote Invocation
- Hotpatch Mode
Module 8: AutoConfig and Configuration Changes
- Reduced Role for AutoConfig
- Configuration Tools
- New AutoConfig Tools for System Configuration
- Service Groups and Services in Release R12.1.3/12.2.3
- AutoConfig Managed Service Groups and Services
- Managing Oracle HTTP Server Configurations
- Web Applications
- Summary of Configuration Changes
- Autoconfig Template and Driver files Concepts
Module 9: Cloning
- Rapidclone Concepts
- Cloning From Single node to Single node
- Cloning From Multi-Node to Multi-Node
- Cloning From Multi-Node to Single-Node
- Database Refresh
- 2.X and R12.1.X key changes
- Post-Clone Procedures
Module 10: Security
- Creating Users
- Assigning Responsibilities
- FNDCPASS Concepts
- Changing User Passwords using FNDCPASS
Module 11: Workflow
- Workflow Configuration
- Workflow Troubleshooting and Debugging
Module 12: System Administration
- Creating Users
- Assigning Responsibilities
- Setting Up Printers
- Changing Profile Options.
- XML Publisher and Administration in DBA Perspective.
- Code Migrations and awareness on Migration tools.
- Key roles in Support for APPS DBA.
- OAF Migrations
Module 13: Troubleshooting & Performance Tuning
- User connectivity issues Troubleshooting
- Apache Troubleshooting
- Jserv Troubleshooting
- OC4J Troubleshooting
- Forms & Concurrent Processing Troubleshooting
- Autoconfig related issues Troubleshooting
- Long-Running Jobs Troubleshooting
- Java Memory Settings and Tuning
- Troubleshooting Cloning Issues
- Apps Health Monitoring
- Certification matrix / CPU patchig for Applications and DB.
- Raising DB and Apptier monitoring
Module 14: Oracle Applications Advanced Topics
- Creating Custom Product Top’s
- Creating Custom Concurrent Managers
- Weblogic Installation
- Weblogc Domain Creation
- Weblogic Administration
- RAC DB and Oracle Applications using effectively.
Oracle Dataguard
Module 1 : Introduction to Oracle Data Guard
- Describe the basic components of Oracle Data Guard
- Explain the differences between physical and logical standby databases
- Explain the benefits of implementing Oracle Data Guard
Module 2 : Creating a Physical Standby Database by Using Enterprise Manager Cloud Control
- Create a Data Guard broker configuration
- Create a physical standby database
- Verify a Data Guard configuration
- Edit database properties related to Data Guard
- Test a Data Guard configuration
Module 3 : Oracle Net Services in a Data Guard Environment
- Understand the basics of Oracle Net Services
- Configure client connectivity in a Data Guard configuration
- Implement Data Guard best practice solutions in networking setup
Module 4 : Creating a Physical Standby Database by Using SQL and RMAN Commands
- Configure the primary database and Oracle Net Services to support the creation of the physical standby database and role transition
- Create a physical standby database by using the
Module 5 : Using Oracle Active Data Guard
- Use real-time query to access data on a physical standby database
- Enable RMAN block change tracking for a physical standby database
- Use Far Sync to extend zero data loss protection for intercontinental configurations
Module 6 : Creating and Managing a Snapshot Standby Database
- Create a snapshot standby database to meet the requirement for a temporary, updatable snapshot of a physical standby database
- Convert a snapshot standby database back to a physical standby database
Module 7 : Creating a Logical Standby Database
- Determine when to create a logical standby database
- Create a logical standby database
- Manage SQL Apply filtering
Module 8 : Oracle Data Guard Broker: Overview
- The Data Guard broker architecture
- Data Guard broker components
- Benefits of the Data Guard broker
- Data Guard broker configurations
- How to use Enterprise Manager to manage your Data Guard configuration
- How to invoke DGMGRL to manage your Data Guard configuration
Module 9 : Creating a Data Guard Broker Configuration
- Create a Data Guard broker configuration
- Manage the Data Guard broker configuration
Module 10 : Monitoring a Data Guard Broker Configuration
- Use Enterprise Manager Cloud Control to monitor the configuration
- Use DGMGRL to monitor the configuration
- Use SQL to monitor the configuration
Module 11 : Configuring Data Protection Modes
- Describe the data protection modes
- Change the data protection mode of your configuration
- Using Enterprise Manager Cloud Control
- Using DGMGRL
- Using SQL
Moudle 12 : Performing Role Transitions
- Explain the database roles
- Perform a switchover
- Perform a failover
Module 13 : Using Flashback Database in a Data Guard Configuration
- Explain the advantages of using Flashback Database in a Data Guard configuration
- Configure Flashback Database
Module 14 : Enabling Fast-Start Failover
- Configure fast-start failover
- View information about the fast-start failover configuration
- Manage the observer
- Perform role changes in a fast-start failover configuration
- Manually reinstate the primary database
Module 15 : Backup and Recovery Considerations in an Oracle Data Guard Configuration
- Use Recovery Manager (RMAN) to back up and restore files in a Data Guard configuration
- Offload backups to a physical standby database
- Recover your primary database by using a file from the physical standby database
Module 16 : Enhanced Client Connectivity in a Data Guard Environment
- Configure client connectivity in a Data Guard configuration
- Implement failover procedures to automatically redirect clients to a new primary database
Module 17 : Patching and Upgrading Databases in a Data Guard Configuration
- By using Standby-First Patch Apply technique
- By using traditional upgrade methods
- By performing rolling upgrades
- By using the DBMS_ROLLING package with Active Data Guard
Module 18 : Optimizing a Data Guard Configuration
- Monitor configuration performance
- Optimize redo transport for best performance
- Optimize SQL Apply
Module 19 : Oracle Database Exadata Cloud Service Overview
- Describe the architecture and capabilities of Exadata Cloud Service
- Compare and contrast between Exadata Cloud Service and an on-premise Exadata implementation
PL/SQL New Features and Enhancements in Oracle Database 12c Release 1 (12.1)
- Design PL/SQL packages and program units that execute efficiently
- Write code to interface with external applications and the operating system
- Create PL/SQL applications that use collections
- Write and tune PL/SQL code effectively to maximize performance
- Implement a virtual private database with fine-grained access control
- Write code to interface with large objects and use SecureFile LOBs
- Gain an understanding of the Oracle Database Exadata Express Cloud Service
- Invoker Rights Functions Can Be Result-Cached
- Libraries Defined Using Directory Objects and Credentials
- New Predefined Inquiry Directives ($$PLSQL_UNIT_OWNER, $$PLSQL_UNIT_TYPE)
- PLSQL_DEBUG Compilation Parameter is Deprecated
- PL/SQL Packages and Types Reference
- Code Based Access Control (CBAC) : Granting Roles to PL/SQL Program Units in Oracle Database 12 Release 1 (12.1)
- Control Invoker Rights Privileges for PL/SQL Code in Oracle Database 12c Release 1 (12.1) (INHERIT [ANY] PRIVILEGES)
- Control Invoker Rights Privileges in Views in Oracle Database 12c Release 1 (12.1) (BEQUEATH CURRENT_USER)
- Edition-Based Redefinition Enhancements in Oracle Database 12c Release 1 (12.1)
- Extended Data Types in Oracle Database 12c Release 1 (12.1)
- Implicit Statement Results in Oracle Database 12c Release 1 (12.1) (DBMS_SQL.RETURN_RESULT and DBMS_SQL.GET_NEXT_RESULT)
- Invisible Columns in Oracle Database 12c Release 1 (12.1)
- Multitenant : Database Triggers on Pluggable Databases (PDBs) in Oracle 12c Release 1 (12.1)
- WITH Clause Enhancements in Oracle Database 12c Release 1 (12.1)
- PL/SQL-to-SQL Interface Enhancements for PL/SQL-Only Data Types in Oracle Database 12c Release 1 (12.1)
- PL/SQL White Lists Using the ACCESSIBLE BY Clause in Oracle Database 12c Release 1 (12.1)
- Using the TABLE Operator with Locally Defined Types in PL/SQL
- UTL_CALL_STACK : Get Detailed Information About the Currently Running Subprogram in Oracle Database 12c Release 1 (12.1)