Data Warehousing Training

Catalogue index: IFS/84

  • In stock
  • Delivery: free
  • Dedicated training:
  • Producer:
  • Training level:
    • Średniozaawansowany
  • Type of training:
    • stacjonarnie; online
PLN993.33 net / particip. PLN14,899.95  net for 1 workshop PLN1,221.80 gross incl. 23% VAT / particip.

product- line 1

Features

Features
Certification:
  • TAK
Dedicated training:
Number of training hours:
  • 16
Producer:
Training language:
  • polski
Training level:
  • Średniozaawansowany
Type of training:
  • stacjonarnie; online

Description

Company Description

InfoShare Academy is a leading IT academy offering comprehensive educational programs in new technologies for companies. Since 2015, we have been supporting organizations in developing technology teams through dedicated courses in Machine Learning, DevOps, Data Engineering, Python, UX/UI Design, AWS, and Kubernetes. Our training is based on practical skills and real business cases. We collaborate with over 300 industry practitioners, ensuring that our programs are tailored to current market needs. We specialize in reskilling and upskilling employees. With us, you will build effective teams implementing new technologies that will accelerate innovation and strengthen your company's competitiveness in the market. Check out our training offerings designed for companies, created to enhance your employees' competencies in the IT field.

Training Description
  • The Data Warehousing training is an intensive two-day course focused on the practical application of leading tools for managing data warehouses, such as Amazon Redshift, Google BigQuery, and Snowflake. The training program is designed so that 80% of the time is dedicated to practical workshops and 20% to theory. Participants will gain the skills necessary to design, implement, and manage data warehouses in the cloud, working on real examples and use cases.
  • Required technical skills:
  • Basic knowledge of SQL
  • Basic understanding of databases and data processing
  • Ability to work in a cloud environment (AWS, GCP, or others)
Who the training is for
  • Data engineers and analysts who want to expand their skills in data warehousing
  • Developers and IT specialists who want to use cloud tools for data management
  • Managers and IT team leaders who wish to understand and implement modern data warehouse solutions in their organizations
Goals

 

Benefits
  • You will learn:
  • How to design, implement, and manage data warehouses in Amazon Redshift, Google BigQuery, and Snowflake
  • How to optimize queries and improve operational performance in data warehouses
  • How to integrate data warehouses with other cloud tools and services
  • How to monitor, manage, and scale data warehouses in a production environment
Training Program

Day 1: Introduction to Data Warehousing and Basics of Tools

  1. Basics of Data Warehousing

  • Data warehouse architecture: concepts and components

  • Comparison of traditional and cloud data warehouses

  1. Amazon Redshift

  • Architecture and basic functions of Redshift

  • Loading data into Redshift, creating tables and SQL queries

  1. Google BigQuery

  • Architecture and basic functions of BigQuery

  • Importing data, creating and executing SQL queries

  1. Workshop: Creating and Managing a Data Warehouse

  • Implementing basic operations in Redshift and BigQuery

  • Query optimization and performance analysis

Day 2: Advanced Techniques and Practical Applications

  1. Snowflake

  • Architecture and basic functions of Snowflake

  • Loading data, creating structures and SQL queries

  1. Optimization and Scaling of Data Warehouses

  • Performance optimization techniques in Redshift, BigQuery, and Snowflake

  • Scaling data warehouses and resource management

  1. Workshop: Practical Applications and Integrations

  • Implementing advanced operations in Snowflake

  • Integrating data warehouse tools with other cloud services

  1. Deploying and Managing Data Warehouses

  • Preparing and deploying data warehouses in a production environment

  • Monitoring, managing, and maintaining data warehouses

Duration

16 h/2 days

Price includes
  • Certificate of completion
  • Monthly access to the training recording (in case of online format)
  • Customization of the training program to client needs

Zamów szkolenie