T SQL

View

• Order By in View
• Refreshing a View

General Topics

• Update statement using join condition in sql server
• PIVOT and UNPIVOT in SQL Server
• Dynamic Incremental load using sql query and merge join
• Find last day of the month using SQL Server
• SQL Query to convert Date from MM/DD/YYYY to YYYY-MM-DD Format

Fibonacci Sequence
organization chart with depth
Directory Structure
Hierarchy of Employees
Calculate the factorial of a number
Path Enumeration in a Graph

Dynamic pivoting in t-sql

Pivoting with tricky example

Dynamic SQL with example

Transparent Data Encryption (TDE)
Column-Level Encryption
Always Encrypted
Dynamic Data Masking (DDM)
Transport Layer Security (TLS)

Recursive Common Table Expressions (CTEs):
Dynamic SQL
Pivot and Unpivot
JSON Data Handling
XML Data Handling
Computed Columns
Full-Text Search
Partitioned Tables and Indexes
FileStream Data
Service Broker
Change Data Capture (CDC)
Merge Statements
Triggers
CLR Integration
Spatial Data
Columnstore Indexes
Query Performance Tuning
Extended Events
Parameterized Queries
Encryption
Batch Mode Processing
Memory-Optimized Tables
Query Store