Create Complete Web Applications easily with APEX 5

Create modern, complete and functional web applications with Oracle's Amazing APEX 5 framework.
4.3 (80 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
745 students enrolled
$25
Take This Course
  • Lectures 81
  • Length 7 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

Course Description

UPDATED June 7th, 2015 - Now Includes full download of this FULLY FUNCTIONAL website + DB + Web App located at http : // info lims . com

What is this course about?

This course is about Oracle's APEX framework which allows you to create modern, fully-functional web applications using nothing more than your browser. Applications in APEX are configured and not coded. But don't let that fool you. APEX is modern and allows for advanced web programming if you want to get your hands dirty. In this course we dive into the basics and intermediate level of APEX configuration. There is no heavy coding in this course. We use configuration and drag-and-drop in this course to get some pretty advanced functionality.

What terminology would your audience expect to find in this course?

We cover all of APEX's terminology (Don't worry if you are not familiar)

Table, Sequences, Workspace, Page, Page Designer, Application Builder, SQL Workshop, Exporting, Importing, Interactive Reports, Regions, Items, Buttons, Select Lists, List Managers, Template Options, Icon Classes, Shared Components, Authentication Schemes, Theme Roller, Dynamic Actions, Application Rollback, Team Development Module, Packaged Apps, Page Processes, Branching, Page Redirection, SQL, Query Builder, and so much more

We also cover some web and database terminology (Would help to have a basic understanding)

HTML, h1, h2, div, SQL, Select, From, Where

What kind of material are included?

The format for this course is watch and follow along. You are given two options for following along:

Request your own Oracle Workspace and follow along (Free)

Install your own instance of Oracle XE and APEX (Free) on your Windows machine

Both options are free. The student is expected to complete all of the same exercises in the video.

How long will the course take to complete?

The student should expect to dedicate 8 or more hours to complete the course.

How is this course structured?

Watch and follow along. I take you from beginning to end with this course video series. I will occasionally ask you to pause the video and complete a task to test your skills.

Why take this course?

There is nothing like seeing a developer in action and watching them build from beginning to end. You can try and use a book or blog tutorial to get your knowledge about APEX. But the experience with those formats could end up leaving you stuck. APEX is the future of web application development. If you think visually and would prefer to configure an application rather than get stuck in the weeds with code, take this course and get started on your next web app.

What are the requirements?

  • Very, very basic dos commands such as CD
  • How to Utilize a Browser
  • You should have a basic understanding of Windows
  • You should have a basic understanding of SQL and HTML and possibly some programming language

What am I going to get from this course?

  • Create Fully-functional web applications with Oracle APEX
  • Understand APEX areas such as the Application Builder, SQL Workshop, Team Development, and Packaged Apps
  • Install pre-packaged sample applications
  • Install Oracle's free version Oracle XE
  • Upgrade Oracle XE from version 4.2 to version 5.0
  • Create a Task Tracking Application
  • Create List of Values the right way
  • Create shared components such as Lists of Values, Breadcrumbs, Navigation Menus, Lists and more
  • Utilize Dynamic Actions to autmatically update fields on a form
  • Utilize the SQL Workshop to Create, Alter, and Drop Database objects such as tables, views, and sequences
  • Create dynamics lists, cards, badges based on page item entry
  • Create dynamic breadcrumbs
  • Create a search bar landing page
  • Export, Import and Rollback Applications
  • Work with Page Submission and Page Redirection
  • Utilize basic PL/SQL Functionality to create awesome page logic
  • Use the theme-roller to customize the look and feel of their APEX applications

