*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3498-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, KSA 0502283468

Oracle APEX – Application Express Course


Be the first to rate Oracle APEX – Application Express Course
Or log in to access your purchased courses
by admin
Price: 40,000
2 Months
0 Lessons

Oracle APEX Course

Oracle APEX – Application Express (Complete Course)

Oracle Application Express (APEX) is a low-code development platform that enables you to build stunning, scalable, secure apps with world-class features that can be deployed anywhere. Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. You won’t need to be an expert in a vast array of technologies to deliver sophisticated solutions. Focus on solving the problem and let APEX take care of the rest.

Omni Academy APEX developer course is ideal for students wanted to learn modern fast-pace world class application development step-by-step without past programming background (online classes available).


Why APEX – Concept to Working Prototype in Minutes
You can define new data structures, complete with sample data, using Quick SQL. Quick SQL allows you to generate SQL scripts based on a simple shorthand syntax. These scripts can be saved and easily run within your Oracle APEX environment to create database tables, triggers and views. Then use the Create App Wizard to create reports and forms for the tables you defined. You can even add additional functionality, such as access control, activity reporting and more, to create a fully featured app in minutes.


Oracle Apex Training Course Contents

What is Oracle?

  • Benefit of Oracle
  •  History of Oracle

What is Oracle Application Express (APEX)?

  •  Benefits of Oracle APEX.
  • History of Oracle APEX.
  • APEX useful Resources and links.

Getting Started with Application Express

  • Installation And Configuration of Oracle APEX
  • What is a Workspace?
  •  Creating and managing workspace
  • Application Express Components
  •  Types of APEX Applications.

What is a packaged application?

  • Install various packaged application.
  • Dynamic Actions
  • Validations

SQL Workshop

  •  What is SQL Workshop?
  •  Browsing, creating and modifying Database Objects.
  •  Processing ad hoc SQL and PL/SQL statements
  • Using Query Builder to build queries graphically
  • Generating DDL Data Loading

Workspace and User Administration

  •  Manage and Requesting Services
  •  Create and Manage Users and Groups
  • Understanding different type of users.
  • Monitor Activity

Understanding Application Builder

  •  Application Builder Home Page
  •  Application Builder Defaults
  • User Interface
  • Defaults Application Groups
  •  Managing export repository
  •  Utilities (imp/exp) CSV, Text
  • Oracle Apex Training Course Contents

Creating an Application

  • Creating an application from scratch.
  •  Components of an application.
  •  Page Definition.
  •  Import and Export Application.

Themes & Templates

  •  Understanding Themes
  •  Switching Themes
  • Changing Theme Defaults
  • Understanding Templates and viewing template definitions

Understanding Pages & Regions

  • What is a Page in APEX?
  • Controls on a Page.
  • Different Sections of a Page.
  •  Attributes of a Page.
  •  Create a New Region.
  •  Different Attributes of a Region.

Page Rendering & Processing

  •  Computations
  •  Validations (client side and server side)
  •  Processes
  •  Branches

Creating Reports

  •  Types of Reports
  •  Creating Report with SQL Query
  •  Toggle Report & Attributes
  •  Classic Report & Attributes
  •  Interactive Grid & Attributes
  •  Interactive Reports & Attributes
  •  Add Links to Reports

Creating Charts

  •  Understanding different Types of Charts.
  •  Understanding Different Attributes of a Chart.
  •  Drill down and linked Charts.

Creating Forms

  • Creating Forms with Report
  • Creating Simple Forms
  •  Creating Tabular Forms
  •  Editable Interactive Grid
  •  Creating Master-Detail Forms

Working with Items & Buttons

  •  Understand different Types of Items
  • Creating Different Types of Items (Text, Text Area, Checkbox, Select List, Radio Groupetc.)
  • Edit Item Attributes
  • Create and Edit Buttons (Attribute).

Working with Shared Components

  •  Create Parent and Standard Navigation Menu.
  •  Create Navigation Bar Entries.
  •  Create Dynamic and Static Lists of Values.
  • Create Breadcrumbs
  • Data Load Definition
  • Globalization

Dynamic Actions

  • Refresh items and regions
  • Invoke PL/SQL processes from browser events
  • Retrieve data from the DB and set items values.

Plugins

  • How to use Plugins in applications

Using Files

  • Uploading Image
  • Uploading Static Files
  • Adding an Image as an Application Logo.

API’s

  • API (GET,POST,PUT,DELETE)

Download Free Oracle Autonomous Database (and Web Development with APEX)

  • Final Project

🎥 Your Team FREE eLEARNING Courses (Click Here)


Top  10 Oracle APEX FREE Resources [For APEX Developers]

  1. About APEX
  2. Download APEX 20.2
  3. Oracle Application Express Community Shortcuts
  4. Oracle Application Express Community Links
  5. APEX World Links
  6. Awesome Oracle APEX Resources
  7. Key URLs for new Oracle Developers
  8. Useful Oracle APEX URLs
  9. Oracle APEX Interactive Grid Cheat Sheet
  10. APEX Course Videos 

International Student Fee : 500 USD


Flexible Class Options

  • Evening Classes | Corporate Group Workshops | Fast-Track
  • Week End Classes For Professionals  SAT | SUN
  • Online Classes – Live Virtual Class (L.V.C), Online Training

Related Courses

Oracle Techno Functional Consultant – Oracle Apps R12

Diploma SAP ERP Complete All-in-One Course
Oracle ERP R12 Supplychain Management
R12i Oracle E Business Suite Fundamentals
Oracle E-Business Suite R12 Applications DBA
Oracle Fusion Financials Cloud – 1Z0-408


[/vc_column_text]

KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now

[/vc_column][/vc_row]

Print Friendly, PDF & Email

Lessons

Or log in to access your purchased courses
ABOUT US

OMNI ACADEMY & CONSULTING is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Head Office: A-2/3 Westland Trade Centre, Shahra-e-Faisal PECHS Karachi 75350 Pakistan Call 0213-455-6664 WhatsApp 0334-318-2845, 0336-7222-191, +92 312 2169325
  • Gulshan Branch: A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi-75300, Call/WhatsApp 0213-498-6664, 0331-3929-217, 0334-1757-521, 0312-2169325
  • ONLINE INQUIRY: Call/WhatsApp +92 312 2169325, 0334-318-2845, Lahore 0333-3808376, Islamabad 0331-3929217, Saudi Arabia 050 2283468
  • DHA Branch: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 0213-5344600, 0337-7222-191, 0333-3808-376
  • info@omni-academy.com
  • FREE Support | WhatsApp/Chat/Call : +92 312 2169325
WORKING HOURS

  • Monday10.00am - 7.00pm
  • Tuesday10.00am - 7.00pm
  • Wednesday10.00am - 7.00pm
  • Thursday10.00am - 7.00pm
  • FridayClosed
  • Saturday10.00am - 7.00pm
  • Sunday10.00am - 7.00pm
WhatsApp Us