EncartaLabs

Amazon Redshift

( Duration: 1 Day )

Traditional approaches to data manipulation are becoming obsolete and more expensive in the face of the new breed of cloud-based solutions. As enterprises capture more and more data, it is essential to derive vital information in order to maintain a competitive edge. Amazon Redshift allows all size of businesses to create databases running from terabytes up to even petabytes, without the need to invest in costly and difficult to maintain infrastructure. With Amazon Web Services, you can instantly fire up a cluster which delivers amazing performance, at a fraction of the TCO of existing traditional databases.

The Amazon Redshift training course will give you hands-on practical skills to create robust ETL solutions for your software applications.

By attending Amazon Redshift workshop, attendees will learn:

  • Amazon Web Services Architecture
  • Data Warehouse Design and Architecture
  • Migrating data to Redshift
  • Integrating Business Intelligence tools with Redshift

  • Experience developing enterprise database and / or software applications.
  • This course is aimed at Data Scientists, Analysts, Software Developers, Database Developers, Data Warehouse Managers and Business Intelligence Specialists, Software Architects.

COURSE AGENDA

1

Overview Amazon Web Services architecture

  • Creating an AWS cluster step-by-step
  • Overview of third-party ETL solutions (Extract, Transform, Load)
  • Loading data via S3
  • Batch and real-time data loaders
2

Study architecture design and optimisations

  • Data warehouse best practices
  • Designing a Star Schema
  • Schema optimisations
  • Tuning your query performance
3

Migrating to Redshift

  • Common patterns and anti-patterns
  • JDBC and other interfaces
  • Support for third-party business intelligence tools
  • Security considerations

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top