Using:

• MS SQL Server Mgmt Studio (18)
• Azure Data Studio
  • Postgres DB

Basic Commands

SELECT + FROM

The read operation. Get all or a specific subset of columns rows for all rows of a table.

SELECT column_1, column_2 FROM my_cool_table

WHERE

Filter the rows you select to only those that meet a certain condition.

SELECT * FROM my_table
WHERE column_1 = 123

LIKE

Sub-string matching. Good sheeit. Link.

SELECT * FROM mytable
WHERE column1 LIKE '%word1%'
   OR column1 LIKE '%word2%'
   OR column1 LIKE '%word3%'

INSERT + VALUES

Insert new row. The create operation. Link.

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

Extra: INSERT INTO SELECT statement: Link

UPDATE + SET

Modify existing records in the table.Link.