Databases & Data
Learn SQL Server
SQL Server is Microsoft's relational database engine. It stores your tables, runs your queries, and enforces the rules you define about your data.
Why teams use it
- It is common in organisations already invested in the Microsoft ecosystem.
- Tooling for query analysis and performance work is mature.
- It integrates cleanly with .NET applications and Azure hosting.
Where you will meet it
A .NET line-of-business application in an enterprise environment very often has SQL Server behind it.
What to learn, and in what order
Work through these roughly in order. Jumping to the advanced list before the basics are solid is the most common way people get stuck.
Beginner
- Connecting and running queries
- Creating tables and keys
- Basic data types
Intermediate
- Indexes
- Stored procedures
- Backups and restores
- Security and permissions
Advanced
- Execution plan analysis
- Concurrency and locking
- Partitioning strategies
Have a project worth talking through?
Tell us what you're building or what's slowing your current system down. We'll give you a direct read on scope and approach.