A Beginner's Guide To Creating Database Driven Applications

A Beginner's Guide To Creating Database Driven Applications, available at $44.99, has an average rating of 3.8, with 33 lectures, based on 26 reviews, and has 1155 subscribers.

You will learn about 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 This course is ideal for individuals who are Business Intelligence Developer or Web Administrator or Application Developers or Database Administrators or System Analysts or Project Manager or Forms Developer It is particularly useful for Business Intelligence Developer or Web Administrator or Application Developers or Database Administrators or System Analysts or Project Manager or Forms Developer.

Enroll now: A Beginner's Guide To Creating Database Driven Applications

Summary

Title: A Beginner's Guide To Creating Database Driven Applications

Price: $44.99

Average Rating: 3.8

Number of Lectures: 33

Number of Published Lectures: 33

Number of Curriculum Items: 33

Number of Published Curriculum Objects: 33

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Business Intelligence Developer
Web Administrator
Application Developers
Database Administrators
System Analysts
Project Manager
Forms Developer

Target Audiences

Business Intelligence Developer
Web Administrator
Application Developers
Database Administrators
System Analysts
Project Manager
Forms Developer

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

Course Curriculum

Chapter 1: Introduction and setting up your database environment

Lecture 1: Introduction

Lecture 2: Database Concepts Part 1

Lecture 3: Database Concepts Part 2

Lecture 4: Download Oracle Database

Lecture 5: Install Oracle Database

Lecture 6: Unlock Oracle HR Schema Objects

Lecture 7: TOAD Download

Lecture 8: TOAD Installation

Lecture 9: Explore TOAD Interface

Chapter 2: CRASH SQL REFRESHER

Lecture 1: What is SQL

Lecture 2: Using SELECT Statement

Lecture 3: Using CREATE Statement

Lecture 4: Using Create Part 2

Lecture 5: Using Aliases

Lecture 6: using INSERT Statement

Lecture 7: Limiting and sorting data

Lecture 8: Checking Table Structure

Lecture 9: Using sub-query

Lecture 10: WHERE clause

Lecture 11: FROM clause

Lecture 12: ORDER BY clause

Chapter 3: Creating a Database Driven Application with APEX

Lecture 1: What is APEX

Lecture 2: Applications built with APEX

Lecture 3: How to access APEX

Lecture 4: Displaying Schema Objects

Lecture 5: APEX Workspace

Lecture 6: What you will build

Lecture 7: Create a Database Driven Crud Application

Lecture 8: Modifying the application view

Lecture 9: Create APEX user account

Lecture 10: Publishing your Application to end users

Lecture 11: Perform basic crud functions on the application

Lecture 12: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 2 votes
2 stars: 2 votes
3 stars: 7 votes
4 stars: 7 votes
5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu