All ApEx Lessons

Watch Preview

Length: 18:41:19

All of the ApEx lessons all bundled together, including version 18.2. Mapping, packages, procedures, master detail and more. This is the best value for your money! 6 courses bundled together - best value EVER!

All ApEx Lessons

All ApEx Lessons

All of the ApEx lessons all bundled together. Mapping, packages, procedures, master detail and more. This is the best value for your money!

6 Courses in this Lesson. Value of over $6,100 for just $349.

You get these 6 courses bundled together:

Oracle ApEx - $2100 value

What's New in ApEx 5.0? - $800 value

Mapping Your Data (with ApEx) - $800 value

Master Detail with Mass Update with ApEx - $800 value

WSDL and RESTful Web Services with ApEx - $800 value

Packages, Procedures and Functions with ApEx - $800 value

Brad Brown is a former Oracle ACE Director (recognized Oracle expert by Oracle Corporation). In fact, he was one of the first 12 people to be recognized as an Oracle ACE. Brad has been educating people on Oracle technologies since the last 80s. Brad founded TUSC in 1988 after working for Oracle. He co-authored one of the first books on Oracle ApEx and he's a world renowned speaker at Oracle conferences too.

If you attended this course in person, it would take 5+ days and would cost you over $6000. Take a look at Oracle's pricing!

There is SO much content in this class! What do you get for just $349 (for one year, less for less time)?

Access to the online course Oracle ApEx Training complete with over 50 lectures

On demand access to complete the course

Download and watch the videos from any device (Roku, Android, iOS, Windows, Mac, or Linux)

This Easy-To-Follow Educational Course Will Walk You Through How to Develop with Oracle Application Express Step by Step. This course is more than 8 hours of direct training. The exercises will take you at least another 8-16 hours. Take it at your own

This is a 40 minute introduction to Oracle Application Express. This course is typically offered in a multi-day format in person. You can take this course at your own pace!
Oracle Application Express (ApEx) is a rapid web application development tool for the Oracle database. Using only a Web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure. Oracle APEX is a fully supported, no cost option of the Oracle database. In this video series, Bradley D. Brown (bio below) walks you through everything you need to do in order to start creating ApEx applications. Brad starts by showing you how to creating your own FREE cloud-based workspace on Apex.Oracle.Com and walks you through everything from provisioning your ApEx account after receiving your confirmation email to the ApEx object browser (i.e. like TOAD or SQL Developer for the browser), executing SQL commands, writing SQL scripts, the query builder, how to load data into an existing or new table from a delimited file, generating Data Definition Langage code (DDL), writing MVC methods (i.e. insert, update, delete and select functions) on tables, creating and editing user interface defaults, then Brad covers administrative functions such as managing services, users and groups, monitoring activity, dashboards, and utilization reports. There are starting with an introduction to application development with ApEx, loading the data for the application,creating an application from a spreadsheet, creating an instant application, creating an application from scratch, and then Brad goes into detail about page region controls and shared components are explained in detail. Brad covers the many application regions starting with creating your first region such as an HTML Region. There are videos that cover page rendering and page processing and shared components. Additional regions are discussed such as multiple HTML regions, interactive reports, classic reports, wizard-based reports, creating a form and report, creating a tabular form, creating master detail and form on SQL, creating a form on a procedure and creating a summary form, creating charts, plug-ins, maps, trees (i.e. connect-bys), calendars, lists and the purpose of page 0. Breadcrumbs and PLSQL regions, URL regions and iFrames, the region display selector, help text, wizard pages, data mapper loader wizard, feedback pages and the infamous login page and access control. There is SO much content in this class! This training session will take you from 1-5 days to complete. Brad covers Oracle Application Express (ApEx) from the ground up through advanced topics. Bradley D. Brown. Brad is the CTO and founder of InteliVideo, a cloud-based video marketplace. Brad was a TUSC founder and is currently a board advisor for TUSC. TUSC was sold to Rolta in 2008. Brad also founded IntelliReal in 2005, which was sold to Equifax in 2011. His vast experience and expertise have earned him roles as acting chief information officer of several companies over more than 23 years at TUSC. Brad has also served on numerous company boards. Brad is the author of several best selling Oracle Press books. Oracle awarded Brad the honorary title of Oracle ACE Director for Fusion Middleware. Brad taught “New Venture Creation” at the University of Denver’s Daniels College of Business for 2 years. In 2009, his alma mater, Illinois State University put Brad into their first Hall of Fame for the College of Applied Science and Technology.

Bradley D. Brown, brad@intelvideo.com. Brad is the CEO, President and founder of InteliVideo, a cloud-based white and private label video on demand platform. Brad was a TUSC founder. TUSC was sold to Rolta in 2008. Brad also founded IntelliReal in 2005, which was sold to Equifax in 2011. Brad worked for Equifax in 2012 and 2013.

If you don't want to install ApEx in your own environment, you can use Oracle's hosted ApEx environment to learn (and develop) your ApEx applications. If you plan on installing and running it in your environment, you can skip this session.

ApEx has 2 different report features. Classic reports and Interactive reports. Interactive reports are more exciting, but you can only have one interactive report on a page, so sometimes you have to resort to a classic report. A classic report is a simple tabular report that can allow users to sort data.

If you need to call a (Oracle) procedure (a function that doesn't return anything, but executes some code), this functionality allows your users to enter their parameters, then it will call a specific procedure.

ApEx has a cool feature that allows people / developers to create plug-ins for ApEx. These plug-ins allow you to create functionality very quickly and easily. Some are free, some charge for their plug-ins.

One of the all time best ApEx features is the data load functionality. You can easily implement this functionality for your users. This way they can easily add users, customers, email addresses, etc. through your application.

If you would like to put your data onto a map, this set of lessons will walk you through how to add latitude and longitudes to your data and how to place your data on a map using Google Maps. This series will walk you through step-by-step how to do this

Have you ever needed to call a web service? Or have you ever wanted to give a customer or vendor a web service? A web service is an API. This course walks you through everything you need to do step-by-step to set everything up.

Bradley D. Brown, brad@intelvideo.com. Brad is the CEO, President and founder of InteliVideo, a cloud-based white and private label video on demand platform. Brad was a TUSC founder. TUSC was sold to Rolta in 2008. Brad also founded IntelliReal in 2005, which was sold to Equifax in 2011. Brad worked for Equifax in 2012 and 2013.

Have you ever needed to call a function, but wanted to return the data as if you were querying a table? This lesson will walk you through exactly how you go about doing that using the Oracle pipeline function!

Many of you have asked for an ApEx 5.0 New Features Class, so I created it just for you. This is in the everything ApEx class too. This covers how to get access to ApEx version 5.0 (or download it), the new features in detail and specific feature review