Training On Developing Applications with Oracle® Application Express
Information Technology is simplifying our life but in itself is becoming complex. Oracle Application Express or APEX is like breath of fresh air in this complex environment. APEX is browser based rapid web application development tool with extremely simple architecture. Oracle Application Express - Easy to develop, Easy to deploy and Easy to manage.
This training an excellent way to learn and to start developing applications with Oracle Application Express.
We heard somewhere - "when you hear you forget, when you see you remember but it is when you do you understand". And while designing our training program we kept this in mind.
We have come up with exhaustive hands-on lab exercises with each topic. We will give you step-by-step instructions on how to build the application using wizards and manually. How to build different components individually and then like the pieces of a jigsaw puzzle put everything together to see the big picture. In this training you will actually develop one application along the way to have an end-to-end understanding of the entire process.
If you are looking to learn Oracle Application Express, look no further. We conduct training in this because we love the product and with our 100% Money Back Guarantee, what can you possibly lose ?
Course Contents
- Introduction to Oracle Application Express
- What is APEX ?
- Apex Architecture
- Key Features of APEX
- Usage of APEX
- Benefits of APEX
- Getting Started with Oracle Application Express
- Creating Workspace & Users
- Logging on to Workspace
- Running & Exploring Sample Application
- Working with SQL Workshop
- Using Object Browser to view, create, edit, drop database objects
- Using SQL Commands to interact with database
- Using SQL Scripts to create, edit, delete and run SQL & PL/SQL scripts
- Using Query Builder to build queries graphically
- Building Application in Application Express
- Building Application From Scratch
- Building Application From Spreadsheet
- Understanding Behind-The-Scene Activities
- Understanding Application Builder
- Application Builder Defaults
- Developer's Preferences
- User Interface Defaults
- Application Groups
- Workspace Themes
- Managing export repository
- Understanding Pages and Regions
- What is a Page in APEX
- Controls on a Page
- Different Sections of a Page
- Page Rendering
- Page Processing
- Shared Components
- Attributes of a Page
- What is a Region
- Different Attributes of a Region
- Creating Interactive Reports
- Creating Interactive Reports
- Interactive Report Attributes
- Interactive Report Column Attributes
- Passing Parameters to Interactive Reports
- Creating SQL Reports
- Creating SQL Reports
- SQL Report Attributes
- SQL Report Column Attributes
- Creating Forms with Report
- Creating Simple Forms
- Creating Tabular Forms
- Creating Master-Detail Forms
- Creating Forms Using Wizards and Manually
- Understanding Page Rendering & Page Processing Components Required for Form
- Working with Items & Buttons
- Creating Different Types of Items (Text, Text Area, Checkbox, Select List, Radio Group etc.)
- Creating Buttons
- Understanding Different Attributes of an Item and Button to Control its Look & Feel, Positioning and Functionality
- Working with Shared Components
- Uploading & Using Images in an APEX Application
- Creating Tabs, Lists, Breadcrumbs, Navigation Bar, List of Values, Trees
- Understanding Different Attributes of Shared Components
- Using Shared Components in Pages
- Understanding & Using Build Options
- Understanding & Using Shortcuts
- Using Application Items, Application Computations & Application Processes
- Having a Thorough Understanding of Following Sections of Page Rendering & Processing
- Computations
- Validations
- Processes
- Branches
- Creating Calendars
- Easy Calendar
- SQL Calendar
- Understanding Different Attributes of a Calendar
- Creating Charts
- Understanding Different Types of Charts
- Creating Charts
- Understanding Different Attributes of a Chart
- Miscellaneous
- Understand & Use Page Zero
- Understanding Different Options on Developer's Toolbar
- Understanding Session State Management
- Understanding Sessions & Session IDs
- Referencing Session States in the Application
- Tools, Tips & Tricks for Debugging & Troubleshooting
- Maintaining an APEX Application
- Understand the URL of an APEX Application its different components
- Changing Home Page of an APEX Application
- Using Logos
- Using Substitution Strings
- Taking an application down for upgrade or maintenance
- Preventing direct modifications to an application in production environment
- Packaging & Deploying Application
- Understanding Different Deployment Options
- Understanding the Packaging & Deployment Process
- Packaging Application with Supporting Objects
- Deploying Application from One Environment to Another
- Using Team Development Functionality
- Using 'Features' - to manage software features
- Using 'Feedback' - to collect user feedback on application. Feedbacks can then be converted into a bug, a feature or a to do.
- Using 'Bugs' - capture and manage software defects optionally related to an APEX application
- Using 'Milestones' - to track and manage software project
- Using 'To-Dos' - to define and manage the development of small tasks
- Using 'Tags' with features, bugs, to-dos
Audience
An excellent course for anyone who wants to learn Oracle Application Express and how to develop applications in APEX.
Pre-requisites
Following are the suggested pre-requisites for this course.
- Basic understanding of database objects (tables, views, sequences, triggers, constraints etc.)
- Basic knowledge of SQL, PL/SQL & HTML
If you are not sure whether you should be doing this course, contact us and we will schedule a one-to-one discussion with you to understand your requirements and advise you.
Lab Environment
For these lab exercises, participants will be provided access to his/her own dedicated APEX Workspace which can be accessed from web browser over the internet. This workspace will be available to you 24 hours a day for the entire duration of your course. The APEX version is 4.0 running on Oracle XE database.
