Data Warehouse Opplæringskurs

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.

Kurset er en del av Data Scientist ferdighetssettet (Domain: Data and Technology).

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

Format of the course

- Part lecture, part discussion, exercises and heavy hands-on practice

Apache Druid er et open source, kolonneorientert, distribuert datalager skrevet i Java . Den ble designet for å raskt innta store mengder hendelsesdata og utføre OLAP-spørsmål med lav latens på disse dataene. Druid brukes ofte i forretningsintelligensapplikasjoner for å analysere høye mengder sanntids- og historiske data. Det er også godt egnet til å bruke raske, interaktive, analytiske dashbord for sluttbrukere. Druid brukes av selskaper som Alibaba, Airbnb, Cisco , eBay, Netflix, Paypal og Yahoo.

I dette instruktørledede, live-kurset utforsker vi noen av begrensningene i datavarehusløsninger og diskuterer hvordan Druid kan komplimentere disse teknologiene til å danne en fleksibel og skalerbar streaming-analysestabel. Vi går gjennom mange eksempler, og tilbyr deltakerne sjansen til å implementere og teste Druid-baserte løsninger i et laboratoriemiljø.

Kursets format

- Delforelesning, deldiskusjon, tung praktisk praksis, sporadiske tester for å måle forståelse

Pivotal Greenplum is a Massively Parallel Processing (MPP) Data Warehouse platform based on PostgreSQL.

This instructor-led, live training (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 distributing data across multiple nodes.
- Improve database performance through tuning.
- Monitor and troubleshoot a Greenplum database.

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 Database is a database software for business intelligence and data warehousing. Users can run Greenplum Database for massive parallel data processing.

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

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.

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

Mem SQL er et internt, distribuert, SQL databasesystem for sky og lokale. Det er et datalager i sanntid som umiddelbart leverer innsikt fra levende og historiske data.

I denne instruktørledede, liveopplæringen, vil deltakerne lære det vesentlige av Mem SQL for utvikling og administrasjon.

Ved slutten av denne opplæringen vil deltakerne kunne:

- Forstå nøkkelbegrepene og egenskapene til Mem SQL
- Installere, designe, vedlikeholde og betjene Mem SQL
- Optimaliser skjemaer i Mem SQL
- Forbedre spørsmål i Mem SQL
- Benchmark-ytelse i Mem SQL
- Bygg dataprogrammer i sanntid ved hjelp av Mem SQL

Publikum

- Utviklere
- administratorer
- Operasjonsingeniører

Kursets format

- Delforelesning, deldiskusjon, øvelser og tung praktisk øvelse