Overview
The Data Warehousing on AWS course focuses on leveraging Amazon Redshift, a petabyte-scale data warehouse service in AWS, to develop an effective cloud-based Data Warehousing System. Throughout the course, participants will gain exposure to principles, techniques, and best practices for building and optimising data warehouses in the cloud.
By enrolling in this course, you will learn how to harness the power of various AWS services to gather, store, and prepare data for your data warehouse. Services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3 will be explored, enabling you to understand their roles in the data warehousing process.These services provide scalable and reliable solutions for data ingestion, storage, and transformation, enhancing the overall efficiency of your data warehouse.
Moreover, the course covers how to effectively analyze the data within your data warehouse using Amazon QuickSight. QuickSight offers intuitive and interactive visualization capabilities that empower users to gain valuable insights from their data.
Throughout the course, you will not only learn about the individual services but also understand how they integrate and work together to create a comprehensive data warehousing solution on AWS. The course emphasises best practices to ensure optimal performance, scalability, and security of your data warehouse.
Intended Audience
- Database Architects
- Database Administrators
- Database Developers
- Data Analysts
- Data Scientists
Prerequisites
- Enrolled on AWS Technical Essentials course
- Knowledge of relational databases
- Knowledge of database design concepts
Deliverables
- Understand the fundamental principles of data warehousing and how big data solutions and data warehousing connect
- Launch an Amazon Redshift cluster and construct a cloud data warehouse using its components, features, and capabilities
- Contribute to the data warehousing solution by leveraging other AWS data and analytical services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis and Amazon S3
- Understand data warehouse’s designRecognise performance problems, improve queries, and tune the database for improved performance
- To analyze data directly from an Amazon S3 bucket, utilise Amazon Redshift Spectrum
- Perform data analysis and visualisation tasks against the data warehouse using Amazon QuickSight
Contact Us
Testimonials
“
Thoroughly enjoyed Security Essentials it was engaging and well delivered. The course was well structured and instructor was knowledgable.
Arthur Jones
Solutions Architect
“
I got a lot of value from the course, we covered a large amount of material in the short time it ran. The labs we did with our own AWS accounts were very useful.
James White
Cloud Engineer
“
Excellent course that was very informative, covering theory and then reinforcing with hands on examples.
Jason George
Cloud Support Engineer