Pointe Claire - Transcanada

6500 TransCanada Service Road, Pointe Claire, Canada, H9R 0A5
Designed by an industry-leading architect and equipped with the latest energy-efficient technology. Host overseas clients and...

Subcategories (1)

Image for Data Vault category
Data Vault

Explore Our Courses

Azure Data Lake Storage Gen2

14 Hours
This instructor-led, live training in Pointe Claire (online or onsite) is aimed at intermediate-level data engineers who wish to learn how to use Azure Data Lake Storage Gen2 for effective data analytics solutions.By the end of this training, participants will be able to:
  • Understand the architecture and key features of Azure Data Lake Storage Gen2.
  • Optimize data storage and access for cost and performance.
  • Integrate Azure Data Lake Storage Gen2 with other Azure services for analytics and data processing.
  • Develop solutions using the Azure Data Lake Storage Gen2 API.
  • Troubleshoot common issues and optimize storage strategies.
Read more...

IBM Datastage For Administrators and Developers

35 Hours
This instructor-led, live training in Pointe Claire (online or onsite) is aimed at intermediate-level IT professionals who wish to have a comprehensive understanding of IBM DataStage from both an administrative and a development perspective, allowing them to manage and utilize this tool effectively in their respective workplaces.By the end of this training, participants will be able to:
  • Understand the core concepts of DataStage.
  • Learn how to effectively install, configure, and manage DataStage environments.
  • Connect to various data sources and extract data efficiently from databases, flat files, and external sources.
  • Implement effective data loading techniques.
Read more...

Apache Kylin: From Classic OLAP to Real-Time Data Warehouse

14 Hours
Apache Kylin is an extreme, distributed analytics engine for big data. In this instructor-led live training, participants will learn how to use Apache Kylin to set up a real-time data warehouse. By the end of this training, participants will be able to:
  • Consume real-time streaming data using Kylin
  • Utilize Apache Kylin's powerful features, rich SQL interface, spark cubing and subsecond query latency
Note
  • We use the latest version of Kylin (as of this writing, Apache Kylin v2.0)
Audience
  • Big data engineers
  • Big Data analysts
Format of the course
  • Part lecture, part discussion, exercises and heavy hands-on practice
Read more...

Amazon Redshift

21 Hours
Amazon Redshift is a petabyte-scale cloud-based data warehouse service in AWS. In this instructor-led, live training, participants will learn the fundamentals of Amazon Redshift. By the end of this training, participants will be able to:
  • Install and configure Amazon Redshift
  • Load, configure, deploy, query, and visualize data with Amazon Redshift
Audience
  • Developers
  • IT Professionals
Format of the course
  • Part lecture, part discussion, exercises and heavy hands-on practice
Note
  • To request a customized training for this course, please contact us to arrange.
Read more...

Big Data & Database Systems Fundamentals

14 Hours
The course is part of the Data Scientist skill set (Domain: Data and Technology).
Read more...

Apache Druid for Real-Time Data Analysis

21 Hours
Apache Druid is an open-source, column-oriented, distributed data store written in Java. It was designed to quickly ingest massive quantities of event data and execute low-latency OLAP queries on that data. Druid is commonly used in business intelligence applications to analyze high volumes of real-time and historical data. It is also well suited for powering fast, interactive, analytic dashboards for end-users. Druid is used by companies such as Alibaba, Airbnb, Cisco, eBay, Netflix, Paypal, and Yahoo. In this instructor-led, live course we explore some of the limitations of data warehouse solutions and discuss how Druid can compliment those technologies to form a flexible and scalable streaming analytics stack. We walk through many examples, offering participants the chance to implement and test Druid-based solutions in a lab environment.
Format of the Course
  • Part lecture, part discussion, heavy hands-on practice, occasional tests to gauge understanding
Read more...

Pivotal Greenplum for Developers

