Online or onsite, instructor-led live Data Warehouse training courses demonstrate through discussion and hands-on practice how to understand, plan and set up a Data Warehouse.
Data Warehouse training is available as "online live training" or "onsite live training". Online live training (aka "remote live training") is carried out by way of an interactive, remote desktop. Kelowna onsite live Data Warehouse trainings can be carried out locally on customer premises or in NobleProg corporate training centers.
Data Warehouse is also known as Enterprise Data Warehouse (EDW) or Data Warehousing.
NobleProg -- Your Local Training Provider
Kelowna - Landmark
1631 Dickson Avenue, Kelowna, Canada
Described as Kelowna’s most prestigious business location, Landmark compromises of six office towers in a campus-style complex. Take advantage of close proximity to Highway 97 with on-site parking and local bus routes within a three-minute walk.
Spark creativity during the workday, with floor to ceiling windows looking out over the city below. When you need a break, take a stroll to Parkinson’s Recreation Centre, or entertain visitors at the many restaurants and bars nearby.
Kelowna - The Innovation Centre
460 Doyle Ave, Kelowna, Canada
Inspiring, dynamic and inviting, The Innovation Center is your new working home. Welcome to a different kind of working in Kelowna. The Innovation Center is the city’s first foray into flexible workspace, and makes creating an inspiring environment the priority. Based inside the one-of-a-kind Okanagan Centre for Innovation, this dynamic office environment offers more than just four walls and a desk. Instead, professionals and entrepreneurs will find a choice of spaces, from impressive meeting rooms to collaborative desks and laptop charge points. This highly convenient and incredibly well equipped modern working hub is sure to become your new go-to place for productivity. Located in Kelowna’s vibrant downtown area, it’s near popular local eateries such as nearby Blenz Coffee and Dawett Fine Indian Cuisine.
Whether you’re using the site’s super-fast Wi-Fi connection or getting that extra bit of help from the friendly administrative support staff, Innovation Centre pushes you to achieve more in business. The building itself is a partnership between the local government and a group of technology executives who joined forces to accelerate the tech industry in in Kelowna. They’ve created an incredible location, which is immediately connected to the wider area via a pair of convenient bus stops. What’s more, its central position places it next to some of the city’s most enticing venues, such as Kelowna Yacht Club, the tranquil Kasugai Gardens and Stuart Park. Alternatively, those in need of a bit of inspiration shouldn’t miss the Okanagan Military Museum and Okanagan Regional Library - Kelowna Branch – ideal places to top up your creativity.
Greenplum is an open-source massively parallel processing (MPP) data platform designed for analytics and large-scale data environments.
This instructor-led, live training (online or onsite) is aimed at intermediate-level to advanced-level technical users who wish to understand the internal architecture of Greenplum, build optimized data models, and apply high-performance SQL in distributed environments.
By the end of this training, participants will be able to:
Understand Greenplum’s shared-nothing architecture and parallelism model.
Design distributed table structures and partitions optimized for query performance.
Use indexing strategies, storage formats, and physical design techniques.
Interpret EXPLAIN plans and optimize queries using best practices.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
Course Customization Options
To request a customized training for this course, please contact us to arrange.
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.
This instructor-led, live training in Kelowna (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.
This instructor-led, live training in Kelowna (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.
This instructor-led, live training in Kelowna (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.
This instructor-led, live training in Kelowna (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.
This instructor-led, live training in Kelowna (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.
This instructor-led, live training in Kelowna (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.
This instructor-led, live training in Kelowna (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.
This instructor-led, live training in Kelowna (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.
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
This instructor-led, live training in Kelowna (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:
Online Enterprise Data Warehouse training in Kelowna, Data Warehouse (DWH) training courses in Kelowna, Weekend DW (Data Warehouse) courses in Kelowna, Evening DW (Data Warehouse) training in Kelowna, EDW (Enterprise Data Warehouse) instructor-led in Kelowna, Data Warehouse instructor in Kelowna, Enterprise Data Warehouse boot camp in Kelowna, Evening EDW courses in Kelowna, Enterprise Data Warehouse (EDW) on-site in Kelowna, Enterprise Data Warehouse private courses in Kelowna, Enterprise Data Warehouse one on one training in Kelowna, Online Data Warehouse training in Kelowna, DWH (Data Warehouse) classes in Kelowna, Enterprise Data Warehouse (EDW) instructor-led in Kelowna, Enterprise Data Warehouse trainer in Kelowna, DWH (Data Warehouse) coaching in Kelowna, Weekend Enterprise Data Warehouse (EDW) training in Kelowna
