*Schedule subject to change

• CCNA Cisco –level 1 Details >

CCNA Cisco –level 1

×

Course Title	CCNA Cisco –level 1
Course Number	900-103-EQ-01
Duration Platform   Gouvernement du Quebec fee ( taxes incl.)	56 hours Windows     $112.00
General public fee (taxes incl.)	$1,014.08
Schedule	Monday ,Tuesday & Thursday : 6 p.m. – 10:00 p.m.
Dates	September 7 to October 5 Class on Wednesday, September 8
Prerequisites	Have a very good working knowledge of the Windows environment and the Internet
Target Audience	Computer network technicians; computer engineering, engineers; IT consultants Cisco level 1 is the first of 3 courses that train individuals to provide level 1, 2, 3 Network and Technical Support in companies. This course is the first of three courses that prepare participants to write the CCNA exam. It is recommended that participants register for level 1, 2, 3 of the CCNA courses
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
	By the end of this course, the participant will have learned about the key concepts of switching and routing technologies in small business networks, wireless local area networks (WLANs) as well as security concepts. The student will have learned the basics of network configuration and troubleshooting, how to identify and counter threats on the LAN, and how to configure and secure a basic WLAN.

 

Teaching Methods
	A combination of theory and practical exercises with the use of Cisco quizzes and exams online to prepare for industry certification in the CCNA A certificate of participation is given to people who have attended 80% of the training hours. Participants who score above 75% on online final Cisco Exams in certain modules are eligible for a 60% % reduction on the price of the CCNA exam.  It is recommended that participants register for level 1, 2, 3 of the CCNA courses

 

Required Text / Course Materials

Online Access to the Cisco Curriculum

 

 

Topics Covered in this Course
	Networking Concept Overview Network components Network topologies and representations Internet connections Reliable networks Network trends Network security Basic configuration of Cisco switches IP addressing configuration Protocol suites Reference models Role of the physical layer Characteristics of the physical layer Review of Network cabling standards Wireless Technologies Binary system and Hexadecimal system Practical module and questionnaire Data Link Layer Introduction to Routing Configuration of a Cisco router IPv4 addressing Network segmentation VLSM IPv6 addressing Network testing commands Transport layer Application, Presentation and Session Layers Fundamentals of Network Security Threats and security breaches Network attacks Mitigation of network attacks Troubleshooting methodologies and scenarios

 

 

REGISTER NOW

• CCNA Cisco –level 2 Details >

CCNA Cisco –level 2

×

Course Title	CCNA Cisco –level 2
Course Number	900-104-EQ-01
Duration Platform   Gouvernement du Quebec fee ( taxes incl.)	56 hours Windows     $112.00
General public fee (taxes incl.)	$1,014.08
Schedule	Monday ,Tuesday & Thursday : 6 p.m. – 10:00 p.m.
Dates	October 12 to November 11
Prerequisites	Completion of CCNA Level 1 –version 7 or equivalent knowledge Have a very good working knowledge of the Windows environment and the Internet
Target Audience	Computer network technicians; computer engineering, engineers; IT consultants Cisco level 2 is the second of 3 courses that train individuals to provide level 1, 2, 3 Network and Technical Support in companies. This course is the second of three courses that prepare participants to write the CCNA exam. It is recommended that participants register for level 1, 2, 3 of the CCNA courses
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
	By the end of this course, the participant will have learned about the key concepts of switching and routing technologies in small business networks, wireless local area networks (WLANs) as well as security concepts. The student will have learned the basics of network configuration and troubleshooting, how to identify and counter threats on the LAN, and how to configure and secure a basic WLAN.

 

Teaching Methods
	A combination of theory and practical exercises with the use of Cisco quizzes and exams online to prepare for industry certification in the CCNA A certificate of participation is given to people who have attended 80% of the training hours. Participants who score above 75% on online final Cisco Exams in certain modules are eligible for a 60% % reduction on the price of the CCNA exam.  It is recommended that participants register for level 1, 2, 3 of the CCNA courses

 

Required Text / Course Materials

Online Access to the Cisco Curriculum

 

 

Topics Covered in this Course
	Basic Cisco and router device configuration Secure remote access Verification of directly connected networks Switching concepts Overview of virtual local area networks (VLANs) VLANs in a multi-switch environment VLAN configuration VLAN trunks DTP (Dynamic Trunking Protocol) Inter-VLAN routing Inter-VLAN routing with the Router-on-a-stick method Configure inter VLAN routing using Layer 3 switches Troubleshooting inter-VLAN routing STP Concepts Operation of the STP protocol EtherChannel Concepts EtherChannel configuration EtherChannel verification and troubleshooting DHCPv4 concepts Configuration of a Cisco IOS DHCPv4 server SLAAC • DHCPv6 Configuring the DHCPv6 server First hop redundancy protocols HSRP Layer 2 security threats Implementation of Switch security Mitigation of DHCP attacks Mitigation of STP attacks Introduction to Wireless WLAN components Operation of a WLAN network Threats to the WLAN network Secure WLANs WLAN configuration WPA2-Enterprise configuration of a WLAN on the WLC Troubleshooting WLAN Network Problems Practice and summary of the module Routing concepts Packet forwarding Review of basic router configuration IP routing table Static and dynamic routing Configuration of static IP routes Configuration of default static IP routes Configuration of static floating routes Configure static host routes Troubleshooting static and default route configuration

 

 

