Skip to main content

Oracle APEX: Principles

Oracle APEX: Principles

Program Description (Version 2.0)

 

Vision

Creating technology awareness of those in need and providing a platform for the underprivileged to learn from successful people for the attainment of the above objects and also teach the software development technology and process to the student communities, guide and help them to be well equipped to get employment opportunities.

Mission

Provide Oracle APEX Fundamentals Trainings to the University, College, School Students in India and globe.

Syllabus 

1.    Introduction to Oracle APEX 

Ø   What is Oracle APEX?

Ø   Power of Oracle APEX

Ø   About Oracle APEX Community

Ø   Architecture

Ø   Out of the box Development Features

Ø   Provisioning an APEX Workspace

Ø   Product Components 

2.    Gallery Applications 

Ø   Installing a Sample Application

Ø   Understanding Sample Application (Reports, Forms, Cards, Calendars and etc.,)

3. Introduction to Oracle SQL and PL/SQL 

Ø   Oracle SQL: Introduction

Ø   Live SQL

Ø   Oracle PL/SQL: Introduction 

4. Exploring SQL Workshop   

Ø   Object Browser

Ø   Use SQL Commands and SQL Scripts

Ø   Sample Datasets

Ø   Data Workshop (Load and Unload Data)

Ø   Query Builder 

     5. Building an Application 

Ø   Application Builder Concepts

Ø   Create a New Application

Ø   Create an Application from a File

Ø   Copy & Delete an Application 

6. Understanding Application Definition 

Ø   Application Definition

Ø   User Interface

Ø   Progressive Web Application (PWA) 

7. Exploring Shared Components – Files & Reports 

Ø   Static Application Files

Ø   Static Workspace Files 

8. Managing Pages in an Application 

Ø   Understanding Page and Page Components

Ø   Pages, Regions, Items, Buttons and Page Designer 

     9. Developing Different Types of Reports 

Ø   Developing Reports (Interactive Report, Interactive Grid)

Ø   Classic Reports and Cards

Ø   Developing Different Types of Reports

      10. Developing and Using Forms 

Ø   Application Form Types

Ø   Create and Edit a Form

Ø   Master Detail Form  

     11. Oracle APEX Security 

Ø   Authentication

Ø   Authorization 

12. Introduction to HTML, CSS and JavaScript 

Ø   HTML & CSS: Introduction

Ø   JavaScript: Introduction 

     13. Create a Mobile Application

Ø   Tips & Tricks to create a Mobile Application 

     14. Export and Import Application

Program Events

I) Inauguration

II) Sessions

5 online sessions (5*3 = 15 hrs) will be conducted on weekends. 

Note: 

            1)     Session duration would be 3 hrs

            2)     Preferably on Saturday

III) Assessments

Two online and One offline assessments will be conducted and total would be for 100 marks. 

I) Assessment I: Objective type questions – 25 marks

II) Assessment II: Objective type questions – 25 marks

III) Assessment III: Mini Project – 20 marks

IV) Graduation 

Certificate distribution. End of the program.

Complementary 

Rewards from the Community

After students have completed their course and cleared the assessment, they will earn below rewards. 

1)     Oracle APEX: Principles Badge


2)     Certificate of Excellence (Top 5 Students)


3)     Course Completion or Participation Certificate


4)     Oracle Academy APEX Course (Version 19.2) PDFs will be shared, which provide step-by-step instructions for implementing Oracle APEX in your real-time projects.

Rewards Eligibility

Oracle APEX: Principles badge: 

Upon completion of the course and clear the assessment, students will be getting course completion badge.

Certificate of Excellence: 

Top 5 students will be qualified to receive the certificate of excellence.

Certificate of Completion: 

Students, who scored >= 70 marks will be eligible to receive the course completion certificate. 

Certificate of Participation: 

Students, who scored >= 40 marks will be eligible to receive the participation certificate.

Certificate of Attendance: 

Students, who have 90% attendance and not scored >= 40.

Oracle APEX Course Curriculum: 

For all the attendees.

About Author(s) 

I) Karkuvelraja Thangamariappan

