An ode to how Oracle SQL got me interested in the world of DBMS.
- 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.