21 Hours
This instructor-led, live training in Pointe Claire (online or onsite) is aimed at developers who wish to set up a multi-node Greenplum database. By the end of this training, participants will be able to:
  • Install and configure Pivotal Greenplum.
  • Model data in accordance to current needs and future expansion plans.
  • Carry out different techniques for distribute data across multiple nodes.
  • Improve database performance through tuning.
  • Monitor and troubleshoot a Greenplum database.
Read more...

Greenplum Database

14 Hours
This instructor-led, live training in Pointe Claire (online or onsite) is aimed at administrators who wish to set up Greenplum Database for business intelligence and data warehousing solutions. By the end of this training, participants will be able to:
  • Address processing needs with Greenplum.
  • Perform ETL operations for data processing.
  • Leverage existing query processing infrastructures.
Read more...

MemSQL

28 Hours
MemSQL is an in-memory, distributed, SQL database management system for cloud and on-premises. It's a real-time data warehouse that immediately delivers insights from live and historical data. In this instructor-led, live training, participants will learn the essentials of MemSQL for development and administration. By the end of this training, participants will be able to:
  • Understand the key concepts and characteristics of MemSQL
  • Install, design, maintain, and operate MemSQL
  • Optimize schemas in MemSQL
  • Improve queries in MemSQL
  • Benchmark performance in MemSQL
  • Build real-time data applications using MemSQL
Audience
  • Developers
  • Administrators
  • Operation Engineers
Format of the course
  • Part lecture, part discussion, exercises and heavy hands-on practice
Read more...

Data Vault: Building a Scalable Data Warehouse

28 Hours
In this instructor-led, live training in Pointe Claire, participants will learn how to build a Data Vault. By the end of this training, participants will be able to:
  • Understand the architecture and design concepts behind Data Vault 2.0, and its interaction with Big Data, NoSQL and AI.
  • Use data vaulting techniques to enable auditing, tracing, and inspection of historical data in a data warehouse.
  • Develop a consistent and repeatable ETL (Extract, Transform, Load) process.
  • Build and deploy highly scalable and repeatable warehouses.
Read more...

Last Updated:

Testimonials (4)

The general topic itself

- Verizon Connect
Course - Amazon Redshift

Trainer had good grasp of concepts

Josheel - Verizon Connect
Course - Amazon Redshift

Lo que más me gustó fue el dominio del tema por parte del trainer, su paciencia y claridad al explicar los conceptos, y especialmente su disposición constante para responder todas las dudas que surgieron. Fue una experiencia de aprendizaje realmente enriquecedora y muy agradable.

Patricio Condado - SOKODB
Course - Greenplum Database

how the trainor shows his knowledge in the subject he's teachign

john ernesto ii fernandez - Philippine AXA Life Insurance Corporation
Course - Data Vault: Building a Scalable Data Warehouse

Upcoming Courses

Other regions in Canada

Other Countries

These courses are also available in other countries

Consulting

Data Warehouse Consulting
Online Enterprise Data Warehouse training in Pointe Claire, Data Warehouse (DW) training courses in Pointe Claire, Weekend Data Warehouse courses in Pointe Claire, Evening Enterprise Data Warehouse training in Pointe Claire, EDW (Enterprise Data Warehouse) instructor-led in Pointe Claire, Online EDW (Enterprise Data Warehouse) training in Pointe Claire, Enterprise Data Warehouse (EDW) on-site in Pointe Claire, Enterprise Data Warehouse instructor-led in Pointe Claire, DWH (Data Warehouse) private courses in Pointe Claire, Evening DW (Data Warehouse) courses in Pointe Claire, Enterprise Data Warehouse (EDW) classes in Pointe Claire, DWH (Data Warehouse) one on one training in Pointe Claire, Data Warehouse (DW) boot camp in Pointe Claire, EDW (Enterprise Data Warehouse) trainer in Pointe Claire, Weekend EDW (Enterprise Data Warehouse) training in Pointe Claire, EDW coaching in Pointe Claire, Data Warehouse (DWH) instructor in Pointe Claire
1