Oracle Database Administration 1

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.

To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

• Introduction
• Oracle Database Architecture
• Introduction to Oracle Database Cloud Service
• Creating DBCS Database Deployments
• Accessing an Oracle Database
• Managing DBCS Database Deployments
• Managing Database Instances
• Understanding Oracle Net Services
• Administering User Security
• Creating PDBs
• Creating Master Encryption Keys for PDBs
• Creating and Managing Tablespaces
• Managing Storage Space
• Managing Undo Data
• Moving Data
• Backup and Recovery Concepts
• Backup and Recovery Configuration
• Creating Database Backups
• Performing Database Recovery
• Monitoring and Tuning Database Performance
• SQL Tuning
• Miscellaneous

Oracle Database 19c Administration 2

Creating CDBs and Regular PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

• Configure and create a CDB
• Create a new PDB from the CDB seed
• Explore the structure of PDBs

Backup and Duplicate – Oracle Database: Managing Multitenant Architecture Ed 1

• Perform Backup and Recover CDBs and PDBs
• Duplicate an active PDB
• Duplicate a Database

Manage Application PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

• Explain the purpose of application root and application seed
• Define and create application PDBs
• Install, upgrade and Patch applications
• Create and administer Application PDBS
• Clone PDBs and Application containers
• Plug and unplug operations with PDBs and application containers
• Comparing Local Undo Mode and Shared Undo Mode

Recovery and Flashback – Oracle Database: Managing Multitenant Architecture Ed 1

• Restore and Recovering Databases with RMAN
• Perform CDB and PDB flashback

Backup Strategies and Terminology – Oracle Database: Backup and Recovery Workshop

• Perform Full and Incremental Backups and Recoveries
• Compress and Encrypt RMAN Backups
• Use a media manager
• Create multi-section backups of very large files
• Create duplexed backup sets
• Create archival backups
• Backup of recovery files
• Backup non database files
• Back up ASM meta data

Restore and Recovery Concepts – Oracle Database: Backup and Recovery Workshop

• Employ the best Oracle Database recovery technology for your failure situation
• Describe and use Recovery technology for Crash, Complete, and Point-in-time recovry

Using Flashback Technologies – Oracle Database: Backup and Recovery Workshop

• Configure  your Database  to support Flashback
• Perform flashback operations

Duplicating a Database – Oracle Database: Backup and Recovery Workshop

• Duplicate Databases

Diagnosing Failures – Oracle Database: Backup and Recovery Workshop

• Detect and repair database and database block corruption
• Diagnosing Database Issues

Transporting Data – Oracle Database: Backup and Recovery Workshop

• Transport Data

Install Grid Infrastructure and Oracle Database – Oracle Database: Deploy, Patch and Upgrade Workshop

• Install Grid Infrastructure for a Standalone server
• Install Oracle Database software

Patching Grid Infrastructure and Oracle Database – Oracle Database: Deploy, Patch and Upgrade Workshop

• Patch Grid Infrastructure and Oracle Database

Upgrading to Oracle Grid Infrastructure – Oracle Database: Deploy, Patch and Upgrade Workshop

• Upgrade Oracle Grid Infrastructure

Oracle Database 18c: New Features – Oracle Database: Deploy, Patch and Upgrade Workshop

• Image and RPM based Database Installation

Oracle Restart – Oracle Database: Deploy, Patch and Upgrade Workshop

• Configure and use Oracle Restart to manage components

Install Grid Infrastructure for a Standalone server – Oracle Database: Deploy, Patch and Upgrade Workshop

• Rapid Home Provisioning

Using Availability Enhancements – Oracle Database 19c: New Features for Administrators

• Use an RMAN recovery catalog
• Use Flashback Database

Monitoring and Tuning Database Performance – Oracle Database: Administration Workshop

• Managing Memory Components
• Understanding The Automatic Workload Repository (AWR)
• Understanding The Advisory Framework
• Monitoring Wait Events, Sessions, and Services
• Managing Metric Thresholds and Alerts
• Understanding and Using The Performance Tuning Methodology
• Performing Performance Planning
• Understanding The Automatic Database Diagnostic Monitor (ADDM)