REGISTER NOW

• CCNA Cisco –level 3 Details >

CCNA Cisco –level 3

×

Course Title	CCNA Cisco –level 3
Course Number	900-105-EQ-01
Duration Platform   Gouvernement du Quebec fee ( taxes incl.)	56 hours Windows     $112.00
General public fee (taxes incl.)	$1,014.08
Schedule	Monday ,Tuesday & Thursday : 6 p.m. – 10:00 p.m.
Dates	November 15 – December 14
Prerequisites	Completion of CCNA Level 1 & level 2–version 7 or equivalent knowledge Have a very good working knowledge of the Windows environment and the Internet
Target Audience	Computer network technicians; computer engineering, engineers; IT consultants Cisco level 3 is the last of 3 courses that train individuals to provide level 1, 2, 3 Network and Technical Support in companies. This course is the second of three courses that prepare participants to write the CCNA exam. It is recommended that participants register for level 1, 2, 3 of the CCNA courses
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
	By the end of this course, the participant will have seen the architecture, components, operations, and security of large complex networks, including wide area network (WAN) technologies. The course emphasizes network security concepts and introduces network virtualization and automation. The participant will learn how to configure, troubleshoot, and secure corporate network devices. The participant will learn how application programming interfaces (APIs) and configuration management tools enable network automation and will have a solid understanding of networking concepts and skills.

 

Teaching Methods
	A combination of theory, practical and online quizzes and exams. A certificate of participation is given to people who have attended 80% of the training hours. At the end of this training (Cisco level 1, 2 & 3), the participant will be ready to take the Cisco CCNA certification exam. Participants who score above 75% on online final Cisco Exams in certain modules are eligible for a 60% % reduction on the price of the CCNA exam.

 

Required Text / Course Materials

Online Access to the Cisco Curriculum

 

 

Topics Covered in this Course
	OSPFv2 concepts: Single Area OSPFv2 and Multiarea OSPFv2 Network security concepts ACL Access Control Lists Concepts Configure ACLs for IPv4 NAT for IPv4 WAN Concepts VPN and IPsec concepts Qo’s Concepts Network management Network architecture and troubleshooting Network virtualization and Network automation

 

 

REGISTER NOW

---

Register Now

*Schedule subject to change

• Management and Processing of Big Data–Level I Details >

Management and Processing of Big Data–Level I

×

Course Title	Management and Processing of Big Data – Level I
Course Number	900-058-EQ-01
Platform	Linux
Duration	48 hours
Gouvernement du Québec fee (taxes incl.)	$96
General Public fee (taxes incl.)	$869.21
Schedule	Saturday: 9 a.m.- 3:30: p.m. (30 minute lunch)
Dates	Saturday: October 16 – December 4
Prerequisites	Comfortable in Linux environment, some programming experience is required (ideally JAVA )
Target Audience	Data base analysts and administrators, IT analysts and consultants, programmers and developers, computer engineers, computer network technicians
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

• 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

Components of Hadoop: Basic Concepts and HDFS

• Installation, configuration and setup of Single Node 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

Hadoop MapReduce Framework

• MapReduce Architecture
• What is YARN?
  YARN components
  YARN Architecture
• Input splits, HDFS blocks
• Distributed Cache

Apache Sqoop

• What is Sqoop? Why do we need it?
• Sqoop Architecture
• Importing and exporting data from RDBMS
• Hands-on Sqoop commands

Apache Hive – Analysis and Data Warehousing tool in Hadoop Ecosystem

• What is Hive? – Architecture & Components Overview
• Hive history and its components
• Comparison with Traditional Database
• Hive Installation and Configuration on Google Cloud
  Hive Meta-store & Engine Configuration.
• Hive Data Types and Data Models
• Hands on Hive – orderBy, clusterBY, distributeBy and so on
• Data Manupulation with Hive
• Hive SerDe
• Hive – internal vs external tables
• Different file formats – Avro, JSON, parquet, RC, ORC

Hive Case Study – Olympic Data analysis

Apache Hive Advanced – Optimization

• Partitioning and Bucketing
• Optimized advanced Joins.
• Indexes and Views
• Analytical and window functions in Hive – rank, dense_rank, lag, lead.

Hive Case Study – Retail data analysis, Consumer Complaints analysis

Apache HBase – Introduction to NoSQL DataBase

• Difference between RDBMS and NOSQL
• HBASE architecture
• HBase – Hands On

Integration of Hadoop Ecosystem

• Integrate with Sqoop and Hive
• Integrate with Hive and HBase

REGISTER NOW

• Management and Processing of Big Data – Level 2 Details >

Management and Processing of Big Data – Level 2

×

Course Title	Management and Processing of Big Data – Level II
Course Number	900-068-EQ-01
Platform	Linux
Duration	45 hours
Gouvernement du Québec fee (taxes incl.)	$90
General Public fee (taxes incl.)	$814.89
Schedule	Saturday: 9 a.m. – 4 p.m. (30 minute lunch) Sunday: 9 a.m. – 12 p.m.
Dates	WINTER 2022
Prerequisites	Absolute prerequisite: Management and Processing of Big Data – Level I
Target Audience	Database analysts and administrators , IT analysts and consultants, programmers and developers, computer engineers, computer network technicians
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 enable 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

• What is Apache Spark and why is it needed?
• Spark VS Hadoop
  How does Spark fit in Hadoop Ecosystem?
