Querying Data with Transact-SQL

Course Statuse

Registration Open


7 Days, 49 Hours


9:00 AM - 04:00 PM


Weekdays - Weekends

Course Id:


Exam #:


Seat Reservation:

Before 14 Days

Course Overview

Transact-SQL is an essential skill-set for data developers and professionals. The primary purpose of this course is to give students a good understanding of the Transact-SQL language, which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course is part of the Microsoft Certificate in Data Science, Big […]

Learning Outcome

Upon successful completion of Transact-SQL students will be able to:

  • Describe the basic architecture and concepts of Microsoft SQL Server
  • Write SELECT queries and Query multiple tables
  • Describe the similarities and differences between Transact-SQL and other computer languages
  • Sort and filter data
  • Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions, Group, and aggregate data
  • Use subqueries, table expressions and set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting, and grouping sets Execute stored procedures
  • Program with T-SQL
  • Implement error handling and transactions


  • Must have good knowledge of relational Database or have one year IT industry experience in relational Database.

Course Content

  • 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 Set Operators
  • Pivoting and Grouping Sets
  • Executing Stored Procedures
  • Executing Stored Procedures
  • Implementing Error Handling
  • Implementing Transactions

Courses Details

Personal Details

(905) 212-9039

Enquire Now

Courses Form

Courses you maybe interested

Programming with PHP and MYSQL

Programming with PHP and MYSQL course offers advanced knowledge in open source technologies MySQL and PHP to develop console and web applications. Gain hands-on training to use Connectors to access MySQL databases, query the database effectively, present data in...

CCNA Scaling Networks

CCNA Scaling Networks certification training advances your networking career and prepares you for networking analyst and engineering jobs. The course focuses on hands-on training to configure and troubleshoot routers and switches and resolve common issues with OSPF,...