QA | 26 September 2016
A few months ago, I blogged about the Big Data on AWS course, which describes how to build a big data processing pipeline on AWS. That course covers many different technologies, including EMR (Amazon’s managed Hadoop service), Kinesis (streaming big data) and Redshift (data warehousing).
Ever since that course was introduced, customers have been asking for a second course that focuses specifically on data warehousing – and now there is one: Data Warehousing on AWS.
This is a three-day course targeted at database professionals and data analysts. It discusses the concepts, strategies and best practices involved in building a data warehousing solution on the AWS cloud. As a prerequisite, delegates are expected to be familiar with relational databases, and to have attended the one-day AWS Technical Essentials course (see my previous blog in this series) or have equivalent experience.
The course content is primarily a deep-dive on Amazon Redshift, intended to teach delegates how to implement, design, configure, secure, optimise and monitor a data warehouse on the Redshift platform. There is also an introductory section about the core concepts of data warehousing, and some other AWS data and analytics technologies are discussed insofar as they relate to collecting, storing and preparing data.
As usual, I’d like to add more detail to the course outline – and, as usual, please be aware that AWS frequently release new versions of courseware, each delivery is different, and this blog will surely be outdated after a while. Please don’t treat these details as contractual – contact us if you want to know more. That said, the course goes like this:
There are eight hands-on labs throughout the course, particularly on days two and three. That ensures that delegates can have substantial hands-on experience with Redshift as well as theoretical knowledge of it, and be ready at the end of the course to implement their own data warehousing solutions.
If you’re interested in learning more about this or any other AWS course, please give us a call.Related blogs