Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Developing SQL queries for oracle databases

Video Introducing this tutorial

Introduction and Oracle Database Setup :
Introduction
Basic Database concepts
Download Oracle Database
Installing Oracle Database
Attach sample schema
Install Java JDK
Install Oracle developer
Exploring Oracle Developer
Download TOAD
Install TOAD
Connecting TOAD to Oracle Database


Essentials SQL Query building components :
Sub Queries
Query optimisation
Removing duplicates
Views


Leveraging SQL Aggregate Functions to Build Queries :
AVG
COUNT
MAX
MIN
SUM


Single-row functions :
Character
Conversion
Date
Numeric


Perform Analysis with Analytical functions :
Rank
Dense Rank
Lead
ListAgg
Lag
Row Number
First and Last


Developing complex queries using Joins :
SELF Join
EQUI Join
NON -EQUI Join
Cartesian Join
OUTER Join


Manipulating SET operators to build queries :
UNION
UNION ALL
INTERSECT
MINUS