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
Talk to an Advisor
Talk to an Advisor
Duration
5 weeks
Duration
5 weeks
Duration
5 weeks
Learning Methodologies
Self paced - Mentor guided
Online - Instructor Led
Learning Methodologies
Self paced - Mentor guided
Online - Instructor Led
Learning Methodology
Self paced - Mentor guided
Online - Instructor Led
Program Overview
Program Overview
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.
Key Benefits
Key Benefits
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
Skills gained
Skills gained
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
Instructor Spotlight
Instructor Spotlight
Connect with our instructors at an event . Build your intelligent network .
Connect with our instructors at an event . Build your intelligent network .
Iraj Hedayati
Data Engineering Lead
15 +Years
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.
Davood Fekret
Warehouse and Inventory Manager
10 + Years
Davood Fekret is an experienced supply chain and operations management professional with a strong background in inventory control, logistics, and ERP systems implementation. With over 20 years of experience in the automotive manufacturing and distribution industry, he excels at streamlining processes, improving warehouse efficiency, and leading cross-functional teams. Davood is highly skilled in Lean Manufacturing, Warehouse Management, and end-to-end process implementation. He is passionate about data-driven decision-making and continuous improvement.
Mojtaba Faramarzi
Applied Research Scientist
10 + Years
Mojtaba holds a Ph.D. in Machine Learning from the University of Montreal–Mila, along with two master’s degrees in Software Engineering from Concordia University and Machine Learning from the University of Montreal. He brings extensive experience in both academia and industry, having taught a range of computer science and software engineering courses with a focus on practical AI applications. He has also worked in leading tech companies, including Amazon, Microsoft, SAP, and Ericsson. Passionate about student engagement and interdisciplinary learning, he is committed to fostering critical thinking and innovation in the classroom.
Ali Alavi
Network Administrator
10 + Years
Ali Alavi is a seasoned Network Engineer with over a decade of experience in designing, implementing, and managing secure and scalable network infrastructures. Known for his deep technical expertise and calm, solutions-oriented approach, Ali has successfully led complex network deployments and transformations across various industries.
Sami Islam
Senior Cloud Technical Architect
5 + Years
Sami Islam has 10+ years of experience in the IT and Consulting Industry, specializing in comprehensive Cloud solutions. With expertise in Agile Methodology, he has led numerous Cloud Transformation projects, including migration, CI/CD Pipeline automation, and Data Warehousing solutions. Sami holds multiple certifications, including Google Cloud Professional Cloud Architect, AWS Solutions Architect Associate, and Azure Certifications.
Ahmad Mousavi
Cloud Architect
15 + Years
After a successful stint with Quebec's top game developer, Ubisoft as a virtualisation architect, Ahmad stepped aside to pursue his passion for teaching & developing IT infrastructure for medium sized enterprises, ground up. A product of Iranian university. He is the head of IT infrastructure & facility at Montreal College of Information Technology. A key resource in career pathway & mentorship for aspiring virtualisation experts.
Mirna Mardini
Software Engineer
15 + Years
Mirna Mardini, based in Montreal, Canada, is an accomplished developer and instructor with a diverse background spanning various roles and industries. Currently working at Tema Solutions as an ERP Developer/ Divalto, she excels in developing new features, installing functionality, and providing technical support.
Ehsan Shirazi
Cybersecurity Coordinator
10 + Years
Ehsan, with over 10 years of experience in IT and as a graduate of McGill University, delivers courses and supports the professional growth of students at MCIT. He is passionate about sharing his knowledge and expertise to help students develop the skills needed for successful careers in IT.
Sridharan Kilvidi
Senior Tester
2 Years
Sridaran is a Software Test Consultant and Trainer with 8 years of teaching experience in private colleges in Montreal and Toronto. With over 15 years of professional experience in Programming and QA, Sridaran has successfully managed Software Quality Assurance efforts for enterprise applications in finance, telecommunications, and service business domains. Passionate about sharing expertise and guiding aspiring professionals in the field of software testing.
Rebecca Spagnolo
Sr. SAP Functional Analyst and Trainer
20 + Years
With a background in Business Administration from John Molson's School and a information systems management at Concordia University has had a silver streak through some of the industry's best, including Radio Canada, Dotmar & Motovan Corporation, Rebecca's grip on the field is indomitable. Associated with MCIT for over 10 years, Her insights into career patterns and day to day on the job activities lend mentor guidance to aspiring SAP professionals.
Iraj Hedayati
Data Engineering Lead
15 +Years
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.
Davood Fekret
Warehouse and Inventory Manager
10 + Years
Davood Fekret is an experienced supply chain and operations management professional with a strong background in inventory control, logistics, and ERP systems implementation. With over 20 years of experience in the automotive manufacturing and distribution industry, he excels at streamlining processes, improving warehouse efficiency, and leading cross-functional teams. Davood is highly skilled in Lean Manufacturing, Warehouse Management, and end-to-end process implementation. He is passionate about data-driven decision-making and continuous improvement.
Mojtaba Faramarzi
Applied Research Scientist
10 + Years
Mojtaba holds a Ph.D. in Machine Learning from the University of Montreal–Mila, along with two master’s degrees in Software Engineering from Concordia University and Machine Learning from the University of Montreal. He brings extensive experience in both academia and industry, having taught a range of computer science and software engineering courses with a focus on practical AI applications. He has also worked in leading tech companies, including Amazon, Microsoft, SAP, and Ericsson. Passionate about student engagement and interdisciplinary learning, he is committed to fostering critical thinking and innovation in the classroom.
Ali Alavi
Network Administrator
10 + Years
Ali Alavi is a seasoned Network Engineer with over a decade of experience in designing, implementing, and managing secure and scalable network infrastructures. Known for his deep technical expertise and calm, solutions-oriented approach, Ali has successfully led complex network deployments and transformations across various industries.
Sami Islam
Senior Cloud Technical Architect
5 + Years
Sami Islam has 10+ years of experience in the IT and Consulting Industry, specializing in comprehensive Cloud solutions. With expertise in Agile Methodology, he has led numerous Cloud Transformation projects, including migration, CI/CD Pipeline automation, and Data Warehousing solutions. Sami holds multiple certifications, including Google Cloud Professional Cloud Architect, AWS Solutions Architect Associate, and Azure Certifications.
Ahmad Mousavi
Cloud Architect
15 + Years
After a successful stint with Quebec's top game developer, Ubisoft as a virtualisation architect, Ahmad stepped aside to pursue his passion for teaching & developing IT infrastructure for medium sized enterprises, ground up. A product of Iranian university. He is the head of IT infrastructure & facility at Montreal College of Information Technology. A key resource in career pathway & mentorship for aspiring virtualisation experts.
Mirna Mardini
Software Engineer
15 + Years
Mirna Mardini, based in Montreal, Canada, is an accomplished developer and instructor with a diverse background spanning various roles and industries. Currently working at Tema Solutions as an ERP Developer/ Divalto, she excels in developing new features, installing functionality, and providing technical support.
Ehsan Shirazi
Cybersecurity Coordinator
10 + Years
Ehsan, with over 10 years of experience in IT and as a graduate of McGill University, delivers courses and supports the professional growth of students at MCIT. He is passionate about sharing his knowledge and expertise to help students develop the skills needed for successful careers in IT.
Sridharan Kilvidi
Senior Tester
2 Years
Sridaran is a Software Test Consultant and Trainer with 8 years of teaching experience in private colleges in Montreal and Toronto. With over 15 years of professional experience in Programming and QA, Sridaran has successfully managed Software Quality Assurance efforts for enterprise applications in finance, telecommunications, and service business domains. Passionate about sharing expertise and guiding aspiring professionals in the field of software testing.
Rebecca Spagnolo
Sr. SAP Functional Analyst and Trainer
20 + Years
With a background in Business Administration from John Molson's School and a information systems management at Concordia University has had a silver streak through some of the industry's best, including Radio Canada, Dotmar & Motovan Corporation, Rebecca's grip on the field is indomitable. Associated with MCIT for over 10 years, Her insights into career patterns and day to day on the job activities lend mentor guidance to aspiring SAP professionals.
Iraj Hedayati
Data Engineering Lead
15 +Years
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.
Davood Fekret
Warehouse and Inventory Manager
10 + Years
Davood Fekret is an experienced supply chain and operations management professional with a strong background in inventory control, logistics, and ERP systems implementation. With over 20 years of experience in the automotive manufacturing and distribution industry, he excels at streamlining processes, improving warehouse efficiency, and leading cross-functional teams. Davood is highly skilled in Lean Manufacturing, Warehouse Management, and end-to-end process implementation. He is passionate about data-driven decision-making and continuous improvement.
Mojtaba Faramarzi
Applied Research Scientist
10 + Years
Mojtaba holds a Ph.D. in Machine Learning from the University of Montreal–Mila, along with two master’s degrees in Software Engineering from Concordia University and Machine Learning from the University of Montreal. He brings extensive experience in both academia and industry, having taught a range of computer science and software engineering courses with a focus on practical AI applications. He has also worked in leading tech companies, including Amazon, Microsoft, SAP, and Ericsson. Passionate about student engagement and interdisciplinary learning, he is committed to fostering critical thinking and innovation in the classroom.
Ali Alavi
Network Administrator
10 + Years
Ali Alavi is a seasoned Network Engineer with over a decade of experience in designing, implementing, and managing secure and scalable network infrastructures. Known for his deep technical expertise and calm, solutions-oriented approach, Ali has successfully led complex network deployments and transformations across various industries.
Sami Islam
Senior Cloud Technical Architect
5 + Years
Sami Islam has 10+ years of experience in the IT and Consulting Industry, specializing in comprehensive Cloud solutions. With expertise in Agile Methodology, he has led numerous Cloud Transformation projects, including migration, CI/CD Pipeline automation, and Data Warehousing solutions. Sami holds multiple certifications, including Google Cloud Professional Cloud Architect, AWS Solutions Architect Associate, and Azure Certifications.
Ahmad Mousavi
Cloud Architect
15 + Years
After a successful stint with Quebec's top game developer, Ubisoft as a virtualisation architect, Ahmad stepped aside to pursue his passion for teaching & developing IT infrastructure for medium sized enterprises, ground up. A product of Iranian university. He is the head of IT infrastructure & facility at Montreal College of Information Technology. A key resource in career pathway & mentorship for aspiring virtualisation experts.
Mirna Mardini
Software Engineer
15 + Years
Mirna Mardini, based in Montreal, Canada, is an accomplished developer and instructor with a diverse background spanning various roles and industries. Currently working at Tema Solutions as an ERP Developer/ Divalto, she excels in developing new features, installing functionality, and providing technical support.
Ehsan Shirazi
Cybersecurity Coordinator
10 + Years
Ehsan, with over 10 years of experience in IT and as a graduate of McGill University, delivers courses and supports the professional growth of students at MCIT. He is passionate about sharing his knowledge and expertise to help students develop the skills needed for successful careers in IT.
Sridharan Kilvidi
Senior Tester
2 Years
Sridaran is a Software Test Consultant and Trainer with 8 years of teaching experience in private colleges in Montreal and Toronto. With over 15 years of professional experience in Programming and QA, Sridaran has successfully managed Software Quality Assurance efforts for enterprise applications in finance, telecommunications, and service business domains. Passionate about sharing expertise and guiding aspiring professionals in the field of software testing.
Rebecca Spagnolo
Sr. SAP Functional Analyst and Trainer
20 + Years
With a background in Business Administration from John Molson's School and a information systems management at Concordia University has had a silver streak through some of the industry's best, including Radio Canada, Dotmar & Motovan Corporation, Rebecca's grip on the field is indomitable. Associated with MCIT for over 10 years, Her insights into career patterns and day to day on the job activities lend mentor guidance to aspiring SAP professionals.
Iraj Hedayati
Data Engineering Lead
15 +Years
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.
Davood Fekret
Warehouse and Inventory Manager
10 + Years
Davood Fekret is an experienced supply chain and operations management professional with a strong background in inventory control, logistics, and ERP systems implementation. With over 20 years of experience in the automotive manufacturing and distribution industry, he excels at streamlining processes, improving warehouse efficiency, and leading cross-functional teams. Davood is highly skilled in Lean Manufacturing, Warehouse Management, and end-to-end process implementation. He is passionate about data-driven decision-making and continuous improvement.
Mojtaba Faramarzi
Applied Research Scientist
10 + Years
Mojtaba holds a Ph.D. in Machine Learning from the University of Montreal–Mila, along with two master’s degrees in Software Engineering from Concordia University and Machine Learning from the University of Montreal. He brings extensive experience in both academia and industry, having taught a range of computer science and software engineering courses with a focus on practical AI applications. He has also worked in leading tech companies, including Amazon, Microsoft, SAP, and Ericsson. Passionate about student engagement and interdisciplinary learning, he is committed to fostering critical thinking and innovation in the classroom.
Ali Alavi
Network Administrator
10 + Years
Ali Alavi is a seasoned Network Engineer with over a decade of experience in designing, implementing, and managing secure and scalable network infrastructures. Known for his deep technical expertise and calm, solutions-oriented approach, Ali has successfully led complex network deployments and transformations across various industries.
Sami Islam
Senior Cloud Technical Architect
5 + Years
Sami Islam has 10+ years of experience in the IT and Consulting Industry, specializing in comprehensive Cloud solutions. With expertise in Agile Methodology, he has led numerous Cloud Transformation projects, including migration, CI/CD Pipeline automation, and Data Warehousing solutions. Sami holds multiple certifications, including Google Cloud Professional Cloud Architect, AWS Solutions Architect Associate, and Azure Certifications.
Ahmad Mousavi
Cloud Architect
15 + Years
After a successful stint with Quebec's top game developer, Ubisoft as a virtualisation architect, Ahmad stepped aside to pursue his passion for teaching & developing IT infrastructure for medium sized enterprises, ground up. A product of Iranian university. He is the head of IT infrastructure & facility at Montreal College of Information Technology. A key resource in career pathway & mentorship for aspiring virtualisation experts.
Mirna Mardini
Software Engineer
15 + Years
Mirna Mardini, based in Montreal, Canada, is an accomplished developer and instructor with a diverse background spanning various roles and industries. Currently working at Tema Solutions as an ERP Developer/ Divalto, she excels in developing new features, installing functionality, and providing technical support.
Ehsan Shirazi
Cybersecurity Coordinator
10 + Years
Ehsan, with over 10 years of experience in IT and as a graduate of McGill University, delivers courses and supports the professional growth of students at MCIT. He is passionate about sharing his knowledge and expertise to help students develop the skills needed for successful careers in IT.
Sridharan Kilvidi
Senior Tester
2 Years
Sridaran is a Software Test Consultant and Trainer with 8 years of teaching experience in private colleges in Montreal and Toronto. With over 15 years of professional experience in Programming and QA, Sridaran has successfully managed Software Quality Assurance efforts for enterprise applications in finance, telecommunications, and service business domains. Passionate about sharing expertise and guiding aspiring professionals in the field of software testing.
Rebecca Spagnolo
Sr. SAP Functional Analyst and Trainer
20 + Years
With a background in Business Administration from John Molson's School and a information systems management at Concordia University has had a silver streak through some of the industry's best, including Radio Canada, Dotmar & Motovan Corporation, Rebecca's grip on the field is indomitable. Associated with MCIT for over 10 years, Her insights into career patterns and day to day on the job activities lend mentor guidance to aspiring SAP professionals.
Iraj Hedayati
Data Engineering Lead
15 +Years
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.
Davood Fekret
Warehouse and Inventory Manager
10 + Years
Davood Fekret is an experienced supply chain and operations management professional with a strong background in inventory control, logistics, and ERP systems implementation. With over 20 years of experience in the automotive manufacturing and distribution industry, he excels at streamlining processes, improving warehouse efficiency, and leading cross-functional teams. Davood is highly skilled in Lean Manufacturing, Warehouse Management, and end-to-end process implementation. He is passionate about data-driven decision-making and continuous improvement.
Mojtaba Faramarzi
Applied Research Scientist
10 + Years
Mojtaba holds a Ph.D. in Machine Learning from the University of Montreal–Mila, along with two master’s degrees in Software Engineering from Concordia University and Machine Learning from the University of Montreal. He brings extensive experience in both academia and industry, having taught a range of computer science and software engineering courses with a focus on practical AI applications. He has also worked in leading tech companies, including Amazon, Microsoft, SAP, and Ericsson. Passionate about student engagement and interdisciplinary learning, he is committed to fostering critical thinking and innovation in the classroom.
Ali Alavi
Network Administrator
10 + Years
Ali Alavi is a seasoned Network Engineer with over a decade of experience in designing, implementing, and managing secure and scalable network infrastructures. Known for his deep technical expertise and calm, solutions-oriented approach, Ali has successfully led complex network deployments and transformations across various industries.
Sami Islam
Senior Cloud Technical Architect
5 + Years
Sami Islam has 10+ years of experience in the IT and Consulting Industry, specializing in comprehensive Cloud solutions. With expertise in Agile Methodology, he has led numerous Cloud Transformation projects, including migration, CI/CD Pipeline automation, and Data Warehousing solutions. Sami holds multiple certifications, including Google Cloud Professional Cloud Architect, AWS Solutions Architect Associate, and Azure Certifications.
Ahmad Mousavi
Cloud Architect
15 + Years
After a successful stint with Quebec's top game developer, Ubisoft as a virtualisation architect, Ahmad stepped aside to pursue his passion for teaching & developing IT infrastructure for medium sized enterprises, ground up. A product of Iranian university. He is the head of IT infrastructure & facility at Montreal College of Information Technology. A key resource in career pathway & mentorship for aspiring virtualisation experts.
Mirna Mardini
Software Engineer
15 + Years
Mirna Mardini, based in Montreal, Canada, is an accomplished developer and instructor with a diverse background spanning various roles and industries. Currently working at Tema Solutions as an ERP Developer/ Divalto, she excels in developing new features, installing functionality, and providing technical support.
Ehsan Shirazi
Cybersecurity Coordinator
10 + Years
Ehsan, with over 10 years of experience in IT and as a graduate of McGill University, delivers courses and supports the professional growth of students at MCIT. He is passionate about sharing his knowledge and expertise to help students develop the skills needed for successful careers in IT.
Sridharan Kilvidi
Senior Tester
2 Years
Sridaran is a Software Test Consultant and Trainer with 8 years of teaching experience in private colleges in Montreal and Toronto. With over 15 years of professional experience in Programming and QA, Sridaran has successfully managed Software Quality Assurance efforts for enterprise applications in finance, telecommunications, and service business domains. Passionate about sharing expertise and guiding aspiring professionals in the field of software testing.
Rebecca Spagnolo
Sr. SAP Functional Analyst and Trainer
20 + Years
With a background in Business Administration from John Molson's School and a information systems management at Concordia University has had a silver streak through some of the industry's best, including Radio Canada, Dotmar & Motovan Corporation, Rebecca's grip on the field is indomitable. Associated with MCIT for over 10 years, Her insights into career patterns and day to day on the job activities lend mentor guidance to aspiring SAP professionals.
Toufiq Lazhri
EPM & Data Analytics Delivery Lead
15 + Years
Sr, Software Consultant with over 25 years of solid programming experiecc , who began hais career with IBM and went on to lead projects in over a dozen torp tire companies. Responsible for founding the Program Analyst program at Montreal COllege is an effective teacher who transmits knowledge to enable student outcomes.
Michel Chamoun
Data Science & Business Analyst
5 Years
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.
Iraj Hedayati
Data Engineering Lead
15 +Years
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.
Davood Fekret
Warehouse and Inventory Manager
10 + Years
Davood Fekret is an experienced supply chain and operations management professional with a strong background in inventory control, logistics, and ERP systems implementation. With over 20 years of experience in the automotive manufacturing and distribution industry, he excels at streamlining processes, improving warehouse efficiency, and leading cross-functional teams. Davood is highly skilled in Lean Manufacturing, Warehouse Management, and end-to-end process implementation. He is passionate about data-driven decision-making and continuous improvement.
Mojtaba Faramarzi
Applied Research Scientist
10 + Years
Mojtaba holds a Ph.D. in Machine Learning from the University of Montreal–Mila, along with two master’s degrees in Software Engineering from Concordia University and Machine Learning from the University of Montreal. He brings extensive experience in both academia and industry, having taught a range of computer science and software engineering courses with a focus on practical AI applications. He has also worked in leading tech companies, including Amazon, Microsoft, SAP, and Ericsson. Passionate about student engagement and interdisciplinary learning, he is committed to fostering critical thinking and innovation in the classroom.
Ali Alavi
Network Administrator
10 + Years
Ali Alavi is a seasoned Network Engineer with over a decade of experience in designing, implementing, and managing secure and scalable network infrastructures. Known for his deep technical expertise and calm, solutions-oriented approach, Ali has successfully led complex network deployments and transformations across various industries.
Sami Islam
Senior Cloud Technical Architect
5 + Years
Sami Islam has 10+ years of experience in the IT and Consulting Industry, specializing in comprehensive Cloud solutions. With expertise in Agile Methodology, he has led numerous Cloud Transformation projects, including migration, CI/CD Pipeline automation, and Data Warehousing solutions. Sami holds multiple certifications, including Google Cloud Professional Cloud Architect, AWS Solutions Architect Associate, and Azure Certifications.
Ahmad Mousavi
Cloud Architect
15 + Years
After a successful stint with Quebec's top game developer, Ubisoft as a virtualisation architect, Ahmad stepped aside to pursue his passion for teaching & developing IT infrastructure for medium sized enterprises, ground up. A product of Iranian university. He is the head of IT infrastructure & facility at Montreal College of Information Technology. A key resource in career pathway & mentorship for aspiring virtualisation experts.
Mirna Mardini
Software Engineer
15 + Years
Mirna Mardini, based in Montreal, Canada, is an accomplished developer and instructor with a diverse background spanning various roles and industries. Currently working at Tema Solutions as an ERP Developer/ Divalto, she excels in developing new features, installing functionality, and providing technical support.
Ehsan Shirazi
Cybersecurity Coordinator
10 + Years
Ehsan, with over 10 years of experience in IT and as a graduate of McGill University, delivers courses and supports the professional growth of students at MCIT. He is passionate about sharing his knowledge and expertise to help students develop the skills needed for successful careers in IT.
Sridharan Kilvidi
Senior Tester
2 Years
Sridaran is a Software Test Consultant and Trainer with 8 years of teaching experience in private colleges in Montreal and Toronto. With over 15 years of professional experience in Programming and QA, Sridaran has successfully managed Software Quality Assurance efforts for enterprise applications in finance, telecommunications, and service business domains. Passionate about sharing expertise and guiding aspiring professionals in the field of software testing.
Rebecca Spagnolo
Sr. SAP Functional Analyst and Trainer
20 + Years
With a background in Business Administration from John Molson's School and a information systems management at Concordia University has had a silver streak through some of the industry's best, including Radio Canada, Dotmar & Motovan Corporation, Rebecca's grip on the field is indomitable. Associated with MCIT for over 10 years, Her insights into career patterns and day to day on the job activities lend mentor guidance to aspiring SAP professionals.
Toufiq Lazhri
EPM & Data Analytics Delivery Lead
15 + Years
Sr, Software Consultant with over 25 years of solid programming experiecc , who began hais career with IBM and went on to lead projects in over a dozen torp tire companies. Responsible for founding the Program Analyst program at Montreal COllege is an effective teacher who transmits knowledge to enable student outcomes.
Michel Chamoun
Data Science & Business Analyst
5 Years
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.
Iraj Hedayati
Data Engineering Lead
15 +Years
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.
Davood Fekret
Warehouse and Inventory Manager
10 + Years
Davood Fekret is an experienced supply chain and operations management professional with a strong background in inventory control, logistics, and ERP systems implementation. With over 20 years of experience in the automotive manufacturing and distribution industry, he excels at streamlining processes, improving warehouse efficiency, and leading cross-functional teams. Davood is highly skilled in Lean Manufacturing, Warehouse Management, and end-to-end process implementation. He is passionate about data-driven decision-making and continuous improvement.
Mojtaba Faramarzi
Applied Research Scientist
10 + Years
Mojtaba holds a Ph.D. in Machine Learning from the University of Montreal–Mila, along with two master’s degrees in Software Engineering from Concordia University and Machine Learning from the University of Montreal. He brings extensive experience in both academia and industry, having taught a range of computer science and software engineering courses with a focus on practical AI applications. He has also worked in leading tech companies, including Amazon, Microsoft, SAP, and Ericsson. Passionate about student engagement and interdisciplinary learning, he is committed to fostering critical thinking and innovation in the classroom.
Ali Alavi
Network Administrator
10 + Years
Ali Alavi is a seasoned Network Engineer with over a decade of experience in designing, implementing, and managing secure and scalable network infrastructures. Known for his deep technical expertise and calm, solutions-oriented approach, Ali has successfully led complex network deployments and transformations across various industries.
Sami Islam
Senior Cloud Technical Architect
5 + Years
Sami Islam has 10+ years of experience in the IT and Consulting Industry, specializing in comprehensive Cloud solutions. With expertise in Agile Methodology, he has led numerous Cloud Transformation projects, including migration, CI/CD Pipeline automation, and Data Warehousing solutions. Sami holds multiple certifications, including Google Cloud Professional Cloud Architect, AWS Solutions Architect Associate, and Azure Certifications.
Ahmad Mousavi
Cloud Architect
15 + Years
After a successful stint with Quebec's top game developer, Ubisoft as a virtualisation architect, Ahmad stepped aside to pursue his passion for teaching & developing IT infrastructure for medium sized enterprises, ground up. A product of Iranian university. He is the head of IT infrastructure & facility at Montreal College of Information Technology. A key resource in career pathway & mentorship for aspiring virtualisation experts.
Mirna Mardini
Software Engineer
15 + Years
Mirna Mardini, based in Montreal, Canada, is an accomplished developer and instructor with a diverse background spanning various roles and industries. Currently working at Tema Solutions as an ERP Developer/ Divalto, she excels in developing new features, installing functionality, and providing technical support.
Ehsan Shirazi
Cybersecurity Coordinator
10 + Years
Ehsan, with over 10 years of experience in IT and as a graduate of McGill University, delivers courses and supports the professional growth of students at MCIT. He is passionate about sharing his knowledge and expertise to help students develop the skills needed for successful careers in IT.
Sridharan Kilvidi
Senior Tester
2 Years
Sridaran is a Software Test Consultant and Trainer with 8 years of teaching experience in private colleges in Montreal and Toronto. With over 15 years of professional experience in Programming and QA, Sridaran has successfully managed Software Quality Assurance efforts for enterprise applications in finance, telecommunications, and service business domains. Passionate about sharing expertise and guiding aspiring professionals in the field of software testing.
Rebecca Spagnolo
Sr. SAP Functional Analyst and Trainer
20 + Years
With a background in Business Administration from John Molson's School and a information systems management at Concordia University has had a silver streak through some of the industry's best, including Radio Canada, Dotmar & Motovan Corporation, Rebecca's grip on the field is indomitable. Associated with MCIT for over 10 years, Her insights into career patterns and day to day on the job activities lend mentor guidance to aspiring SAP professionals.
Toufiq Lazhri
EPM & Data Analytics Delivery Lead
15 + Years
Sr, Software Consultant with over 25 years of solid programming experiecc , who began hais career with IBM and went on to lead projects in over a dozen torp tire companies. Responsible for founding the Program Analyst program at Montreal COllege is an effective teacher who transmits knowledge to enable student outcomes.
Michel Chamoun
Data Science & Business Analyst
5 Years
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.
Iraj Hedayati
Data Engineering Lead
15 +Years
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.
Davood Fekret
Warehouse and Inventory Manager
10 + Years
Davood Fekret is an experienced supply chain and operations management professional with a strong background in inventory control, logistics, and ERP systems implementation. With over 20 years of experience in the automotive manufacturing and distribution industry, he excels at streamlining processes, improving warehouse efficiency, and leading cross-functional teams. Davood is highly skilled in Lean Manufacturing, Warehouse Management, and end-to-end process implementation. He is passionate about data-driven decision-making and continuous improvement.
Mojtaba Faramarzi
Applied Research Scientist
10 + Years
Mojtaba holds a Ph.D. in Machine Learning from the University of Montreal–Mila, along with two master’s degrees in Software Engineering from Concordia University and Machine Learning from the University of Montreal. He brings extensive experience in both academia and industry, having taught a range of computer science and software engineering courses with a focus on practical AI applications. He has also worked in leading tech companies, including Amazon, Microsoft, SAP, and Ericsson. Passionate about student engagement and interdisciplinary learning, he is committed to fostering critical thinking and innovation in the classroom.
Ali Alavi
Network Administrator
10 + Years
Ali Alavi is a seasoned Network Engineer with over a decade of experience in designing, implementing, and managing secure and scalable network infrastructures. Known for his deep technical expertise and calm, solutions-oriented approach, Ali has successfully led complex network deployments and transformations across various industries.
Sami Islam
Senior Cloud Technical Architect
5 + Years
Sami Islam has 10+ years of experience in the IT and Consulting Industry, specializing in comprehensive Cloud solutions. With expertise in Agile Methodology, he has led numerous Cloud Transformation projects, including migration, CI/CD Pipeline automation, and Data Warehousing solutions. Sami holds multiple certifications, including Google Cloud Professional Cloud Architect, AWS Solutions Architect Associate, and Azure Certifications.
Ahmad Mousavi
Cloud Architect
15 + Years
After a successful stint with Quebec's top game developer, Ubisoft as a virtualisation architect, Ahmad stepped aside to pursue his passion for teaching & developing IT infrastructure for medium sized enterprises, ground up. A product of Iranian university. He is the head of IT infrastructure & facility at Montreal College of Information Technology. A key resource in career pathway & mentorship for aspiring virtualisation experts.
Mirna Mardini
Software Engineer
15 + Years
Mirna Mardini, based in Montreal, Canada, is an accomplished developer and instructor with a diverse background spanning various roles and industries. Currently working at Tema Solutions as an ERP Developer/ Divalto, she excels in developing new features, installing functionality, and providing technical support.
Ehsan Shirazi
Cybersecurity Coordinator
10 + Years
Ehsan, with over 10 years of experience in IT and as a graduate of McGill University, delivers courses and supports the professional growth of students at MCIT. He is passionate about sharing his knowledge and expertise to help students develop the skills needed for successful careers in IT.
Sridharan Kilvidi
Senior Tester
2 Years
Sridaran is a Software Test Consultant and Trainer with 8 years of teaching experience in private colleges in Montreal and Toronto. With over 15 years of professional experience in Programming and QA, Sridaran has successfully managed Software Quality Assurance efforts for enterprise applications in finance, telecommunications, and service business domains. Passionate about sharing expertise and guiding aspiring professionals in the field of software testing.
Rebecca Spagnolo
Sr. SAP Functional Analyst and Trainer
20 + Years
With a background in Business Administration from John Molson's School and a information systems management at Concordia University has had a silver streak through some of the industry's best, including Radio Canada, Dotmar & Motovan Corporation, Rebecca's grip on the field is indomitable. Associated with MCIT for over 10 years, Her insights into career patterns and day to day on the job activities lend mentor guidance to aspiring SAP professionals.
Toufiq Lazhri
EPM & Data Analytics Delivery Lead
15 + Years
Sr, Software Consultant with over 25 years of solid programming experiecc , who began hais career with IBM and went on to lead projects in over a dozen torp tire companies. Responsible for founding the Program Analyst program at Montreal COllege is an effective teacher who transmits knowledge to enable student outcomes.
Michel Chamoun
Data Science & Business Analyst
5 Years
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.
Eligibility Criteria
Eligibility Criteria
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.
Prerequisites
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.
Upcoming sessions & Schedule
Upcoming sessions
& Schedule
Summer
Apply Early
No date
Register Before
Summer
Apply Early
No date
Register Before
Fall
Apply Early
Oct 27, 2025
Register Before
Sep 29, 2025
Fall
Apply Early
Oct 27, 2025
Register Before
Sep 29, 2025
Winter
Apply Early
Feb 27, 2026
Register Before
Jan 30, 2026
Winter
Apply Early
Feb 27, 2026
Register Before
Jan 30, 2026
Take action
Take action
Get Certified
Get Certified
Related programs
Related programs
FAQs
FAQs
What is SQL?
What does a SQL developer do?
What are the benefits of enrolling in a SQL certification?
What skills or experience do I need before joining a SQL certification training?
Who are the instructors for this SQL certification, and how were they selected?
What will be the career path after completing the SQL Certification?
What are the most common forms of SQL, and how do they differ?
Can I learn SQL without a technical background?
What if I miss a live class?
Are there any prerequisites for enrolling in these programs?
What does a SQL developer do?
Are these programs suitable for beginners?
What are the benefits of enrolling in a SQL certification?
How is the program content structured?
What skills or experience do I need before joining a SQL certification training?
What is the admission Criteria for this Program?
Who are the instructors for this SQL certification, and how were they selected?
What career paths can I pursue after completing these programs?
What will be the career path after completing the SQL Certification?
What teaching methods are used in your programs?
What are the most common forms of SQL, and how do they differ?
Are there opportunities for practical experience or internships?
Can I learn SQL without a technical background?
Can I study part-time or online?
What if I miss a live class?
What does the software testing program entail?
What is SQL?
Montreal College of Information Technology
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