To wersja testowa nowego serwisu infoShare Academy — wyświetlane treści i oferta nie są wiążące ani kompletne

Data

Data Warehousing

The Data Warehousing Training is an intensive two-day course focused on the practical application of leading data warehousing tools such as Amazon Redshift, Google BigQuery, and Snowflake.

Duration
16h · 2 days
Ask about the program → See all
Who it's for

Ideal for teams that…

1 Data engineers and analysts who want to expand their skills in data warehousing.
2 Developers and IT specialists who want to utilize cloud tools for data management.
3 Managers and team leaders aiming to understand and implement modern data warehousing solutions in their organizations.
Outcomes after the program

Hands-on AI and data analytics workshops — built around your team's real cases.

✓

How to design, implement, and manage data warehouses in Amazon Redshift, Google BigQuery, and Snowflake.

✓

How to optimize queries and improve performance in data warehouses.

✓

How to integrate data warehouses with other tools and cloud services.

✓

How to monitor, manage, and scale data warehouses in a production environment.

Requirements

What you should know before we start

  • Basic knowledge of SQL.
  • Fundamental understanding of databases and data processing.
  • Ability to work in a cloud environment (AWS, GCP, or others).
Program

What we actually do

Day 1: Introduction to Data Warehousing and Basics of Tools

  • · Data warehouse architecture: concepts and components
  • · Comparison of traditional and cloud-based data warehouses
  • · Architecture and basic features of Redshift
  • · Loading data into Redshift
  • · Creating tables and writing SQL queries
  • · Architecture and basic features of BigQuery
  • · Importing data
  • · Creating and executing SQL queries
  • · Implementing basic operations in Redshift and BigQuery
  • · Query optimization and performance analysis

Day 2: Advanced Techniques and Practical Applications

  • · Architecture and basic features of Snowflake
  • · Loading data, creating structures, and writing SQL queries
  • · Performance optimization techniques in Redshift, BigQuery, and Snowflake
  • · Scaling data warehouses and resource management
  • · Implementing advanced operations in Snowflake
  • · Integrating data warehousing tools with other cloud services
  • · Preparing and deploying data warehouses in production environments
  • · Monitoring, managing, and maintaining data warehouses
Every module is adapted to your stack and context. The above is a starting point — not a fixed agenda.
How we work

From brief to retro in 30 days.

01

Brief & diagnosis

A call with the team lead + a short survey for participants. We define goals, gap and context.

02

Program customization

We adapt modules, case studies and code examples to your stack. Approval in 5 days.

03

Workshop

Trainer-led sessions, hands-on, code review. Mentor available between sessions too.

04

Retro + report

Outcome report for the team and lead. 30 days of consulting included.

Inquiry

Send a brief. We'll reply within 1 day.

After a short brief we'll prepare a program and a quote. No obligations — it's just a starting point.

✓Quote within 48h of the brief
✓First session within 30 days
✓Pilot before the full decision
✓VAT invoice, payment in instalments possible

How we handle your data

We process your business data (name, work e-mail, phone number, company, job title) in order to handle your corporate training inquiry and prepare an offer. The data controller is infoShare Academy Sp. z o.o., Al. Grunwaldzka 472B, 80-309 Gdańsk. Providing the data is voluntary but necessary to receive a response. You have the right to access, rectify, erase or restrict the processing of your data and to object to it. Full information is available in our data processing notice.

Optional marketing consents

The controller of your personal data is infoShare Academy sp. z o.o. The rules for processing personal data are set out in the Privacy Policy and the Data Processing Notice.

Other programs for teams

See all →
Data

Active Directory

Hands-on AI and data analytics workshops — built around your team's real cases.

16h · 2 days →
Data

AI SQL Developer

Hands-on AI and data analytics workshops — built around your team's real cases.

24h · 3 days →
Data

Amazon Redshift - Introductory Training

Hands-on AI and data analytics workshops — built around your team's real cases.

16h · 2 days →