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

Microsoft

Query and modify data with Transact-SQL

Microsoft via Microsoft Learn

Go to class Write review
Corporate Finance Institute Ad

35% Off Finance Skills That Get You Hired - Code CFI35

Learn More → Udacity Ad

Master AI & Data—50% Off Udacity (Code CC50)

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
  • Introduction to Transact-SQL

    After completing this module, you'll 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
  • 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
  • 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
  • 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
  • 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
  • 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

  • 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
    • Module assessment
    • Summary
  • 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
    • Module assessment
    • Summary
  • 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
    • Module assessment
    • Summary
  • Write Subqueries in T-SQL
    • Introduction
    • Understand subqueries
    • Use scalar or multi-valued subqueries
    • Use self-contained or correlated subqueries
    • Exercise - Use subqueries
    • Module assessment
    • Summary
  • 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
    • Module assessment
    • Summary
  • Modify data with T-SQL
    • Introduction
    • Insert data
    • Generate automatic values
    • Update data
    • Delete data
    • Merge data based on multiple tables
    • Exercise - Modify data
    • Module assessment
    • Summary

Tags

Reviews

Start your review of Query and modify data with Transact-SQL

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.