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

CERTIFICATES

Querying Data with 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.

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

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

Querying Data with Transact-SQL
Sihame B

BI Developer

Querying Data with Transact-SQL
Jyothi Puthulatha

STQA

Querying Data with Transact-SQL
Azemat Imani

STQA

Querying Data with Transact-SQL
Karla P

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.

Querying Data with 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

  • 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

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
  • Querying Data with Transact-SQL
  • Querying Data with Transact-SQL
  • Querying Data with Transact-SQL
  • Querying Data with Transact-SQL
  • Querying Data with 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)