Skip to content

Latest commit

 

History

History
14 lines (13 loc) · 759 Bytes

README.md

File metadata and controls

14 lines (13 loc) · 759 Bytes

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.