Learning Transact-SQL

Go to class
Write Review

Free Online Course: Learning Transact-SQL provided by LinkedIn Learning is a comprehensive online course, which lasts for 4-5 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Learning Transact-SQL is taught by Jeff Jones.

Overview
  • Learn how to utilize Transact-SQL to address real business requirements and gain a solid understanding of your SQL Server database.

Syllabus
  • Introduction

    • Welcome
    1. Discovering the Database
    • Using SQL Server Management Studio (SSMS)
    • Identifying table relationships
    • SSMS diagram support
    • Preparing to write SQL
    2. Accessing Tables
    • The basic SELECT statement
    • Combining two tables with a join
    • Combining multiple tables with a join
    3. Filtering the Data
    • Filtering the data
    • Using functions
    4. Displaying Data
    • Defining the result set
    • Manipulating numbers and data types
    • Using conditional column output
    • Controlling output rows
    5. Aggregating Data
    • Grouping data