A Beginner's Guide To Creating Database Driven Applications
4.5 (4 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.
1,045 students enrolled
Wishlisted Wishlist

Please confirm that you want to add A Beginner's Guide To Creating Database Driven Applications to your Wishlist.

Add to Wishlist

A Beginner's Guide To Creating Database Driven Applications

Learn how to create a database driven application with ease using oracle's APEX
4.5 (4 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.
1,045 students enrolled
Last updated 12/2016
English
Current price: $10 Original price: $125 Discount: 92% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create and Run Database Applications
  • Create and manage user accounts
  • Create workspace
  • Create database driven applications with APEX
  • Modify application views
  • Change application theme
  • Perform CRUD functions on an application
  • Publish your application to end users
  • Use APEX application builder to create applications
  • Use APEX Object browser to view and access objects
  • Use SQL commands within APEX
  • Create forms and pages for your application in APEX
View Curriculum
Requirements
  • You should be able to use a PC at a beginner level
  • You should have Oracle Database but it will cover installation in section 1.
  • You should have basic understanding of relational database concepts
  • You should have basic understanding of SQL
Description

Learn the essential skills required to develop a complete application using Oracle Application Express (APEX).

Most applications will need some type of database interaction at some point.
This beginner's course will teach you how to quickly create a fully functional database driven application using Oracle's application express (APEX) which comes bundled with all instances of Oracle database installation since 2004.

Application Express  is a free tool  by Oracle that enables you to design, develop and deploy responsive and database-driven applications which are robust and scalable.  APEX is a rapid tool used to develop web based oracle database applications that can be deployed and published for end users to consume. 
Application Express runs wherever there is an Oracle database is installed.

In this course we are going to build a functional application using sample data from the Oracle database.


What You Will Learn include:

Create a complete database -driven application from scratch
Using SQL Workshop in Executing adhoc SQL and PL/SQL statements using SQL Commands
How to create a workspace
Creating and modifying a page
Use Application Builder to create applications from scratch
Page rendering and processing overview
Create a form and associated report
Quickly navigate the builder by using the Developer Toolbar
Understand how to user the theme repository
Identify users using Authentication schemes
Create end user accounts
Gain understanding of APEX URL structure


After completing this course you will be able to develop oracle database- driven applications  that are robust and scalable using Oracle Application Express (APEX)

I look forward to welcoming you to the course

Who is the target audience?
  • Business Intelligence Developer
  • Web Administrator
  • Application Developers
  • Database Administrators
  • System Analysts
  • Project Manager
  • Forms Developer
Students Who Viewed This Course Also Viewed
Curriculum For This Course
32 Lectures
03:12:04
+
Introduction and setting up your database environment
9 Lectures 46:05



Download Oracle Database
06:25

Install Oracle Database
05:48

Unlock Oracle HR Schema Objects
03:30

TOAD Download
03:36

TOAD Installation
04:08

Explore TOAD Interface
05:41
+
CRASH SQL REFRESHER
12 Lectures 01:20:42
What is SQL
05:46

Using SELECT Statement
09:15

Using CREATE Statement
08:50

Using Create Part 2
08:03

Using Aliases
07:47

using INSERT Statement
09:32

Limiting and sorting data
07:18

Checking Table Structure
03:18

Using sub-query
08:38

WHERE clause
05:22

FROM clause
02:51

ORDER BY clause
04:02
+
Creating a Database Driven Application with APEX
11 Lectures 01:05:17
What is APEX
02:41

Applications built with APEX
02:08

How to access APEX
03:32

Displaying Schema Objects
07:08

APEX Workspace
07:51

What you will build
02:20

Create a Database Driven Crud Application
10:51

Modifying the application view
04:34

Create APEX user account
07:27

Publishing your Application to end users
08:06

Perform basic crud functions on the application
08:39
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,559 Reviews
35,111 Students
85 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.