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

Oracle SQL for Developers

 35 Hours

This instructor-led, live training in Manitoba (online or onsite) is aimed at intermediate-level developers and database administrators who wish to use Oracle SQL to design, manage, and optimize database applications and automate tasks efficiently.

By the end of this training, participants will be able to:

  • Understand Oracle database architecture and manage users, schemas, and permissions.
  • Write optimized SQL queries for data retrieval, manipulation, and analysis.
  • Use advanced SQL techniques, including joins, subqueries, and hierarchical queries.
  • Design and manage database objects like tables, indexes, views, and sequences.
Read more...

Oracle SQL for Administrators

 21 Hours

This instructor-led, live training in Manitoba (online or onsite) is aimed at beginner-level database administrators and developers who wish to learn SQL to efficiently manage, query, and manipulate data in Oracle databases for administrative and operational tasks.

By the end of this training, participants will be able to:

  • Understand Oracle database architecture, including schemas, users, and sessions.
  • Write and optimize SQL queries for data retrieval, filtering, and manipulation.
  • Use joins, subqueries, and set operators to work with multiple tables and complex queries.
  • Perform data aggregation, grouping, and analysis using SQL functions.
  • Manage schema objects like views, sequences, and indexes to enhance database operations. 
Read more...

Oracle SQL for beginners

 21 Hours

Listeners

This training is addressed for people starting to work with the SQL language in Oracle database

The course answer for questions:

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

ORACLE SQL Fundamentals

 14 Hours

This 2 day course gives an introduction to SQL Developer, SQL*Plus and to SQL, the Structured Query Language used to access a Relational Database and includes the new features of the latest version of ORACLE. The principles learnt may also be applied to databases as diverse as Microsoft SQL Server, MySQL, Access, Informix and DB2.

The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.

Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.

Read more...

Oracle SQL Intermediate

 14 Hours

Audience

All who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge.

Format of the course

25% lectures, 75% labs

Read more...

Oracle SQL Advanced

 14 Hours

Listeners

This course is designed for people who want to use the advanced features of SQL in Oracle

The course answers the questions

  • How to build advanced queries?
  • How to create advanced reports?
Read more...

Oracle SQL for Development and Database Management

 35 Hours

This instructor-led, live training in Manitoba (online or onsite) is aimed at intermediate-level database professionals who wish to enhance their skills in Oracle SQL development and administration.

By the end of this training, participants will be able to:

  • Build and optimize complex SQL queries.
  • Manage databases efficiently using Oracle SQL tools.
  • Apply best practices in database development and maintenance.
  • Administer user access and database security in an Oracle environment.
Read more...

Oracle SQL Intermediate - Data Extraction

 14 Hours

The objective of the course is to enable participants to gain a mastery of how to work with the SQL language in Oracle database for data extraction at intermediate level.

Read more...

Oracle SQL Language

 14 Hours

The course answers questions

How to build a query?

What possibilities have SQL?

What is a relational database?

What is the structure and SQL commands

Read more...

Last Updated:

Testimonials (5)

I learned complex functions and how to apply them

Ana Alexandrescu - DB Global Technology

Course - Oracle SQL Advanced

Great comunication, Łukasz explained everything in easy and understandable way

Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.

Course - ORACLE SQL Fundamentals

the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.

Jade Stappaerts - KULeuven

Course - Oracle SQL Language

the exercises

Amna AlAli - Federal Demographic Council

Course - Oracle SQL for beginners

Trainer provided some topic and support it with plenty of exercises. We had a chance to apply knowledge by doing them on our own.

UBS Business Solutions Poland Sp. z o.o.

Course - Oracle SQL Intermediate

Upcoming Courses

Oracle SQL for Developers

2025-08-18 09:30
35 hours
Winnipeg-201 Portage Avenue
CA$ 8,784 (Online)
CA$ 12,284 (Classroom)

Oracle SQL for Developers

2025-09-15 09:30
35 hours
Winnipeg-201 Portage Avenue
CA$ 8,784 (Online)
CA$ 12,284 (Classroom)

Oracle SQL Intermediate

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

Oracle SQL for Development and Database Management

2025-10-13 09:30
35 hours
Winnipeg-201 Portage Avenue
CA$ 8,784 (Online)
CA$ 12,284 (Classroom)

ORACLE SQL Fundamentals

2025-10-27 09:30
14 hours
Winnipeg-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

Oracle SQL Consulting
Online Oracle Structured Query Language (SQL) training in Manitoba, Oracle SQL training courses in Manitoba, Weekend Oracle SQL courses in Manitoba, Evening Oracle Structured Query Language (SQL) training in Manitoba, Oracle Structured Query Language (SQL) instructor-led in Manitoba, Weekend Oracle Structured Query Language (SQL) training in Manitoba, Oracle Structured Query Language (SQL) private courses in Manitoba, Oracle Structured Query Language (SQL) classes in Manitoba, Oracle Structured Query Language (SQL) on-site in Manitoba, Oracle Structured Query Language (SQL) trainer in Manitoba, Oracle SQL boot camp in Manitoba, Oracle SQL one on one training in Manitoba, Online Oracle SQL training in Manitoba, Evening Oracle SQL courses in Manitoba, Oracle Structured Query Language (SQL) coaching in Manitoba, Oracle SQL instructor-led in Manitoba, Oracle SQL instructor in Manitoba