Skip to content

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.