Data Codex

Question - 03 | SQL Interview Questions | SQL Server

ALTER PROCEDURE Command | SQL Server

COLLATE COMMAND | SQL Server

System assigned managed Identity auth. for Storage accounts | Session - 11 | Azure Data Factory

Service Principal authentication for Storage accounts | Session - 13 | Azure Data Factory

CROSS JOIN | SQL Server

CASE Command | SQL Server

CONTINUE Function | SQL Server

Linked Services in ADF | Session - 07 | Azure Data Factory

CLUSTERED INDEX | SQL Server

What is Azure Blob & ADLS Gen 2 ? | Session -09 | Azure Data Factory

Copy Data Tool in ADF | Session - 15 | Azure Data Factory

CHECK CONSTRAINT| SQL Server

CURRENT_TIMESTAMP Function | SQL Server

CAST Function | SQL Server

CURRENT_USER Function | SQL Server

AS Command | SQL Server

Understanding and Handling Null Values in SQL Server

Foreign key reference, Check Constraint | SQL Server

DATE COMMAND | SQL Server

Understanding Dense Rank and NTILE | SQL Server

ALL Command | SQL Server

Unique Constraint & Identity Constraint | SQL Server

Understanding PIVOT and UNPIVOT Commands| SQL Server

BACKUP DATABASE Command | SQL Server

SAS URI authentication for Storage accounts | Session - 14 | Azure Data Factory

ADLS Gen2 to Blob using Access Key authentication | Session - 10 | Azure Data Factory

ABS Function | SQL Commands | SQL Server

Understanding UPDATE Trigger | SQL Server

Mastering TCL & DCL Commands | SQL Server

Mastering GROUP BY and HAVING Commands | SQL Server

Delete Activity | Session - 23 | Azure Data Factory

Understanding Sequences and Window Functions | SQL Server

EXISTS COMMAND | SQL Server

COMMIT COMMAND | SQL Server

Unlocking the Power of Sub Queries | SQL Server

Question - 12 | SQL Interview Questions | SQL Server

Index | Types of Index | SQL Server

Mastering INNER JOIN and FULL OUTER JOIN | SQL Server

CONVERT Function | SQL Server

Primary keys, Foreign keys, and Default Constraint in SQL Server

Variables & Dynamic Queries | SQL Server

Mastering DDL and DML Commands | SQL Server

AVG Command | SQL Server

Question - 16 | SQL Interview Questions | SQL Server

ALTER FUNCTION Command | SQL Server

Self-hosted Integration Runtime | Session - 05 | Azure Data Factory

Mastering CROSS JOIN and SELF JOIN | SQL Server

What is Azure Data Factory? | Session - 01 | Azure Data Factory

Question - 03 | SQL Interview Questions | SQL Server

Tips and Tricks | Every SQL Developer must know | SQL Server