Amazon Redshift Training

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 develop your employees' competencies in the IT field.

The training "Redshift – modern data analysis in the 21st century" is for those who want to learn about Amazon Redshift, a managed data warehouse used by the largest companies. The course covers launching, cost optimization, ensuring security, and analysis using artificial intelligence. It is intended for both those with AWS experience and those without. The course is workshop-based, with lab tasks that aid in material absorption.

• For those who want to enhance analytical capabilities in their company and draw conclusions faster from the vast amounts of data collected every day.
• For those who want to learn the secrets of the world's most popular data warehouse.
• For anyone who wants to understand how the Redshift service works and how to quickly, easily, and securely design modern Data Lake solutions within their own company.

The Amazon Redshift training provides essential knowledge and skills to effectively use this service for data analysis and managing a cloud data warehouse. It also helps understand best practices regarding performance, security, and scalability in the Amazon Redshift environment.

• How does Redshift work?

  • Architecture of Redshift clusters

• Evolution of the Redshift service

  • How not to get lost in the maze of Redshift functionalities

• Decoupling in action

  • Why separating storage space and computing power has become the new standard for analyzing data warehouses, exemplified by RA3

• Scalability of Redshift

  • Automatic adjustment of computing power to real needs

• Optimization of Redshift

  • What affects the performance of the warehouse

  • Data distribution in the cluster

• Redshift in production

  • How to ensure data security and access in the warehouse

  • How to create and manage backups

• Loading data into the cluster

  • Best practices and integration with the S3 service

• Data consumption from Redshift

  • Visual Query Editor

  • Communication via JDBC/ODBC protocols

• Monitoring and auditing Redshift

  • Observability of the warehouse

• Redshift ML

  • Building AI models based on data

  • Using models without knowledge of ML tools

• Cost optimization

  • Control and optimization of costs resulting from the Redshift warehouse

16 h/2 days

• Certificate of completion
• Monthly access to the training recording (for online format)
• Customization of the training program to the client's needs