Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Start Here|
Install Options ExplainedPreview
Section 1 Quiz
|Section 2: Install Option 1 - Requesting an APEX Workspace|
Requesting an APEX workspacePreview
|Section 3: Install Option 2 - Installing Oracle XE and APEX on Windows|
Lecture Notes for Installation Notes
Installing Oracle XE (part 1)
Installing Oracle XE (part 2)
Installing APEX (part 1)
Installing APEX (part 2)
Installing APEX (part 3)
Installing APEX (part 4)
|Section 4: Oracle APEX 5 Overview|
Application Builder Overview
SQL Workshop Overview
Team Development Overview
Packaged Applications Overview (part 1)
Packaged Apps (part 2)
The Universal Theme ApplicationPreview
|Section 5: App 1 - The Task Tracker Application|
App Functionality Review - Task TrackerPreview
Creating the T_TASK Table
Creating the App
Editing a Shared Component List Item
Editing a Shared Component Breadcrumb
Editing an Interactive Report Column
Editing the Home Page URL App Property
A bit more cleanup
Adding a Priority Field
Configuring our Priority List of Values
Reconfiguring our Priority LOV the Right Way
Fixing the Login Screen
Fixing the Login Screen (Part 2)
Adding a Contact Table
Adding our Contacts Form and Report
Fixing our Contacts Menu Icon and Breadcrumb
Some Date Picker Options
Introducing Dynamic ActionsPreview
Associating the Contacts with our Tasks with a List Manager
|Section 6: App 2 - Udemee - A Udemy Knockoff|
Creating the App
Creating the UDM_COURSE table
Creating the Course Form and Report
Creating a Dynamic List of Courses
Getting Icons for our Courses
Adding a Course Price Field
Fixing our Course Card Colors and Price
Filtering our Course Cards by Subcategory
Editing our Category / Subcategory List to work with the filter
Fixing our Breadcrumb with a Page Item Substitution Sring
Super Fast Data Entry with Data Workshop and Tabular FormsPreview
Pimp your App Style with the Theme RollerPreview
Explaining Authentication Schemes
Exporting, Importing, and Rolling Back Functionality
Adding a Search Button to our Landing Page
Fixing our Redirection Item Setting
Making Search and Subcategory work together
Introduction to PL/SQL Functions
Making our Search Case Insensitive
Making the Landing Page Look nicer
Creating our Course Page and Updating our Card Links
Updating our Card Links
Pulling in Content based on Course ID
Dynamic Content with PL/SQL
Adding more course details
Creating our Course Lecture Table
Introducing the Region SelectorPreview
Adding a Lecture Modal Form
Conditional Logic Using Dynamic ActionsPreview
Fixing Double firing of JS with a Global Page and Dyn. Action
Adding a Lectures List OR How to do a Master Detail Form
Making our Lectures List Sortable with JQueryUIPreview
|Section 7: Conclusion|
|Section 8: App 2 - Udemee (revisited)|
Creating the app
Exporting and Importing our App
Page Template BasicsPreview
|Section 9: LIMSCentral App|
The App Downloads
NuLIMS App Download
|Section 10: Bonus Features|
Custom Authentication SchemesPreview
Free Custom Authentication Starter App Download
Custom Authentication + User Groups App Starter
Full Solution - Laboratory Information System
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.