SQL Server

Service Account-

Authentications-

collation settings-

Server Role-

Database Role-

schema concept-

Entities-

Primary Key & Foreign Key-

Relations-

Cardinality-

Join Concepts-

Data Types-

Exact numerics-

Approximate numerics-

Decimal-

Date and Time-

Character Strings-

BLOB-

Referential Integrity laws-

Check Constraints-

DDL Statements to CREATE / ALTER / DROP tables-

Working with Scalar Functions-

Using Case Expressions-

ALL-

DISTINCT-

TOP-

Table-

View-

(Derived Table and Common Table Expressio (CTE-

Table Valued Functions-

Synonyms-

Casting and conversion-

Working with Date and Time data types-

UNION-

INTERSECT-

EXCEPT-

Update from existing data-

WRITE extension to the UPDATE command-

Deleting related data-

Truncate Table-

ROW_NUMBER-

RANK-

Working with Variables-

IF Statement-

CASE Expressions-

WHILE Loop-

Auto Commit Transactions-

BEGIN TRAN and compound transactions-