record versioning
fact table
dimension
fact
OLTP vs OLAP
MAterialised view
SP vs function
Isolation levels
ACID properties
SCD
Indexes
DBMS vs RDBMS
Normalisation
temp table vs table variable vs cte
parent child package
delete vs truncate
table vs view
where vs having
star schema vs snow flake
can we create table inside function
can we create clustered index on non pk column

Print 1 to 10 numbers using sql query