Databases & SQL

Database fundamentals, SQL Server, and data storage patterns.

SQL Fundamentals

• Database Types Guide - RDBMS, NoSQL, and polyglot persistence

Topics Covered

Relational Databases

• SQL Server basics
• Table design and normalization
• Indexes and query optimization
• Transactions and ACID
• Stored procedures and functions

NoSQL Databases

• Document databases (MongoDB, CosmosDB)
• Key-value stores (Redis)
• Column-family stores (Cassandra)
• Graph databases (Neo4j)

Data Modeling

• Entity-relationship diagrams
• Normalization forms (1NF, 2NF, 3NF)
• Denormalization strategies
• Polyglot persistence

Performance

• Query execution plans
• Index strategies
• Query optimization
• Connection pooling