This module introduces SQL Server and its different versions, including cloud versions. It also explains how to connect to SQL Server using SQL Server Management Studio, in addition to describing the elements of T-SQL and their role in writing queries.
CERTIFICATES
Programming - Transact SQL
State of the Industry
SQL is the foundation of most data tools used today. This advanced level course provides IT professionals with the knowledge to develop a Microsoft SQL Server database. This course focuses on providing all the skills needed to be proficient in SQL and also on how to use SQL Server product features and tools related to developing a database. Participants will learn concepts of relational databases and SQL (structured language query). They will also learn how to store, query and manipulate data in order to produce relevant information. This course prepares professionals for three official Microsoft certifications.
- English
- 40 hours*
- As per demand
- Talk to an
ADVISOR
* Morning, evening, weekends
Who should apply
Professionals work in a wide array of companies, from startups to global organizations. The annual salary range for a database administrator is between $41,06 and $89,881. There would be 10% increase in the number of jobs by 2020 Database administrator, Database developers, BI professionals, Developers from other product platforms(eg.,Oracle), IT professionals
Programming – Transact-SQL
This modules examines the fundamentals of the SELECT statement, writing queries that combine data from multiple sources in Microsoft SQL Server, implementing sorting and filtering, and usage of aggregate functions.
This module is designed to introduce students to the various data types SQL Server uses to store data. They also learn about DML queries and some of the many built-in functions in SQL Server.
SKILLS ACQUIRED
DML statements with filtering and sorting.
Built-in functions and aggregate data
Subqueries, implement views and table-valued functions.
Window ranking, offset, and aggregate functions.
Implement stored procedures.
Data integrity through constraints.
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
COMMUNITY TESTIMONIAL
Being an international student, I think it was crucial how I started my education in Canada. Small classes, laid-back atmosphere, and cheerful people are the factors that made Montreal College a perfect starting point for me.
Sanketh Joshi — STQA Student
