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


Programming - Transact SQL
State of the Industry

SQL is the foundation of most data tools used today. This advanced level course teaches IT professionals to develop a Microsoft SQL Server database. It also focuses on SQL Server product features and more broadly on the tools necessary to develop a database. Participants learn concepts of relational databases and SQL (structured language query). They also learn to store, query and manipulate data in order to produce relevant information. This course also prepares professionals for three official Microsoft certification courses.

* Morning, evening, weekends

Professional Benefits

Professionals work in a wide array of companies, from startups to global organizations. The median annual salary for a database administrator is $64,446 with a usual range between 41 and 90K. There would be 10% increase in the number of jobs by 2020.

Who Should Apply

Database administrator
Database developers
BI professionals
Developers from other product platforms(Oracle)
IT professionals

Programming - Transact SQL
Sihame B

BI Developer

Programming - Transact SQL
Jyothi Puthulatha


Programming - Transact SQL
Azemat Imani


Programming - Transact SQL
Karla P

Java Developer


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

Abilities acquired
at course completion

Writing SELECT statements with filtering and sorting.

Writing DML statements.

Writing queries that use built-in functions and aggregate data

Writing subqueries, Implement views and table-valued functions.

Writing queries that use window ranking, offset, and aggregate functions.

Creating and implementing stored procedures.

Add programming constructs such as variables, conditions, and loops to T-SQL code.


Programming - Transact-SQL

This modules introduces you to SQL Server, the differents versions of SQL Server, including cloud versions, and to connecting to SQL Server using SQL Server Management Studio. It also focuses on the element 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, and,the implementation of sorting and filtering, and the usage of aggregate functions.

Learn the data types SQL Server uses to store data and how to create DML queries and some of the many built-in functions in SQL Server.

This module addresses several types of subqueries, the use of set operators UNION, INTERSECT, and EXCEPT (by which rows can be compared between two sets) and executing stored procedures. This module also covers programming with SQL and error handling.



70-761 - Querying Data with Transact-SQL


  • Industry-relevant, job-ready programs
  • Internship possibilities
  • Eligibility for off-campus work permit program [ocwpp]
  • Eligibility for post-graduation work permit [pgwp]
  • Eligibility for points under Quebec’s immigration policy
  • Scholarships and financial aid



The Instructor led knowledge dissemination is effective owing to the micro-strength of the class rooms and its personalized approach to learning.

Amentor Messanvi — STQA Student
  • Programming - Transact SQL
  • Programming - Transact SQL
  • Programming - Transact SQL
  • Programming - Transact SQL
  • Programming - Transact SQL

Montreal College
of Information Technology

Collège des TI de Montréal

110-1255 Robert-Bourassa Blvd.
Montreal, Quebec H3B 3V8

+1 514-312-2383
.(JavaScript must be enabled to view this email address)