Live Online 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 ?

This training covers the following

 

  • 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 Query Builder to build queries graphically
    • Using SQL Scripts to create, edit, delete and run SQL & PL/SQL scripts
  • 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
    • Attributes of a page
    • What is a region
    • Different attributes of a region
  • Creating Reports
    • Creating Interactive Reports
    • Creating SQL Reports
    • Understanding report attributes & report column attributes
  • Creating forms
    • Creating forms with report
    • Creating simple forms
    • Creating tabular forms
    • Creating master-detail forms
    • Creating forms using wizards and manually
  • Working with Items & Buttons
    • Creating different types of items (text, text area, checkbox, select list, radio group etc.)
    • Creating buttons
    • Understanding different attributes of items and buttons to control its look & feel, positioning and functionality
  • Working with shared components
    • Creating Tabs, lists, breadcrumbs, Navigation Bar, List of values
    • Understanding different attributes of shared components
    • Using shared components in pages
  • Understanding different sections of a page in details
    • 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 charts
  • Security
    • Understanding different authentication options in APEX
    • Creating a custom authentication
    • Switching from one authentication method to another
    • Understanding authorization in APEX
    • Creating authorization schemes
    • Attaching authorization schemes to tabs, pages etc.
  • Page Zero, Themes & Templates
    • What is Page Zero
    • Creating Page Zero
    • Understanding themes
    • Switching themes
    • Changing theme defaults
    • Understanding templates and viewing template definitions
  • Session State, Debugging & Troubleshooting
    • Understanding session state management
    • Understanding sessions & session IDs
    • Referencing session states in the application
    • Exploring Developer's Toolbar
    • Tools, tips & tricks for debugging & troubleshooting
  • Packaging & Deploying Application
    • Understanding different deployment options
    • Understanding the packaging & deployment process
    • Packaging application with supporting objects
    • Deploying application using export/import

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 knowledge of SQL, PL/SQL & HTML
  • Basic understanding of database objects (tables, views, sequences, triggers, constraints etc.)

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.

Instructor profile


The instructor is an Oracle Certified Master & Oracle Certified Professional in Oracle 10g, 9i, 8i & 8 & certified Project Management Professional having 12 years of exhaustive experience in IT and over 9 years of experience in Oracle Technologies .

Certifications

 

Training duration


The total training duration for this course is approximately 14 hours, which excludes the time that you will be spending on doing the lab exercises.

At the end of each theory session, you are expected to finish all the lab exercises before next session. 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 3.1.2 running on Oracle XE database.

There will be a maximum of only 5 participants per batch.

Schedule, Investment & Freebies


The upcoming schedule for "Developing Applications with Oracle Application Express" for year 2008 is as follows.

Schedule for 2008 Remarks
Nov - 3rd - 13th (Mon, Tue, Wed, Thu) Corporate Booking. Registration Closed.
Nov - 12th, 13th, 14th (Wed, Thu, Fri) Batch Full. Registration Closed.
Nov - 28th, 29th, 30th (Fri, Sat, Sun)* Batch Full. Registration Closed
Dec - 1st To 5th (Mon To Fri) 5 days part time on weekdays (3 hrs/day x 5 days)
Dec - 6th, 7th, 13th, 14th (Sat & Sun) 4 days part time on weekends (3.5 hrs/day x 4 days)
Dec - 15th To 19th (Mon To Fri) 5 days part time on weekdays (3 hrs/day x 5 days)
For Year 2009 To be announced in December

 

* This batch was originally scheduled for Nov 21st, 22nd & 23rd. It has been rescheduled to Nov 28th, 29th & 30th.

It typically takes two to three weeks to get a batch of your choice, so please register in advance to start on time.

Apart from the schedule mentioned above, we also have batches on demand. The schedule and timings for on-demand batches depend on the location and preferences of the participants. However, there should be a minimum of 3 participants to schedule an on-demand batch.

The price of this training program is US$ 850, which is one-half to one-fourth of what other institutes are charging for the same course. Apart from that, no other institute offers try before buy, money back guarantee, hands-on practice environment, live interactive training by certified master and referral reward program - all these features except us. Don't believe us blindly. Google yourself now (opens in a separate window). It's 100% risk free to you.

Free Pro Oracle Application Express
And that's not all. You'll get this eBook worth US$ 38.49 absolutely free.

 

Once you have the thorough understanding of Oracle Application Express after going through our training program, use this book to gain advanced skills. This book will be delivered to you in a PDF format as an eBook.

In Pro Oracle Application Express, authors John Scott and Scott Spendolini open the “hood” of APEX and expose the full power behind its easy–to–use GUI interface. They show you what you need to know to produce powerful, professionally polished applications, things such as user-authentication models, approaches to layout and navigation, how to integrate Ajax, how to deal with localization issues such as time zones and translations, how to customize the look and feel of an APEX web site, and much, much more.

Free
Plus - Get our support and free Step-by-step Guide to to install Oracle XE Database & Oracle Application Express on your PC.

 

We will give you a Step-by-step guide to install Oracle Application Express and Oracle XE Database on your PC. And in case you are not able to configure Oracle XE Database with Oracle Application Express on your PC following the step-by-step guide, we will even arrange a web conference to troubleshoot and help you with the installation after the training is over. Have your own Oracle Application Express Test Lab on your own PC to practice and learn as much as you want.

We want to equip you with all the resources that we can so that there are no barriers in learning Oracle Application Express and mastering it.

Please use the the form below to contact us for this training program.

How it works ?


Video PresentationClick here to check out this 5 minutes video presentation (with audio) highlighting the features and benefits of our Live Online Training and how exactly it works.

Don't forget to adjust the volume of your PC.

 

Testimonials

 

Team DBCON's APEX training provides a great start on developing applications using Oracle's APEX tool. The content is comprehensive and very useful. I have been able to apply things learned in the class directly in applications I am working on at work. The program was very helpful.

- Tom Adams, Washington DC, USA

The materials that the training program covered and the hands-on exercises it provided enable me to develop more advanced skills. The online training tool is easy to use and is convenient for the users to receive training anywhere they like with the Internet access. In general, the price you pay is reasonable and totally worth it. 

- Cindy Hu, BC, Canada

Although it is simple to start using APEX, the breadth of the product can be a little overwhelming. This excellently structured and well delivered course provides a solid grounding that should enable you to develop APEX applications with confidence. The on-line conferencing technology proved to be quick and unintrusive. I would not hesitate to take another course that is delivered in this way. 

- Stuart Ellis, London, UK

From content to deliverable technique DBCON delivers outstanding quality and knowledge.

- Alejandro Barrere, Florida, USA

(If you would like to contact these participants to check on our training program, please feel free to contact us. We will provide you their contact details after ensuring that they do not have any objections on your contacting them).

Act now

 

Never leave the sight of your decision without taking first action towards it - By famous and most sought after success coach Anthony Robbins.

Take action now. Fill in your details below and we will get in touch with you.

First Name  
Last Name  
E-Mail  
Message  
 

 

Or call us on the any of the numbers mentioned here to speak to an actual person. If we are not able to answer you, please leave a voice mail with your name, contact number, location, preferred time to call and we will get back to you.

Make Payment


Please ensure that you have a confirmed batch schedule before making the payment. It may take to 2-3 weeks to get a batch schedule and timing that works best for you. Once the batch is confirmed please click on the link below to pay and register for the course. (Please pay as soon as the batch is confirmed as we take limited number of participants per batch and it is on "first come (read pay), first serve" basis. Payments can be made online by all the major credit cards.