by | Released July 2014 | ISBN: 9781771372664

In this Oracle Application Express (Oracle APEX) training course, expert author Chris Ostrowski will teach you everything you need to know about Oracle's primary tool for developing web applications with SQL and PL/SQL. This course is designed for new users to Application Express, but you should have familiarity with Oracle SQL fundamentals.You will start by learning how to install and administer Apex, then jump into learning the basics of creating applications and pages. Chris continues with teaching you all about forms, reports, and charts, templates, and themes. This video tutorial also covers creating mobile applications, and advanced topics including security features, team development features, and the Apex listener.Once you have completed this computer based training course, you will have a fundamental understanding of how to use Oracle Application Express for your own development projects. Show and hide more Publisher resources View/Submit Errata

1. Apex - Installation And Administration
   • Introduction And About The Author 00:01:45
   • What Is Oracle Application Express? 00:02:27
   • The Apex Architecture 00:01:44
   • Downloading And Installation 00:08:01
   • High-Level Overview Of Apex Pages 00:01:19
   • Apex Hierarchy - Workspaces, Applications, Pages, Regions And Items 00:04:24
   • Creating A Workspace 00:07:20
   • Creating Workspace Users 00:06:48
   • Setting Workspace-Level Attributes 00:05:37
   • Setting Security Attributes 00:01:56
2. Apex Basics - Applications, Pages And Regions
   • Types Of Apex Applications - Part 1 00:07:46
   • Types Of Apex Applications - Part 2 00:07:04
   • Creating A New Application - Part 1 00:06:30
   • Creating A New Application - Part 2 00:06:37
   • Understanding Pages And Regions 00:07:15
   • Using The Wizards - Part 1 00:08:52
   • Using The Wizards - Part 2 00:06:41
   • After The Wizards - Part 1 00:06:00
   • After The Wizards - Part 2 00:05:26
   • Page Rendering - Part 1 00:05:55
   • Page Rendering - Part 2 00:06:12
   • Page Rendering - Part 3 00:06:09
3. Apex Regions - Forms, Reports, Charts And More
   • Forms - Part 1 00:06:07
   • Forms - Part 2 00:05:16
   • Forms - Part 3 00:06:24
   • Forms - Part 4 00:04:45
   • Forms - Part 5 00:04:59
   • Forms - Part 6 00:08:09
   • Reports - Part 1 00:07:25
   • Reports - Part 2 00:08:09
   • Reports - Part 3 00:01:51
   • Reports - Part 4 00:03:16
   • Reports - Part 5 00:03:16
   • Charts - Part 1 00:06:19
   • Charts - Part 2 00:04:45
   • Maps 00:03:18
   • Trees 00:04:33
   • Calendars 00:03:19
   • Other Types 00:08:32
   • Shared Components - Part 1 00:07:07
   • Shared Components - Part 2 00:05:24
   • Dynamic Actions 00:03:38
   • Tabs 00:05:24
   • Linking To Other Pages - Part 1 00:05:51
   • Linking To Other Pages - Part 2 00:08:04
4. User Interface, Templates And Themes
   • What Is A Template? 00:08:42
   • What Is A Theme? 00:07:22
   • Applying Themes And Templates To Your Application 00:04:18
   • Making Changes To A Template 00:03:56
   • Allowing Users To Make Their Own Changes 00:05:23
5. Creating Mobile Applications
   • Mobile Vs. Desktop 00:05:41
   • The Apex Mobile Theme - Part 1 00:06:26
   • The Apex Mobile Theme - Part 2 00:03:50
   • ThemeRoller And PhoneGap 00:04:54
6. Apex Advanced Topics - Security, Performance And Team Development
   • Authentication Schemes 00:05:44
   • Other Security Features 00:04:26
   • Debugging And Tuning Your Application For Performance 00:04:15
   • Team Development Features 00:05:42
   • The Apex Listener 00:03:38
   • Web Services 00:06:04
7. Conclusion
   • Wrap-Up 00:03:48
Show and hide more