• Spark Use Case

Brief Introduction to Python for Apache Spark

• 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

Functions, OOPS in Python

• Lambda functions
• Object Oriented Concepts
• Standard Libraries and Modules used in Python
• Hands-On

Deep Dive into Apache Spark

• Spark Architecture and its Components
  Understanding SparkContext, SparkSession, Driver, Stages and Tasks.
• Spark features and characteristics
• Installation of Apache Spark in windows
• Introduction to PySpark Shell and how to submit a PySpark Job
• Brief discussion on Spark Web UI

Spark RDDs

• What are RDDs, features and characteristics.
• RDDs Transformations and Actions
• Key-Value Pair RDDs and operations
• Brief discussion on RDD Lineage
• RDD Partitioning
  Coalesce
  Repartition
• Hands-On
  Read and write data using RDDs
  Use cases on map, flatMap, reduceByKey, aggregateBykey, groupByKey, fold, sortByKey

Case Study on Spark RDDs

DataFrames and Spark SQL

• 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
• Case Study:
  Stock Market data analysis
  Aviation data analysis
  How to use complex Joins to make analysis

Additional Topics to be covered if time permits:

• Integrate Spark with Cloud Services (Mostly GCP)
• Spin up a Databricks cluster in GCP
• How to read data from BigQuery to Spark DataFrames and perform data analysis

 

REGISTER NOW

 

 

 

 

• Processing of Big Data with SPARK Details >

Processing of Big Data with SPARK

×

Course Title	Processing of Big Data with SPARK
Course Number	900-107-EQ-01
Platform	Linux
Duration	30 hours
Gouvernement du Québec fee (taxes incl.)	$60
General Public fee (taxes incl.)	$543.26
Schedule	Saturday & Sunday 9:00 a.m. – 3:30 p.m. (30 minute lunch)
Dates	WINTER 2022
Prerequisites	Management and Processing of Big Data-level I and level 2 Basic SQL. Good understanding of any of the following Python/Java/Scala Knowledge of Linux Shell Commands. Hive and HDFS
Target Audience	Data engineer/architect; Big data developer; Enterprise application developer
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

Recommended Textbook

We will not follow any specific Textbook

Course Description:

Spark is an open source distributed processing engine built around speed, ease of use, and analytics. Its unique in-memory data processing technique reduces processing time drastically compared to a typical MapReduce program. It has well integrated APls for Batch, SQL, Streaming, Machine Learning and Graph processing in popular programming languages including Java, Scala, Python and R. These advantages made it top level Apache project in 2014.

This course will help you understand and practice various transformation and action Spark APls for data processing pipeline. You will also get familiar with data holder APls including RDD, Dataframe and Dataset.

Topics Covered in this Course:

• Introduction to Apache Kafka
  • Kafka and its importance in Big Data field
  • Configuring Kafka Cluster
  • Kafka features, concepts, architecture and components.
  • Kafka Producer, Consumer, and Kafka Internals.
  • Hands-On
    • How to produce messages?
    • How to consume messages?

  Apache Spark Streaming

  • What is Spark Streaming and why is Streaming necessary?
  • Brief overview on DStreams and Transformation on DStreams
  • Spark Streaming Features and Workflow
  • Window Operators
  • Slice, Window, ReduceByWindow Operators Stateful Operators
  • Hands-On
    • Twitter Hash Tag analysis

  Machine Learning using Spark MLLib

  • What is Machine Learning and why is it needed?
  • Where is Machine Learning used?
    • Different Types of Machine Learning Techniques
  • Introduction to MLlib
  • Various ML algorithms supported by MLlib
  • Hands-On
    • Supervised Learning: Linear Regression, Logistic Regression, Decision Tree, Random Forest
    • Unsupervised Learning: K-Means Clustering and how it works with MLlib?

REGISTER NOW

• BIG DATA Reporting and Prediction Details >

BIG DATA Reporting and Prediction

×

Course Title	BIG DATA – Reporting and Prediction
Course number	900-059-EQ-01
Platform	MS teams, Tableau Public & 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	September 14, 16, 21, 23, 28, 30, October 5, 7, 12, 14, 19, 21, 26, 28, November 2
Instructor	Diego Perea  – Ph.D.
Room	Online format
Schedule	Tuesday & Thursday : 6:30-9:30
Gouvernement du Québec fee (taxes incl.)	$90.00
General public fee (taxes incl.)	$814.89

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 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

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: Google Big Query Connecting analytics to Big Data distributed processing systems Forecasting and prediction. Introduction to machine learning.

 

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.

1. Uber trip data: trip information including Uber service type, source, destination, distance, duration and paid fare. Example

https://public.tableau.com/views/Lab4-DatacharacterizationA-categoricalfields/Dashboard2

2. On-line store purchasing behavior data: Characterization of on-line purchasing behavior. Example:

https://public.tableau.com/views/Lab3-Gizmoon-linestore/Dashboard2

3. Mobile video trending data: Characterization and trending analysis of video consumption from mobile devices. Example:

https://public.tableau.com/shared/XX6T2DZZ2

4. Google Cloud NOAA data: Worldwide meteorological information including temperature, wind and rain for more than 60 years. Example:

https://public.tableau.com/shared/D3MPD5GYH

5. Google Cloud Shakespeare data: word count of all Shakespeare works. Example:

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

*Schedule subject to change

