My Software Engineering Notes!
Paradigms
Database Theory
Keys & Relationships
Database Model
Data Model
Normalization and Denormalization
Data Warehouse
Database Design
Data Types
Tables
Views
Indexes
Functions
Store Procedures
Triggers
XML Schema/Data Type
Assemblies & CLR Objects
Full-Text Search
Synonyms
Extended Property
Query Database
Query Basics
Basics
“CASE” Expression
Type Casting
Joins
"GROUP BY"
TOP, Pagination, Ranking
Aggregate Functions
UNION, INTERSECT, EXCEPT
CTE (Common Table Expressions)
"IN, BETWEEN, LIKE" (Predicates)
Advanced Concepts
Cursors
String Functions
Join String Column Records
Date & Time
Dynamic Queries
Querying Database Metadata
Encryption & Hashing
Collations
Statistics
Query Performance
Data Manipulation
Insertion & Update
“BULK INSERT”
"MERGE" Statement
“OUTPUT” Clause
"SET NOEXEC"
"PIVOT" & "UNPIVOT"
"DELETE" & "TRUNCATE"
JSON Processing
Transactions
Error Handling
SQL Server interview questions for experienced developers - Simple Talk
