Live instructor-led training
Data Warehousing on AWS
- CMDBID 1036
- Course Code AMWSDW
- Duration 3 Days
Scroll
Course content
What you will learn
Overview
Data Warehousing on AWS is a practical training course for teams that need structured, instructor-led skills in Data Warehousing, AWS Day, Course Introduction Introduction.
Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data.
Target Audience
- Database architects
- Database administrators
- Database developers
- Data analysts and scientists
Delivery Method
This course is delivered through a mix of:
- Instructor-Led Training (ILT)
- Hands-On Labs
Hands-On Activity
This course allows you to test new skills and apply knowledge to your working environment through a variety of practical exercises.
Skills Gained
By completing the Data Warehousing on AWS AMWSDW course participants will gain practical knowledge, configuration skills, implementation techniques and best practice understanding relevant to real enterprise environments.
Prerequisites
We recommend that attendees of this course have the following prerequisites:
- Courses taken: AWS Technical Essentials (or equivalent experience with AWS)
- Familiarity with relational databases and database design concepts
Outline
Day 1
- Course Introduction
- Introduction to Data Warehousing
- Introduction to Amazon Redshift
- Understanding Amazon Redshift Components and Resources
- Launching an Amazon Redshift Cluster
Day 2
- Choosing a Data Warehousing Approach
- Identifying Data Sources and Requirements
- Architecting the Data Warehouse
- Loading Data into the Data Warehouse
Day 3
- Optimizing Queries and Tuning Performance
- Monitoring and Auditing the Data Warehouse
- Maintaining the Data Warehouse
- Analyzing and Visualizing Data
Certification
Labs - Please note: The labs for your AWS course will be delivered through AWS Builder labs. In order to access these labs you will need to have an Amazon BuilderID. You can set up your new Amazon account here. Please ensure that you have set up this Amazon BuilderID in advance of attending your class.
Courseware - Please note: In order to access your digital course materials you are required to set up a Gilmore account in advance of attending your course. To do this please follow this.
Please also be aware that in order to access your materials and Labs it is important that your device and network should not restrict access to AWS or Vitalsource content. For that reason, AWS recommend NOT using a Corporate laptop with any security restrictions in place or the use of a VPN.
Continue your learning pathway: view all AWS courses or compare related courses and follow-on options.
Is Data Warehousing on AWS AMWSDW right for me?
This course is for learners who want structured, expert-led training in cloud technology with practical workplace outcomes.
What will I learn on Data Warehousing on AWS AMWSDW?
You will build practical cloud technology skills, understand key concepts and apply the course outcomes in real workplace scenarios.
Does Data Warehousing on AWS AMWSDW include exam preparation?
Exam availability depends on the selected delivery option; check the course details before booking.
Talk to an expert
Thinking about Onsite?
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost-effective option. One-to-one training can be delivered too, at reasonable rates.
Submit an enquiry from any page on this site and let us know you are interested in the requirements box, or simply mention it when we contact you.
All $ prices are in USD unless it’s a NZ or AU date
SPVC = Self Paced Virtual Class
LVC = Live Virtual Class
Please note: All courses are available as Live Virtual Classes
Trusted by over 1/2 million students in 15 countries
Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.
