Building Data Analytics Solutions Using Amazon Redshift Training
Duration
Prerequisites
- A minimum of one-year experience managing data warehouses.
- Completed either AWS Technical Essentials or Architecting on AWS
- Completed Building Data Lakes on AWS
Target Audience
Skills Gained
- Compare the features and benefits of data warehouses, data lakes, and modern data architectures
- Design and implement a data warehouse analytics solution
- Identify and apply appropriate techniques, including compression, to optimize data storage
- Select and deploy appropriate options to ingest, transform, and store data
- Choose the appropriate instance and node types, clusters, auto scaling, and network topology for a particular business use case
- Understand how data storage and processing affect the analysis and visualization mechanisms needed to gain actionable business insights
- Secure data at rest and in transit
- Monitor analytics workloads to identify and remediate problems
- Apply cost management best practices
- Overview of Data Analytics and the Data Pipeline
- Data analytics use cases
- Using the data pipeline for analytics
- Using Amazon Redshift in the Data Analytics Pipeline
- Why Amazon Redshift for data warehousing?
- Overview of Amazon Redshift
- Introduction to Amazon Redshift
- Amazon Redshift architecture
- Amazon Redshift features
- Ingestion and Storage
- Ingestion
- Data distribution and storage
- Querying data in Amazon Redshift
- Processing and Optimizing Data
- Data transformation
- Advanced querying
- Resource management
- Automation and optimization
- Security and Monitoring of Amazon Redshift Clusters
- Securing the Amazon Redshift cluster
- Monitoring and troubleshooting Amazon Redshift clusters
- Designing Data Warehouse Analytics Solutions
- Data warehouse use case review
- Activity: Designing a data warehouse analytics workflow
- Developing Modern Data Architectures on AWS
- Modern data architectures
Partner Registration
The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.
You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.
Partner Registration
The course you are registering for is being delivered by our sister company - ExitCertified. All logistics related to course delivery will be managed by the ExitCertified team. If you have a dedicated Web Age representative, please feel to reach out to them with any questions/concerns you may have.
You'll now be redirected to https://www.exitcertified.com to complete the enrollment process.