Institute of Business
and Technology

iBtech Logo | Institute of Business & Technology

Business & Technology

Institute of Business & Technology

Course Status
Availability
Course Duration
Timing
Course ID
Exam Number
Registration Open
Weekdays – Weekends
7 Days, 49 Hours
9:00 AM – 04:00 PM
20761
70-761

Querying Data with Transact-SQL

After completing this course, students will be able to:

  • 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 and 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.
  • Must have completed MCSA SQL Server Administration

You have made the
best choice!

Students | IT Health, and Business Courses | iBtech Toronto & Mississauga

Book Your Seat Today

Request Information

Request Information