ORACLE SQL (Structure Query Language)
| 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 |
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 |
ORACLE APEX 20.1
| 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 |