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

CERTIFICATES

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.

  • English
  • 40 hours*
  • As per demand
  • APPLY
    HERE

* 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

BI Developer

Programming - Transact SQL
Jyothi Puthulatha

STQA

Programming - Transact SQL
Azemat Imani

STQA

Programming - Transact SQL
Karla Perez

Java Developer

ELIGIBILITY AND REQUIREMENTS

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.

WHAT YOU WILL LEARN COURSE OUTLINE

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.

SKILLS ACQUIRED

CERTIFICATION EXAMS

70-761 - Querying Data with Transact-SQL

TOP REASON
TO JOIN MCIT

  • 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

INSTRUCTOR SPOTLIGHT

COMMUNITY TESTIMONIAL

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