Querying Data With Microsoft Transact-SQL

T-SQL or Transact SQL is the query language specific to the Microsoft SQL Server product. It can help perform operations like retrieving the data from a single row, inserting new rows, and retrieving multiple rows. It is a procedural language that is used by the SQL Server

 

  • Use SQL Server query tools
  • Write SELECT statements to retrieve columns from one or more tables
  • Sort and filter selected data
  • Use built-in functions to returned data values
  • Create groups of data and aggregate the results
  • Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE

 

  • Data Analyst
  • Data Engineer
  • Data Scientist
  • Database administrator
  • Database Developer

 

  • Introduction to Transact-SQL
  • Using the SELECT statement
  • Get started with SQL Server query tools and writing queries in T-SQL

 

  • Sorting query results
  • Filtering the data
  • Sort and filter data returned by SELECT queries

 

  • Using JOIN operations
  • Using subqueries
  • Write queries with JOIN operations
  • Write SELECT statements using subqueries

 

  • Getting started with scalar functions
  • Grouping aggregated results
  • Built-in functions

 

  • Inserting data into tables
  • Modifying and deleting data

 

Related Courses