

SQL Programming
SQL Programming
Learn the language that powers data across every industry.
Guided by industry experts, you’ll build practical SQL skills and gain the confidence to query, manage, and analyze data from day one
Learn the language that powers data across every industry.
Guided by industry experts, you’ll build practical SQL skills and gain the confidence to query, manage, and analyze data from day one
Parlez à un conseiller
Parlez à un conseiller
36 hours
Schedule : Mon - Wed - Thu
6 PM - 9 PM
Duration
36 hours
Schedule : Mon - Wed - Thu
6 PM - 9 PM
Duration
Modular thinking,
Programming basics,
Algorithimic thinking,
Problem solving
Debugging
Skills Gained
Modular thinking,
Programming basics,
Algorithimic thinking,
Problem solving
Debugging
Skills Gained
Instructor led or
Self paced
Mentor guided
Online & Hybrid
learning
Learning Methodology
Instructor led or
Self paced
Mentor guided
Online & Hybrid
learning
Learning Methodology
Aperçu du programme
Aperçu du programme
This certificate is designed for SQL Server programmers or database administrators, system engineers, and developers with or without prior experience who want to certify their abilities and understanding in creating queries and extracting data for reporting purposes. You can use SQL to save, query, and manipulate data with the help of our certificate. Many apps and businesses throughout the world utilize SQL, a special-purpose programming language created to manage data in a relational database. Students who complete this course will be prepared to sit for the official Oracle Database SQL Certified Associate certification exam, number 1Z0-071.
This certificate is designed for SQL Server programmers or database administrators, system engineers, and developers with or without prior experience who want to certify their abilities and understanding in creating queries and extracting data for reporting purposes. You can use SQL to save, query, and manipulate data with the help of our certificate. Many apps and businesses throughout the world utilize SQL, a special-purpose programming language created to manage data in a relational database. Students who complete this course will be prepared to sit for the official Oracle Database SQL Certified Associate certification exam, number 1Z0-071.
Avantages clés
Avantages clés

