Skip to content
Deadline to Die

01. DBMS Foundations

Overview

This module introduces the fundamental concepts of Database Management Systems (DBMS) and the specific architecture of Microsoft SQL Server.

Topics Covered

  • DBMS Basics: What is a database? RDBMS vs. NoSQL.
  • SQL Server Architecture: Client-Server model, the Relational Engine, and the Storage Engine.
  • SSMS & Tooling: Setting up SQL Server Management Studio (SSMS) and basic navigation.
  • Transact-SQL (T-SQL): Introduction to the SQL Server dialect.