Skip to content

Instantly share code, notes, and snippets.

@salRoid

salRoid/InterviewReadySQL.md

Last active January 2, 2021 14:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save salRoid/97d75a1d42f4dfb217101d09e06f5bf9 to your computer and use it in GitHub Desktop.
Save salRoid/97d75a1d42f4dfb217101d09e06f5bf9 to your computer and use it in GitHub Desktop.
Download ZIP
PL/SQL Interview Preparations
Raw
InterviewReadySQL.md

Interview Ready SQL

This is an topic wise check list to prepare before an SQL Interview

  • RDBMS
  • DBMS
  • DML/DDL/TCL
  • Aggregate Functions
  • String Functions
  • Functions
  • Procedures
  • Triggers
  • Cursors
  • Partition BY clause
  • Binding
  • Context Switching
  • Connect by level
  • Hints
  • Indexes
  • Primary Key
  • Foreign Key
  • Composite Key
  • Constraints
  • Data Types
  • Loop Constructs
  • Sequence
  • Group By, Having Clause
  • Joins
  • Subquery
  • Optimistic / Pessimistic Locking
  • ACID (Atomicity, Consistent, Isolation, Durability)
  • Rank and Dense Rank
  • LAG and LEAD
  • Normalization
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment