Software Development by ORACLE

ORACLE SQL

*Fundamental Database*	*Creating Tables & Constraints*
*Retrieving Data Using the SQL SELECT Statement*	*Restricting and Sorting Data*
*Row Functions to Customize Output*	*Reporting Aggregated Data Using the Group Functions*
*Displaying Data from Multiple Tables*	*Displaying Data from Multiple Tables*
*Using Subqueries to Solve Queries*	*Control transactions*
*Creating Other Schema Objects*	*Managing Objects with Data Dictionary Views*
*Controlling User Access*	*Managing Schema Objects*
*Manipulating Large Data Sets*	*Generating Reports by Grouping Related Data*
*Managing Data in Different Time Zones*	*Hierarchical Retrieval*
*Regular Expression Support*	*Exam*

Practical use of ORACLE SQL with Example

ORACLE PL/SQL

Introduction to PL/SQL	Declaring PL/SQL Identifiers
Writing Executable Statements	Interacting with the Oracle Server
Writing Control Structures	Working with Composite Data Types
*Using Explicit Cursors*	Handling Exceptions
Creating Stored Procedures	Creating Stored Functions
Creating Packages	*Using More Package Concepts*
Utilizing Oracle Supplied Packages in Application Development	Dynamic SQL and Metadata
Design Considerations for PL/SQL Code	Managing Dependencies
Manipulating Large Objects	Creating Triggers
Applications for Triggers	Understanding and Influencing the PL/SQL Compiler

Practical use of ORACLE PL/SQL with Example

ORACLE Apex 19.2

Form Builder	Tabular Form
Customized Form	Procedure Form
Report Builder	Customized Report
Parameterize Report	Updatable Report
Interactive Report	Chart
Invoice/Bill Generation	Branching
Data Validation	Process
Plugins	Export & import front end
Create application for j-quary mobile version