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


Data Management with SQL

With data becoming the core part of our daily lives, there’s a need to learn to manage it using various storage & manipulation techniques. Microsoft’s SQL Server enables you to design, query and maintain data using MSSQL. And more importantly, working knowledge of SQL has become a crucial skill in any data job.

This course focuses on helping you to use Microsoft’s SQL Server products and tools to implement a database server. Also, you get to learn querying using T-SQL along with foundations of database administration, development and business intelligence. Furthermore, you shall be exposed to the BI & Data Warehousing fundamentals like dimensional modelling and principles behind the lifecycle of a Business Intelligence solution

​Class Schedule: Monday, Wednesday and Friday (6PM to 9PM)

Professional Benefits

The median annual salary for a database administrator is $64,446, with a usual range between 40 and 90K.
A 10% job increase by 2022 is currently being anticipated.
To further develop their career, students can obtain certifications in Microsoft’s PowerBI tool and analyze data.

Who Should Apply

Anyone who would like to foray into the world of analytics
Seasoned professionals who would like to upskill themselves to work with the latest tools
Aspiring BI professionals and Software Developers


- Working knowledge of Windows or Mac OS

- Familiarity with Excel but not mandatory


MCSA - SQL Server 2016

  • ​SQL Server architecture, editions & versions
  • Introducing Transact-SQL (T-SQL)
  • ​Understanding & writing SELECT queries in SQL
  • Eliminating duplicates with DISTINCT
  • Using column, table aliases & CASE expressions
  • ​Understanding Joins
  • Querying with Inner, Outer, Cross Self Joins
  • ​Sorting data
  • Filtering data with Predicates, TOP & OFFSET-FETCH
  • Introducing SQL Server Data Types
  • Working with date & time data
  • ​Using DML to modify data
  • Using Built-in functions in SQL
  • ​Using Aggregate functions
  • Using Group By clause
  • Filtering groups with HAVING
  • Writing self-contained subqueries
  • Writing correlated subqueries
  • ​Using Views
  • Using Inline Table Valued Functions (TVFs)
  • Using Common Table Expressions (CTEs)
  • Writing queries with UNION operator
  • ​Using Window ranking, offset & aggregate functions
  • Writing queries with PIVOT & UNPIVOT
  • Working with Grouping Sets
  • Understanding Stored Procedures & executing them
  • Programming with T-SQL
  • ​Implementing T-SQL Error Handling
  • Implementing Structured Exception Handling
  • Transactions & the database engine


Earn MCIT Certification

You shall receive a certification of completion from MCIT towards the end of this course.
Furthermore, you can attempt these examinations:

70-761 - Querying Data with Transact-SQL.

70-762 - Developing SQL Databases.

Why join MCIT?

  • Taught by Industry Experts as instructors
  • Discount on Certification Program
  • Eligible to claim tax credit up to 25% of course fees
  • 24*7 Lab Virtual Desktop access
  • Evening and Weekend schedule
  • Vendor Authorized Training


  • MCSA - SQL Server 2016
  • MCSA - SQL Server 2016
  • MCSA - SQL Server 2016
  • MCSA - SQL Server 2016
  • MCSA - SQL Server 2016

— F.A.Q —

To register for a course, you can either call us or enter your request online and our administrative staff will call you with steps to register.
Definitely. Please feel free to contact our office, we will be more than happy to work with you to meet your training needs.
You can find most of the scheduling and pricing information on our website, or you can call our office for assistance.
Montreal College offers a new session every four months, i.e., in October (fall session), February (winter session) and June (summer session). Students are encouraged to register at least 2 to 16 weeks in advance. Please note that many programs fill up before the registration deadline.

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)