Part 1 of 7 in the Data Engineering with SQL Server path

SQL Server Essentials booklet cover

SQL Server Essentials

DOCX 183 KB Beginner Sep 2026

Microsoft SQL Server is a robust relational database management system (RDBMS) designed to handle a wide range of applications, from small-scale projects to enterprise-level systems. It supports structured data storage, querying, and management using Transact-SQL (T-SQL), Microsoft’s extension of the SQL standard.

What you'll learn

  • Introduction to SQL Server
  • Basic SQL Queries
  • Joins and Subqueries
  • Stored Procedures

Table of contents

  1. Introduction to SQL Server
  2. Basic SQL Queries
  3. Joins and Subqueries
  4. Stored Procedures
  5. User-Defined Functions
  6. Triggers
  7. Indexes and Performance Optimization
  8. Transactions and Error Handling
  9. Security in SQL Server
  10. Best Practices and Advanced Topics