Udemy, Coursera, 2U/edX Face Lawsuits Over Meta Pixel Use

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

Go to class Write review

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

Tags

Reviews

Start your review of Get Started Querying 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.