Oracle APEX 19 : SQL, PL/SQL to Web Application Development

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Overview – Topics of coverage

Chapter 2: Overview about RDBMS and SQL

Lecture 1: What is RDBMS?

Lecture 2: Business flows, ER diagrams and RDBMS

Lecture 3: Structured Query Language – Introduction

Lecture 4: Environments to Practice SQL

Lecture 5: Data Definition Language Overview

Lecture 6: DDL Demonstration : Part 1

Lecture 7: DDL Demonstration: Part 2

Lecture 8: DML Demonstration: Part 1

Lecture 9: DML Demonstration: Part 2

Chapter 3: Overview about PL/SQL

Lecture 1: What is PL/SQL?

Lecture 2: PL/SQL code block

Lecture 3: PL/SQL program contruct

Lecture 4: PL/SQL compute demonstration

Lecture 5: Subprogram – Procedure, Functions

Lecture 6: Database Stored Procedure : Demonstration

Lecture 7: Caution : Having the objects valid

Lecture 8: Importance of exception handling – An overview

Chapter 4: Oracle APEX 19 : Introduction and access

Lecture 1: Why Oracle APEX?

Lecture 2: Accessing the Online environment

Lecture 3: Navigation in Oracle APEX

Chapter 5: Oracle APEX 19: Building a simple spreadsheet application

Lecture 1: Building a simple application from spreadsheet data

Chapter 6: Oracle APEX 19: Building Application Dashboard using database objects

Lecture 1: Creating Database objects using sample dataset

Lecture 2: Review of Database Objects

Lecture 3: Building a report using Oracle Apex

Lecture 4: Validating the report

Chapter 7: Oracle APEX 19: Building Report and Form Based Application – 1

Lecture 1: Building Report and Form based application

Lecture 2: Executing the Report and Form based Application

Chapter 8: Oracle APEX 19: Building Report and Form Based Application – 2

Lecture 1: Creation of Data objects from Data set

Lecture 2: Creating a Card Report based on DEPT

Lecture 3: Creating Form and linking it to card report

Chapter 9: Oracle APEX 19: Page Designer

Lecture 1: What is a Page Designer in Oracle Apex?

Lecture 2: Navigation in Page Designer in Oracle Apex.

Lecture 3: Passing Parameter between two Interactive Reports.

Lecture 4: Modification of report using Page Designer

Lecture 5: Custom designing sample requirement using Page Rendering and Page Processing

Lecture 6: Triggering Email from Oracle APEX based on event

Chapter 10: Oracle Apex 19 : Page Designer – Dynamic action

Lecture 1: What is Dynamic Action?

Lecture 2: Sample Application for Dynamic Action

Chapter 11: Oracle Apex 19: Page Designer – Shared Components

Lecture 1: Shared Components – Menus

Lecture 2: Shared Components – Breadcrumbs

Lecture 3: Shared Components – Authentication and Authorization Overview

Lecture 4: User Authentication – Demonstration

Lecture 5: User Authorization – Demonstration

Chapter 12: Oracle APEX 19: RESTful Webservices – communicating with external devices

Lecture 1: What is RESTful webservices

Lecture 2: Setting up RESTful webservices in Oracle APEX

Lecture 3: RESTful services set up review & Demonstration 1

Lecture 4: RESTful services – Communication between APEX & Raspberry pi (IOT Device)

Chapter 13: Oracle Apex 19: Additional learning through Sample application install

Lecture 1: Additional Learning through Sample application

Chapter 14: Next Step

Lecture 1: Next step towards further learning