Certification in MCSA SQL Server 2016 | Microsoft SQL Server Database

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

CERTIFICATES

Data Management with SQL
State of the Industry

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

Flexible Schedule

Mornings | Evenings | 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

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
Software Developers

MCSA - SQL Server 2016
Dwany H

Big Data Developer

MCSA - SQL Server 2016
Sihame B

BI Developer

MCSA - SQL Server 2016
Rosana N

Java Developer

MCSA - SQL Server 2016
Aasma A

SAP

ELIGIBILITY AND REQUIREMENTS

Working knowledge of Windows or Mac OS
Familiarity with Excel but not mandatory

Abilities acquired after course completion

Writing SELECT statements with filtering and sorting

Writing DML statements & various data types in SQL

Writing queries using built-in functions and aggregating data

Writing subqueries, implementing views and table-valued functions

Writing queries using window ranking, offset, and aggregate functions

Creating and implementing stored procedures

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

Understanding advanced table designs and ensuring data integrity through constraints

Designing and implementing user-defined functions in-memory tables

Handling exceptions in SQL

Writing queries using Transactions

WHAT YOU WILL LEARN COURSE OUTLINE

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 EXCEPT, INTERSECT & APPLY
  • ​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

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

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)