Manage CDBs and PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

• Manage PDB service names and connections
• Manage startup, shutdown and availability of CDBs and PDBs
• Change the different modes and settings of PDBs
• Evaluate the impact of parameter value changes
• Performance management in CDBs and PDBs
• Control CDB and PDB resource usage with the Oracle Resource Manager

Upgrading and Transporting CDBs and Regular PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

• Upgrade an Oracle Database
• Transport Data

Manage Security in Multitenant databases – Oracle Database: Managing Multitenant Architecture Ed 1

• Manage Security in Multitenant databases
• Manage PDB lockdown profiles
• Audit Users in CDBs and PDBs
• Manage other types of policies in application containers

Configuring and Using RMAN – Oracle Database: Backup and Recovery Workshop

• Configure RMAN and the Database for Recoverability
• Configureand Using an RMAN recovery catalog

Performing Recovery – Oracle Database: Backup and Recovery Workshop

• Restore and Recovering Databases with RMAN
• Perform Non RMAN database recovery

RMAN Troubleshooting and Tuning – Oracle Database: Backup and Recovery Workshop

• Interpret the RMAN message output
• Diagnose RMAN performance issues

Creating an Oracle Database by using DBCA – Oracle Database: Deploy, Patch and Upgrade Workshop

• Create, Delete and Configure Databases using DBCA

Upgrade the Oracle Database – Oracle Database: Deploy, Patch and Upgrade Workshop

• Plan for Upgrading an Oracle Database
• Upgrade an Oracle Database
• Perform Post-Upgrade tasks

Using General Overall Database Enhancements – Oracle Database 19c: New Features for Administrators

• Install Oracle Database software
• Create, Delete and Configure Databases using DBCA
• Creating CDBs and Regular PDBs
• Use Miscellaneaous 19c New Features

Using Diagnosibility Enhancements – Oracle Database 19c: New Features for Administrators

• Use new Diagnoseability Features

Tuning SQL Statements – Oracle Database: Administration Workshop

• Understanding The Oracle Optimizer
• Using The SQL Tuning Advisor
• Managing Optimizer Statistics
• Using The SQL Access Advisor
• Understanding The SQL Tuning Process

Introduction to Oracle SQL

Introduction

• Explain the theoretical and physical aspects of a relational database)

Restricting and Sorting Data

• Limit the rows that are retrieved by a query
• Sort the rows that are retrieved by a query
• Use ampersand substitution to restrict and sort output at runtime
• Use SQL row limiting clause

Using Conversion Functions and Conditional Expressions

• Describe various types of conversion functions that are available in SQL
• Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Apply conditional expressions in a SELECT statement

Displaying Data From Multiple Tables Using Joins

• Use SELECT statements to access data from more than one table using equijoins and nonequijoins
• Join a table to itself by using a self-join
• View data that generally does not meet a join condition by using OUTER joins

Managing Tables using DML statements

• Insert rows into a table
• Update rows in a table
• Delete rows from a table
• Control transactions

Retrieving Data using the SQL SELECT Statement

• Execute a basic SELECT statement

Using Single-Row Functions to Customize Output

• Describe various types of functions available in SQL
• Use character, number, and date functions in SELECT statements

Reporting Aggregated Data Using the Group Functions

• Describe the use of group functions
• Group data by using the GROUP BY clause
• Include or exclude grouped rows by using the HAVING clause

Using Subqueries to Solve Queries

• Define subqueries
• Describe the types of problems that the subqueries can solve
• Describe the types of subqueries
• Use single-row and multiple-row subqueries
• Use a set operator to combine multiple queries into a single query
• Control the order of rows returned

Introduction to Data Definition Language

• Describe the data types that are available for columns
• Create a simple table
• Create constraints for tables
• Describe how schema objects work

Program with Oracle PL/SQL

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

Oracle Fusion Middleware : Build Application with Oracle Forms.