• SQL – Introduction Details >

SQL – Introduction

×

Course Title	SQL – Introduction
Course Number	900-002-EQ-01
Platform	Windows
Duration	24 hours
Gouvernement du Québec fee (taxes incl.)	$48
General Public fee (taxes incl.)	$434.61
Schedule	Monday & Wednesday: 6:00 p.m. – 10:00 p.m. Saturday: 9:00 a.m. – 1:00 p.m.
Dates	September 8, 11, 13, 15, 18, 20
Prerequisites	Basic knowledge of the Windows operating system
Target Audience	Individuals willing to get into the software development career, and are new to database development, database analysts and administrators.
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 hands-on course examines the database and design concepts, introduces SQL Structure Query Language (SQL) and explores the concept of relational database management systems. It also covers 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

• Relational database management systems (RDBMS)
• Structure of Relational Databases
• Introduction to SQL Languages: data-definition language (DDL), and data-manipulation language (DML), and Data-Control language (DCL)
• Database design
• Keys and Constraints
• Entity Relationship Diagram
• Normalization of Database Tables

REGISTER NOW

• SQL – Intermediate Details >

SQL – Intermediate

×

Course Title	SQL – Intermediate
Course Number	900-006-EQ-01
Platform	Windows
Duration	24 hours
Gouvernement du Québec fee (taxes incl.)	$48
General Public fee (taxes incl.)	$434.61
Schedule	Wednesday: 6:00 p.m. – 10:00 p.m. Saturday: 9:00 a.m. – 1:00 p.m.
Dates	September 22, 25, 27, 29; October 2, 4
Prerequisites	SQL – Introduction 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. More specifically, this course is intended for Database Administrators, Database Developers, and Business Intelligence professionals.
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 instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Topics to be covered

• Introduction to SQL Server and its Toolset
• Introduction to T-SQL language
• 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

REGISTER NOW

• SQL – Advanced Details >

SQL – Advanced

×

Course Title	SQL – Advanced
Course Number	900-024-EQ-01
Platform	Windows
Duration	24 hours
Gouvernement du Québec fee (taxes incl.)	$48
General Public fee (taxes incl.)	$434.61
Schedule	Monday & Wednesday; 6:00 p.m. – 10:00 p.m. Saturday: 9:00 a.m. – 1:00 p.m.
Dates	October 13, 16, 18, 20, 23, 25
Prerequisites	SQL-Introduction and SQL Intermediate courses or working knowledge of relational databases
Target Audience	Participants interested in acquiring the knowledge and skills needed to implement a Microsoft SQL Server database. More specifically, this course is intended for Database Administrators, Database Developers, and Business Intelligence professionals.
Instructor	Khattar Daou
Location	Online format

 

N.B.: This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours.

 

Description:

In this level, participants will continue to learn advanced techniques for building and designing databases using Microsoft SQL server.

Topics to be covered:

• Creating views
• T-SQL view statements: create, alter, and encrypt views
• T-SQL stored procedures: System and user-defined procedures
• Create and alter stored procedures
• T-SQL triggers: Create and Modify triggers
• T-SQL built-in and user defined functions
• Create and manage transactions

REGISTER NOW

• SQL – Reporting Services (SSRS) Details >

SQL – Reporting Services (SSRS)

×

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.)	$434.61
Schedule	Monday & Wednesday: 6:00 p.m. – 10:00 p.m. Saturday: 9:00 a.m. – 1:00 p.m.
Dates	October 27, 30; November 1, 3, 6, 8
Prerequisites	SQL – Intermediate, SQL – Advanced and/or experience with Microsoft SQL Server
Target Audience	This course is intended for database professionals who need to fulfill a Business (BI) Intelligence Developer role to create reporting solutions.
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 instructor led course describes how to empower information workers through self-service reporting. Students will learn how to deliver rich data visualizations with Microsoft SQL Server Reporting Services.

Topics to be covered:

• Introduction to Business Intelligence and Data Modeling
• Implementing Reports with SQL Server Reporting Services
• Create and modify reports with Report Designer
• Create and modify reports with Report Builder
• Group and summarize data
• Use parameters to filter data
• Manage report execution and delivery
• Create reusable report items that simplify self-service reporting.

REGISTER NOW

• SQL – Analysis Services (SSAS) Details >

SQL – Analysis Services (SSAS)

×

Course title	SQL Analysis Services (SSAS)
Course number	900-049-EQ-01
Platform	Windows
Duration	24 hours
Emploi-Québec fee (taxes incl.)	$48
General public fee (taxes incl.)	$434.61
Schedule	Monday & Wednesday: 6:00 p.m. – 10:00 p.m. Saturday: 9:00 a.m. – 1:00 p.m.
Dates	November 10, 13, 15, 17, 20, 22
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 need to build BI solutions using Microsoft SQL Server Analysis Services.
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 instructor led course describes how to develop and deploy a SQL Server Analysis Services project. Students 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:

• Introducing Microsoft SQL Server Analysis Services (SSAS)
• Creating Analysis Services Tabular Project
• Creating Analysis Services multidimensional Project
• Understanding Data Analysis Expressions (DAX)
• Understanding Multidimensional Expressions (MDX)
• Creating Data Sources and Data Source Views
• Working with Cubes and Dimensions
• Creating and managing calculations, measures, and Key Performance Indicators that help users analyze model data
• Creating and managing perspectives and hierarchies that help users more easily browse model data by providing business and application specific view points
• Creating partitions that divide table data into smaller logical parts that can be processed independent

