Introduction
Introduction to DBMS
Introduction to Data Management
File system concepts
Database Models
Hierarchal Model
Network Model
Relational Model
Introduction to Oracle
History of Oracle
Oracle products and features
Oracle versions and releases
About SQL & SQL*PLUS
SQL*NET
Introduction to SQL
Sub-language Commands
Data Retrieval Language (DRL)
Data Definition Language (DDL)
Data Manipulation Language (DML)
Transaction Control Language (TCL)
Database security and Privileges
Working with DRL
Select statement
Distinct Selection
‘Where’ Clause
‘Order by’ Clauses
Working with DDL and DML
DDL commands
Database objects and object types
Working with Tables
Data Types
Table partitions Create, Alter
Add, Modify, Drop Insert, Update,
Delete
Commit, Rollback
Oracle Built-in Functions
Arithmetic Functions Character
Functions Date Functions Queries
with Single Row Functions
Misc Functions
Working with Regular Expressions
Constraints
Constraints
Data Integrity Concepts
Different types of Constraints
Table Level and Column Level
Composite Constraints
Check Constraint and
Restrictions Referential Integrity
Sub Queries
Normal Sub Queries.
Co-related Sub Queries.
Updating Using Co-Related.
Deleting Co-Related
Using Exists and Not Exists
Inline Queries
Miscellaneous Sub-queries.
Joins
Joining Tables
Simple Joins
Outer Joins
Self Joins
Joins with Inline Queries
ANSI Join Syntax
Select Statement with Misc Options
Set Operators
Pseudo Columns
Views, Synonyms & Indexes
Simple & Complex Views
Modifying the View Query
Synonyms
Indexes
Sequences