Oracle PL/SQL

Basic SQL

Overview

RDBMS Concepts

Databases

Syntax

SQL Sub Languages: DDL, DML, TCL, DQL/DRL

Data Types

Operators

Expressions

Create Database

Drop Database

Select Database

Create Table

Drop Table

Insert Query

Select Query

Where Clause

AND & OR Clauses

Update Query

Delete Query

Like Clause

Top Clause

Order By

Group By

Having Clause

Distinct Keyword

Sorting Results

Advanced SQL

Constraints

Joins – Types

Unions Clause

NULL Values

Alias Syntax

Indexes

Alter Command

Truncate Table

Views

Transactions

Wildcards

Date Functions

Character Functions

Temporary Tables

Clone Tables

Sub Queries

Using Sequences

Handling Duplicates

Distinct

PL/SQL

Overview

Environment

Basic Syntax

Data Types

Variables

Constants

Operators

Conditions

Loops

Strings

Arrays

Procedures

Functions

Cursors

Records

Exceptions

Triggers

Packages

Collections

Transactions

DBMS Output

Object Oriented