*IMPORTANT MESSAGE*
SET YOUR CALENDARS!
ONLINE REGISTRATION for Winter 2021 Part-Time Specialized IT courses IS ONGOING!
Courses are all on a first come, first serve basis and fill up quickly! So be sure not to miss out!!!
Note : All courses are offered online
Courses
NETWORK & SECURITY
*Schedule subject to change
- Linux – Operating System Details >
- Summarize the history and nature of Linux
- Explain correctly the purpose of an operating system.
- Outline correctly the basic structure of an operating system.
- Outline briefly and concisely the history of Linux.
- Compare correctly Linux to other operating systems.
- Utilize a Linux shell
- Explain correctly the kernel-shell relationship.
- Enter Linux commands and their parameters successfully and appropriately at the shell prompt.
- Interpret the output from Linux commands correctly.
- Customize the shell environment appropriately.
- Make appropriate use of shell utilities.
- Create and execute shell script files correctly to run operating system commands.Install and configure a Unix/Linux system
- Install correctly a default configuration of Unix system in a PC (Intel architecture).
- Install correctly a Unix system in dual-boot mode (sharing hardware resources with Windows).
- Explain correctly the differences between server, workstation, and custom installation of a Unix system.
- Install correctly a Unix/Linux system in a virtual machine (VMware).
- Install Software Packages in a Unix/Linux system
- Install correctly a Software Package using RPMs.
- Install correctly a Software Package using DEB files.
- Automate installation of packages with yum and with apt-get.
- Update packages already installed in a Unix/Linux system.
- Compile packages directly from the source code.
- Administer a Linux system
- Complete basic administration tasks.
- Create, modify, suspend, and close user accounts correctly.
- Create, modify, and remove groups.
- Create and administer hard disk partitions.
- Administer runlevels and correctly shutdown/reboot a Unix/Linux system.
- Configure the graphical (X Window) system correctly.
- Implement Internet access
- Implement and configure effectively TCP/IP correctly on a Linux system.
- Use networking commands correctly and appropriately on a Linux system.
- Make use of Internet services on a Linux system.
- Secure a Linux system
- Explain clearly the difference between the super-user, users, and groups in Unix/Linux.
- Describe accurately the components of a Linux user account.
- Properly use the user/group rights to secure files and directories.
- Administer globally the permissions of all users.
- Install and Configure a web server
- Explain clearly how to start/stop/query services in a Unix/Linux system.
- Describe accurately the basic components of a web server.
- Install correctly the Apache web server.
- Properly configure the Apache web server.
- Start, stop, and query the Apache web server.
- Configure Virtual Hosts in the Apache web.
- Linux Security Details >
Linux – Operating System
×Course Title | Linux – Operating System |
Course Number | 900-003-EQ-02 |
Platform | Linux |
Duration | 40 hours |
Emploi-Québec fee (taxes incl.) | $80 |
General Public fee (taxes incl.) | $722.50 |
Schedule | Thursday : 6 p.m. – 10 p.m. |
Dates | January 21, 28, February 4, 11, 18, 25, March 4, 11, 18, 25 |
Prerequisites | Background in IT This is a beginner/intermediate level course. |
Target Audience | Individuals who wish to learn how to apply multi-user operating system concepts with an emphasis on Unix. |
Instructor | Oswaldo Moreno |
Location | Online format |
NB: This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours.
Course Description
The main focus will be the application and administration of the Linux file system. Protocols and configurations dealing with security will also be studied and applied.
Topics to be covered in this course
REGISTER NOW
Linux Security
×Course Title | Linux Security |
Course Number | 900 -050-EQ-01 |
Duration
Platform Duration Gouvernement du Quebec fee ( taxes incl.) |
30 hours
Linux 30 hours
$60 |
General public fee (taxes incl.) |
$541.88 |
Schedule | Saturday & Sunday
9 a.m.-5 p.m. ( 30 minute lunch) |
Dates | February 6,7,13,14 |
Prerequisites | Basic knowledge of Linux command line |
Target Audience | IT Professionals with basic knowledge in Linux |
Instructor | Michael Hughes |
Location | Online format |
|
Please note that this is a non-credit course. Certificate provides for all participants who have completed 80% of the course
Course Description | ||
This course will introduce you to Linux security.
It begins with a review of Linux command line and operating system components. First focus is on standard Unix security mechanisms such as users, groups, file and directory permissions. Further topics include ACL (Access Control Lists – similar to MS Windows security permissions) and firewall setup for workstations, servers and routers using firewalld. Apache with SSL, FTP and other network servers, less known powerful security features of SSH, and common mistakes made by Linux administrators that often result in compromised security. This is a practical, hands on course. |
||
Required Text / Course Materials |
None |
Topics Covered in this Course |
Weekly Topics
Please note that the instructor reserves the right to modify this schedule |
|
Week 1
|
Installation of Linux- Basic Commands Basic Linux System Administration |
Week 2
|
Installation, configuration of various services DNS, Apache, Apache-SSL, SSH, Samba, Configuration of Firewalld, Setting up Squid Proxy Server |
REGISTER NOW
Register Now
BIG DATA
*Schedule subject to change
- Management and Processing of Big Data–Level I Details >
- What is Big Data?
- Introduction to Big data and its challenges
- Importance of Big Data and Hadoop in the industry
- Various dimensions of Big Data
- Big Data Use Cases in different domains like telecom, banking, social media, and so on
- Traditional systems vs Big Data tools
- Scope and future of Big Data in industry
- Installation, configuration and setup of Hadoop cluster
- Working with Hadoop in pseudo-distributed mode
- Brief introduction to Hadoop and its ecosystem
- Hadoop cluster Architecture
- Hadoop Administration and troubleshooting
- Running basic HDFS commands
- MapReduce Architecture
- What is YARN?
- YARN components
- YARN Architecture
- Input splits, HDFS blocks
- Distributed Cache
- What is Sqoop? Why do we need it?
- Sqoop Architecture
- Importing and exporting data from RDBMS
- Hands-on Sqoop commands
- Drawbacks of MapReduce
- What is Pig? – Architecture Overview
- Hands-on Pig scripts
- What is Hive? – Architecture Overview
- Hive history and its components
- Hands on Hive – orderBy, clusterBY, distributeBy and so on
- Hive SerDe
- Hive – internal vs external tables
- Different file formats – avro, JSON, parquet, RC, ORC
- Partitioning and Bucketing
- Optimized advanced Joins
- Indexes and Views
- Analytical and window functions in Hive – rank, dense_rank, lag, lead.
- Difference between RDBMS and NOSQL
- HBASE architecture
- HBase – Hands On
- Management and Processing of Big Data – Level 2 Details >
- What is Apache Spark and why it is needed?
- Spark VS Hadoop
- Spark Use Case
- Data types, variables
- Conditional statements and Loops
- Python files I/O Functions
- Numbers, Strings and related operations
- Lists, Tuples, Dictionaries, Sets and related operations
- Hands-On
- Lambda functions
- Object Oriented Concepts
- Standard Libraries and Modules used in Python
- Hands-On
- Spark Architecture and its Components
- Spark features and characteristics
- Introduction to PySpark Shell and how to submit a PySpark Job
- Installation of Apache Spark in windows
- Brief discussion on Spark Web UI
- What are RDDs, features and characteristics.
- RDDs Transformations and Actions
- Key-Value Pair RDDs and operations
- Brief discussion on RDD Lineage
- RDD Partitioning
- Hands-On
- Drawbacks of RDDs
- What are DataFrames and Spark SQL and what is the need of it?
- Spark SQL Architecture and Catalyst optimizers
- A tale of 3 Spark API – RDDs VS DataSets VS DataFrames
- Interoperating with RDDs
- Brief overview of different file formats
- Avro
- Parquet
- JSON
- CSV
- RC and ORC
- Partitioning and Bucketing in DataFrames
- Advanced Analytical Windowing functions
- Performance tuning in Spark
- Spark – Hive integration
- Hands-On
- BIG DATA Reporting and Prediction Details >
- Data processing stages in data mining
- Hardware and software systems for data mining
- Extracting, transforming and loading data
- Principles of data analysis
- Effective reports and dashboards displaying the data insights
- Big Data distributed processing systems: Hadoop, Spark and Google Big Query
- Connecting analytics to Big Data distributed processing systems
- Forecasting and prediction. Introduction to machine learning.
- Uber trip data: trip information including Uber service type, source, destination, distance, duration and paid fare. Example
- On-line store purchasing behavior data: Characterization of on-line purchasing behavior. Example:
- Mobile video trending data: Characterization and trending analysis of video consumption from mobile devices. Example:
- Google Cloud NOAA data: Worldwide meteorological information including temperature, wind and rain for more than 60 years. Example:
- Google Cloud Shakespeare data: word count of all Shakespeare works. Example:
Management and Processing of Big Data–Level I
×Course Title | Management and Processing of Big Data – Level I |
Course Number | 900-058-EQ-02 |
Platform | Linux |
Duration | 48 hours |
Gouvernement du Québec fee (taxes incl.) |
$96 |
General Public fee (taxes incl.) |
$867.00 |
Schedule | Saturdays 9:00 a.m.- 4:00 p.m. (30 minute lunch); Sunday, February 28: 9:30 a.m. – 12:00 p.m. |
Dates | February 6, 13, 20, 27, March 6, 13, 20 & Sunday, February 28: 9:30am-12:00pm |
Prerequisites | Comfortable in Linux environment, some programming experience is required (ideally JAVA ) |
Target Audience | Developers |
Instructor | Deepak Parameshwarappa |
Location | Online Format |
NB: This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
Course Description:
This course provides practical foundation level training that enables participation in big data projects. Participants will be introduced to big data technology and tools, including MapReduce and Hadoop. They will learn how to install and configure the Hadoop in cluster environment, how to write complex MapReduce programs, and how to analyze Big Data using Pig and Hive.
Topics Covered in this Course
Introduction into Hadoop
Components of Hadoop: Basic Concepts and HDFS
Hadoop MapReduce Framework
Apache Sqoop
Apache Pig – Alternative to MapReduce
Pig Use case – Olympic Data analysis using Apache Pig
Apache Hive – Analysis and Data Warehousing tool in Hadoop Ecosystem
Hive Use case – Olympic Data analysis
Apache Hive Advanced – Optimization
Hive Use case – Retail data analysis, Consumer Complaints analysis
Apache HBase – Introduction to NoSQL DataBase
REGISTER NOW
Management and Processing of Big Data – Level 2
×Course Title | Management and Processing of Big Data – Level II |
Course Number | 900-068-EQ-02 |
Platform | Linux |
Duration | 45 hours |
Gouvernement du Québec fee (taxes incl.) | $90 |
General Public fee (taxes incl.) | $812.82 |
Schedule | Saturday: 9 a.m. – 4 p.m.
May 15: 9 a.m. – 3:30 p.m. 30 minute lunch |
Dates |
March 27, April 10 ,17, 24 ,May 1,8,
May 15: 9 a.m. -3:30 p.m. No class on April 3: Easter Saturday |
Prerequisites | Absolute prerequisite: Management and Processing of Big data – Level I |
Target Audience | Developers |
Instructor | Deepak Parameshwarappa |
Location | Online format |
NB: This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
Course Description
A continuation of the course Management and Processing of Big Data –level I, this course provides practical foundation level training that enables participation in big data projects. Participants will be introduced to big data technology and tools, including MapReduce and Hadoop. They will learn how to install and configure the Hadoop in cluster environment, how to write complex MapReduce programs, and how to analyze Big Data using Pig and Hive.
Topics covered in this course
Introduction to PySpark
o How does Spark fits in Hadoop Ecosystem?
Brief Introduction to Python for Apache Spark
Functions, OOPS in Python
Deep Dive into Apache Spark
o Understanding SparkContext, SparkSession, Driver, Stages and Tasks.
Spark RDDs
o Coalesce
o Repartition
o Read and write data using RDDs
o Use cases on map, flatMap, reduceByKey, aggregateBykey, groupByKey, fold, sortByKey
o UBER data analysis
DataFrames and Spark SQL
o Stock Market data analysis
o UBER data analysis
o Aviation data analysis
o How to use complex Joins to make analysis
REGISTER NOW
BIG DATA Reporting and Prediction
×Course Title | BIG DATA – Reporting and Prediction |
Course number | 900-059-EQ-02 |
Platform | MS teams,Tableau Public, Knime & Google Cloud Platform |
45 hours | |
Prerequisites | Basic understanding of databases is preferred. Otherwise, Excel spreadsheet processing experience and an understanding of computer software systems. Basic understanding of data mining. |
Target Audience | Data analysts; Computer Analysts; Individuals in any role dealing with small or large amounts of data needing to analyze it and produce insightful and actionable dashboards. |
Dates | February 2, 4, 9, 11, 16, 18, 23, 25, March 2, 4, 9, 11, 16, 18, 23 |
Instructor | Diego Perea – Ph.D. |
Room | Online format |
Schedule | Tuesday & Thursday : 6:30 p.m. – 9:30 p.m. |
Gouvernement du Québec fee (taxes incl.) | $90.00 |
General public fee (taxes incl.) | $812.82 |
Recommended textbook: Tableau and Google Cloud Platform on-line documentation
NB: This is a non- credit course. Certificate provided for all participants who have completed 80% of course hours.
Course Description |
This course provides an introduction to data mining and big data. It gives participants the concepts and software skills needed to research, load, process and analyze data to obtain actionable insights. It focuses on developing software skills in Tableau, Knime and Google Big Query required to process data and prepare presentations and dashboards that highlight the data’s added value and support decisions and actions to follow.The course methodology is based on lectures led by the instructor who will present the concepts using industry examples. Each lecture is followed by a lab where participants complete specific tasks designed to reinforce the concepts introduced in the lecture.
In addition, participants are expected to complete a small assignment during the course and present it to the class. This will give them the confidence to apply the data mining skills learned in the course and to present the data insights in a clear, concise and engaging way. |
Topics Covered in this Course |
|
Weekly Topics Please note that the instructor reserves the right to modify this schedule |
|
Week 1 | Introduction and lab preparation and topic 1 |
Week 2 | Topics 1 and 2 Data processing stages in data mining Hardware and software systems for data mining |
Week 3 | Topics 3 and 4 Extracting, transforming and loading data |
Week 4 | Topics 4 and 5 Principles of data analysis Effective reports and dashboards displaying the data insights |
Week 5 | Topic 5 Mid-course review Project presentation. |
Week 6 | Topics 6 and 7 Big Data distributed processing systems Connecting analytics to Big data systems |
Week 7 | Topic 8 Forecasting and prediction. Introduction to Machine Learning. |
Week 8 | Project presentations and concluding remarks. |
SOFTWARE TO BE USED
For the course, we will primarily use Tableau public to load, process and analyze data, and produce reports and dashboards. For the large data portion of the course, we will use Google Big Query platform. Knime will be used for prediction and basic machine learning techniques. Other complimentary software includes MS Excel and MS Access. Data analytics software tools besides Tableau and Knime will be discussed in the course to provide participants a holistic view of data mining.
LABS and DATASETS
In the labs, participants will practice the skills needed for the different stages of the data mining process. Namely, ETL (Extraction Transformation and Load), Analysis and Reporting. Students are encouraged to bring their own datasets. However, for the lectures and labs we will use the following datasets.
https://public.tableau.com/views/Lab4-DatacharacterizationA-categoricalfields/Dashboard2
https://public.tableau.com/views/Lab3-Gizmoon-linestore/Dashboard2
https://public.tableau.com/shared/XX6T2DZZ2
https://public.tableau.com/shared/D3MPD5GYH
https://public.tableau.com/views/Lab12A-Shakespearedataset/Story1
Students work on a small project during the course to get comfortable using the techniques learned in class. Find below a link to some of the student projects.
https://public.tableau.com/views/StudentAssignmentsFall2017/StudentAssignmentsStory
In addition, in the middle of the course we host a friendly competition in the style of a hackathon where students are given a dataset and a problem to solve. They work for half a day and present a dashboard showing how the problem was solved and the main data insights. Please find below links to the project winners in the spring of 2019.
First place: Analysis of Bixi Ridership data in Montreal
https://public.tableau.com/profile/sfmdorval#!/vizhome/Bixiproject-2/BIXIrides
Second place: Dashboard for Real State sales in King County https://public.tableau.com/shared/WHDM2W78D
REGISTER NOW
Register Now
DATABASES (SQL SERIES)
*Schedule subject to change
- SQL – Introduction Details >
- Overview of the relational database management systems (RDBMS)
- Introduction to SQL Language and Sublanguages (DDL, DML and DCL)
- Steps for Database design
- Primary Key
- Foreign Key
- Entity Relationship Diagram
- Normalization of Database Tables
- SQL – Intermediate Details >
- This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
- Introduction to SQL Server and its Toolset
- Introduction to T-SQL Querying
- Creating Databases and Database Files
- Designing and Implementing Tables
- Working with SQL Server Data Types
- Writing SELECT Queries
- Querying Multiple Tables
- Sorting and Filtering Data
- Using Built-In Functions
- Grouping and Aggregating Data
- Using Subqueries
- Designing and Implementing Views
- SQL – Advanced Details >
- This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
- Creating views
- T-SQL view statements
- Alter views
- Encrypt views
- Creating stored procedures
- Overview of systems stored procedures
- Create user defined stored procedures
- Modify and alter stored procedures
- Create triggers
- Creating DML triggers
- Modify triggers
- Built-in and user defined functions
- Using built-in SQL server functions
- Creating user defined functions
- SQL – Reporting Services (SSRS) – Section 1 Details >
- Overview of Microsoft SQL Server Reporting Services
- Create a report using Report Designer
- Modify a report using Report Designer
- Group and summarize data
- Use parameters to filter data
- SQL – Reporting Services (SSRS) – Section 2 Details >
- This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
- Overview of Microsoft SQL Server Reporting Services
- Create a report using Report Designer
- Modify a report using Report Designer
- Group and summarize data
- Use parameters to filter data
- SQL Analysis Services (SSAS) Details >
- SQL Server Integration Services (SSIS) – Introduction Details >
- SQL Server Integration Services (SSIS) – Advanced Details >
- SQL – Data Quality Services (DQS) Details >
SQL – Introduction
×Course Title | SQL – Introduction |
Course Number | 900-002-EQ-02 |
Platform | Windows |
Duration | 24 hours |
Gouvernement du Québec fee (taxes incl.) |
$48 |
General Public fee (taxes incl.) |
$433.50 |
Schedule | Saturday: 9:00am-3:30pm (30 minute lunch) |
Dates | January 16, 23, 30, February 6 |
Prerequisites | Basic knowledge of the Windows operating system |
Target Audience | Individuals who are new to writing SQL queries |
Instructor | Khattar Daou |
Location | Online Format |
NB. This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
Course Description
This course provides an introduction to SQL Structure Query Language (SQL) and explores the concept of relational database management systems. We will cover the topics of designing a database, creating tables, setting primary and foreign keys as well as normalizing the database tables.
Topics Covered in this Course
REGISTER NOW
SQL – Intermediate
×Course Title | SQL – Intermediate |
Course Number | 900-006-EQ-02 |
Platform | Windows |
Duration | 24 hours |
Gouvernement du Québec fee (taxes incl.) | $48 |
General Public fee (taxes incl.) | $433.50 |
Schedule | Saturday: 9 a.m.-3:30 p.m. (30 minute lunch)
Monday & Wednesday: 6 p.m. -9 p.m. |
Dates | February 13, 20, 22, 24, 27 |
Prerequisites | SQL – Beginner, or working knowledge of relational databases (database design skills) |
Target Audience | Participants interested in acquiring the knowledge and skills needed to implement a Microsoft SQL Server database |
Instructor | Khattar Daou |
Location | Online format |
Course Description
The course focuses on teaching individuals how to use SQL Server product features and tools related to implementing a database server. This training provides students with the technical skills required to write basic Transact-SQL queries. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
Topics to be covered
REGISTER NOW
SQL – Advanced
×Course Title | SQL – Advanced |
Course Number | 900-024-EQ-02 |
Platform | Windows |
Duration | 24 hours |
Gouvernement du Québec fee (taxes incl.) | $48 |
General Public fee (taxes incl.) | $433.50 |
Schedule | Monday & Wednesday March 1, 3: 6 p.m. – 9 :30 p.m.;
Monday & Wednesday March 8, 10: 6 p.m. -10 p.m. Saturday March 6 : 9 a.m.- 3:30 p.m. ( 30 minute lunch ) Saturday March 13 : 9 a.m.-12 p.m. |
Dates | March 1,3,6,8,10,13 |
Prerequisites | SQL Level 1 and Level 2 or working knowledge of relational databases |
Target Audience | Participants interested in acquiring the knowledge and skills needed to implement a Microsoft SQL Server database |
Instructor | Khattar Daou |
Location | Online format |
Description:
In this level, participants will continue to learn advanced techniques for building and designing databases using Microsoft SQL server.
Topics to be covered:
REGISTER NOW
SQL – Reporting Services (SSRS) – Section 1
×Course Title | SQL – Reporting Services (SSRS) |
Course Number | 900-045-EQ-01 |
Platform | Windows |
Duration | 24 hours |
Gouvernement du Québec fee (taxes incl.) |
$48 |
General Public fee (taxes incl.) |
$433.50 |
Schedule | Monday & Wednesday – 6 p.m. – 10 p.m. |
Dates | January 11, 13, 18, 20, 25, 27 |
Prerequisites | SQL – Beginner, Intermediate, Advanced and/or experience with Microsoft SQL Server |
Target Audience | This course is aimed at data analysts, Business Intelligence developers, consultants or members of BI development teams. |
Instructor | Khattar Daou |
Location | Online Format |
NB. This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
Course Description:
Participants will learn how to create reports using Microsoft SQL Server Reporting Services.
Topics to be covered:
REGISTER NOW
SQL – Reporting Services (SSRS) – Section 2
×
Course Title | SQL – Reporting Services (SSRS) |
Course Number | 900-045-EQ -02 |
Platform | Windows |
Duration | 24 hours |
Gouvernement du Québec fee (taxes incl.) | $48 |
General Public fee (taxes incl.) | $433.50 |
Schedule | Monday & Wednesday, 6 p.m.-10 p.m. Saturday, March 20: 9 a.m.-3:30 p.m. (30 minute lunch)
First class on March 13: 1 p.m. – 4 p.m. Last class on march 24 : 6 p.m. – 9 p.m. |
Dates | March 13, 15, 17, 20, 22, 24 |
Prerequisites | SQL – Beginner, Intermediate, Advanced and/or experience with Microsoft SQL Server |
Target Audience | This course is aimed at data analysts, Business Intelligence developers, consultants or members of BI development teams . |
Instructor | Khattar Daou |
Location | Online format |
Course Description:
Participants will learn how to create reports using Microsoft SQL Server Reporting Services.
Topics to be covered:
REGISTER NOW
SQL Analysis Services (SSAS)
×Course title | SQL Analysis Services (SSAS) |
Course number | 900-049-EQ-02 |
Platform | Windows |
Duration | 24 hours |
Emploi-Québec fee (taxes incl.) | $48 |
General public fee (taxes incl.) | $433.50 |
Schedule | Monday & Wednesday: 6:00p.m.-10:00p.m. |
Dates | March 29, 31, April 7, 12, 15, 19 (no class April 5, Easter Monday) |
Prerequisites | SQL – Beginner, Intermediate, Advanced and/or experience with Microsoft SQL Server |
Target audience | This course is aimed at data analysts, Business Intelligence developers, consultants or members of BI development teams who are about to create a project using Microsoft SQL Server Analysis Services Tabular Model. |
Instructor | Khattar Daou |
Location | Online Format |
NB: This is a non-credit course.Certificate provided for all participants who have completed 80% of course hours. |
Course Description:
Microsoft SQL Server Analysis Services (SSAS) provides Online Analytical Processing (OLAP) and data mining features and capabilities to business intelligence (BI) projects and solutions. The tabular model in Analysis Services provides an easy-to-use and handy way for business users to access their data.
Analysis Services also offers rich experiences to BI users through interoperability in Microsoft Office and Microsoft SharePoint Server, helping people gain, use, and share insight.
This training course describes how to use SQL Server Data Tools to develop and deploy an Analysis Services project and we will be focusing exclusively on Tabular Model. You will learn how to simplify the process of building complex solutions by taking advantage of the rich modeling capabilities in Analysis Services.
Topics to be covered:
Module 1 – Microsoft SQL Server Analysis Services (SSAS)
• Introducing Microsoft SQL Server Analysis Services (SSAS)
• What Is Analysis Services and Why Should I Use It?
• Describes how to use SQL Server Data Tools to develop and deploy an Analysis Services project
• Understanding the SQL Server Data Tools Tabular Model Authoring Environment
Module 2 – Analysis Services 2012 Architecture
• The Tabular Model
• Data Sources
• Import Data
• Understanding Data Analysis Expressions (DAX) in Tabular Models
Module 3 – Microsoft SQL Server Data Tools
• Working with SQL Server Data Tools
• Create a new tabular model project in SQL Server Data Tools
• Import data from a SQL Server relational database into a tabular model project
• Create and manage relationships between tables in the model
• Create and manage calculations, measures, and Key Performance Indicators that help users analyze model data
• Create and manage perspectives and hierarchies that help users more easily browse model data by providing business and application specific viewpoints
• How to create partitions that divide table data into smaller logical parts that can be processed independent
Module 4 – Building a Tabular Model
• Loading Data into Tables
• Working in the Diagram View
• Rename columns
• Creating calculated columns and measures using DAX formulas
• Deployment
Module 5 – Querying a Tabular Model in Excel
• Connecting to a Tabular Model
• Browsing a Workspace Database
• Connecting to a Deployed Database
• Filter the table data prior to importing
Module 6 – Querying a Tabular Model in Power View
• Creating a Connection to a Tabular Model
• Building a Basic Power View Report
• Adding Charts and Slicers
• Interacting with a Report
REGISTER NOW
SQL Server Integration Services (SSIS) – Introduction
×Course Title | SQL Integration Services (SSIS) – Introduction |
Course Number | 900-083-EQ-02 |
Platform | Windows |
Duration | 21 hours |
Gouvernement du Québec fee (taxes incl.) |
$42 |
General Public fee (taxes incl.) |
$373.31 |
Schedule | Saturday: 9:00am-3:30pm (30 minute lunch) Last class: 9:00am-12:00pm |
Dates | March 27, April 10, 17, 24 (no class April 3, Easter Saturday) |
Prerequisites | SQL Level 2 or working knowledge of relational databases (database design skills) |
Target Audience | Participants interested in acquiring the knowledge and skills needed to implement Microsoft SQL Server Integration Services (SSIS) |
Instructor | Khattar Daou |
Location | Online Format |
NB. This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
*Textbook:
SQL Server 2016 Integration Services Cookbook | Christian Cote | ISBN: 978-1786461827 © 2017 | Packt Publishing Limited.
Course Description:
Microsoft SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
The primary objective of this course is to provide students with the knowledge and skills to use SSIS Designer to create a simple Microsoft SQL Server Integration Services package. The created package takes then data from a flat file, reformats the data, and then inserts the reformatted data into a fact table.
This course walks you through SSIS Designer to create a simple ETL package that includes looping, configurations, error flow logic and logging.
Topics to be covered:
Module 1 – Overview of SQL Server Integration Services
Overview of SSIS
Integration Services (SSIS) Development and Management Tools
Integration Services (SSIS) Projects and Solutions
Install/ Upgrade Integration Services
Change Data Capture (SSIS)
Integration Services (SSIS) Connections
Control Flow
Integration Services Containers
Integration Services Tasks
Precedence Constraints
Module 2 – Create a simple ETL package
Create a Project and Basic Package with SSIS
Adding Looping with SSIS
Add Logging with SSIS
Add Error Flow Redirection with SSIS
Add SSIS Package Configurations for the Package Deployment Model
Using Parameters with the Project Deployment Model in SSIS
Module 3 – Deploy Packages with SSIS
Preparing to Create the Deployment Bundle
Create the Deployment Bundle in SSIS
Install SSIS Packages
REGISTER NOW
SQL Server Integration Services (SSIS) – Advanced
×Course Title | SQL Integration Services (SSIS)- Advanced
|
Course Number | 900-092-EQ-01 |
Platform | Windows |
Duration | 14 hours |
Gouvernement du Québec fées ( taxes incl.) |
$28.00 |
General public fees (taxes incl.) | $252.88 |
Schedule | Monday & Wednesday: 6 p.m.- 10 p.m.
Saturday : 9 a.m.-3:30 p.m. (30 minute lunch ) |
Dates | January 4,6,9 |
Prerequisites | SQL Server Integration Services (SSIS) – Advanced |
Target Audience | This course is not designed for students who are new to SQL Server BI technologies; it is targeted at BI professionals with experience of implementing solutions with SQL Server database Engine, SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services. |
Instructor | Khattar Daou |
Location | Online format |
Please note that this is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
Recommended Textbook |
Exam Ref 70-767 Implementing a SQL Data Warehouse
Jose Chinchilla, Raj Uchhana Copyright © 2018 by Pearson Education |
Course Description
This training course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server and other Microsoft BI technologies.
This course describes how to implement a BI platform to support information worker analytics. Students will learn how to create a data warehouse with Microsoft SQL Server, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
|
Topics Covered in this Course | |
Weekly Topics
Please note that the instructor reserves the right to modify this schedule |
|
Module 1
|
Overview of Data Warehousing
This module provides an introduction to the key components of a data warehousing solution and the high-level considerations that you must take into account when you embark on a data warehousing project.
After completing this module, you will be able to: • Describe the key elements of a data warehousing solution • Describe the key considerations for a data warehousing project. |
Module 2 | Designing and Implementing a Data Warehouse
In this module, you will learn how to implement the logical and physical architecture of a data warehouse based on industry-proven design principles.
After completing this module, you will be able to: • implement a logical design for a data warehouse • implement a physical design for a data warehouse |
Module 3
|
Creating an ETL Solution with SSIS
This module discusses considerations for implementing an ETL process, and then focuses on Microsoft SQL Server Integration Services (SSIS) as a platform for building ETL solutions.
After completing this module, you will be able to: • Describe the key features of SSIS • Explore source data for an ETL solution • Implement a data flow by using SSIS |
REGISTER NOW
SQL – Data Quality Services (DQS)
×Course Title | Data Quality Services (DQS)
|
|
Course Number | 900-078-EQ-01 | |
Platform | Microsoft Windows | |
Duration | 21 hours
|
|
Gouvernement du Québec fee ( taxes incl) | $42 | |
General public feee ( taxes incl) | $379.31 | |
Schedule | Monday & Wednesday: 6 p.m. -9:30 p.m. | |
Dates | February 1, 3, 8, 10, 15, 17 | |
Prerequisites | SQL Level 2 or working knowledge of relational databases (database design skills | |
Target Audience | Data quality is one of the common challenges in every database system, especially when data comes from different kinds of sources.
This course will explain the concept of data quality through a new Microsoft engine for data cleansing named Data Quality Services. |
|
Instructor | Khattar Daou | |
Location | Online format | |
Course Description | ||
Please note that this is a non-credit course. Certificate provided for participants who have completed 80% of course hours | ||
SQL Server Data Quality Services (DQS) enables you to cleanse, match, standardize, and enrich data, so you can deliver trusted information for business intelligence, a data warehouse, and transaction processing workloads.
By the end of this course, you will have good understanding of the most common challenges in data quality and you will also learn how to design and implement a solution with Data Quality Services to overcome these challenges and provide better data quality for the data warehouse. |
||
Topics Covered in this Course |
Module 1: Introducing Data Quality Services
· Unit 1: SQL Server Data Quality Services (DQS) & Master Data Services (MDS) · Unit 2: Prerequisites and Setup · Unit 3: Configure MDS using Master Data Services Configuration Manager · Unit 4: Setting up the Database and Website
Module 2: A Knowledge-Driven Solution · Unit 1: Deploying Sample Models and Data · Unit 2: Install and Configure DQS using Data Quality Server Installer · Unit 3: Install Master Data Services Add-in for Excel · Unit 4: Creating DQS Knowledge Base
Module 3: Data Cleansing · Unit 1: Cleansing Data using Knowledge Base · Unit 2: Matching Data to Remove Duplicates Values · Unit 3: Storing Data in MDS · Unit 4: Reference Data Services in DQS
|
Weekly Topics
Please note that the instructor reserves the right to modify this schedule |
|
Week 1 | Module 1 |
Week 2 | Module 2 |
Week 3 | Module 3 |
REGISTER NOW
Register Now
PYTHON PROGRAMMING LANGUAGE
*Schedule subject to change
- Python – Level 1 – Section 4 Details >
- Python – Level 1 – Section 5 Details >
- Python – Level 2 – section 4 Details >
- Regular Expressions
- Exploring python modules
- Other datatypes (Sets and Tuples)
- Variable parameters functions
- Web Scraping
- Working with serialized formats (JSON)
- Interacting with a database
- Python and object Oriented Programming
- Classes, Objects, attributes, methods, Inheritance and more
- Iterators and Generators
- Decorators
- Python – Level 2 – section 5 Details >
- Regular Expressions
- Exploring python modules
- Working with dates
- Other data types ( Sets and Tuples )
- Variable parameters functions
- Web Scraping
- Working with serialized formats (JSON)
- Interacting with a database
- Python and object Oriented Programming
- Classes, Objects, attributes, methods, Inheritance and more
- Generators
- Python – Level 3 – Section 2 Details >
- Introduction to basic GUI programming and concepts
- Drawing basic objects in a canvas
- Working with event listeners
- Mouse and Keyboard events
- Working with timers and callback functions
- Moving objects across the canvas
- Loading images
- Introduction to Django and MVC backend web programming in Python
- Understanding the MVC architecture
- Using templates
- Introduction to APIs in Python
Python – Level 1 – Section 4
×
Course Title |
Python Level 1 – Section 4 |
Course Number |
900-051-EQ-04 |
Platform |
Windows |
Duration |
24 hours |
Gouvernement du Québec fee (taxes incl.) |
$48 |
General Public fee (taxes incl.) |
$433.50 |
Schedule |
Tuesday & Thursday: 6:00pm – 9:30pm; First class on January 5: 6:30pm-9:30pm |
Dates |
January 5, 7, 12, 14, 19, 21, 26 First class on January 5: 6:30pm-9:30pm |
Prerequisites |
Basic knowledge of programming or scripting (otherwise a strong motivation to learn is required). Participants must know how to work with the Windows graphical interface, and use Windows Explorer to manipulate files and folders.Note: This course is a prerequisite of Python level 2 and level 3. |
Target Audience |
Programmers or anyone interested in an introduction to programming and the python language. Professionals from any field interested in automating computer tasks, can take advantage of the content of this course. |
Instructor |
José Porras |
Location |
Online format REGISTER NOW |
Python – Level 1 – Section 5
×
Course Title |
Python Level 1 – Section 5 |
Course Number |
900-051-EQ-05 |
Platform |
Windows |
Duration |
24 hours |
Gouvernement du Québec fee (taxes incl.) |
$48 |
General Public fee (taxes incl.) |
$433.50 |
Schedule |
Monday & Wednesday: 6:00pm – 9:30pm |
Dates |
January 11, 13, 18, 20, 25, 27, February 1 First class on January 11: 6:30-9:30pm |
Prerequisites |
Basic knowledge of programming or scripting (otherwise a strong motivation to learn is required). Participants must know how to work with the Windows graphical interface, and use Windows Explorer to manipulate files and folders.Note: This course is a prerequisite of Python level 2 and level 3. |
Target Audience |
Programmers or anyone interested in an introduction to programming and the python language. Professionals from any field interested in automating computer tasks, can take advantage of the content of this course. |
Instructor |
José Rafael Porras |
Location |
Online format REGISTER NOW |
Python – Level 2 – section 4
×Course Title | Python – Level 2 |
Course Number | 900-052-EQ-04 |
Platform | Windows |
Duration | 24 hours |
Gouvernement du Québec fee (taxes incl.) | $48 |
General Public fee (taxes incl.) | $433.50 |
Schedule | Tuesday & Thursday : 6 p.m. – 9:30 p.m. |
Dates | February 2, 4, 9, 11, 16, 18, 23
First class on February 2: 6:30 p.m. – 9:30 p.m. |
Prerequisites
|
Python – Level 1 Note: This course is a prerequisite to Data Science 1 and Python – Level 3 |
Target Audience
|
Programmers or anyone interested in an introduction to programming and the python language. Professionals from any field interested in automating computer tasks, can take advantage of the content of this course. |
Instructor | José Rafael Porras |
Location | Online format |
NB: This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours.
No textbook is required for this course.
Course Description
The world of software programming and scripting is a fascinating place. Computers, smartphones and electronic gadgets are all controlled by software instructions. Python is a great way to start developing programming skills, have fun and become more acquainted with the technological world around us. This course continues exploring the Python language beyond the introductory level. Object Oriented programming and other topics are explored using the Python language.
Topics Covered in this Course:
REGISTER NOW
Python – Level 2 – section 5
×Course Title | Python – Level 2 |
Course Number | 900-052-EQ-05 |
Platform | Windows |
Duration | 24 hours |
Gouvernement du Québec fee (taxes incl.) | $48 |
General Public fee (taxes incl.) | $433.50 |
Schedule | Monday & Wednesday : 6 p.m. – 9:30 p.m. |
Dates | February 3, 8,10,15,17, 22, 24
First class on February 3: 6:30 p.m. – 9:30 p.m. |
Prerequisites
|
Python – Level 1 Note: This course is a prerequisite to Data Science 1 and Python – Level 3 |
Target Audience
|
Programmers or anyone interested in an introduction to programming and the python language. Professionals from any field interested in automating computer tasks, can take advantage of the content of this course. |
Instructor | José Rafael Porras |
Location | Online format |
NB: This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours.
No textbook is required for this course.
Course Description
The world of software programming and scripting is a fascinating place. Computers, smartphones and electronic gadgets are all controlled by software instructions. Python is a great way to start developing programming skills, have fun and become more acquainted with the technological world around us. This course continues exploring the Python language beyond the introductory level. Object Oriented programming and other topics are explored using the Python language.
Topics Covered in this Course:
REGISTER NOW
Python – Level 3 – Section 2
×Course Title | Python – Level 3 |
Course Number | 900-062-EQ-02 |
Platform | Windows |
Duration | 30 hours |
Gouvernement du Québec fee (taxes incl.) |
$60 |
General Public fee (taxes incl.) |
$541.88 |
Schedule | Tuesday & Thursday : see schedule of dates / times below |
Dates | March 30, April 1 & 27: 6:30 p.m. – 9:30 p.m. April 6, 8, 13, 15, 20, 22: 6:00 p.m. – 9:30 p.m. |
Prerequisites | Python – Level II |
Target Audience | Students interested in exploring the relationship between Python and web development, as well as exploring basic GUI concepts. |
Instructor | José Rafael Porras |
Location | Online Format |
NB: This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours.
No textbook is required for this course.
Course Description:
This course is a continuation of the courses Python level I and level II. Students explore several programming topics and their implementation using the Python programming language ,
Students will be introduced to simple GUI (Graphic User Interface) topics, web development with a Python framework and a brief introduction to APIs services.
Topics Covered in this Course:
REGISTER NOW
Register Now
DATA SCIENCE
*Schedule subject to change
- Data Science – Level 1 – Section 3 Details >
- Introduction to ETL processes and data wrangling using Python
- Using Pandas module to explore data
- Working with Databases and SQL
- Introduction to APIS
- Introduction to static Web Scraping
- Introduction to Data Visualization using Matplotlib
- Overview of simple linear regression and K-Means Clustering techniques
- Data Science – Level 1 – Section 4 Details >
- Introduction to ETL processes and data wrangling using Python
- Using Pandas module to explore data
- Working with Databases and SQL
- Introduction to APIS
- Introduction to static Web Scraping
- Introduction to Data Visualization using Matplotlib
- Overview of simple linear regression and K-Means Clustering techniques
- Data Science – Level 1 – Section 5 Details >
- Introduction to ETL processes and data wrangling using Python
- Using Pandas module to explore data
- Working with Databases and SQL
- Introduction to APIS
- Introduction to static Web Scraping
- Introduction to Data Visualization using Matplotlib
- Overview of simple linear regression and K-Means Clustering techniques
- Data Science – Level 2 Details >
- Introduction to Statistical Learning for Data Science
- Basic statistical analysis in Knime and Python: Histograms, box and scatter plots
- Continuous variables regression linear
- Regression beyond linearity
- Maximum Likelihood and Logistic regression Classifier. K-Nearest Neighbors (KNN) classifier
- Decision trees for regression and classification
- Support Vector Machine Classifier and Practical applications of Classification and regression.
- Data Science – Level 3 Details >
Data Science – Level 1 – Section 3
×Course Title | Data Science – Level 1 |
Course number | 900-080-EQ-03 |
Platform | Windows desktop |
Duration | 24 hours |
Prerequisites | Python I, programming experience. This is a programming intensive course. Students must be comfortable working with text files (opening, reading and writing text files using a programming language). Knowledge of conditionals, loops, functions, indexing, slicing, lists, dictionaries and arrays is essential. |
Target Audience | All those interested in an introduction to the world of data science. Students must have programming background. See prerequisites. |
Dates | January 9, 16, 23, 30, February 6, 13 |
Instructor | José Rafael Porras |
Room | Online format |
Schedule | Saturday: 9:00am – 1:00pm |
Gouvernement du Québec fee | $48.00 |
General public fee | $433.50 |
Recommended textbook: Class Notes
NB: Certificate provided for all participants who have completed 80% of course hours
Course Description |
Please note that this is a non-credit course. |
This course is the first in a series of three courses on the subject of data science. The course will introduce the participant to the concepts of data extraction, transformation and loading using the Python language and the Pandas module.The course will also explore concepts of storing data in relational databases (SQL), Consuming APIS, JSON and basic web scraping. Beyond ETL concepts, the course will also introduce the basics of data visualization and statistical concepts as applied. The course will end with an introduction to simple linear regression and K-Means clustering.
It is strongly recommended that students have competed the course Python I prior to registering in this course. This is a programming intensive course. The student must be comfortable working with text files (opening, reading and writing text files using a programming language). |
Topics Covered in this Course |
|
REGISTER NOW
Data Science – Level 1 – Section 4
×Course Title | Data Science – Level 1 – Section 4 |
Course number | 900-080-EQ-04 |
Platform | Windows desktop |
Duration | 24 hours |
Prerequisites | Python I, programming experience. This is a programming intensive course. Students must be comfortable working with text files (opening, reading and writing text files using a programming language). Knowledge of conditionals, loops, functions, indexing, slicing, lists, dictionaries and arrays is essential. |
Target Audience | All those interested in an introduction to the world of data science. Students must have programming background. See prerequisites. |
Dates | March 2, 4, 9, 11, 16, 18, 23 |
Instructor | José Rafael Porras |
Room | Online format |
Schedule | Tuesday & Thursday: 6 p.m. – 9:30 p.m. First class on March 2: 6:30 p.m. – 9:30 p.m. |
Gouvernement du Québec fee | $48.00 |
General public fee | $433.50 |
Recommended textbook: Class Notes
NB: Certificate provided for all participants who have completed 80% of course hours
Course Description |
Please note that this is a non-credit course. |
This course is the first in a series of three courses on the subject of data science. The course will introduce the participant to the concepts of data extraction, transformation and loading using the Python language and the Pandas module.The course will also explore concepts of storing data in relational databases (SQL), Consuming APIS, JSON and basic web scraping. Beyond ETL concepts, the course will also introduce the basics of data visualization and statistical concepts as applied. The course will end with an introduction to simple linear regression and K-Means clustering.
It is strongly recommended that students have competed the course Python I prior to registering in this course. This is a programming intensive course. The student must be comfortable working with text files (opening, reading and writing text files using a programming language). |
Topics Covered in this Course |
|
Data Science – Level 1 – Section 5
×Course Title | Data Science – Level 1 – Section 5 |
Course number | 900-080-EQ-05 |
Platform | Windows desktop |
Duration | 24 hours |
Prerequisites | Python I, programming experience. This is a programming intensive course. Students must be comfortable working with text files (opening, reading and writing text files using a programming language). Knowledge of conditionals, loops, functions, indexing, slicing, lists, dictionaries and arrays is essential. |
Target Audience | All those interested in an introduction to the world of data science. Students must have programming background. See prerequisites. |
Dates | March 1, 3, 8, 10, 15, 17, 22 |
Instructor | José Rafael Porras |
Room | Online format |
Schedule | Monday & Wednesday: 6 p.m. – 9:30 p.m. First class on March 1: 6:30 p.m. – 9:30 p.m. |
Gouvernement du Québec fee | $48.00 |
General public fee | $433.50 |
Recommended textbook: Class Notes
NB: Certificate provided for all participants who have completed 80% of course hours
Course Description |
Please note that this is a non-credit course. |
This course is the first in a series of three courses on the subject of data science. The course will introduce the participant to the concepts of data extraction, transformation and loading using the Python language and the Pandas module.The course will also explore concepts of storing data in relational databases (SQL), Consuming APIS, JSON and basic web scraping. Beyond ETL concepts, the course will also introduce the basics of data visualization and statistical concepts as applied. The course will end with an introduction to simple linear regression and K-Means clustering.
It is strongly recommended that students have competed the course Python I prior to registering in this course. This is a programming intensive course. The student must be comfortable working with text files (opening, reading and writing text files using a programming language). |
Topics Covered in this Course |
|
Data Science – Level 2
×Course Title | Data Science – Level 2 |
Course number | 900-081-EQ-02 |
Platform | MS Teams, Knime and Python |
Duration | 24 hours |
Prerequisites | Basic understanding of Probability and Algebra. Basic Data analysis and processing in Excel, Tableau or any database systems. Data manipulation and basic Linear regression in Python. Completion of the Data Science Level 1 course. |
Target Audience | Data Analysts; Computer Analysts; Individuals in any role dealing with small or large amounts of data needing to model the data to obtain predictions. |
Dates | March 25, 29, April 1, 6, 8, 13, 15 |
Instructor | Diego Perea – Ph.D. |
Room | Online Format |
Schedule | Tuesday & Thursday: 6 p.m. – 9:30 p.m. First class on March 25 : 6:30 p.m. – 9:30 p.m. |
Gouvernement du Québec fee | $48.00 |
General public fee | $433.50 |
NB: Certificate provided for all participants who have completed 80% of course hours
Recommended textbook |
[1] An Introduction to Statistical Learning with Applications in R by G. James, D. Whitten, R. Tibshirani and T. Hastie. |
Course Description |
Please note that this is a non-credit course. |
The Descriptive analytic methods, seen in previous big data courses, form the basis for the Predictive Analytic methods that are at the heart of this new course. In this course, participants will learn the standard statistical methods currently used in industry to perform predictive analytics. These include linear and non-linear regression and several classification methods such as Logistic regression, KNN, Decision Trees and SVM. Participants will learn how to research the available data and choose the best predictive method to apply. Key components of this course are the understanding of these methods, the methodology to evaluate them and the criteria to choose the best method.The course methodology is based on on-line short lectures in MS-Teams presenting the concepts using industry examples. Each lecture is followed by a lab using real data, where the participants will complete specific tasks in Knime and Python designed to reinforce the concepts introduced in the lecture. |
Topics Covered in this Course |
|
Weekly Topics Please note that the instructor reserves the right to modify this schedule |
|
Week 1 | Topics 1 and 2 Introduction, course description and Knime overview. Basic statistical analysis: Histograms, box and scatter plots. |
Week 2 | Topics 3 and 4 Continuous variables regression beyond linearity |
Week 3 | Topics 5 and 6 Supervised classification |
Week 4 | Topic 7 Support Vector Machines and concluding remarks |
SOFTWARE TO BE USED
For the course, we will mainly use Python, which is the industry standard for statistical learning and provides functions for most of the methods. Other software used for statistical learning is Knime that has a friendly graphical interface. MS-Teams will be the on-line learning platform which allows on-line meetings and presentations, posting of polls and assignments and lecture recording for the students review of the lecture.
LABS and DATASETS
In the labs, the participant will apply the prediction and classification methods seen in class using different datasets.
REGISTER NOW
Data Science – Level 3
×Course Title | Data Science-Level 3 |
Course number | 900-082-EQ-01 |
Platform | Python, Knime |
Duration | 21 hours |
Gouvernement du Québec fee ( taxes incl.) | $42 |
General Public fee | $379.31 |
Schedule | Tuesday & Thursday 6:30 p.m.- 9 :30 p.m. |
Dates | January 7,12,14,19,21,26, 28 |
Prerequisites | Data Science – Level 2 course |
Target Audience | Data Analysts; Computer Analysts; Professionals dealing with small or large amounts of data needing to apply Machine Learning Methods. |
Instructor | Diego Perea Ph.D. |
Room | Online format |
NB: This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours.
Recommended Textbook |
“An Introduction to Statistical Learning with applications in R” by G. James, D. Whitten, R. Tibshirani and T. Hastie. |
Course Description |
This course deals with advanced methods of Machine Learning for data science. At the end of the course the participant will have at disposal a large set of methods to apply for regression, supervised and unsupervised classification problems.
The course methodology is based on lectures led by the instructor, who will present the concepts using examples followed by a lab using real data where the participants will complete specific tasks in Knime and Python designed to reinforce the concepts introduced in the lecture. Students will complete a small data prediction project with data of their choice during the course, where they apply the methods learned in the course. Examples of previous students projects are listed below https://public.tableau.com/views/StudentProjects/StudentProjects
|
Topics Covered in this Course |
1. Regression Review and advanced variable selection methods: Ridge, Lasso.
2. Supervised and unsupervised classification methods 3. Forecasting 4. Big data and commercial machine learning systems 5. Project presentation
|
Weekly Topics
Please note that the instructor reserves the right to modify this schedule |
|
Week 1
|
Topics 1
|
Week 2
|
Topic 2
|
Week 3
|
Topic 3
|
Week 4 | Topic 4
|
SOFTWARE TO BE USED
For the course, we will mainly use Knime and Python, which are the industry standard for statistical learning and provides functions for most of the methods. Other software will be addressed in the course to give the participant a holistic view of statistical learning.
LABS and DATASETS
In the labs, the participant will apply the prediction and classification methods seen in class using practical datasets. We will use datasets from the textbook and from public sources such:
https://archive.ics.uci.edu/ml/datasets.html
REGISTER NOW
Register Now
VIRTUALIZATION TECHNOLOGIES
*Schedule subject to change
- Microsoft Azure – Fundamental Concepts – Section 001 Details >
- Microsoft Azure – Fundamental Concepts – Section 002 Details >
- Microsoft Azure – Fundamental Concepts – Section 003 Details >
- Amazon Web Services – Section 001 Details >
- Amazon Web Services – Section 002 Details >
- Amazon Web Services – Section 003 Details >
- Container Based System Architecture: Docker – Section 001 Details >
- Install and Use Docker on Debian 9
- Using the Docker Command
- Working with Docker Images
- Running a Docker Container
- Managing Docker Containers
- Committing Changes in a Container to a Docker Image
- Pushing Docker Images to a Docker Repository
- Push and Pull images from Docker Hub
- Deploying containers in Docker
- How to Scale an App
- Deploy your app on the swarm cluster
- Using Dockerfiles for Repeatable, Consistent Builds
- How to Setup DNS Server with Docker Container
- Docker Compose
- Scheduling, Cluster Management, and Orchestration
- Using a Docker Registry for Container Management
- Container Based System Architecture: Docker – Section 002 Details >
- Install and Use Docker on Debian 9
- Using the Docker Command
- Working with Docker Images
- Running a Docker Container
- Managing Docker Containers
- Committing Changes in a Container to a Docker Image
- Pushing Docker Images to a Docker Repository
- Push and Pull images from Docker Hub
- Deploying containers in Docker
- How to Scale an App
- Deploy your app on the swarm cluster
- Using Dockerfiles for Repeatable, Consistent Builds
- How to Setup DNS Server with Docker Container
- Docker Compose
- Scheduling, Cluster Management, and Orchestration
- Using a Docker Registry for Container Management
- Hyper-V Details >
Microsoft Azure – Fundamental Concepts – Section 001
×Course Title | Microsoft Azure Fundamental Concepts
|
Course Number | 900-067-EQ-01 |
Platform | Cloud Technologies |
Duration | 45 hours |
Gouvernement du Québec fee ( taxes incl.) | $90 |
General public fee (taxes incl.) |
$812.82 |
Prerequisites |
· A basic understanding of virtualization · A basic understanding of Active Directory concepts, including domains, users and domain controllers. · An understanding of Web Sites A basic understanding of database concepts including tables and simple queries |
Schedule | Saturday & Sunday : 9 a.m.-5 p.m. ( 30 minute lunch) |
Dates | January 16,17,23,24,30,31, |
Prerequisites | Windows and /or Linux Servers experience /or knowledge |
Target Audience | Individuals ( Developers, Administrators, IT professionals, Database administrators ) who want to evaluate, deploy ,configure and administer services and VMs using Azure |
Instructor | Michael Hughes |
Location | Online format |
Please note that this is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
Course Description
This course provides the skills required to set up and sustain an Office 365 tenant and user. Participants will learn to evaluate, plan , deploy and operate Microsoft Office 365 services that include : identities, dependencies, requirements, supporting technologies
After completing this course, students will be able to:
|
Topics Covered in this Course
Weekly Topics Module 1: Getting Started with Microsoft Azure This module introduces students to cloud services and the various Azure services. It describes how to use the Azure portal to access and manage Azure services, and to manage Azure subscription and billing. Lessons · o What is cloud computing? o What is Azure? o Managing Azure o Subscription management, support, and billing Lab: Using the Azure portals · o Customizing the Azure portal interface o Viewing billing, usage, and quotas data
Module 2: Microsoft Azure management tools This module explains Azure PowerShell and its use in managing Azure subscriptions. It also describes the Azure Software Development Kit (SDK) and the Azure cross-platform command-line interface, and explains their benefits and uses. Lessons · o What is Azure PowerShell o The Azure SDK and the Azure CLI Lab: Using Microsoft Azure management tools · o Using the Azure PowerShell modules o Explain the Azure CLI
Module 3: Virtual machines in Microsoft Azure This module explains how to use Azure to deploy virtual machines. It also explains the highly available and scalable configuration of Azure virtual machines, and the management of virtual machine disks by using Azure. Lessons · o Creating and configuring VMs Lab: Creating a VM in Azure · o Create a VM from the Azure Portal by using an Azure Marketplace images (Linux and Windows) o Verify the functionality of the VM o Log into and explore the virtual machines crated using different clients
Module 4: Creating and Configuring Virtual Networks This module explains Azure virtual networks and how to create them. It also covers variety of virtual network components. Lessons · o Getting started with virtual networks o Creating a virtual network Lab: Create a Virtual Network · o Creating a virtual network o Verifying virtual network functionality
Module 5: Web Apps and Cloud Services This module explains how to create, configure, and monitor Web apps by using Azure. It also describes the creation and deployment of Cloud Services on Azure. Lessons · o Creating and configuring web apps o Deploying and monitoring web apps o Creating and deploying PaaS cloud services Lab: Web Apps and Cloud Services · o Creating and configuring web apps (Using selected tools) o Create a cloud service o Logging into Azure and Configuring Web Apps using Visual Studio
|
REGISTER NOW
Microsoft Azure – Fundamental Concepts – Section 002
×Course Title | Microsoft Azure Fundamental Concepts
|
Course Number | 900-067-EQ-02 |
Platform | Cloud Technologies |
Duration | 45 hours |
Gouvernement du Québec fee ( taxes incl.) | $90 |
General public fee (taxes incl.) |
$812.82 |
Prerequisites |
· A basic understanding of virtualization · A basic understanding of Active Directory concepts, including domains, users and domain controllers. · An understanding of Web Sites A basic understanding of database concepts including tables and simple queries |
Schedule | Saturday & Sunday : 9 a.m.-5 p.m. ( 30 minute lunch) |
Dates | February 27, 28, March 6, 7, 13, 14 |
Prerequisites | Windows and /or Linux Servers experience /or knowledge |
Target Audience | Individuals ( Developers, Administrators, IT professionals, Database administrators ) who want to evaluate, deploy ,configure and administer services and VMs using Azure |
Instructor | Michael Hughes |
Location | Online format |
Please note that this is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
Course Description
This course provides the skills required to set up and sustain an Office 365 tenant and user. Participants will learn to evaluate, plan , deploy and operate Microsoft Office 365 services that include : identities, dependencies, requirements, supporting technologies
After completing this course, students will be able to:
|
Topics Covered in this Course
Weekly Topics Module 1: Getting Started with Microsoft Azure This module introduces students to cloud services and the various Azure services. It describes how to use the Azure portal to access and manage Azure services, and to manage Azure subscription and billing. Lessons · o What is cloud computing? o What is Azure? o Managing Azure o Subscription management, support, and billing Lab: Using the Azure portals · o Customizing the Azure portal interface o Viewing billing, usage, and quotas data
Module 2: Microsoft Azure management tools This module explains Azure PowerShell and its use in managing Azure subscriptions. It also describes the Azure Software Development Kit (SDK) and the Azure cross-platform command-line interface, and explains their benefits and uses. Lessons · o What is Azure PowerShell o The Azure SDK and the Azure CLI Lab: Using Microsoft Azure management tools · o Using the Azure PowerShell modules o Explain the Azure CLI
Module 3: Virtual machines in Microsoft Azure This module explains how to use Azure to deploy virtual machines. It also explains the highly available and scalable configuration of Azure virtual machines, and the management of virtual machine disks by using Azure. Lessons · o Creating and configuring VMs Lab: Creating a VM in Azure · o Create a VM from the Azure Portal by using an Azure Marketplace images (Linux and Windows) o Verify the functionality of the VM o Log into and explore the virtual machines crated using different clients
Module 4: Creating and Configuring Virtual Networks This module explains Azure virtual networks and how to create them. It also covers variety of virtual network components. Lessons · o Getting started with virtual networks o Creating a virtual network Lab: Create a Virtual Network · o Creating a virtual network o Verifying virtual network functionality
Module 5: Web Apps and Cloud Services This module explains how to create, configure, and monitor Web apps by using Azure. It also describes the creation and deployment of Cloud Services on Azure. Lessons · o Creating and configuring web apps o Deploying and monitoring web apps o Creating and deploying PaaS cloud services Lab: Web Apps and Cloud Services · o Creating and configuring web apps (Using selected tools) o Create a cloud service o Logging into Azure and Configuring Web Apps using Visual Studio
|
REGISTER NOW
Microsoft Azure – Fundamental Concepts – Section 003
×Course Title | Microsoft Azure Fundamental Concepts
|
Course Number | 900-067-EQ-03 |
Platform | Cloud Technologies |
Duration | 45 hours |
Gouvernement du Québec fee ( taxes incl.) | $90 |
General public fee (taxes incl.) |
$812.82 |
Prerequisites |
· A basic understanding of virtualization · A basic understanding of Active Directory concepts, including domains, users and domain controllers. · An understanding of Web Sites A basic understanding of database concepts including tables and simple queries |
Schedule | Monday, Tuesday, Wednesday: 6 p.m.-9 p.m. Monday, March 29 & April 21: 6 p.m.-9 p.m. Thursday, April 8: 6 p.m.-9 p.m. No class Easter Monday, April 5 |
Dates | March 29, 2021 – April 21, 2021 |
Prerequisites | Windows and /or Linux Servers experience /or knowledge |
Target Audience | Individuals ( Developers, Administrators, IT professionals, Database administrators ) who want to evaluate, deploy ,configure and administer services and VMs using Azure |
Instructor | Michael Hughes |
Location | Online format |
Please note that this is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
Course Description
This course provides the skills required to set up and sustain an Office 365 tenant and user. Participants will learn to evaluate, plan , deploy and operate Microsoft Office 365 services that include : identities, dependencies, requirements, supporting technologies
After completing this course, students will be able to:
|
Topics Covered in this Course
Weekly Topics Module 1: Getting Started with Microsoft Azure This module introduces students to cloud services and the various Azure services. It describes how to use the Azure portal to access and manage Azure services, and to manage Azure subscription and billing. Lessons · o What is cloud computing? o What is Azure? o Managing Azure o Subscription management, support, and billing Lab: Using the Azure portals · o Customizing the Azure portal interface o Viewing billing, usage, and quotas data
Module 2: Microsoft Azure management tools This module explains Azure PowerShell and its use in managing Azure subscriptions. It also describes the Azure Software Development Kit (SDK) and the Azure cross-platform command-line interface, and explains their benefits and uses. Lessons · o What is Azure PowerShell o The Azure SDK and the Azure CLI Lab: Using Microsoft Azure management tools · o Using the Azure PowerShell modules o Explain the Azure CLI
Module 3: Virtual machines in Microsoft Azure This module explains how to use Azure to deploy virtual machines. It also explains the highly available and scalable configuration of Azure virtual machines, and the management of virtual machine disks by using Azure. Lessons · o Creating and configuring VMs Lab: Creating a VM in Azure · o Create a VM from the Azure Portal by using an Azure Marketplace images (Linux and Windows) o Verify the functionality of the VM o Log into and explore the virtual machines crated using different clients
Module 4: Creating and Configuring Virtual Networks This module explains Azure virtual networks and how to create them. It also covers variety of virtual network components. Lessons · o Getting started with virtual networks o Creating a virtual network Lab: Create a Virtual Network · o Creating a virtual network o Verifying virtual network functionality
Module 5: Web Apps and Cloud Services This module explains how to create, configure, and monitor Web apps by using Azure. It also describes the creation and deployment of Cloud Services on Azure. Lessons · o Creating and configuring web apps o Deploying and monitoring web apps o Creating and deploying PaaS cloud services Lab: Web Apps and Cloud Services · o Creating and configuring web apps (Using selected tools) o Create a cloud service o Logging into Azure and Configuring Web Apps using Visual Studio
|
REGISTER NOW
Amazon Web Services – Section 001
×Course Title | Amazon Web Services |
Course Number | 900-094-EQ-01 |
Platform | Cloud Technologies |
Duration | 30 hours |
Prerequisites | Windows and/or Linux Servers experience or knowledge |
Target Audience | Individuals currently working in IT with either Windows and/or Linux Servers experience |
Dates | January 12, 13, 18, 19, 20, 25, 26, 27 |
Instructor | Michael Hughes |
Room | Online Format |
Schedule | Monday, Tuesday, Wednesday: 6:00p.m. – 10:00p.m.; Last class on January 27: 6:00p.m.-8:00p.m. |
Gouvernement du Québec fee ( taxes incl.) | $60 |
General public fee (taxes incl.) | $541.88 |
Course Description: This course introduces the key concepts and services of Amazon Web Services |
NB: Certificate provided for all participants who have completed 80% of course hours |
Topics Covered in this Course:
· AWS Cloud concepts and basic global infrastructure
REGISTER NOW |
Amazon Web Services – Section 002
×Course Title | Amazon Web Services – Section 002 |
Course Number | 900-094-EQ-02 |
Platform | Cloud Technologies |
Duration | 30 hours |
Prerequisites | Windows and/or Linux Servers experience or knowledge |
Target Audience | Individuals currently working in IT with either Windows and/or Linux Servers experience |
Dates | February 1, 2, 3, 8, 9, 10, 15, 16 |
Instructor | Michael Hughes |
Room | Online Format / BH-311 |
Schedule | Monday, Tuesday, Wednesday: 6:00p.m. – 10:00p.m.; Last class on February 16: 6:00p.m.-8:00p.m. |
Gouvernement du Québec fee ( taxes incl.) | $60 |
General public fee (taxes incl.) | $541.88 |
Course Description: This course introduces the key concepts and services of Amazon Web Services |
NB: Certificate provided for all participants who have completed 80% of course hours |
Topics Covered in this Course:
· AWS Cloud concepts and basic global infrastructure
REGISTER NOW |
Amazon Web Services – Section 003
×Course Title | Amazon Web Services – Section 002 |
Course Number | 900-094-EQ-03 |
Platform | Cloud Technologies |
Duration | 30 hours |
Prerequisites | Windows and/or Linux Servers experience or knowledge |
Target Audience | Individuals currently working in IT with either Windows and/or Linux Servers experience |
Dates | March 20, 2021 – March 28, 2021 |
Instructor | Michael Hughes |
Room | Online Format / BH-311 |
Schedule | Saturday & Sunday: 9:00a.m. – 5:00p.m. (30 minute lunch) |
Gouvernement du Québec fee ( taxes incl.) | $60 |
General public fee (taxes incl.) | $541.88 |
Course Description: This course introduces the key concepts and services of Amazon Web Services |
NB: Certificate provided for all participants who have completed 80% of course hours |
Topics Covered in this Course:
· AWS Cloud concepts and basic global infrastructure
REGISTER NOW |
Container Based System Architecture: Docker – Section 001
×Course Title | Container Based System Architecture – Docker |
Course number | 900-090-EQ-01 |
Platform | Linux |
Duration | 15 hours |
Gouvernement du Québec fee (taxes incl.) | $30.00 |
General public fee (taxes incl.) | $270.94 |
Schedule | Saturday & Sunday : 9 a.m.-5 p.m. ( 30 minute lunch) |
Dates | January 9, 10 |
Prerequisites | Good Knowledge of 2016 Server |
Target audience | Individuals currently working in IT with either Windows and/or Linux Servers experience |
Instructor | Michael Hughes |
Location | Online format |
NB: This is a non-credit course. Certificate provided for all participants who complete 80% of course hours. | |
Course description Linux-based containers provide an isolated and portable operating environment that works consistently and repeatedly when deployed in development, staging or in production. |
|
Topics to be covered include: | |
Weekly Topics Please note that the instructor reserves the right to modify this schedule. |
|
· Fundamentals of containers
· Understanding how containers work explore some of the most commonly used cases of containers · Learn the basics about container hosts, container images and working with images registries |
|
· Day 1 | Container technology is an established technology. Various distributions of Linux can run Docker containers in your own environment or on the cloud.
In this course, you implement Containers on a Debian distribution of linux. You will deploy and manage containers on a Debian server |
Day 2 |
|
Time Permitting | · Examining the basics of Docker networking
· Docker Compose |
REGISTER NOW
Container Based System Architecture: Docker – Section 002
×Course Title | Container Based System Architecture – Docker |
Course number | 900-090-EQ-02 |
Platform | Linux |
Duration | 15 hours |
Gouvernement du Québec fee (taxes incl.) | $30.00 |
General public fee (taxes incl.) | $270.94 |
Schedule | Saturday & Sunday : 9 a.m.-5 p.m. ( 30 minute lunch) |
Dates | February 20 & 21, 2021 |
Prerequisites | Good Knowledge of 2016 Server |
Target audience | Individuals currently working in IT with either Windows and/or Linux Servers experience |
Instructor | Michael Hughes |
Location | Online format / BH-311 |
NB: This is a non-credit course. Certificate provided for all participants who complete 80% of course hours. | |
Course description Linux-based containers provide an isolated and portable operating environment that works consistently and repeatedly when deployed in development, staging or in production. |
|
Topics to be covered include: | |
Weekly Topics Please note that the instructor reserves the right to modify this schedule. |
|
· Fundamentals of containers
· Understanding how containers work explore some of the most commonly used cases of containers · Learn the basics about container hosts, container images and working with images registries |
|
· Day 1 | Container technology is an established technology. Various distributions of Linux can run Docker containers in your own environment or on the cloud.
In this course, you implement Containers on a Debian distribution of linux. You will deploy and manage containers on a Debian server |
Day 2 |
|
Time Permitting | · Examining the basics of Docker networking
· Docker Compose |
REGISTER NOW
Hyper-V
×Course Title | Hyper-V |
Course Number | 900-093-EQ-01 |
Platform | Windows |
Duration | 35 hours |
Gouvernement du Québec fee ( taxes incl.) |
$70 |
General public fee (taxes incl.) |
$632.19 |
Schedule | Monday, Tuesday, Wednesday: 6 p.m. -10 p.m. March 24: 6 p.m. -9 p.m. |
Dates | March 8, 9, 10, 15, 16, 17, 22, 23, 24 |
Prerequisites | Prior networking and installation experience |
Target Audience | Individuals currently working in IT either with Windows and /or Linux Servers |
Instructor | Michael Hughes |
Location | Online format |
NB: This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours
Recommended Textbook
Mastering Windows Server 2016 Hyper-V Paperback – Dec 9 2016 by John Savill Publisher: Sybex (Dec 19 2016) ISBN-10: 1119286182 ISBN-13: 978-1119286189
|
Course Description |
This course serves as an Introduction to the initial installation, configuration and management of Hyper-V.
|
Topics Covered in this Course | |
Weekly Topics
Please note that the instructor reserves the right to modify this schedule |
|
Module 1
|
Introduction to Microsoft Virtualization |
Module 2 | Hyper -V Infrastructure |
Module 3
|
Hyper-V Networking |
Module 4 |
Hyper-V Storage
|
Module 5 |
Hyper-V Management Hyper-V Availability and Live Migration
|
REGISTER NOW
Register Now
MICROSOFT APPLICATIONS
*Schedule subject to change
- VBA for Excel Details >
- Programming Basics (Concepts)
- History of VBA
- Record Macros and Modifying Macros
- Assign Macros to Toolbar, Buttons, Shortcut key
- Visual Basic Editor and its options
- Learn Procedures: Functions and Sub-routines
- Use of Ranges
- Use control Flow (Do…Loop, While; For… Next; Arrays and Loops and more)
- Learn R1C1 formulas
- Create simple dialog boxes
- Create complex forms
- Debugging code and handling errors
VBA for Excel
×Course Title | VBA for Excel |
Course Number | 900-047-EQ-02 |
Platform | Windows |
Duration | 27 hours |
Gouvernement du Québec fee (taxes incl.) |
$54 |
General Public fee (taxes incl.) |
$447.33 |
Schedule | Tuesday & Thursday – 6:30 p.m. – 9:30 p.m. |
Date | February 16, 18, 23, 25, March 2, 4, 9, 11, 16 |
Prerequisites | No programming experience is required however participants must have prior experience or knowledge ( Intermediate to Advanced Excel) in Microsoft Excel or spreadsheets |
Target Audience | Excels users wanting to automate tasks using VBA ( Visual Basic for Applications) |
Instructor | Javier Marchan |
Location | Online Format |
NB: This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours.
Excel VBA Programming for Dummies by John Walkrenbach
Course Description:
This course will focus on the fundamental concepts of VBA (Visual Basic for Application). The course will include a mixture of lectures and hands-on experience.
The following topics will be covered:
REGISTER NOW
Register Now
Eligibility
$2/hour – funded by Services Québec de l’Ile de Montréal
Am I eligible?
- Determine if you are eligible for the subsidized rate of $2 per hour.
Eligible Participants | Non-Eligible Participants |
|
|
Although individuals in the Greater Montreal area (Montréal, Laval, Laurentides, Lanaudière et Montérégie) are eligible to take these courses, individuals who live and/or work on the Island of Montreal have priority.
Participants cannot be registered in more than two (2) courses AT THE SAME TIME. However, a subsidized participant may apply for as many courses as they wish over the course of the year, just not more than two (2) simultaneously.
No more than three (3) employees from the same company may be registered in any one course at the same time.
Registration
How do I register?
Carefully read the eligibility requirements above. If you are ELIGIBLE for the course at the rate of $2/hr:
For each course for which you register:
Step 1
- Select the course found in the Schedule tab
- On the course page, click on the “REGISTER” button. This will take you to Mia, the online registration module
- In the left-hand column, select #1 “PART-TIME IT COURSES (SERVICES QUÉBEC)”
- Select the course from the resulting list
- Select “Add to cart”
- Select “Confirm registration and go to payment”
Step 2
- Login to your Omnivox account with your email address and password. If you do not have an account, select “First-time Access” to create on and fill in the required information in order to use the system for the first time.
- Complete the Registration Form
- Proceed to the payment for your course by credit card (Visa or MasterCard)
- A “Web registration receipt” will appear (you will receive this by e-mail as well)
Step 3
- In order to complete your registration, you MUST fill out the form required by the Gouvernement du Québec (a link to the form is provided in your e-mail receipt)
- NOTE: Your form will not be submitted until you have clicked on the “Confirm your answers” button at the end of the process
Upon receipt of your registration, the Centre for Continuing Education will review your registration form to confirm your eligibility.
If it is determined that you are not eligible for the subsidized rate of $2/hr, the Centre for Continuing Education will contact you. You will be required to pay the fee that is applicable to the General Public (see the course description) OR you may withdraw from the course with no penalty and a complete refund of any payment will be mailed to you.
If you are NOT ELIGIBLE for the course at the rate of $2/hr
Please note that priority is given to participants who meet the eligibility criteria. However, there may be space available to the General Public, at an additional cost (see course description for the exact cost). If you are interested in taking a course and you know in advance that you do not meet the eligibility criteria, please follow the steps above.
Note:
- You will still need to complete the mandatory form required by Services Québec, in order for your registration to be processed
- In this form, respond “NO” to the question “I meet the eligibility requirements…”. You will be redirected to the end of the form
- The Centre for Continuing Education will review your form and the registration module will apply the non-subsidized cost for the course (General Public fee) to your Omnivox account
- You will be notified by e-mail to proceed to the online registration module, to pay your balance
Important Information:
- The Centre for Continuing Education will confirm receipt of your application form and payment via email
- You will receive an email approximately 5 working days before the class starts, providing all course details including class location
- You cannot register for more than 2 courses AT THE SAME TIME. However, a subsidized participant can apply for as many courses as they wish over the course of the year, just not more than 2 simultaneously
- We cannot accept more than three employees from the same company in the same course
- The cost of manuals or textbooks is not included in the course fees, unless otherwise indicated.
- Taxes are included in course fees.
The part-time IT specialized courses are popular and have very limited spaces available. Register early to avoid disappointment. Please refer back to the website often for regular updates & information and Services Québec specific eligibility requirements.
If you experience technical problems with our online registration module for part-time IT courses, please call 514-457-5036 or e-mail conted@johnabbott.qc.ca.
Refund Policy
The Centre for Continuing Education reserves the right to cancel any course due to insufficient registration prior to the start of classes. Participants registered in a cancelled class will be contacted and receive a full refund for the course. If the Centre for Continuing Education determines that a participant is not eligible for the course at the reduced rate of $2 / hour, the participant will be notified and may pay the balance of the fee offered to the general public, or receive a full refund. Tuition fees for non-credit IT courses offered in collaboration with the Services Québec are refundable upon receipt of written notification as follows:
- Full refund 7 days or more before the first scheduled class
- No refund 6 days before the first scheduled class
For withdrawal requests, all applicants are required to notify the Centre for Continuing Education in writing, as soon as possible at: iteq@johnabbott.qc.ca.