Course curriculum

  • 1

    Skill 1.1: Create Transact-SQL SELECT queries

    • 00 Data Source

    • SQL Server 2019 Installation

    • 01 T-SQL intro

      FREE PREVIEW

    • 02 Install SQL Server

    • 03 The Querying Environment

    • 04 Select Statement

    • 05 Return records with SELECT and FROM

    • 06 Filter Data With Where Basic

    • 07 Filter Data With Where Like

    • 08 Filter Data With Where And OR NOT

    • 09 Aggregating Data with Group By

  • 2

    Skill 1.2: Query multiple tables by using joins

    • 001 Normalization vs Denormalization

    • 002 Combine Two Tables With Join

    • 003 Combine Multiple Tables With Join