What is the target audience?

  • This course is meant for folks with a basic understanding of HTML, SQL, and possibly some programming language
  • This course is NOT meant for hardcore, advanced web programmers
  • This course is meant for those wanting to get a web application up and running quickly but don't want or aren't able to dive into heavy coding

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Start Here
Course Introduction
Preview
04:30
Introduction
Article
Install Options Explained
Preview
01:17
Section 1 Quiz
1 question
Section 2: Install Option 1 - Requesting an APEX Workspace
Requesting an APEX workspace
Preview
06:08
Section 3: Install Option 2 - Installing Oracle XE and APEX on Windows
Lecture Notes for Installation Notes
Article
Installing Oracle XE (part 1)
04:11
Installing Oracle XE (part 2)
03:32
Installing APEX (part 1)
05:16
Installing APEX (part 2)
04:26
Installing APEX (part 3)
06:21
Installing APEX (part 4)
09:24
Section 4: Oracle APEX 5 Overview
APEX Overview
Preview
04:02
Application Builder Overview
06:33
SQL Workshop Overview
05:12
Team Development Overview
05:05
Packaged Applications Overview (part 1)
03:28
Packaged Apps (part 2)
09:49
The Universal Theme Application
Preview
03:36
Section 5: App 1 - The Task Tracker Application
App Functionality Review - Task Tracker
Preview
02:09
Creating the T_TASK Table
03:35
Creating the App
05:21
Editing a Shared Component List Item
03:20
Editing a Shared Component Breadcrumb
03:54
Editing an Interactive Report Column
03:53
Editing the Home Page URL App Property
02:21
A bit more cleanup
02:59
Adding a Priority Field
04:08
Configuring our Priority List of Values
08:13
Reconfiguring our Priority LOV the Right Way
06:00
Fixing the Login Screen
06:27
Fixing the Login Screen (Part 2)
02:00
Adding a Contact Table
04:12
Adding our Contacts Form and Report
05:23
Fixing our Contacts Menu Icon and Breadcrumb
04:28
Some Date Picker Options
03:29
Introducing Dynamic Actions
Preview
06:00
Additional Cleanup
05:13
Associating the Contacts with our Tasks with a List Manager
08:18
Section 6: App 2 - Udemee - A Udemy Knockoff
Creating the App
09:41
Creating the UDM_COURSE table
04:04
Creating the Course Form and Report
05:01
Creating a Dynamic List of Courses
06:24
Getting Icons for our Courses
10:07
Adding a Course Price Field
06:33
Fixing our Course Card Colors and Price
06:13
Filtering our Course Cards by Subcategory
05:29
Editing our Category / Subcategory List to work with the filter
09:23
Fixing our Breadcrumb with a Page Item Substitution Sring
07:05
Super Fast Data Entry with Data Workshop and Tabular Forms
Preview
07:42
Pimp your App Style with the Theme Roller
Preview
04:42
Explaining Authentication Schemes
06:34
Exporting, Importing, and Rolling Back Functionality
06:01
Adding a Search Button to our Landing Page
07:21
Fixing our Redirection Item Setting
05:16
Making Search and Subcategory work together
03:15
Introduction to PL/SQL Functions
06:39
Making our Search Case Insensitive
02:57
Making the Landing Page Look nicer
04:02
Creating our Course Page and Updating our Card Links
05:53
Updating our Card Links
07:11
Pulling in Content based on Course ID
04:42
Dynamic Content with PL/SQL
05:51
Adding more course details
06:17
Creating our Course Lecture Table
04:21
Introducing the Region Selector
Preview
04:54
Adding a Lecture Modal Form
07:42
Conditional Logic Using Dynamic Actions
Preview
06:06
Fixing Double firing of JS with a Global Page and Dyn. Action
07:52
Adding a Lectures List OR How to do a Master Detail Form
11:55
Making our Lectures List Sortable with JQueryUI
Preview
08:13
Section 7: Conclusion
Thanks
Article
Section 8: App 2 - Udemee (revisited)
Creating the app
05:10
Exporting and Importing our App
03:48
Page Template Basics
Preview
10:06
Section 9: LIMSCentral App
The App Downloads
Article
NuLIMS App Download
Article
Section 10: Bonus Features
Custom Authentication Schemes
Preview
11:41
Free Custom Authentication Starter App Download
Article
Custom Authentication + User Groups App Starter
Article
Hosting
Article
Full Solution - Laboratory Information System
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Andrew Vega, Mobile and Web Development Instructor

I have been a web designer and developer for over 10 years. I have worked on various projects ranging from full-fledged Enterprise web applications to small mobile applications for the iPhone and iPad. In addition to development, I also have a passion for teaching and instruction. I have taught students around the world various courses ranging from Commercial Off the Shelf software packages to Data Science and Illustration and Design tools. My primary focus recently has been the instruction of Oracle APEX.

Ready to start learning?
Take This Course