REGISTER NOW

• SQL – Integration Services (SSIS) – Introduction Details >

SQL – Integration Services (SSIS) – Introduction

×

Course Title	SQL – Integration Services (SSIS) – Introduction
Course Number	900-083-EQ-01
Platform	Windows
Duration	21 hours
Gouvernement du Québec fee (taxes incl.)	$42
General Public fee (taxes incl.)	$380.28
Schedule	Monday & Wednesday: 6:00 p.m. – 9:30 p.m. Saturday: 9 a.m. – 12:30 p.m.
Dates	November 24, 27, 29; December 1, 4, 6
Prerequisites	SQL Intermediate or working knowledge of relational databases (database design skills)
Target Audience	This course is intended for database professionals who need to fulfill a Business (BI) Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation and ETL.
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 instructor led course provides students with the knowledge and skills to use SSIS Designer to create a simple Microsoft SQL Server Integration Services solution. Students will learn how to create a data warehouse with Microsoft SQL Server, implement ETL with SQL Server Integration Services.

 

Topics to be covered:

• Developing SSIS packages for data extraction, transformation, and loading
• Implement Data Flow in an SSIS Package
• Implement Control Flow in an SSIS Package
• Debug and Troubleshoot SSIS packages
• Extend SSIS with custom scripts
• Deploy and Configure SSIS packages

REGISTER NOW

• SQL – Integration Services (SSIS) – Advanced Details >

SQL – 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.)	$253.52
Schedule	Monday & Wednesday: 6:00 p.m. – 9:30 p.m. Saturday: 9 a.m. – 12:30 p.m.
Dates	December 8, 11, 13, 15
Prerequisites	SQL Server Integration Services (SSIS) – Advanced
Target Audience	This course is targeted at BI professionals with experience of implementing solutions with SQL Server Business Intelligence.
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

 

Course Description

This instructor led 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.

Topics to be covered

Overview of Data Warehousing Describe the key elements of a data warehousing solution Describe the key considerations for a data warehousing project Implement a logical design for a data warehouse Implement a physical design for a data warehouse

REGISTER NOW

• SQL – Data Quality Services (DQS) Details >

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)	$380.28
Schedule	Monday & Wednesday: 6:00 p.m. – 10:00 p.m. Saturday: 9 a.m. – 2:30 p.m. (30-minute lunch)
Dates	Winter 2022
Prerequisites	SQL Intermediate or working knowledge of relational databases (database design skills)
Target Audience	This course is intended for database professionals who need to fulfill a Business (BI) Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including data cleansing by using Data Quality Services.
Instructor	Khattar Daou
Location	Online format

Please note that this is a non-credit course. Certificate provided for participants who have completed 80% of course hours

Course Description

This instructor led course describes how to use SQL Server Data Quality Services (DQS) to cleanse, match, standardize, and enrich data, so you can deliver trusted information for business intelligence, a data warehouse, and transaction processing workloads.

 

Topics to be covered:

Implement data cleansing by using Microsoft Data Quality Services. Describe how Data Quality Services can help you manage data quality Use Data Quality Services to cleanse your data Use Data Quality Services to match data Describe the need for data quality management Describe the feature and components of Data Quality Services

 

 

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

*Schedule subject to change

• Python – level 1 – section 1 Details >

Python – level 1 – section 1

×

Course Title	Python Level 1
Course Number	900-051-EQ-01
Platform	Windows
Duration	24 hours
Gouvernement du Québec fee (taxes incl.)	$48
General Public fee (taxes incl.)	$434.61
Schedule	Monday & Wednesday : 6 p.m. – 9:30 p.m.
Dates	August 30; September 1, 8, 13, 15, 20, 22 First class on August 30: 6:30 p.m. – 9:30 p.m. No class on September 6 : Labor Day
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

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 introduces the Python language and basic software development and problem solving practices.

Topics to be covered:

• Introduction to the Python language
• The programming environment (Interpreter, IDE, Web IDE)
• Python basic data types and variables
• Operators
• User input and output
• Conditional Statements
• Loops and iteration
• More data types (Lists, dictionaries)
• Functions and scopes
• Working with Files and OS
• Exception Handling

REGISTER NOW

• Python ­- level 1 – section 2 Details >

Python ­- level 1 – section 2

×

Course Title	Python Level 1 – Section 2
Course Number	900-051-EQ-02
Platform	Windows
Duration	24 hours
Gouvernement du Québec fee (taxes incl.)	$48
General Public fee (taxes incl.)	$434.61
Schedule	Tuesday & Thursday: 6 p.m. – 9:30 p.m.
Dates	August 31; September 2, 7, 9, 14, 16, 21 First class on August 31: 6:30 p.m. – 9:30 p.m.
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

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 introduces the Python language and basic software development and problem solving practices.

Topics to be covered:

• Introduction to the Python language
• The programming environment (Interpreter, IDE, Web IDE)
• Python basic data types and variables
• Operators
• User input and output
• Conditional Statements
• Loops and iteration
• More data types (Lists, dictionaries)
• Functions and scopes
• Working with Files and OS
• Exception Handling

REGISTER NOW

• Python – level 2 – section 1 Details >

Python – level 2 – section 1

×

