Included with SQL Cheatsheet Pack

The complete SQL Cheatsheet Pack package includes:

• SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, ALTER TABLE, data types comparison across…
• INNER, LEFT, RIGHT, FULL, CROSS, SELF joins with visual diagrams, multiple join…
• GROUP BY, HAVING, aggregate functions (COUNT, SUM, AVG, MIN, MAX), ROLLUP, CUBE…
• ROWNUMBER, RANK, DENSERANK, NTILE, LAG, LEAD, FIRSTVALUE, LASTVALUE, SUM/AVG OVER…
• Common Table Expressions, recursive CTEs, correlated subqueries, EXISTS, IN vs JOIN…
• B-tree, hash, GIN, GiST indexes, composite indexes, partial indexes, covering indexes…