ORACLE APEX

TechgenLabs is one of the leading IT online Training and Placements Organization in USA. Oracle Apex  Online Training classes by TechgenLabs with highly qualified and excellent experienced trainers. Our trainers are experts and they have more experience in the real time environment in Oracle Apex  online training. We provide interactive and effective training for our student. So that you can interact with the faculty to clarify your doubts. Our team of well experienced Oracle Apex  online trainers with vast real time IT experience in Oracle Apex  Online Training is dedicated towards providing quality training in Oracle Apex  Online Training. We provide all real time interview questions to the students. We will provide recorded videos and material for future reference. Oracle Apex  Online Training is your one stop & Best solution to learn at your home with flexible timings. We placed our students in USA, UK, Singapore, Malaysia, Canada, South Africa, and Scotland. We  provide Oracle Apex  interview support and project support.

Oracle Apex Online Training Course Content

Introduction to Apex

  • Intro
  • Architecture
  • Versions
  • Documentation
  • Software Requirements

Getting started

  • Application Homepage
  • Developer Navigation Bar
  • Page Editor
  • Page Rendering and Processing
  • Shared Components

SQL Workshop

  • Browsing, Creating and Modifying Objects
  • Issuing adhoc SQL commands
  • Processing Ad Hoc SQL Statements
  • Managing Scripts
  • Creating, Running and Saving SQL Queries

Creating Reports

  • Basic Reports
  • Report Analysis Pages
  • Interactive Reports
  • Report and Column Attributes
  • Report Layout and Pagination
  • APEX ITEM package

Forms

  • Master Detail Form
  • Generating Primary Keys
  • Procedure based Form

Calendars and Charts

  • Calendar wizard
  • SQL Calendar
  • Calendar Attributes
  • Date Intervals
  • Calendar Links
  • Flash Charts
  • SVG Charts
  • HTML Charts
  • Chart Asynchronous Updates

Managing session state

  • Session overview
  • Page URL Syntax
  • Session State Page
  • Setting and Getting Session Data
  • Clearing Session Data
  • Bookmarking Public Pages

Navigation

  • Navigation Bars
  • Bread Crumbs
  • Tab Sets
  • Lists
  • Trees

Validations and Computations

  • Item level validations
  • Page level validations
  • Custom validations using PL/SQL
  • Page Computations

JavaScript and CSS

  • JavaScript Overview
  • Adding JavaScript to an Application
  • Referencing Page Elements with JavaScript
  • JavaScript Events
  • Cascading Style Sheets Overview
  • Uploading and using CSS in Apex

Page Layout

  • Page Templates
  • Substitution Strings
  • Regions
  • Page 0

Uploading and Downloading Documents

  • Uploading Documents to Apex
  • Displaying Uploaded Documents
  • Making Documents Available for Download
  • Storing Document Attributes
  • Storing Documents in Custom Tables

Web Services

  • Web Service Overview
  • SOAP Simple Object Access Protocol
  • WSDL Web Services Description Language
  • UDDI Universal Description, Discovery, and Integration
  • Creating Web Services from a WSDL
  • Creating Web Services Manually
  • Displaying Web Service Results

Emailing with Apex

  • Configuring Email Settings
  • Enabling Network Services for Oracle 11g
  • Sending Text and HTML Email
  • Sending Email Attachments
  • Viewing Email Queue and Logs

Creating PDFs

  • PDF Printing with Apex
  • Installing BI Publisher
  • Configuring Apex to Work with BI Publisher
  • Creating Simple PDF Report
  • Creating Master-Detail PDF Report
  • Using BI Publisher Desktop for Customized PDF Reports

Administering Apex workspaces

  • Managing Users
  • Provisioning options
  • Provisioning a schema
  • Provisioning extra workspace storage
  • Workspace reports
  • Locking workspaces
  • Removing workspaces

Security

  • Authentication
  • Configuring LDAP Authentication
  • Authorization
  • Creating and Using Access Control Page
  • Session State Protection

Using Utilities

  • Importing and Exporting Data
  • Generating Data Definition Language Statements
  • Viewing Object Reports
  • Monitoring the Database

>Globalization

  • Language Preferences
  • Translating Applications and Messages
  • Language Identification
  • Translating Internal Messages

Deploying Applications

  • Deployment Options
  • Packaged Applications
  • Exporting Application Metadata
  • Supporting Objects Page
  • Exporting Supporting Objects
  • Importing an Application