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

CERTIFICATES

MCSA – SQL Server 2016
State of the Industry

SQL is the foundation of most data tools used today. This advanced level course provides IT professionals with the knowledge and skills to develop a Microsoft SQL Server database, be proficient in SQL, and use SQL Server product features and tools related to developing a database. Participants learn the concepts of relational databases and SQL (Structured Language Query), and how to store, query and manipulate data in order to produce relevant information. After completing the course, professionals are able to design advanced table designs, design and implement stored procedures and user-defined functions, store and query XML data, queries and subqueries using aggregate functions. This course also prepares professionals for three official Microsoft certification courses.

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

* Morning, evening, weekends

Professional Benefits

The median annual salary for a database administrator is $64,446, with a usual range between 40 and 90K. An 10% job increase by 2020 is currently being anticipated.
To further develop their career, students can obtain certifications, from beginner to advanced level, in Cisco and network security & administration.

Who Should Apply

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

MCSA - SQL Server 2016
Daniel Klein

Web Developer

MCSA - SQL Server 2016
Sihame

BI Specialist

MCSA - SQL Server 2016
Rosana

Java Developer

MCSA - SQL Server 2016
Aasma Ahmed

SAP

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.

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

Designing advanced table designs.

Data integrity through constraints.

Designing and implementing user-defined functions.

Designing and implementing in-memory tables.

Storing and querying XML data and work with spatial data.

Storing and querying blobs and text documents.

SQL Server concurrency and performance monitoring.

WHAT YOU WILL LEARN COURSE OUTLINE

MCSA - SQL Server 2016

This module introduces SQL Server and its different version, including cloud versions. You learn how to connect to SQL Server using SQL Server Management Studio and become familiar with the elements of T-SQL and their role in writing queries.

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

This module introduces you to the data types SQL Server uses to store data. You will also learn how to create DML queries and some of the many built-in functions in SQL Server.

The focus of this course is to describe several types of subquery and 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.

This is mixture of Partitioning, Compressing data and implementing Data Domain, Referential Integrity. This course teaches students how to improve the quality of data in database, which largely determines the usefulness and effectiveness of applications that rely on it.

This module discusses advanced index topics including the INCLUDE clause, query hints, padding and fill factor, statistics, using DMOs, the Database Tuning Advisor, Query Store and also columnstore indexes, which are used in large data warehouse solutions by many organizations.

This one describes the design and implementation of stored procedures, design and implement user-defined functions (UDFs) that enforce business rules or data consistency which includes modify and maintain existing functions. This module also provides overview of DML triggers, the different types of trigger, and how to define them in your database.

The ability to query XML data directly avoids the need to extract data into a relational format before executing Structured Query Language (SQL) queries. This module will provide knowledge of effectively processing XML by returning existing relational data as XML, and querying data that is already XML.

This one covers the implementation of concurrency, critical feature of multi user database systems in Microsoft SQL Server. You will learn about how SQL Server implements concurrency controls, and the different ways you can configure and work with concurrency settings. This module also covers how to measure and monitor the performance of your SQL Server databases, which includes architectural concepts, troubleshooting strategies and usage scenarios.

SKILLS ACQUIRED

CERTIFICATION EXAMS

70-761 - Querying Data with Transact-SQL.

70-762 - Developing SQL Databases.

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

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