Course Title	Python – Level 2 – Section 1
Course Number	900-052-EQ-01
Platform	Windows
Duration	24 hours
Gouvernement du Québec fee (taxes incl.)	$48
General Public fee (taxes incl.)	$434.61
Schedule	Monday & Wednesday : 6 p.m. – 9:30 p.m.
Dates	September 27, 29; October 4, 6, 13. 18, 20 First class on September 27: 6:30 p.m. – 9:30 p.m. No class on Monday, October 11:Thanksgiving day
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

• 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

REGISTER NOW

• Python – level 2 – section 2 Details >

Python – level 2 – section 2

×

Course Title	Python – Level 2 – Section 2
Course Number	900-052-EQ-02
Platform	Windows
Duration	24 hours
Gouvernement du Québec fee (taxes incl.)	$48
General Public fee (taxes incl.)	$434.61
Schedule	Tuesday & Thursday : 6 p.m. – 9:30 p.m.
Dates	September 28, 30; October 5, 7, 12 ,14, 19 First class on September 28: 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é 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

• 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

REGISTER NOW

• Python – level 3 Details >

Python – level 3

×

Course Title	Python – Level 3
Course Number	900-062-EQ-01
Platform	Windows
Duration	30 hours
Gouvernement du Québec fee (taxes incl.)	$60
General Public fee (taxes incl.)	$543.26
Schedule	Monday & Wednesday : see schedule of dates / times below
Dates	November 17; December 13, 15 : 6:30 p.m. – 9:30 p.m. November 22, 24, 29; December 1, 6, 8 : 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

N.B.: 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:

• 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

REGISTER NOW

• JavaScript – Introduction Details >

JavaScript – Introduction

×

Course Title	Javascript – Introduction
Course Number	900-020-EQ-01
Platform	Microsoft Windows
Duration	45 hours
Prerequisites	Some prior programming experience is required. You’ll need to be familiar with HTML and CSS and have a reasonable level of understanding of JavaScript to follow the discussion.
Target Audience	Front-end developers who wish to improve their JavaScript skills.
Dates	October 21, 28; November 4, 11, 18, 25, 27; December 2, 4, 9, 11, 16
Instructor	Khattar Daou
Room	Online Format
Schedule	Thursday: 6 p.m. – 10 p.m. Saturday: 1 p.m. – 4 p.m.
Gouvernement du Québec fee ( taxes incl.)	$90
General public fee  (taxes incl.)	$814.89

Please note that 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 instructor-led training course is intended for those who want to learn JavaScript, understand JavaScript syntax and structures, create scripts that are easy to understand and maintain, and use tools to debug JavaScript.

 

 

Topics Covered in this Course:

Introduction to JavaScript JavaScript and Development Tools JavaScript Variables JavaScript Objects and Arrays JavaScript Functions and Context JavaScript and Events

REGISTER NOW 

---

Register Now

*Schedule subject to change

• Data Science – level 1 – section 1 Details >

Data Science – level 1 – section 1

×

Course Title	Data Science – Level 1 – Section 1
Course number	900-080-EQ-01
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	October 25, 27; November 1, 3, 8, 10, 15
Instructor	José Rafael Porras
Room	Online format
Schedule	Monday & Wednesday: 6 p.m. – 9:30 p.m. First class on October 25: 6:30 p.m. – 9:30 p.m.
Gouvernement du Québec fee	$48.00
General public fee	$434.61

Recommended textbook: Class Notes

NB: This is a non -credit course. 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. 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). Knowledge of conditionals, loops, functions, indexing, slicing, lists, dictionaries, tuples is essential.

 

Topics Covered in this Course

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

REGISTER NOW

• Data Science – level 1 – section 2 Details >

Data Science – level 1 – section 2

×

Course Title	Data Science – Level 1 – Section 2
Course number	900-080-EQ-02
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	October 26, 28 ; November 2, 4, 9, 11, 16
Instructor	José Rafael Porras
Room	Online format
Schedule	Tuesday & Thursday: 6 p.m. – 9:30 p.m. First class on October 26: 6:30 p.m. – 9:30 p.m.
Gouvernement du Québec fee	$48.00
General public fee	$434.61

Recommended textbook: Class Notes

NB: This is a non -credit course. 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. 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). Knowledge of conditionals, loops, functions, indexing, slicing, lists, dictionaries, tuples is essential.

 

Topics Covered in this Course

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

REGISTER NOW

• Data Science – level 2 Details >

Data Science – level 2

×

Course Title	Data Science – Level 2
Course number	900-081-EQ-01
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	November 23, 25, 30; December 2, 7, 9, 14, 16
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	$434.61

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.

Predictive Analytic methods are at the heart of this new 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

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.

 

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 Machine learning in GCP

 

SOFTWARE TO BE USED

For the course, we will mainly use Python, which is the industry standard for statistical learning that 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

---

Register Now

*Schedule subject to change

• Managing a Cloud Computing Project Details >

Managing a Cloud Computing Project

×

Course Title	Managing a Cloud Computing Project
Course Number	900-064-EQ-01
Platform	Windows
Duration	30 hours
Gouvernement du Québec fee (taxes incl.)	$60
General Public fee (taxes incl.)	$543.26
Schedule	Saturday & Sunday 9 a.m. –5 p.m. ( 30 minute lunch)
Dates	September 11, 12, 18, 19
Prerequisites	Basic understanding of networking concepts and the Internet
Target Audience	IT professionals
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

