Building Data Analytics Solutions Using Amazon Redshift
Course description
You will create a data analytics solution in this course utilizing the cloud data warehouse provider Amazon Redshift. The course focuses on the parts of the analytics pipeline that deal with data collection, ingestion, cataloging, storage, and processing. You will discover how to use Amazon Redshift with a data lake to support machine learning and analytics workloads. Additionally, you will find how to use Amazon Redshift’s best practices for security, performance, and cost control.
Activities
This AWS course will include the following activities:
- Group Discussions
- Live Demonstrations
- Presentations
- Hands-On Labs
- Knowledge Checks
Course Objectives
Intended Audience
Prerequisites
Module Breakdown
Module A: Overview of Data Analytics and the Data Pipeline
- Data analytics use cases
- Using the data pipeline for analytics
Module 1: Using Amazon Redshift in the Data Analytics Pipeline
- Why Amazon Redshift for data warehousing?
- Overview of Amazon Redshift
Module 2: Introduction to Amazon Redshift
- Amazon Redshift architecture
- Interactive Demo 1: Touring the Amazon Redshift console
- Amazon Redshift features
- Practice Lab 1: Load and query data in an Amazon Redshift cluster
Module 3: Ingestion and Storage
- Ingestion
- Interactive Demo 2: Connecting your Amazon Redshift cluster using a Jupyter notebook with Data API
- Data distribution and storage
- Interactive Demo 3: Analyzing semi-structured data using the SUPER data type
- Querying data in Amazon Redshift
- Practice Lab 2: Data analytics using Amazon Redshift Spectrum
Module 4: Processing and Optimizing Data
- Data transformation
- Advanced querying
- Practice Lab 3: Data transformation and querying in Amazon Redshift
- Resource management
- Interactive Demo 4: Applying mixed workload management on Amazon Redshift
- Automation and optimization
- Interactive demo 5: Amazon Redshift cluster resizing from the dc2.large to ra3.xlplus cluster
Module 5: Security and Monitoring of Amazon Redshift Clusters
- Securing the Amazon Redshift cluster
- Monitoring and troubleshooting Amazon Redshift clusters
Module 6: Designing Data Warehouse Analytics Solutions
- Data warehouse use case review
- Activity: Designing a data warehouse analytics workflow
Module B: Developing Modern Data Architectures on AWS
- Modern data architectures
CERTIFICATION : AWS CERTIFIED DATA ANALYTICS - SPECIALTY
This certification enables businesses to find and nurture personnel with the essential competencies to carry out cloud activities. AWS Certified Data Analytics – Specialty status verifies knowledge of how to use AWS data lakes and analytics services to extract insights from data.
Read MoreEXAM READINESS: AWS CERTIFIED DATA ANALYTICS - SPECIALTY
The AWS Certified Data Analytics – Specialty exam verifies candidates’ proficiency in building, deploying, and fine-tuning data models, as well as in utilizing AWS services to scale up this process. In this intermediate-level course, learn how to study for the exam by reviewing the subject areas and how they relate to Data analysis on AWS.
Read MoreFAQ's
Frequently Asked Questions Title
Frequently Asked Questions description
Frequently Asked Questions Title
Frequently Asked Questions description
Frequently Asked Questions Title
Frequently Asked Questions description
Frequently Asked Questions Title
Frequently Asked Questions description
Frequently Asked Questions Title
Frequently Asked Questions description
Frequently Asked Questions Title
Frequently Asked Questions description
Course Schedule
Course Name | Date | Register |
---|