IL, Chicago - CBD - West Loop Riverside Plaza Center

10 South Riverside Plaza Suite 875, Chicago, United States, 60606

The CBD West Loop Riverside Plaza Center is a unique, recently renovated building facing the Chicago River. Located on the outskirts of the Loop, this center is excellent for commuters from the suburbs, with the Ogilvie train station and Union Station two blocks down the street. Amenities include an enhanced business lounge with two Thinkpods to help you focus, a fintness lounge and two full-service restaurants on-site. Our 42 person meeting room is ideal for all forms of training sessions.

Subcategories (1)

Category for Data Vault

Data Vault

Explore Our Courses

Advanced Apache Iceberg

 21 Hours

This instructor-led, live training in Illinois (online or onsite) is aimed at advanced-level data professionals who wish to optimize data processing workflows, ensure data integrity, and implement robust data lakehouse solutions that can handle the complexities of modern big data applications.

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

  • Gain an in-depth understanding of Iceberg’s architecture, including metadata management and file layout.
  • Configure Iceberg for optimal performance in various environments and integrate it with multiple data processing engines.
  • Manage large-scale Iceberg tables, perform complex schema changes, and handle partition evolution.
  • Master techniques to optimize query performance and data scan efficiency for large datasets.
  • Implement mechanisms to ensure data consistency, manage transactional guarantees, and handle failures in distributed environments.
Read more...

Apache Iceberg Fundamentals

 14 Hours

This instructor-led, live training in Illinois (online or onsite) is aimed at beginner-level data professionals who wish to acquire the knowledge and skills necessary to effectively utilize Apache Iceberg for managing large-scale datasets, ensuring data integrity, and optimizing data processing workflows.

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

  • Gain a thorough understanding of Apache Iceberg's architecture, features, and benefits.
  • Learn about table formats, partitioning, schema evolution, and time travel capabilities.
  • Install and configure Apache Iceberg in different environments.
  • Create, manage, and manipulate of Iceberg tables.
  • Understand the process of migrating data from other table formats to Iceberg.
Read more...

Big Data Consulting

 21 Hours

This instructor-led, live training in Illinois (online or onsite) is aimed at intermediate-level IT professionals who wish to enhance their skills in data architecture, governance, cloud computing, and big data technologies to effectively manage and analyze large datasets for data migration within their organizations.

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

  • Understand the foundational concepts and components of various data architectures.
  • Gain a comprehensive understanding of data governance principles and their importance in regulatory environments.
  • Implement and manage data governance frameworks such as Dama and Togaf.
  • Leverage cloud platforms for efficient data storage, processing, and management.
Read more...

Azure Data Lake Storage Gen2

 14 Hours

This instructor-led, live training in Illinois (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...

Greenplum Administration: Installation, Updates, and Libraries

 21 Hours

Greenplum is an open-source massively parallel data platform based on PostgreSQL, designed for advanced analytics and large-scale data warehousing.

This instructor-led, live training (online or onsite) is aimed at intermediate-level administrators who wish to install, configure, and manage Greenplum environments effectively, including managing system updates and libraries.

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

  • Install and configure a production-ready Greenplum cluster.
  • Manage system updates and apply patches safely.
  • Handle Greenplum library management for analytics and extensions.
  • Troubleshoot and monitor Greenplum systems.

Format of the Course

  • Interactive lecture and discussion.
  • Hands-on use of Greenplum in a controlled lab environment.
  • Guided exercises focused on cluster setup, upgrade workflows, and system extensions.

Course Customization Options

  • To request a customized training for this course based on your environment or data platform, please contact us to arrange.
Read more...

IBM Datastage For Administrators and Developers

 35 Hours

This instructor-led, live training in Illinois (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: Real-Time OLAP on Big Data

 14 Hours

This instructor-led, live training in Illinois (online or onsite) is aimed at intermediate-level big data professionals who wish to utilize Apache Kylin for building real-time data warehouses and performing multidimensional analysis on large-scale datasets.

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

  • Set up and configure Apache Kylin with real-time streaming data sources.
  • Design and build OLAP cubes for both batch and streaming data.
  • Perform complex queries with sub-second latency using Kylin's SQL interface.
  • Integrate Kylin with BI tools for interactive data visualization.
  • Optimize performance and manage resources effectively in Kylin.
Read more...

SQL Advanced

 14 Hours

This instructor-led, live training in Illinois (online or onsite) is aimed at intermediate-level database administrators, developers, and analysts who wish to master advanced SQL functionalities for complex data operations and database management.

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

  • Perform advanced querying techniques using unions, subqueries, and complex joins.
  • Add, update, and delete data, tables, views, and indexes with precision.
  • Ensure data integrity through transactions and manipulate database structures.
  • Create and manage databases efficiently for robust data storage and retrieval.
Read more...

Oracle SQL for Development and Database Management

 35 Hours

This instructor-led, live training in Illinois (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...

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

Data Vault: Building a Scalable Data Warehouse

 28 Hours

In this instructor-led, live training in Illinois, 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...

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

Greenplum Database

 14 Hours

This instructor-led, live training in Illinois (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...

Last Updated:

Testimonials (4)

Trainer had good grasp of concepts

Josheel - Verizon Connect

Course - Amazon Redshift

What I liked most was the trainer's mastery of the subject, his patience and clarity when explaining the concepts, and especially his constant willingness to answer all the questions that arose. It was a really enriching and very enjoyable learning experience.

Patricio Condado - SOKODB

Machine Translated

analytical functions

khusboo dassani - Tech Northwest Skillnet

Course - SQL Advanced

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

Other regions in the US

Other Countries

These courses are also available in other countries

Consulting

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