Explore

A Beginner's Guide To Creating Database Driven Applications

3 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

Learn how to create a database driven application with ease using oracle's APEX

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

Requirements

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

Knowledge

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

Recommended for you

R: Neural Nets and CNN Architecture in R - Masterclass!

One stop guide to implement cutting-edge CNN architectures and build Neural Network models to solve complex problems! You’ll also apply supervised and unsupervised learning to your daily projects....

Save Course