1. Running a Forms Application
2. Working in the Forms Builder Environment
3. Creating a Basic Form Module
4. Creating a Master-Detail Form
5. Working Data Blocks and Frames
6. Working with Text Items
7. Creating LOVs and Editors
8. Creating Additional Input Items
9. Creating Noninput Items
10. Creating Windows and Content Canvases
11. Working with Other Canvas Types
12. Producing and Debugging Triggers
13. Adding Functionality to Items
14. Displaying Run-Time Messages and Alerts
15. Using Query Triggers
16. Validating User Input
17. Controlling Navigation
18. Overriding or Supplementing Transaction Processing
19. Writing Flexible Code
20. Sharing Objects and Code
21. Using WebUtil to Interact with the Client
22. Introducing Multiple Form Applications

Oracle Fusion Middleware : Build Reports

• 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

Oracle Apex :

Course Overview

Introducing Oracle Application Express

Application Express Overview
Using Application Express
Application Express Terms and Concepts
How to Install Oracle Apex Latest Version

1 – Creating a Desktop and Mobile Database Application

1. Application Builder Overview
2. Creating Mobile Application
3. Introducing Database Applications
4. Creating Database Applications

2 – Working with Reports for Desktop Application

1. Using Interactive Reports
2. Using Classic Reports
3. Introducing Reports
4. Creating and Customizing an Interactive Report

3 – Working with Reports for Mobile Application

1. Creating a Reflow Report
2. Creating Reports for a Mobile Application
3. Creating Column Toggle Report

4 – Creating Forms

1. Creating Forms
2. Creating a Form in a Mobile Application
3. Modifying Forms
4. Using Forms

5 – Working with Pages and Regions

1. Working with Page Regions
2. Introducing Page Definition
3. Working with Pages

6 – Adding Items and Buttons

1. Creating List of Value (LOV) Type of Items
2. Using Buttons
3. Introducing Items
4. Using Items

7 – Understanding Session State

1. Using Session State in Oracle Application Express
2. Understanding Session State in Oracle Application Express

8 – Including Page Processing

1. Introducing Page Processing
2. Including Computations
3. Including Branches
4. Including Processes
5. Including Validations

9 – Validating and Debugging Your Application

1. Using the Advisor
2. Managing Your Attribute Dictionary
3. Debugging Your Application

10 – Adding Shared Components That Aid Navigation

1. Introducing Shared Components
2. Creating a Navigational Bar
3. Creating Lists
4. Creating Tabs
5. Creating Breadcrumbs

11 – Working with Themes, Templates and Files

1. Using Templates
2. Using Files
3. Using Themes

12 – Implementing Security

1. Using Authorization Schemes
2. Using Authentication Schemes
3. Using Session State Protection
4. Securing an Application

13 – Managing Application Navigation

1. Enforcing Authorization on Your Site Map
2. Building a Site Map
3. Building a Hierarchical List with Images
4. Linking Interactive Reports using a Declarative Filter

14 – Extending Your Application

1. Sending Email from an Application
2. Creating Data Load Wizard Pages
3. Creating an Upload and Download Page
4. Adding BLOB Data to an Existing Application

15 – Creating and Editing Charts

1. Creating and Using Charts
2. Enhanced Charting Examples

16 – Adding Calendars and Trees

1. Using Calendars
2. Using Trees

17 – Using Dynamic Actions and Plug-Ins

1. Using Dynamic Actions
2. Using Plug-Ins

18 – Utilizing Application Express Printing

1. Printing a Standard Report with Derived Output
2. Creating a PDF Report with Multiple Queries

1. Install Jasper Soft Studio
2. Tabular Report
3. Master Details Repor
4. Image in Jasper Reports.
5. Integrate Jasper Report with Oracle Apex.

1. How to Install Putty and SSH Client in Windows.
2. Install Tomcat in Linux
3. Secure Tomcat In Linux
4. Server Time zone In Linux
5. Disable SE-Linux
6. Create Swap Space
7. Install Oracle Database in Linux
8. Connect Oracle Database in Cloud from PC.
9. Install Oracle In database installed in Linux.
10. Install ORDS and run from Tomcat.
11. Tomcat Re-Direct
12. Install Free SSL Certificate in your domain.

This Long Course Includes Projects :

1 – Point of Sell in Oracle Fusion Middleware Forms & Reports

2 – Point of Sell in Oracle Apex.