Oracle-SQL-101

An ode to how Oracle SQL got me interested in the world of DBMS.

Table of Contents:

• DDL Queries
  Creating tables, views, index, sequences. Details about all types of keys.
• DML, DQL, TCL
  Insert, Update, Delete, Select, Grant, Revoke.
• Functions and Group By Clause
  String and aggregate functions. Group By and Having Clause.
• Joins and Subqueries
  Inner, Left Outer, Right Outer, Full, Cross, Self Joins and Subqueries/ Nested Queries.
• PL-SQL
  Anonymous Block, Loops, Stored Procedure, Functions, Cursors, Triggers.