Learning SQL — The SQL Cheatsheet Part I

CREATE TABLE

INSERT

SELECT

ALTER

UPDATE

DELETE

CONSTRAINTS

AS

DISTINCT

WHERE

LIKE & WHERE

IS NULL & WHERE

BETWEEN & WHERE

AND & WHERE

OR & WHERE

ORDER BY

LIMIT

CASE

Example input and output from Codeacademy

Marketing Strategy | Data Viz | Analytics & Experimentation | Entrepreneurship 💡Passion project: beautydupes.xyz | Blog: goodmarketing.club

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store