Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Get Started Querying with Transact-SQL

Microsoft via Microsoft Learn

Overview

  • Module 1: Introduction to Transact-SQL
  • After completing this module, you will be able to:

    • Understand what SQL is for
    • Identify database objects in schemas
    • Identify SQL statement types
    • Use the SELECT statement
    • Work with data types
    • Handle NULLs
  • Module 2: Sort and filter results in T-SQL
  • After completing this module, you will be able to:

    • Sort your results
    • Limit the sorted results
    • Return paged results
    • Remove duplicates
    • Filter data with predicates
  • Module 3: Combine multiple tables with JOINs in T-SQL
  • After completing this module, you will be able to:

    • Describe join concepts and syntax
    • Write queries that use inner and outer joins
    • Write queries that use cross joins
    • Write queries that use self joins
  • Module 4: Write Subqueries in T-SQL
  • After completing this module, you will be able to:

    • Understand what subqueries are
    • Use scalar or multi-valued subqueries
    • Use self-contained or correlated subqueries
  • Module 5: Use built-in functions and GROUP BY in Transact-SQL
  • After completing this module, you will be able to:

    • Categorize built-in functions
    • Use scalar functions
    • Use ranking and rowset functions
    • Use aggregate functions
    • Summarize data with GROUP BY
    • Filter groups with HAVING
  • Module 6: Modify data with T-SQL
  • After completing this module, you will be able to:

    • Insert data into a table
    • Generate automatic values
    • Update data in a table
    • Delete data from a table
    • Merge data based on multiple tables

Syllabus

  • Module 1: Introduction to Transact-SQL
    • Introduction
    • Work with schemas
    • Explore the structure of SQL statements
    • Examine the SELECT statement
    • Work with data types
    • Handle NULLs
    • Exercise - Work with SELECT statements
    • Knowledge check
    • Summary
  • Module 2: Sort and filter results in T-SQL
    • Introduction
    • Sort your results
    • Limit the sorted results
    • Page results
    • Remove duplicates
    • Filter data with predicates
    • Exercise - Sort and filter query results
    • Knowledge check
    • Summary
  • Module 3: Combine multiple tables with JOINs in T-SQL
    • Introduction
    • Understand joins concepts and syntax
    • Use inner joins
    • Use outer joins
    • Use cross joins
    • Use self joins
    • Exercise - Query multiple tables with joins
    • Knowledge check
    • Summary
  • Module 4: Write Subqueries in T-SQL
    • Introduction
    • Understand subqueries
    • Use scalar or multi-valued subqueries
    • Use self-contained or correlated subqueries
    • Exercise - Use subqueries
    • Knowledge check
    • Summary
  • Module 5: Use built-in functions and GROUP BY in Transact-SQL
    • Introduction
    • Categorize built-in functions
    • Use scalar functions
    • Use ranking and rowset functions
    • Use aggregate functions
    • Summarize data with GROUP BY
    • Filter groups with HAVING
    • Exercise - Use built-in functions
    • Knowledge check
    • Summary
  • Module 6: Modify data with T-SQL
    • Introduction
    • Insert data
    • Generate automatic values
    • Update data
    • Delete data
    • Merge data based on multiple tables
    • Exercise - Modify data
    • Knowledge check
    • Summary

Reviews

Start your review of Get Started Querying with Transact-SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.