Course Details

Oracle is a world class database solution and our programme will teach you the Oracle DB technologies in an all round manner. Following are some of the topics of the programme:

Writing Basic SQL SELECT Statements

Basic SELECT Statement

Arithmetic Expressions

Operator Precedence

Defining a Column Alias

Duplicate Rows

Single-Row Functions

Types of SQL Functions

Case Manipulation Functions

Number Functions

NVL Function

The DECODE Function

Aggregating Data Using Group Functions

What Are Group Functions?

Group Functions and Null Values

Grouping by More Than One Column

Excluding Group Results

Nesting Group Functions

Manipulating Data

Data Manipulation Language

The INSERT Statement Syntax

Creating a Script

Updating Rows in a Table

The DELETE Statement

Including Constraints

Constraint Guidelines

The KEY Constraints

The CHECK Constraint

Cascading Constraints

Viewing Constraints

Other Database Objects

Database Objects

What is a Sequence?

Creating a Sequence

What is an Index?

Removing an Index

Using SET Operators

The SET Operators

The INTERSECT Operator

SET Operator Guidelines

Matching the SELECT Statements

Controlling the Order of Rows

Restricting and Sorting Data

Limiting Rows Using a Selection

Using the WHERE Clause

Using the LIKE Condition

Using the AND, OR, NOT Operators

ORDER BY Clause