MS SQL

RESTORE and CREATE a Backup

Fundamentals

Create Database
Go
Create Schema

Scalar Variables
Custom Types

Create Table
Alter Table

Insert
Select
Update

Filters

TOP

WHERE
Operators
LIKE, IN, BETWEEN
And, Or, Not

DELETE
UPDATE

INTO
TRUNCATE

Ordering

ORDER BY
DISTINCT
GROUP BY

Aggregates & Aliases

Aggregates (like methods)
Aliases
HAVING

Built-in Functions

ISNULL & COALESCE
NULLIF
CAST
CONVERT
STRING_AGG
FOR XML PATH (u wont need to know this)

Date

Conditions

CASE

Joining

Note: top table is the left and bottom table is the right table

Column Expansion

INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL OUTER JOIN

OUTER APPLY (left join)
CROSS APPLY (inner join)

Row Expansion

UNION
EXCEPT
INERCECT

Indexes

CLUSTERED INDEX
NONCLUSTERED INDEX
WITH
UNIQUE
PRIMARY KEY
COMPOSITE KEY
Foreign Key

Window Functions

ROW_NUMBER
RANK
DENSE_RANK
NTILE

LAG
LEAD

FIRST_VALUE
LAST_VALUE

Views

View Basics
Common Table Expression
SCHEMABINDING
View Indexing (pointless)

Advanced

Stored Procedure
OFFSET (Pagination)
Nested Queries
Temp Tables
IF & ELSE
TRANSACTION

sp_who2
DBCC INPUTBUFFER
kill
Clear Execution Plan Cache

Cursor