Textbook provided by the teacher.

Course Description

Please note that this is a non-credit course.

This training course uses mainly Microsoft Technology to help you in the understanding and building of the following topics: understanding the cloud; enabling Microsoft cloud services, configuring Microsoft cloud services; and supporting cloud users. Students who are beginning studies in cloud technology need a strong foundation in the basics before moving on to more advanced technology courses. The Google/Amazon platform will be used for specific presentations and for contrast. Upon completion of this course, participants will be familiar with key cloud services and terminology, Microsoft cloud services, Microsoft Office 365 and be able to use, configure, or support parts of other key Microsoft technologies for cloud services. In addition to the theoretical expose, participants will have hands on practice with virtualization and nested virtualization. Based on specific interest the student will have access to and in most cases be able to use such services as Teams, Yammer, Blog, Sway, Forms, Site web applications, Onedrive, Skype PowerApps, Planner Intune, BI , Staff Notes just to mention a few. In general the student will have access to and use most services provided with Office 365 Business.

Topics Covered in this Course

The Seven Business Models – evolution to Cloud computing i. Software Economics ii. Cloud Computing iii. Internet of Things (IoT) Cloud Computing is a business model and virtualization is a technology When and how should Office 365 be used Relationship between datacenters and cloud explained Changes to computer thinking and IoT Hands-on exercises are done using Office 365 and visualization software. (Each student has a JAC O365 account and will be provided with most software and documents as is available to the College.) “What is Cloud Computing?” · Defining Cloud Computing· Understanding Distributed Application Design· Understanding Resource Management Automation· Understanding Virtualized Computing Environments· Understanding High-Performance Computing Environments· Understanding Cloud Computing TechnologiesThis session introduces the basic characteristics of cloud computing

Chapter 2, “Cloud Models” Planning Organizational Roles in the Cloud Identifying Cloud Deployment Models Including Future Cloud Models This session introduces the four basic cloud deployment models – public, private, community and hybrid.

Chapter 3, “Service Models” Categorizing cloud services Examining Software as a Service Examining Platform as a Service Examining Infrastructure as a Service Identifying Emerging Cloud Database Capabilities Defining Everything as a Service This session introduces the three basic cloud service models – Software as a Service (SaaS), Platform as a Service (PaaS) and Infrastructure as a Service (IaaS). It also introduces other as a service cloud models, such as Database as a Service (DBaaS) and Everything as a Service (XaaS).

Chapter 4, “Current Cloud Technologies” Comparing Traditional Technologies and Cloud Alternatives Accessing the Cloud Leveraging Software as a Service Developing within Platform as a Service Implementing Infrastructure as a Service Empowering Mobile Computing This session gives examples of each of the three main cloud service models used.

Chapter 5, “Cloud Business Value” Identifying Business Driver for Cloud Computing Examining the Business Impact This session looks at how to evaluate the possible benefits of cloud computing to a business from an organizational and financial point of view.

 

REGISTER NOW

• Microsoft Azure – Fundamental Concepts Details >

Microsoft Azure – Fundamental Concepts

×

Schedule Saturday & Sunday : 9 a.m.-5 p.m. ( 30 minute lunch)

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.)	$814.89
Dates	October 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: 1. Describe cloud computing, Azure, and Azure subscriptions. 2. Create Azure Hands-on Lab (HOL) 3. Create and configure VMs in Microsoft Azure using HOL 4. Create an Azure virtual network using HOL 5. Describe Azure AD. 6. Describe and create a simple Azure Web App(s) using Visual Studi0

 

Topics Covered in this Course

Weekly Topics Please note that the instructor reserves the right to modify this scheduleModule 1: Getting Started with Microsoft AzureThis 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 Details >

Amazon Web Services

×

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	September 25, 26; October 2, 3
Instructor	Michael Hughes
Room	Online Format
Schedule	Saturday & Sunday : 9 a.m.-5 p.m. ( 30 minute lunch)
Gouvernement du Québec fee ( taxes incl.)	$60
General public fee  (taxes incl.)	$543.26

 

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 ·       The key services on the AWS platform and their common use cases (e.g., compute, analytics, etc.) ·       Basic AWS Cloud architectural principles ·       Basic security and compliance aspects of the AWS platform and the shared security model ·       Billing, account management, and pricing models ·       Sources of documentation or technical assistance (e.g., whitepapers, support tickets, etc.) ·       The AWS Cloud value proposition ·       Core characteristics of deploying and operating in the AWS Cloud   REGISTER NOW

• Container Based System Architecture: Docker Details >

Container Based System Architecture: Docker

×

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.)	$271.73
Schedule	Saturday & Sunday : 9 a.m.-5 p.m. ( 30 minute lunch)
Dates	November 20, 21
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 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
Day  2	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
Time Permitting	·         Examining the basics of Docker networking ·         Docker Compose

REGISTER NOW

• Hyper-V Details >

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.)	$633.80
Schedule	Wednesday, November 3: 6 p.m. -10 p.m. Saturday & Sunday: 9 a.m. – 5:15 p.m. (30 minute lunch)
Dates	November 3, 6, 7, 13, 14
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

• VMware Details >

VMware

×

Space is limited. Register early to avoid disappointment.

