Introduction To Basics Of Oracle Apex For Developers

(2025 Version) Learn Introduction to basics of Oracle APEX : For Developers and for beginners

What you'll learn

Create APEX workspace

Learn to use APEX workspace

Learn to use APEX page designer

Building blocks of APEX application

Basics of APEX page

Create Interactive report

Create Interactive Grid

Create classic report

Create content row

Templates, template components, plugin

Create custom plugin

Page navigation

Theme Roller

Requirements

Prior experience working as a developer in previous assignments

The course is delivered in an Indian English accent, ensuring clarity and relatability throughout. If you find Indian English difficult to understand, it may be best to consider other courses, as this course focuses on an Indian English pronunciation and style.

Good to have basic understanding of HTML, CSS and JavaScript

SQL and PLSQL knowledge is needed for this course

Description

This course is designed to help developers who aspire to learn basics of Oracle APEX from scratch.  Please enroll to this course only if you are planning to learn the basics of Oracle APEX and to become a Oracle APEX developer.If you are a functional or sales professional then this course may not be a best fit for you.NOTE: This course does not cover advanced topics.NOTE: The course is delivered in an Indian English accent, ensuring clarity and relatability throughout. If you find Indian English difficult to understand, it may be best to consider other courses, as this course focuses on an Indian English pronunciation and style.With this course you will learn the basics of development and below are few are the highlights on the topics covered in this course:Create a free APEX workspaceCreate APEX workspace in ATP databaseLearn to use APEX workspaceLearn to use APEX page designerBuilding blocks of APEX applicationCreate page with Interactive reportCreate page with Interactive GridCreate page with Content Row, Classic reportCreate buttons eventsPage navigationTemplates, Template components and PluginCreate a custom Masonry layout pluginTheme RollerCustomize page look and feeland much more…What is Oracle APEX ?Oracle APEX is the world's most popular enterprise low-code application platform that enables you to build scalable, secure web and mobile apps, with world-class features, that can be deployed anywhere – cloud or on premises.Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. You don'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.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: (OPTIONAL) Get a free tier Oracle Cloud Account

Lecture 2 Sign Up for a free tier OCI account

Section 3: Get a APEX workspace

Lecture 3 Create free APEX workspace

Lecture 4 Create a APEX workspace in ATP database

Lecture 5 Delete the workspace

Lecture 6 Delete the workspace in ATP database

Lecture 7 Login to APEX workspace

Lecture 8 APEX product components

Section 4: Getting started with APEX application development

Lecture 9 Create first APEX app using the Gallery starter app in minutes

Lecture 10 Delete APEX application

Section 5: SQL Workshop concepts

Lecture 11 Object Browser

Lecture 12 SQL Command

Lecture 13 SQL Script

Lecture 14 Sample Dataset

Lecture 15 Quick SQL

Lecture 16 Delete table, data and remove sample dataset

Lecture 17 Data Generator (Blueprint)

Lecture 18 SQL developer web

Section 6: Getting started with App Builder

Lecture 19 Create your first app using app builder wizard

Lecture 20 Friendly URL / f?p URL

Lecture 21 Overview on APEX application and how it renders and processes a page

Lecture 22 Create an APEX application using file and file data

Section 7: Working with Page and Page components

Lecture 23 Page components

Lecture 24 Normal, Modal Dialog, Non Modal Dialog page style

Lecture 25 Page Designer

Lecture 26 Global Page

Lecture 27 Lock and Unlock Page

Lecture 28 Debug application

Section 8: Dynamic Content

Lecture 29 Add dynamic content region

Section 9: Reports in APEX

Lecture 30 Different Types of reports

Lecture 31 Interactive Report

Lecture 32 Interactive Grid and Classic Report

Lecture 33 Faceted Search and Smart Filters

Lecture 34 Cards

Lecture 35 Content Row

Section 10: Theme, Templates and more…

Lecture 36 What is Universal Theme

Lecture 37 Theme Roller

Lecture 38 Redwood light theme style

Lecture 39 Add company logo and company name

Lecture 40 Templates

Lecture 41 Template Option

Lecture 42 Avatar template component

Lecture 43 Badge template component

Lecture 44 Content Row template component

Lecture 45 Hide and disable button, select one, select all,…

Lecture 46 Edit button action to open form

Lecture 47 Delete button action to delete the table record

Lecture 48 Upload files to APEX, Copy theme

Lecture 49 Build a custom Plug In

Section 11: Migration of application

Lecture 50 Working Copy

Lecture 51 Migrate application with export / import (with supporting objects)

Lecture 52 Create DDL and DML script

Section 12: Congratulations

Lecture 53 Happy Learning

Beginners in Oracle APEX,This course is only for developers,This is a 100 % hands on course (practical) with no presentation or theory,This course is not for Functional and Sales professionals,This course does not cover advanced topics and covers only basic concepts,The course is delivered in an Indian English accent, ensuring clarity and relatability throughout. If you find Indian English difficult to understand, it may be best to consider other courses, as this course focuses on an Indian English pronunciation and style.