201 Portage Avenue

18th floor, Portage Avenue, Winnipeg, Canada​ , R3B 3K6

Prime Business Location for Professionals and Clients Strategically positioned at the iconic intersection of Portage and Main, 201 Portage Avenue is an excellent choice for businesses that welcome frequent visitors. With on-site parking, a modern business lounge, and diverse dining options, this location ensures a seamless experience for clients and colleagues alike. Work in bright, spacious offices featuring floor-to-ceiling windows and outdoor terraces designed for comfort and productivity. When it’s time to unwind, explore Winnipeg’s rich heritage at The Manitoba Museum or indulge in shopping at Winnipeg Square Shopping Centre.

St. Mary

330 St. Mary Avenue, Winnipeg, Canada, R3C 3Z5

Quick link to Winnipeg James Armstrong Richardson International Airport 20 minutes away.

201 Portage Avenue

201 Portage Avenue - 18th Floor, Winnipeg, Canada, R3B 3K6

Based on the 18th floor of the most prestigious building in Winnipeg, 201 Portage Avenue business centre combines stunning architecture and modern style to create an elegant and upmarket corporate environment.

Explore Our Courses

MySQL Developer

 21 Hours
This instructor-led, live training in Manitoba (online or onsite) is aimed at advanced-level developers who wish to learn and use MySQL and database technologies for building web applications. By the end of this training, participants will be able to:
  • Write SQL queries to retrieve, filter, sort, and aggregate data.
  • Perform data manipulation operations such as inserting, updating, and deleting data.
  • Implement advanced SQL concepts such as subqueries, derived tables, and conditional logic.
  • Integrate MySQL with popular programming languages and execute queries from application code.
Read more...

Python in Data Science

 35 Hours
The training course will help the participants prepare for Web Application Development using Python Programming with Data Analytics. Such data visualization is a great tool for Top Management in decision making.
Read more...

SQL in MySQL

 14 Hours
  • How to build a query?
  • What is a relational database?
  • What is the structure and SQL commands?
Read more...

SQL Advanced in MySQL

 7 Hours
This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features.
Read more...

SQL Fundamentals

 14 Hours
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
  • how to write SQL queries
  • what relational databases are and how we can use them
  • what are relations and how to create them
  • the structure of data
  • differences between SQL dialects (Oracle, T-SQL, ANSI)
  • practical skills for writing queries
This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
Read more...

MySQL Administration

28 Hours
Audience: Any IT professionals who aspire to become DBAs or database support professionals on MySql Database on linx/windows platforms. Format: 40% theoretical/lectures, 60%Practical/hands on lab
Read more...

MariaDB Database Administration

 14 Hours
MariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties. The course explains how MariaDB Database works, what tools are available, how we can use them, how we can secure the MariaDB Database Server and configure it. During the training course you will learn how to manage user accounts and how the MariaDB Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
Read more...

Advanced MariaDB for High Availability and Performance

 28 Hours
In this instructor-led, live training in Manitoba, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering.
Read more...

MariaDB Galera Cluster Administration

 21 Hours
This course is intended for database administrators. The course presents options for High-Availability solutions using Galera Cluster. You will learn the basics of Galera technology, as well as more advanced topics and practical knowledge related to configuring, optimizing and administering a Galera Cluster.
Read more...

MySQL Database Administration

 14 Hours
MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties. The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
Read more...

MySQL / Galera

 21 Hours
This bespoke course has been designed specifically against the requirements provided by Now Managed Learning Services
Read more...

Percona Server dla MySQL

 14 Hours
The "Percona Server for MySQL" training focuses on optimizing the use of Percona Server for MySQL, optimized for cloud computing, NoSQL access, containers, and modern hardware such as SSDs and Flash storage. The course covers the installation, configuration and optimization of Percona Server, focusing on features related to security, scalability, monitoring and data management. Participants will acquire practical skills enabling effective use of the advanced capabilities of Percona Server for MySQL.
Read more...

Last Updated:

Testimonials (9)

The quality of training and wealth of experience !

Edvin - Verizon Connect

Course - MySQL Developer

Was carefully tailored to our needs, very responsive to live questions and situations, gave us lots of practice repeating what we were learning.

Colin - Drax

Course - MySQL Administration

Trainer was accommodative. And actually quite encouraging for me to take up the course.

Grace Goh - DBS Bank Ltd

Course - Python in Data Science

The course built lesson to lesson, and the pacing was a big deal for me.

Bradford Moore - Regis College

Course - SQL in MySQL

exercise: setting up HAProxy for load balancing Galera cluster lecture: certification based replication

Kateryna Tokar - Clay Solutions

Course - MariaDB Galera Cluster Administration

The trainer has extensive knowledge of IT.

Iwan Susanto - Universitas Terbuka

Course - Advanced MariaDB for High Availability and Performance

I enjoyed the backup and restore and multiple instances.

Lakshmi Ponnada - Albany Medical Center

Course - MySQL Database Administration

The trainer, he was knowledgeable, engaging, and easy to learn from. He encouraged a lot of hands-on learning.

Shawn McAndrew

Course - SQL Fundamentals

Training material was very informative. Learned a lot.

Yaw Asamoah

Course - MariaDB Database Administration

Upcoming Courses

MariaDB Galera Cluster Administration

2025-06-02 09:30
21 hours
201 Portage Avenue
CA$ 5,270 (Online)
CA$ 7,370 (Classroom)

SQL Fundamentals

2025-06-16 09:30
14 hours
201 Portage Avenue
CA$ 3,514 (Online)
CA$ 4,914 (Classroom)

MySQL Database Administration

2025-06-30 09:30
14 hours
201 Portage Avenue
CA$ 3,514 (Online)
CA$ 4,914 (Classroom)

SQL in MySQL

2025-07-14 09:30
14 hours
201 Portage Avenue
CA$ 3,514 (Online)
CA$ 4,914 (Classroom)

Other regions in Canada

Other Countries

These courses are also available in other countries

Consulting

MySQL Consulting
Online MySQL training in Manitoba, MySQL training courses in Manitoba, Weekend MySQL courses in Manitoba, Evening MySQL training in Manitoba, MySQL instructor-led in Manitoba, MySQL classes in Manitoba, MySQL coaching in Manitoba, Weekend MySQL training in Manitoba, MySQL instructor in Manitoba, MySQL on-site in Manitoba, MySQL trainer in Manitoba, MySQL boot camp in Manitoba, Evening MySQL courses in Manitoba, MySQL one on one training in Manitoba, MySQL private courses in Manitoba, Online MySQL training in Manitoba, MySQL instructor-led in Manitoba