SQL Cheatsheet
Whether you are a first year student or a database guru, this SQL Cheatsheet will come in handy whenever you forget exactly how the syntax for that windowing function goes. This handy cheatsheet includes.
-
Basic syntax for
SELECT
queries -
Common aggregations like
COUNT
andSUM
. -
Advanced functions like
DENSE_RANK
andNTILE
. - and all the other operators you learned once and promptly forgot about!
Get the Cheatsheet: GET IT HERE
Get the Book: SQL Cookbook: Query Solutions and Techniques for Database Developers
This is a concise, one-page cheatsheet that goes through some of the more commonly used operators and functions in SQL. Designed to support both beginners and experts, this document should serve to guide you onto your personal SQL mastery!
GET IT HERE