Oracle SQL Syllabus

Oracle SQL

1.        Introductions

Oracle, Database, Feature of Database, DBMS, RDBMS, Normalization, Data Types

2.        Structure Query Language(SQL)

Introduction, History, Classifications, Functions (Character, Numeric, Date, Data Type Conversion, Miscellaneous, Group)

3.        Data Definition Language(DDL)

CREATE, ALTER, DROP and TRUNCATE Table

4.        Data Manipulation Language(DML)

INSERT, UPDATE, DELETE and MERGE Command

5.        Data Query Language

SELECT Command, FROM, WHERE, ORDER BY, GROUP BY, HAVING Clause, SQL Operators,

6.        Joins

Equi-Join, Natural, Inner, Outer, Self

7.        Database Objects

Views, Sequences, Indexes

8.        Constraints

NULL, NOT NULL, DEFAULT, UNIQUE, PRIMARY, FOREIGN, CHECK

9.        Subqueries

Types of Subqueries (Single Row & Multi Row), Using ANY, ALL, EXISTS Operators