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

Friendly URL: Redirect to Different Page after Login in Oracle APEX 20.1

Oracle has updated apex.oracle.com to APEX 20.1 which includes among other features the new Friendly URL option. Here i am giving an example to redirect to different page after login in Oracle APEX 20.1 [Friendly URL Enabled] Step 1: Define home page for each user in emp master table as below Step 2: To enable Friendly URL Syntax, follow below steps, 1) On the Workspace home page, click the App Builder icon. 2) Select an application (The Application home page appears). 3) From Application home page, you can access the Definition page in TWO ways: Click the Edit Application Properties button. From Shared Components:              1) Click Shared Components .              2) Under Application Logic, click Application Definition Attributes . The Definition page appears. 4) Under Properties, configure the Friendly URL s attribute: Click Apply Changes to save your ch...

Open modal/inline dialog in Oracle APEX using JS

Analysis: From Oracle Apex 4.2,  Inline dialog can be opened as modal dialog/popup using JS. Open inline dialog region as modal dialog: Step 1: Create static region. Step 2:  Set Template => Inline Dialog. Step 3:  Assign the static id to the region. Fig 1: Set template and Static ID Step 4:  Create button or change one of the report column type to Link. (Action: Redirect URL). Step 5:  Put the below JS to open the region as modal dialog.                javascript:openModal('unitpricedetails');            Fig 2:  Open simple modal dialog Open inline dialog region as modal dialog and pass values to the items: Common Steps:  Step 1 to Step 4. Step 5:  To pass value to that region, create P1_UNIT_ID in the inline  dialog.       javascript:$s('P1_UNIT_ID','#UNIT_ID#');javascript:openModal('unitpricedetai...