All ApEx Lessons
Oracle Application Express Intro
$97.97

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

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.

Resume for Brad Brown 00:02:01

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

Oracle Application Exp ... 00:40:55

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

ApEx - Help Text 00:04:09

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

ApEx - Charts 00:26:22

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

ApEx - Users and Groups 00:04:12

ApEx allows you to create users and groups.

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 - Provisioning Ac ... 00:02:11

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

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

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

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

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

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 - 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 - 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 - Page Rendering, ... 00:18:02

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

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

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

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 - Create emp/dept ... 00:06:35

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

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.

Sales Pitch for Advanc ... 00:02:01

Watch this video which is about the Advanced ApEx session.

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 - SQL Workshop - ... 00:10:41

A number of utilities are available in ApEx.

ApEx - Administration ... 00:04:52

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

ApEx - Administration ... 00:04:13

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

Advanced 1 - Lesson 1 ... 00:13:27

This lesson shows how we took 5 Excel spreadsheets with sample data sets, creating the new tables ...

Advanced 1 - Lesson 2 ... 00:18:43

After adding the tables, 2 of them are list of values type tables. So we create 2 dynamic LOV ob ...

Advanced 1 - Lesson 3 ... 00:12:20

After adding our list of values objects, we build out our first form in the application. A list ...

Advanced 1 - Lesson 4 ... 00:09:51

This lesson will show you another method of creating a master detail form.

Advanced 1 - Lesson 5 ... 00:12:32

This is the last part of this lesson in which the "mass update" functionality will be built. We ...

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 - 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 - SQL Workshop - ... 00:04:13

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

ApEx - Tree 00:02:34

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

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 - Create From Scr ... 00:20:46

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

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 - Wizard Pages 00:06:27

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

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 - 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 - Administration ... 00:06:38

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

ApEx - Maps 00:09:10

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

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 - Breadcrumbs 00:07:59

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

ApEx - Administration ... 00:03:09

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

ApEx - Dashboards 00:04:11

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

ApEx - Plug-Ins 00:10:21

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

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:05:14

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

ApEx - Feedback 00:08:34

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

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

Loading data is one of the best features in ApEx.

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 - 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 - 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 - Login Page and ... 00:07:04

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

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 - Creating First ... 00:11:01

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

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 ...

WS - Apex Web Services ... 00:04:19

If you've ever considered using Web Services with Oracle and/or Oracle Application Express, this ...

WS - Creating a RESTfu ... 00:09:27

If you have a vendor or customer who needs an API to your data, this session will walk you throug ...

WS - Pipeline Function ... 00:05:53

Have you ever needed to call a function, but wanted to return the data as if you were querying a ...

WS - Why RESTful Servi ... 00:14:59

RESTful Web Services with ApEx are a challenge...

WS - WSDL based Web Se ... 00:21:21

WSDL-based Web Services work well (for the most part) with ApEx...but they are a dying breed!

Teaser for Packages Pr ... 00:01:26

If you struggle with understanding best practices for packages, procedures and functions, this se ...

Creating Pages Around ... 00:18:58

This lessons discusses using wizards vs. manually creating pages around packages, procedures and ...

Packages Procedures an ... 00:20:30

Packages, Procedures and Functions can be confusing. This lesson explains the best practices of ...

Calling Packages Proce ... 00:17:24

In this lesson, you'll learn about calling packages, procedures and functions in ApEx processes ( ...

Teaser for Maps with ApEx 00:02:44

If you would like to create maps using ApEx, this series walks you through everything from how to ...

Actually getting our f ... 00:05:26

We were very close to getting the map to display in the last lesson, this lesson closes it up...t ...

Introduction to Mappin ... 00:22:11

This lesson discusses the goals of mapping your data.

Starting your mapping ... 00:11:31

You need to read the documentation in order to understand how to use the mapping APIs.

Updating our Lats and ... 00:41:10

You're going to need to turn addresses or locations into latitudes and longitudes.

Putting Our Points on Map 00:29:06

This lesson talks about places your points on the map.

Displaying Different I ... 00:26:16

This lesson walks you through how to display different icons on a map.

Final Lesson - Popup W ... 00:20:03

Now you're ready to make each icon provide a popup window when clicked. This is the final step t ...