Oracle ApEx
Oracle Application Express Intro
$49.99

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 pace. There are 55 videos in this training session.

Brad Brown is an 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.

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.

ApEx - Introduction to ... 00:17:41

This is a great place to start. Introduce yourself to application development with ApEx.

Oracle Application Exp ... 00:40:55

This is a 40 minute introduction to Oracle Application Express. This course is typically offered ...

Resume for Brad Brown 00:02:01

Bradley D. Brown, brad@intelvideo.com. Brad is the CEO, President and founder of InteliVideo, a ...

ApEx - Creating apex.o ... 00:03:19

If you don't want to install ApEx in your own environment, you can use Oracle's hosted ApEx envir ...

ApEx - Provisioning Ac ... 00:02:11

If you create an Apex.oracle.com account, the next steps after it's provisioned are covered here. ...

ApEx - Instant Applica ... 00:02:01

Creating an instant application (based on a table) can be a good start to an application and it m ...

ApEx - Create emp/dept ... 00:06:35

Oracle developers are used to example after example that reference the emp(loyee) and dept(artmen ...

ApEx - Create App from ... 00:07:02

If you receive a spreadsheet from someone, you can quickly and easily turn it into an entire onli ...

ApEx - Create From Scr ... 00:20:46

Creating an application from scratch is a useful skill since this is often where you'll start.

ApEx - Page, Region, C ... 00:15:14

Fundamental to ApEx is your understanding of pages, regions, controls, shared components and more.

ApEx - Page Rendering, ... 00:18:02

ApEx pages are first rendered and then they are processed (when submitted). It's important to un ...

ApEx - Creating First ... 00:11:01

ApEx pages are composed of regions (at least one). This session will walk you through creating y ...

ApEx - Create Form and ... 00:22:06

A report is a list of records and a form allows you to edit a single record. It's often required ...

ApEx - Classic Reports 00:07:27

ApEx has 2 different report features. Classic reports and Interactive reports. Interactive repo ...

ApEx - Interactive Rep ... 00:10:32

ApEx's interactive reports are the best reports - so much functionality for users - sorting, colo ...

ApEx - Master Detail a ... 00:14:29

Master detail relationships (one to many) exist in every application. This session shows you how ...

ApEx - Create Tabular ... 00:10:26

Reports are tabular displays of data and forms allow you to edit a single row...whereas tabular f ...

ApEx - Form on a Proce ... 00:07:51

If you need to call a (Oracle) procedure (a function that doesn't return anything, but executes s ...

ApEx - Charts 00:26:22

Oracle Application Express allows you to great charts and graphs easily. This lesson will walk y ...

ApEx - Maps 00:09:10

ApEx has mapping functionality built into it. You can integrate with Google maps, Yahoo, etc...b ...

ApEx - Calendar 00:09:28

If you have dates that you want to show, then using the calendar in ApEx is a great way to show it.

ApEx - Wizard Pages 00:06:27

If you want to create a step-by-step walkthrough for your customers, use this feature.

ApEx - Help Text 00:04:09

Sometimes you need more an entire page of help text for your application.

ApEx - PL/SQL Region 00:09:06

If there is something you can't do with a standard region in ApEx, you can absolutely do it progr ...

ApEx - Tree 00:02:34

When you select from a list that allows you to drill into sub levels, trees are your solution.

ApEx - Plug-Ins 00:10:21

ApEx has a cool feature that allows people / developers to create plug-ins for ApEx. These plug- ...

ApEx - URL Region and ... 00:06:35

If you want to include someone else's page on your page, this is the region that will handle this ...

ApEx - Breadcrumbs 00:07:59

Breadcrumbs are a great feature within ApEx pages. They allow you to build a context sensitive m ...

ApEx - Feedback 00:08:34

ApEx has a built in feedback functionality that you can integrate into your application.

ApEx - Login Page and ... 00:07:04

You can create your own login page for your application and you can control access to functionali ...

ApEx - Data Mapper Loa ... 00:14:35

One of the all time best ApEx features is the data load functionality. You can easily implement ...

ApEx - Region Display ... 00:03:52

If you have a number of regions on a page, it's helpful to have a region at the top of the page t ...

ApEx - Multiple HTML R ... 00:06:57

If you have the need for a series of HTML regions on the page, this wizard allows you to create u ...

ApEx - App Builder Wiz ... 00:04:14

Build a report is easy with ApEx's wizard report builder. Point and click to a new report in sec ...

ApEx - Dashboards 00:04:11

Creating your own dashboard is sometimes needed in an application. This sessions walks you throu ...

ApEx - Loading the Data 00:04:57

One of the best features of ApEx is how quickly you can load data into your database. Map the co ...

ApEx - Query Builder 00:06:27

If you aren't great at writing SQL, the query builder will help you point and click your way to w ...

ApEx - SQL Workshop 00:10:41

The SQL Workshop in ApEx is like TOAD or SQL Developer - it's a GUI application that allows you t ...

ApEx - SQL Workshop - ... 00:15:30

When you create forms and reports in an application, it's best if you're consistent about how you ...

ApEx - SQL Workshop - ... 00:10:41

A number of utilities are available in ApEx.

ApEx - SQL Workshop - ... 00:10:06

Loading data is one of the best features in ApEx.

ApEx - SQL Workshop - ... 00:12:38

Within the SQL Workshop, you can browse and edit database objects.

ApEx - SQL Workshop - ... 00:04:13

If you want to enter SQL directly and have it executes (all through your browser), this feature d ...

ApEx - SQL Workshop - ... 00:02:39

If you have SQL scripts that you wish to save an execute any time, here's your opportunity.

ApEx - SQL Workshop - ... 00:04:34

If you have a database and you want to extract the SQL to create database structures (i.e. data d ...

ApEx - SQL Workshop - ... 00:05:14

Create, Read, Update and Delete (CRUD) is an MVC best practice. This feature allows you to creat ...

ApEx - Users and Groups 00:04:12

ApEx allows you to create users and groups.

ApEx - Administration ... 00:04:13

Utilization reports within ApEx administration allow you to see how you're developers are using A ...

ApEx - Administration ... 00:04:52

It's important to know what your ApEx developers (and users) are doing. This functionality allow ...

ApEx - Administration ... 00:06:38

Apex administration allows you to manage the services available to your developers.

ApEx - Administration ... 00:03:09

Administration of your ApEx environment is important. This session covers a general overview of ...