Create Complete Web Applications easily with APEX 5
4.4 (133 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.
926 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Create Complete Web Applications easily with APEX 5 to your Wishlist.

Add to Wishlist

Create Complete Web Applications easily with APEX 5

Create modern, complete and functional web applications with Oracle's Amazing APEX 5 framework.
Bestselling
4.4 (133 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.
926 students enrolled
Created by Andrew Vega
Last updated 6/2016
English
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • 9 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
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
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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
81 Lectures
06:51:39
+
Start Here
3 Lectures 05:50

Introduction
00:03


Section 1 Quiz
1 question
+
Install Option 1 - Requesting an APEX Workspace
1 Lecture 06:08
+
Install Option 2 - Installing Oracle XE and APEX on Windows
7 Lectures 33:16
Lecture Notes for Installation Notes
00:06

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
+
Oracle APEX 5 Overview
7 Lectures 37:45

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

+
App 1 - The Task Tracker Application
20 Lectures 01:31:23

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


Additional Cleanup
05:13

Associating the Contacts with our Tasks with a List Manager
08:18
+
App 2 - Udemee - A Udemy Knockoff
32 Lectures 03:25:26
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



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


Adding a Lecture Modal Form
07:42


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

+
Conclusion
1 Lecture 00:04
Thanks
00:04
+
App 2 - Udemee (revisited)
3 Lectures 19:04
Creating the app
05:10

Exporting and Importing our App
03:48

+
LIMSCentral App
2 Lectures 00:23
The App Downloads
00:06

NuLIMS App Download
00:17
+
Bonus Features
5 Lectures 12:08

Free Custom Authentication Starter App Download
00:04

Custom Authentication + User Groups App Starter
00:06

Hosting
00:11

Full Solution - Laboratory Information System
00:05
About the Instructor
Andrew Vega
4.0 Average rating
354 Reviews
4,757 Students
2 Courses
Mobile and Web Development Instructor

Blah blah blah, I'm so good at this and that.