About the course:
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.
Our Amazon Redshift will give you hands-on practical skills to create robust ETL solutions for your software applications. This hands-on workshop is available for customised on-site delivery as a standalone workshop or part of a wider training programme.
By the end of this course, you will have learnt:
- Amazon Web Services Aarchitecture
- Data Warehouse Design and Architecture
- Migrating data to Redshift
- Integrating Business Intelligence tools with Redshift
Who should attend
This course is aimed at Data Scientists, Analysts, Software Developers, Database Developers, Data Warehouse Managers and Business Intelligence Specialists, Software Architects.
Prerequisites
Delegates should have experience developing enterprise database and / or software applications.This course incorporates hands-on exercises using cloud-based environments.
If you wish to participate in the hands-on exercises you should sign up for an Amazon AWS account prior to the course: http://aws.amazon.com/ and bring your login details, and ensure you are able to connect using a terminal application (Windows users will need an app like Putty)
On-site
If you are interested in custom / on-site training in Redshift and / or other Amazon Web Services products, please feel free to get in touch.
We can take into account your project requirements, existing technical skills, and specific topics of interest to customise the most relevant and focussed course for you.
Real-time Analysis Course Syllabus
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
Study architecture design and optimisations
- Data warehouse best practices
- Designing a Star Schema
- Schema optimisations
- Tuning your query performance
Migrating to Redshift
- Common patterns and anti-patterns
- JDBC and other interfaces
- Support for third-party business intelligence tools
- Security considerations