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
TOPclause. - 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.