Get trained by industry Experts
Our courses are delivered by professionals with years of experience having learned first-hand the best, in-demand techniques, concepts, and latest tools.
Get trained by industry Experts
Our courses are delivered by professionals with years of experience having learned first-hand the best, in-demand techniques, concepts, and latest tools.
Official Certification curriculum
Our curriculum is kept up to date with the latest official Certification syllabus and making you getting ready to take the exam.
Official Certification curriculum
Our curriculum is kept up to date with the latest official Certification syllabus and making you getting ready to take the exam.
Tax Credit
Claim up to 25% of tuition fees and education tax credit from your taxes.
Tax Credit
Claim up to 25% of tuition fees and education tax credit from your taxes.
Discount on Certification Voucher
Upto 50 percent discount voucher will be provided.
Discount on Certification Voucher
Upto 50 percent discount voucher will be provided.
24/7 Lab access
Our students have access to their labs and course materials at any hour of the day to maximize their learning potential and guarantee success.
24/7 Lab access
Our students have access to their labs and course materials at any hour of the day to maximize their learning potential and guarantee success.
Course Outline
Course Outline
Framer is a web builder for creative pros. Be sure to check out framer.com to learn more.
Introduction to Microsoft SQL Server
Framer is a web builder for creative pros. Be sure to check out framer.com to learn more.
Introduction to T-SQL Querying
Framer is a web builder for creative pros. Be sure to check out framer.com to learn more.
Writing SELECT Queries
Framer is a web builder for creative pros. Be sure to check out framer.com to learn more.
Querying Multiple Tables
Querying Multiple Tables
Sorting and Filtering Data
Sorting and Filtering Data
Working with SQL Server Data Types
Working with SQL Server Data Types
Using DML to Modify Data
Using DML to Modify Data
Using Built-In Functions
Using Built-In Functions
Grouping and Aggregating Data
Grouping and Aggregating Data
Using Subqueries
Using Subqueries
Using Table Expressions
Using Table Expressions
Using Set Operators
Using Set Operators
Executing Stored Procedures
Executing Stored Procedures
Implementing Error Handling & Transactions
Implementing Error Handling & Transactions
Introduction to Microsoft SQL Server
Introduction to T-SQL Querying
Writing SELECT Queries
Querying Multiple Tables
Sorting and Filtering Data
Working with SQL Server Data Types
Using DML to Modify Data
Using Built-In Functions
Grouping and Aggregating Data
Using Subqueries
Using Table Expressions
Using Set Operators
Executing Stored Procedures
Implementing Error Handling & Transactions
Compétences acquises
Compétences acquises
SQL basics
T-SQL programming
Grouping & Aggregating data
Built in functions
Write Queries
SQL basics
T-SQL programming
Grouping & Aggregating data
Built in functions
Write Queries
Qui peut postuler
Qui peut postuler
L'éducation pratique en TI est le pont entre votre diplôme et votre carrière.
L'éducation pratique en TI est le pont entre votre diplôme et votre carrière.
Iraj Hedayati
Data Engineering Lead
Iraj Hedayati is a seasoned Data Engineer with over a decade of experience designing and scaling data infrastructure at high-growth tech companies. He currently works as a consultant with Apple, specializing in distributed systems, Spark, and backend development. Iraj teaches Data Engineering courses focused on real-world applications in big data processing, cloud infrastructure, and modern data pipelines. His industry background includes leading large-scale data migrations, optimizing cloud costs, and building end-to-end systems for data ingestion and analytics.
Michel Chamoun
Data Science & Business Analyst
Michel is a highly skilled developer and consultant with expertise in AI, data analysis, and process optimization. As a developer in the GenAI team, he built proof-of-concepts leveraging chatGPT's natural language understanding capabilities and implemented AI modules on Microsoft Azure. As a consultant in the strategy and operations team, he designed algorithms for user access profiling.
Zahid Hossain
EPM & Data Analytics Delivery Lead
A fleeting Industry expert with over a decade in Business Intelligence and Analytics spent primarily in Tableau BI applications, Microsoft Power BI, OAC, PBCS, Data management, OBIEE and Essbase mostly in the big four consulting firms. An MBA and IT graduate who combines business goals with technological prowess. Dispenses his passion for knowledge & learning through teaching Business Intelligence & Data methodologies to ardent aspirants.
Iraj Hedayati
Data Engineering Lead
Iraj Hedayati is a seasoned Data Engineer with over a decade of experience designing and scaling data infrastructure at high-growth tech companies. He currently works as a consultant with Apple, specializing in distributed systems, Spark, and backend development. Iraj teaches Data Engineering courses focused on real-world applications in big data processing, cloud infrastructure, and modern data pipelines. His industry background includes leading large-scale data migrations, optimizing cloud costs, and building end-to-end systems for data ingestion and analytics.
Michel Chamoun
Data Science & Business Analyst
Michel is a highly skilled developer and consultant with expertise in AI, data analysis, and process optimization. As a developer in the GenAI team, he built proof-of-concepts leveraging chatGPT's natural language understanding capabilities and implemented AI modules on Microsoft Azure. As a consultant in the strategy and operations team, he designed algorithms for user access profiling.
Zahid Hossain
EPM & Data Analytics Delivery Lead
A fleeting Industry expert with over a decade in Business Intelligence and Analytics spent primarily in Tableau BI applications, Microsoft Power BI, OAC, PBCS, Data management, OBIEE and Essbase mostly in the big four consulting firms. An MBA and IT graduate who combines business goals with technological prowess. Dispenses his passion for knowledge & learning through teaching Business Intelligence & Data methodologies to ardent aspirants.
Critères d'admissibilité
Critères d'admissibilité
Learners need to possess an undergraduate degree or a high school diploma. No need of any professional experience is required as this is the fundamental course.
Possess an undergraduate degree or a high school diploma.
Prérequis
There are no prerequisites for this course. Knowledge of programming language and idea about the networking concepts could be an advantage while taking the course.
Prochaines sessions et horaire
Prochaines sessions et horaire
Contactez-nous
Contactez-nous
Contactez-nous
Contactez-nous
Questions Fréquemment Posées
Questions Fréquemment Posées
FAQs
FAQs
What is SQL?
Who uses SQL?
Does MCIT provide study materials to prepare for Certification?
When do I get the MCIT Certificate?
Y a-t-il des prérequis pour s'inscrire à ces programmes ?
Who uses SQL?
Ces programmes conviennent-ils aux débutants ?
Does MCIT provide study materials to prepare for Certification?
Comment le contenu du programme est-il structuré ?
When do I get the MCIT Certificate?
Quels sont les critères d'admission pour ce programme ?
Quels parcours professionnels puis-je envisager après avoir terminé ces programmes ?
Quelles méthodes d'enseignement sont utilisées dans vos programmes ?
Y a-t-il des occasions d'acquérir une expérience pratique ou des stages ?
Puis-je étudier à temps partiel ou en ligne ?
Que comprend le programme de test de logiciels ?
What is SQL?

Collège de technologie de l'information de Montréal
Collège des technologies de l’information de Montréal
200-1255 Robert-Bourassa Blvd.
Montreal, Quebec H3B 3B2
+1 514 312 2383


Montreal College of Information Technology
Collège des technologies de l’information de Montréal
200-1255 Robert-Bourassa Blvd.
Montreal, Quebec H3B 3B2
+1 514 405 6874


Montreal College of Information Technology
Collège des technologies de l’information de Montréal
200-1255 Robert-Bourassa Blvd.
Montreal, Quebec H3B 3B2
+1 514 405 6874