Curriculum

Complete Oracle Apex Web Application Development Training

Course Overview

0/3

Oracle SQL

0/2

Install Oracle

0/6

SQL Query : Common SQL*PLUS commands

0/1

SQL Query : Writing Basic SQL Statements

0/6

SQL Query : Restricting Data

0/7

SQL Query : Sorting Data

0/3

SQL Query : Single Row Functions

0/10

SQL Query : Displaying Data from Multiple Tables

0/5

SQL Query : Aggregating Data Using Group Functions

0/5

SQL Query : Subqueries

0/7

SQL DDL : Creating and Managing Tables

0/8

SQL DDL : Including Constraints

0/5

SQL DDL : Creating and Managing Views

0/1

SQL Data Manipulation Language (DML)

0/4

SQL Other Database Objects

0/3

SQL Data Control Language (DCL)

0/1

SQL Transaction Control

0/2

SQL Others

0/3

Oracle SQL Quiz and Free E-books

0/2

Oracle PLSQL - Introduction

0/1

PLSQL - Declaring PLSQL Variables

0/7

Writing Executable Statements

0/5

Writing Control Structure

0/4

Iterative Processing with loops

0/4

Using Cursors

0/5

Handling exceptions

0/2

Creating Procedures

0/3

Creating Functions

0/1

Creating Packages

0/1

Creating Triggers

0/5

Oracle Apex

0/2

Installation of Oracle Apex

0/5

Creating a Desktop and Mobile Database Application

0/4

Working with Reports for Mobile Application

0/4

Creating Forms

0/3

Working with Pages and Regions

0/2

Adding Items and Buttons

0/3

Understanding Session State

0/1

Including DML Page Processing

0/7

Creating Charts and Calendars

0/2

Using Dynamic Actions and Plug-ins

0/2

Software Projects on Human Resource Management Systems

0/21

Software Project: Automobile Workshop Management Systems (Sales Apps)

0/14

Oracle Apex on Cloud – Build Oracle Apex Environment on Cloud VPS

0/11

Text lesson

What is Oracle and Oracle Database ?

What is Oracle?
=========

The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an
object-relational database management system produced and marketed by Oracle Corporation.

Larry Ellison and his friends, former co-workers Bob Miner and Ed Oates, started the
consultancy Software Development Laboratories (SDL) in 1977.
SDL developed the original version of the Oracle software.
The name Oracle comes from the code-name of a CIA-funded project Ellison had worked
on while previously employed by Ampex.

Who is oracle?
=========

Oracle Corporation is an American multinational computer technology corporation headquartered in
Redwood City, California, United States.

The company specializes in developing and marketing computer hardware systems and enterprise software
products – particularly its own brands of database management systems.

What is a Database?
============

A database is basically a collection of information organized in such a way that a computer program can quickly select desired pieces of data. You can think of a database as an electronic filing system.