Oracle Tutorial pdf free download for beginners and experienced pdf free download

Database Management

Approaches to Data Management
Database Management System
Database Models
Relational Database Management System
Object Relational Database Management System

Introduction to ORACLE

What is SQL and SQL*Plus
Oracle Internal Data types
Data Definition Language

3. Constraints
Domain Integrity Constraints
Entity Integrity Constraints

4. Data Manipulation Command
Insert command
Update command
Delete command
Select Command


5. Transaction Control Language
Commit
Savepoint
Rollback

6. Data Control Language
Grant command
Revoke command

7. Operators
Arithmetic Operators
Comparison Operators
Logical Operator

8. Single Row Functions (Scalar Functions):
String Functions:
Numeric Functions:
Date Function:
Conversion Functions:
Miscellaneous Functions:
Group Functions:

9. Group By Clause
Using ROLLUP, GROUPING, and CUBE

10. Set Operators
Union
Union All
Intersect
Minus

11. Joins
Simple Join
Self Join
Outer Join

12. Subquery

13. Partition
Using Partitioned Tables
Creating Subpartitions
Indexing Partitions
Managing Partitioned Table

14. Locks
Level of Lock to be applied
Type of Lock to be applied

15. Views
Updateable Views:
Destroying a view:

16. Sequences
Creating Sequences:
Referencing a Sequence:
Altering Sequence:
Dropping Sequence:

17. Indexes
Address field in the Index:
Duplicate/Unique Index:
Creating Simple Index:
Creating Composite Index:
Creation of Unique Index:

18. Object Relational Database
Abstract Datatypes

19. Nested Tables
Querying Nested Tables