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 Desktop and Mobile Application

0/7

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

Oracle Apex Reporting

0/1

Text lesson

Introduction to Oracle SQL & Classification

SQL Classifications :

SELECT	Query
INSERT UPDATE DELETE MERGE	Data Manipulation Language (DML)
CREATE ALTER DROP RENAME TRUNCATE	Data Definition Language (DDL)
GRANT REVOKE	Data Control Language (DCL)
COMMIT ROLLBACK SAVEPOINT	Transaction Control