Skip to content

03. SQL Basics & DQL

Overview

In this module, we start our journey into querying with Data Query Language (DQL).

Topics Covered

  • SELECT Statements: Retrieving data, aliasing, and the TOP clause.
  • SQL Server Data Types: String (VARCHAR, NVARCHAR), Numeric (INT, DECIMAL), and Date types.
  • The WHERE Clause: Basic filtering with comparison and logical operators.
  • Built-in Functions: Using string, mathematical, and date/time functions.