Amazon Web Services (AWS)
Data Warehousing on AWS
Design and run a data warehouse on Amazon Redshift.
3 daysIntermediate10 modules
About this course
Design and run a data warehouse on Amazon Redshift. You will launch clusters, design schemas, integrate and load data, write and tune queries, use Redshift Spectrum and maintain clusters over time.
Curriculum
10 modules
- Understand fundamental data warehousing concepts and how they align with cloud solutions. Explore the intersection of data warehousing and big data in AWS.
- Overview of Redshift’s architecture and key functionality. Examine real-world use cases and how Redshift integrates with other AWS services.
- Build and configure a Redshift cluster. Implement IAM access management, data encryption, and control user permissions.
- Optimize table design with columnar compression, distribution styles, and sorting. Use best practices to enhance query performance and scalability.
- Connect to Amazon S3, Amazon EMR, Amazon Kinesis Firehose, and DynamoDB. Use AWS Lambda and custom ingestion methods for real-time data flows.
- Use the COPY command to ingest and prepare data for the data warehouse. Handle concurrent writes, data validation, and data processing workflows.
- Use Redshift SQL, UDFs, and the EXPLAIN command. Apply techniques for performance tuning, workload balancing, and resource optimization.
- Query data directly from Amazon S3 without loading it into Redshift. Configure external schemas and run Spectrum queries for serverless analytics.
- Monitor performance with CloudWatch, manage events, backups, and cluster resizing. Review disaster recovery, logging, and cluster management strategies.
- Use Amazon QuickSight to create dashboards and visual reports. Compare QuickSight editions and explore its use for SQL-based analytics and business intelligence.
Who it's for
Database architects, BI developers and data engineers.
Before you start
- AWS Technical Essentials (or equivalent experience with AWS)
- Familiarity with relational databases and database design concepts
Related courses
More in Amazon Web Services (AWS) →Foundation
AWS Technical Essentials
Amazon Web Services (AWS)
View course →Intermediate
Developing on AWS
Amazon Web Services (AWS)
View course →Intermediate
Security Engineering on AWS
Amazon Web Services (AWS)
View course →Advanced
Advanced Architecting on AWS
Amazon Web Services (AWS)
View course →Advanced
Advanced Developing on AWS
Amazon Web Services (AWS)
View course →Advanced
Advanced Generative AI Development on AWS
Amazon Web Services (AWS)
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.