Data Warehouse Training Courses

Data Warehouse Training Courses

Local, 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 "onsite live training" or "remote live training". Onsite live Data Warehouse training can be carried out locally on customer premises in the US or in NobleProg corporate training centers in the US. Remote live training is carried out by way of an interactive, remote desktop. Data Warehouse is also known as Enterprise Data Warehouse (EDW) or Data Warehousing. NobleProg -- Your Local Training Provider

Testimonials

★★★★★
★★★★★

Data Warehouse (DWH) Subcategories

DW (Data Warehouse) Course Outlines

CodeNameDurationOverview
bigddbsysfunBig Data & Database Systems Fundamentals14 hoursThe course is part of the Data Scientist skill set (Domain: Data and Technology).
druidDruid: Build a Fast, Real-Time Data Analysis System21 hoursDruid 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 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.

Audience

- Application developers
- Software engineers
- Technical consultants
- DevOps professionals
- Architecture engineers

Format of the course

- Part lecture, part discussion, heavy hands-on practice, occasional tests to gauge understanding
kylinApache Kylin: From Classic OLAP to Real-Time Data Warehouse14 hoursApache 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, including snowflake schema support, a 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
datavaultData Vault: Building a Scalable Data Warehouse28 hoursData vault modeling is a database modeling technique that provides long-term historical storage of data that originates from multiple sources. A data vault stores a single version of the facts, or "all the data, all the time". Its flexible, scalable, consistent and adaptable design encompasses the best aspects of 3rd normal form (3NF) and star schema.

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

Audience

- Data modelers
- Data warehousing specialist
- Business Intelligence specialists
- Data engineers
- Database administrators

Format of the course

- Part lecture, part discussion, exercises and heavy hands-on practice
memsqlMemSQL28 hoursMemSQL 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
amazonredshiftAmazon Redshift21 hoursAmazon 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.

Upcoming EDW Courses

CourseCourse DateCourse Price [Remote / Classroom]
Big Data & Database Systems Fundamentals - NC, Chapel Hill - Chapel Hill - DowntownThu, Dec 6 2018, 9:30 am$3500 / $4760
Big Data & Database Systems Fundamentals - OH, Cleveland - Cleveland City CenterMon, Jan 21 2019, 9:30 am$3500 / $4820
Big Data & Database Systems Fundamentals - NC, Chapel Hill - Chapel Hill - DowntownTue, Feb 5 2019, 9:30 am$3500 / $4760
Big Data & Database Systems Fundamentals - OH, Cleveland - Cleveland City CenterThu, Mar 21 2019, 9:30 am$3500 / $4820
Big Data & Database Systems Fundamentals - NC, Chapel Hill - Chapel Hill - DowntownWed, Apr 3 2019, 9:30 am$3500 / $4760
Weekend DWH (Data Warehouse) courses, Evening Enterprise Data Warehouse training, DWH (Data Warehouse) boot camp, DWH (Data Warehouse) instructor-led, Weekend Data Warehouse training, Evening EDW courses, EDW coaching, Data Warehouse instructor, Enterprise Data Warehouse trainer, DW (Data Warehouse) training courses, Enterprise Data Warehouse classes, Data Warehouse (DWH) on-site, Enterprise Data Warehouse (EDW) private courses, DWH (Data Warehouse) one on one training

Course Discounts

CourseVenueCourse DateCourse Price [Remote / Classroom]
Web Application Performance Testing with JMeterCA, Sunnyvale - Downtown SunnyvaleWed, Nov 28 2018, 9:30 am$1733 / $2683
Visual Basic for Applications (VBA) in Excel - AdvancedRemote Training (Instructor-led) Thu, Nov 29 2018, 9:30 am$1800 / N/A
Introduction to Ansible Automation TX, Houston - Downtown - Pennzoil PlazaThu, Dec 6 2018, 9:30 am$1733 / $2753
Haskell FundamentalsOH, Columbus - Galleria at PNC PlazaTue, Dec 11 2018, 9:30 am$2700 / $4000
Machine Learning Fundamentals with RCA, San Francisco - Golden Gate - 75 BroadwayWed, Dec 12 2018, 9:30 am$4455 / $5815
Advanced Haskell NC, Charlotte - Charlotte City Center Wed, Dec 12 2018, 9:30 am$2700 / $4000
OCEB2 OMG Certified Expert in BPM - Business Intermediate Exam PreparationNH, Portsmouth - Commerce Way SuiteMon, Dec 31 2018, 9:30 am$4725 / $6725
Programming in ScalaCA, San Francisco - Golden Gate - 75 BroadwayTue, Jan 8 2019, 9:30 am$3465 / $4825

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in the US!

As a Business Development Manager you will:

  • expand business in the US
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!