Kaseya

What is a CTE (Common Table Expression)? What are its uses?

Explain the Medallion Architecture (Bronze, Silver, Gold layers).

Explain the components of ADF: Pipelines, Activities, Linked Services, Datasets, Triggers, and Integration Runtimes

Explain the differences between Azure IR, Self-hosted IR, and Azure-SSIS IR

APPLY Operator - CROSS APPLY and OUTER APPLY

Error Handling in T-SQL - TRY...CATCH, THROW, RAISEERROR

Normalization: 1NF, 2NF, 3NF with examples

PIVOT Operator in T-SQL