We may earn an affiliate commission when you visit our partners.
Xavier Morera, Ami Levin, Jared Westover, Andrew McSwiggan, Tracy Borchert, and Tamara Pattinson

T-SQL is Microsoft's implementation of SQL (Structured Query Language) used to query and manage data in the SQL Server relational database. This skill will teach you how to use T-SQL to query data from SQL Server.

What You'll Learn

Read more

T-SQL is Microsoft's implementation of SQL (Structured Query Language) used to query and manage data in the SQL Server relational database. This skill will teach you how to use T-SQL to query data from SQL Server.

What You'll Learn

  • Querying data with the SELECT statement
  • Filtering data with the WHERE clause
  • Combining data with JOINs
  • Aggregating data
  • Inserting, updating, and deleting data
  • Enroll now

    Share

    Help others find this collection page by sharing it with your friends and followers:

    What's inside

    Five courses

    Querying Data Using T-SQL

    (2 hours)
    Whether you're new to SQL Server or an experienced SQL developer, this course will provide a solid foundation for querying data with T-SQL. You'll learn about SQL and T-SQL, query execution processing, and how to use every clause of the SELECT query. By the end of this course, you'll be able to query data effectively in T-SQL.

    Combining and Filtering Data with T-SQL 2019

    (3 hours)
    Following along with the exercise files, this course takes you from setting up the environment through writing more advanced queries using T-SQL functions, expressions, and logic.

    T-SQL Data Manipulation Playbook

    (2 hours)
    Querying requires data. This training covers inserting, updating, and deleting data in Microsoft SQL Server using T-SQL Data Manipulation Language, or DML.

    Querying JSON, XML, and Temporal Data with T-SQL

    (1 hours)
    The most common scenario with SQL Server is querying structured data. However, there are cases where the schema is not known up front or more flexibility is needed. Additionally, sometimes it is required to know the value of a particular field at a specific point in time. In this course, you’ll gain the ability to use JSON and XML to store, modify, and query semi-structured data. You’ll also learn how to retrieve values at any point in time with temporal tables.

    T-SQL Functions Playbook

    (3 hours)
    In this course, you will learn how to use T-SQL functions to summarize and analyze data. You will learn how to aggregate data, merge data from multiple queries, and apply logic calculations and formatting to transform data. By the end of this course, you will have the skills to take control of and analyze your data.

    Save this collection

    Save Querying Data with T-SQL from SQL Server to your list so you can find it easily later:
    Save
    Our mission

    OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

    Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

    Find this site helpful? Tell a friend about us.

    Affiliate disclosure

    We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

    Your purchases help us maintain our catalog and keep our servers humming without ads.

    Thank you for supporting OpenCourser.

    © 2016 - 2024 OpenCourser