SQL

SQL (Structured Query Language) is a RDBMS  language designed for retrieval of data and management of data in Relational Databases. This page contains the links to all the topics of Oracle SQL Tutorials by Expert-Oracle.com.

This tutorial will give you the quick start of SQL language.

Part 1: Data Retrieval – Basics
Overview of SELECT statement
SELECT Clause (Column aliases, Dual Table, Null values in Expressions)
WHERE clause
ORDER BY Clause
GROUP BY Clause
HAVING Clause
AND, OR and NOT operators
BETWEEN, IN and LIKE operators
CASE Expressions
Subqueries
NULL values

Part 2: Data Retrieval – Functions
Functions overview
Arithmetic Functions
Text Functions
Regular Expressions
Date Functions
General Functions
Conversion Functions
Stored Functions

Part 3: Data Manipulation
INSERT Statement
UPDATE Statement
DELETE Statement
MERGE Statement

Part 4: Data Retrieval – Joins
Cartesian Products
Equijoins
Non Equijoins
Self Joins
Joins of Three or more tables
Outer Joins

Part 5: Data Retrieval – Aggregation
Group functions and Duplicate values
Group functions and NULL values
Grouping the result of join
COUNT(*) function
Valid SELECT and Group BY clause combinations
GROUP BY ROLLUP
GROUP BY CUBE
CUBE, ROLLUP and NULL values

Part 6: Data Retrieval – Advance Features
Correlated Subqueries
EXISTS operator
Subqueries in select statement
Subqueries in FROM clause
WITH clause
Hierarchical Queries
Analytical Functions
FLASHBACK Features

Part 7: Views

 

Leave a Reply