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.
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 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
Professional Benefits
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.
Who Should Apply
Database administrator
Database developers
BI professionals
Developers from other product platforms(eg.,Oracle)
IT professionals
Dwany H
Big Data Developer
Rosana N
Java Developer
Sihame B
BI Developer
Azemat Imani
STQA
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.
WHAT YOU WILL LEARN COURSE OUTLINE
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
- 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
Ayda Ghasemi
I am a SQL instructor at MCIT and a member of the Data and BI team at Couche-Tard. I have expertise in Microsoft Azure stack on-premises and in Azure cloud. I hold a bachelors in Physics and an MBA. I also spent a year as a BI developer at MCIT.
Dhruv Gusain
Enterprise Java developer with a passion for sports. My Aim, to have a connection with the students and make them understand the crux of any concept.
Gregory Shinder
I love working with SQL Server, especially to solve performance problems. Have a poor-performing query? Challenge accepted! I also like to design and implement high availability and disaster recovery solutions. When I’m not trying to break another SQL server, you’ll find me teaching SQL.
Haythem Rehouma
I am a full-stack and mobile developer who works on native mobile (Android and iOS) and cross-platform (PhoneGap/Ionic/ReactNative/Angular) apps for both business and consumer customers. Examples of my apps included location-based services and sensors.
Jiji Raghavan
I am a software QA instructor at MCIT where I help students focus on their vision by guiding them through each phase of their career. I have 6 years of experience as a QA engineer and 2 years in teaching. It motivates me as I can see myself as an agent of change in my students’ life. I want to inspire all of my students to be ambitious and make a difference in their life and career.
Kashyap Vedantam
With more than 6 years of industry experience, I’ve developed many applications in various programming languages. I hold a masters in applied computer science from Concordia and am a certified Microsoft SQL developer. I seek to create a classroom atmosphere that is stimulating and makes students feel valued. "Grow by learning something new every day."
Souleyman Sidibe
I am an experienced IT project manager with significant expertise in business intelligence (BI). I hold high-level degrees in IT networking, telecommunications, business intelligence, and programming. I’ve previously worked as a database specialist, an ETL developer, a BI analyst, and a business analyst. My main motivation in teaching is to transfer the knowledge that helps others fulfill themselves.
Toufik Lazri
I am a university graduate in computer engineering and have been developing and implementing computer applications for more than 25 years. I have been teaching Java technologies for more than 10 years. I enjoy passing on my knowledge in a clear and dynamic way in order for students to make a successful transition to the labor market.
Vimal Kapoor
I am a dynamic IT professional with experience in corporate IT systems, network support solutions, and Wipro technologies. I have the proven ability to provide creative and effective server and networking strategies for all Microsoft operating systems and server products.
Aimable Karangwa
I hold a masters in IT management and am a Certified Business Analyst Professional (CBAP), a PMI-Agile Certified Practitioner (PMI-ACP), and have obtained a PRINCE2 Foundation certification. I have 17 Years of experience as a senior business analyst consultant.
Iraj Hedayati
I'm leading the data team at Guavus, a major data analytics company, working with the Hadoop ecosystem. I hold a master's degree in computer science and one in software engineering. I was always eager to pursue teaching, an activity that I thoroughly enjoy.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
