INTRODUCTION

SQL stands for Structured Query Language and is the standard relational language that is supported by just about every database product. All database professionals should know how to write, troubleshoot, and optimize SQL.

SQL is divided into the following

• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Data Retrieval Language (DRL)
• Transaction Control Language (TCL)
• Data Control Language (DCL)

DDL — create, alter, drop, truncate, rename

DML — insert, update, delete

DRL — select

TCL — commit, rollback, savepoint

DCL — grant, revoke

For download Oracle Database 11g Click DOWNLOAD