Unix, Data Manipulation, Joins, Functions, Partitions, Subqueries, Triggers, Constraints, Sql, Exceptions, Tables, Cursors, Dynamic Sql, Plsql, Python, Github Copilot, Packages, Procedures, indexing strategies, complex SQL queries, table partition concepts, aggregate functions, Oracle database concepts