Querying Data with Transact-SQL

Product information

IT

Reviews

4 out of 5 stars

(no reviews)

Level: Certificate

Inquire Now

Entry Requirement

Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases.

Course Content

  • Introduction to Microsoft SQL Server
  • Introduction to T-SQL Querying
  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server Data Types
  • Using DML to Modify Data
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using Table Expressions
  • Using Set Operators
  • Using Windows Ranking, Offset, and Aggregate Functions
  • Pivoting and Grouping Sets
  • Executing Stored Procedures

Inquire Now