Course Title	VMware
Course Number	900-066-EQ-01
Platform	VMWare
Duration	36 hours
Gouvernement du Québec fee (taxes incl.)	$72
General Public fee (taxes incl.)	$651.91
Schedule	Saturday & Sunday: 9 a.m.-5 p.m. ( 30 minute lunch) Sunday, December 12: 9 a.m. -3:30 p.m. ( 30 minute lunch) No class on Saturday, December 4
Dates	November 27, 28; December 5, 11, 12
Prerequisites	Prior networking and server installation experience
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 have completed 80% of course hours.

 

Recommended textbook:

Mastering VMware vSphere 6.7 1st Edition

by Nick Marshall (Author), Mike Brown (Author), G. Blair Fritz (Author), Ryan Johnson (Author) Publisher : Sybex; 1st edition (November 6, 2018)

ISBN-10 : 1119512948

ISBN-13 : 978-1119512943

 

Course Description:


This course Serves as an Introduction to the initial installation, configuration, and management of VMware vSphere®, which consists of VMware ESXi™ and VMware® vCenter Server™. This course covers VMware ESXi 7.0/ and 6.7 and vCenter Server 7.0 and 6.7

 

Topics Covered in this Course:

Module 1

• Deploy an ESXi host
• Using VCenter Server manage ESXi hosts, storage, networking and Virtual Machines

Module 2

• Deploy and manage thin-provisioned virtual machines
• Migrate virtual machines with VMware vSphere® vMotion®
• Management using VMware vSphere® Web Client and VMware vSphere® Client™

Module 3

• Deploy and manage thin-provisioned virtual machines
• Migrate virtual machines with VMware vSphere® vMotion®

Module 4

Using vCenter Server Manage access control and Monitor resource usage

REGISTER NOW

---

Register Now

*Schedule subject to change

• VBA for Excel Details >

VBA for Excel

×

Course Title	VBA for Excel
Course Number	900-047-EQ-01
Platform	Windows
Duration	27 hours
Gouvernement du Québec fee (taxes incl.)	$54
General Public fee (taxes incl.)	$448.26
Schedule	Tuesday & Thursday – 6:30 p.m. – 9:30 p.m.
Date	October 19, 21, 26, 28; November 2, 4, 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:

• 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

REGISTER NOW

---

Register Now

*Schedule subject to change

• Windows Server 2019 Details >

Windows Server 2019

×

Title	Windows Server 2019
Course Number	900-099-EQ-01
Platform	Windows
Duration	35 hours
Gouvernement du Québec fee (taxes incl.)	$70
General Public fee (taxes incl.)	$633.80
Schedule	Tuesday & Thursday: 6:30 p.m.- 9:30 p.m.
Dates	September 7 – October 14 / Last class on October 14: 6:30 p.m. – 8:30 p.m.
Prerequisites	Familiarity with modern Windows operating systems (Windows 7/8 or 10) Basic knowledge of servers
Target Audience	Individuals seeking to acquire additional knowledge of how to implement Microsoft Servers within existing Microsoft networks.
Instructor	Aref Mourtada
Location	Online format

NB: This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours

Recommended Reference textbooks:

Windows Server 2019 Inside Out Paperback – Oct 24 2019
by Orin Thomas (Author) Product details
Paperback: 912 pages
Publisher: Microsoft Pr (Oct. 24 2019)
Language: English
ISBN-10: 0135492270
ISBN-13: 978-0135492277

Exam Ref 70-742 Identity with Windows Server 2016
Published 3/20/2017 1st Edition 384 pages
Book 978-0-7356-9881-9 eBook 978-0-7356-9757-7

This is an introductory course focused on how to install and configure Windows Server 2019 for use in enterprise networks.  The course will include a mixture of lectures and hands-on experience.

Topics to be covered include:

• Intro to Windows Networking
• Intro to Windows Server
• Installing Windows Server
• Configuring Windows Server
• Configuring Local Storage
• Configuring File and Share Access
• Configuring Windows Firewall
• Intro to Active Directory / Domain Services

REGISTER NOW

• Windows Operating System Details >

Windows Operating System

×

Course title	Windows Operating System
Course number	900-072-EQ-01
Platform	Windows
Duration	30 hours
Emploi-Québec fee (taxes incl.)	$60,00
General public fee (taxes incl.)	$543,26
Schedule	Tuesday & Thursday 6:30 p.m.- 9:30 p.m.
Dates	October 26 – November 25
Prerequisites	Windows Server
Target audience	Individuals seeking to acquire additional knowledge of how to implement Microsoft Clients and servers within existing Microsoft networks.
Instructor	Aref Mourtada
Location	Online format
NB: This is a non-credit course.  Certificate provided for all participants who have completed 80% of course hours.

Recommended textbook

Exam Ref 70-698 Installing and Configuring Windows 10 with Practice Test
By Andrew Bettany, Andrew Warren Part of the Exam Ref series.
Published 10/20/2016 1st Edition 512 pages Book 978-1-5093-0504-9
eBook 978-1-5093-0509-4 

Course description:

This is an introductory course focused on how to install and configure Windows 10 Clients for use in enterprise networks.  The course will include a mixture of lectures and hands-on experience.

Topics to be covered :

Prepare for and perform Windows 10 installation
Configure devices and device drivers
Perform post-installation configuration
Implement Windows in the enterprise
Configure and support networking, storage, data access, and usage
Implement apps
Configure remote management
Configure updates, recovery, authorization, authentication, and management tools
Monitor Windows

REGISTER NOW

---

Register Now