Collège des technologies de l’information de Montréal
Montreal College of Information Technology English flagEN FlagFR


SQL Programming with Transact-SQL

This certificate is intended for SQL Server programmers or database administrators, system engineers, and developers with or without prior experience who are seeking to validate their skills and knowledge in writing queries and extracting data for reporting purposes. Our certificate helps you learn how to use SQL to store, query, and manipulate data. SQL is a special-purpose programming language designed to manage data in a relational database and is used by many apps and organizations across the globe.

Instructor Led


  • Programming - Transact SQL

    Get trained by industry Experts

  • Programming - Transact SQL

    Project Based Learning

  • Programming - Transact SQL

    Learn while you Work

  • Programming - Transact SQL

    State of the Art Infrastructure

  • Programming - Transact SQL

    24/7 Lab access


SQL Programming with Transact-SQL

This module introduces SQL Server and its different versions, including cloud versions. It also explains how to connect to SQL Server using SQL Server Management Studio, in addition to describing the elements of T-SQL and their role in writing queries.

This modules examines the fundamentals of the SELECT statement, writing queries that combine data from multiple sources in Microsoft SQL Server, implementing sorting and filtering, and usage of aggregate functions.

This module is designed to introduce students to the various data types SQL Server uses to store data. They also learn about DML queries and some of the many built-in functions in SQL Server.

The focus of this module is to explain several types of subquery and describe how to use the set operators UNION, INTERSECT, and EXCEPT to compare rows between two sets and executing stored procedures. This module also covers programming with SQL and error handling.



T-SQL or Transact SQL is the query language specific to the Microsoft SQL Server product. If you are into operations like retrieving the data from a single row, inserting new rows, and retrieving multiple rows, this could help.
The SQL query is in high-level language. A translator decrypts the language into ordinary script. Seasonal programmers would find this certification of value.
Career switchers For those people who are either getting into Databases or Business Intelligence roles . This Transact - SQL language program can help you transition into a much sought after career switch.
Career starters : For those people who are either entering the job market or are interested in making a shift in their current job status.


You don't need any formal training to take this course but it is good to at least have:
Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases.

Upon completing this course, you will receive an industry-recognized certificate from MCIT. Once you complete this exam, you will earn your official SQL Programming with Transact-SQL certification. After that you can pursue the exam 70-761 - Querying Data with Transact-SQL



— FAQ —

Absolument. N'hésitez pas à contacter notre bureau, nous serons plus qu'heureux de travailler avec vous pour répondre à vos besoins de formation.