He is an Oracle Certified Professional (OCP) & OracleACE Pro  with 8+ years of experience with Oracle APEX Applications, holding a bachelor's degree (B.E) in Electrical and Electronics Engineering (2014), has a wide range of expertise in the Oracle APEX, PL/SQL & Java environment.

In August 2014, he started his career as an Oracle APEX & PL/SQL developer. Currently, He works as the Lead Engineer for DAMAC Properties, Dubai and serves as the Director - Training & Special Projects for the Indian Oracle APEX User Group (INOAUG).

He further participates actively in the Oracle community by publishing technical posts on my blog ORCLKING. On Twitter, He can be reached at @tkarkuvelraja.

Couple of times, he awarded Member of the Month by the World Oracle APEX Community (apex.world).

II) Varughese Mathew

He is an Oracle Certified Professional (OCP) & OracleACE Associate  with 22+ years of experience IT Industry. He has rich knowledge in almost all the Oracle Technologies. 

He is the CEO & CTO of ATC Technologies, Sharjah and serves as the Director – Overseas & Placement for the India Oracle APEX User Group (INOAUG). On Twitter, He can be reached at @varghese0905.

Contact Us

Email: 

  • tkarkuvelraja@gmail.com
  • vargheseocp@gmail.com

Important Links

Program Summary

Comments

Popular posts from this blog

Printing Page Numbers in RTF Template [Oracle BI Publisher]

Here I am giving an example to print the page numbers dynamically in the RTF (Rich Text Format) template. Step 1:  Go to page footer and copy and paste the below script. Page |  <?fo:page-number?>  of  <?fo:page-number-citation:xdofo:lastpage-joinseq?> <fo:page-number> :   This is the object, which is used to represent the current page-number. <?fo:page-number-citation:xdofo:lastpage-joinseq?> :  This is the syntax, which is used to represent the total number of pages. Step 2:  Load the XML and preview the result. Output: That's it. References: fo:page-number Printing Page Number Code in Oracle XMLP RTF Template

Generating the report with APEX_DATA_EXPORT

With the APEX_DATA_EXPORT package, you are able to export data from Oracle Application Express in the following file types: PDF, XLSX, HTML, CSV, XML, and JSON. Step 1: Create a table and populate it with some sample records. CREATE TABLE emp   (     empno        NUMBER,     first_name   VARCHAR2(240),     last_name    VARCHAR2(240),     mgr          NUMBER,     deptno       NUMBER,     sal          NUMBER,     created_date TIMESTAMP (6),     comm         NUMBER,     hiredate     DATE,     JOB          VARCHAR2(240),     ename        VARCHAR2(240),     PRIMARY KEY (empno) USING INDEX ENABLE   ); /    INSERT INTO emp (empno, first_name, last_name, mgr,                   deptno, sal, created_date)         VALUES                 (1, 'Larry', 'Ellison', ,                  10, 5000, LOCALTIMESTAMP);   INSERT INTO emp (empno, first_name, last_name, mgr,                   deptno, sal, created_date)         VALUES                 (2, 'Juan', 'Juan', 1,  

Save Selected Interactive Grid Records into a Collection - Oracle APEX

Here I am giving an example to save selected interactive grid records into a oracle apex collection. Step 1: Create a new blank page. Note: Mine was page 20. You will need to update reference to " P20 " with your page number if it's different. Step 2: Create a new interactive grid report region to the page using below query. Set Static Id "EmpDetails" to the region. SELECT  *     FROM   ( SELECT  emp . empno ,                emp . ename ,                emp . JOB ,                dept . dname department ,                dept . loc  LOCATION ,                mgr . ename  manager ,                emp . hiredate ,                 nvl ( emp . sal , 0 )  salary ,                 nvl ( emp . comm , 0 )  commission            FROM  eba_demo_chart_emp emp ,                eba_demo_chart_dept dept ,                eba_demo_chart_emp mgr           WHERE  emp . deptno = dept . deptno             AND  emp . mgr      = mgr . empno  ( + )           ORDER   BY  emp . ename