Data Warehousing on AWS
You will be introduced to concepts, strategies and best practices for designing cloud-based data warehousing solutions using Amazon RedShift. The course also teaches you how to collect, store and analyze data for the data warehouse by using AWS services.
- Live Demonstrations
- Group Discussions
- Frequent Knowledge Checks
- Hands-On Labs
- Database Architects
- Database Administrators
- Database Developers
- Data Analysts
- Data Scientists
- Taken AWS Technical Essentials (or equivalent experience with AWS)
- Knowledge of relational databases and database design concepts
Module 1: Introduction to Data Warehousing
- Relational databases
- Data warehousing concepts
- The intersection of data warehousing and big data
- Overview of data management in AWS
- Hands-on lab 1: Introduction to Amazon Redshift
Module 2: Introduction to Amazon Redshift
- Conceptual overview
- Real-world use cases
- Hands-on lab 2: Launching an Amazon Redshift cluster
Module 3: Launching clusters
- Building the cluster
- Connecting to the cluster
- Controlling access
- Database security
- Load data
- Hands-on lab 3: Optimizing database schemas
Module 4: Designing the database schema
- Schemas and data types
- Columnar compression
- Data distribution styles
- Data sorting methods
Module 5: Identifying data sources
- Data sources overview
- Amazon S3
- Amazon DynamoDB
- Amazon EMR
- Amazon Kinesis Data Firehose
- AWS Lambda Database Loader for Amazon Redshift
- Hands-on lab 4: Loading real-time data into an Amazon Redshift database
Module 6: Loading data
- Preparing Data
- Loading data using COPY
- Maintaining tables
- Concurrent write operations
- Troubleshooting load issues
- Hands-on lab 5: Loading data with the COPY command
Module 7: Writing queries and tuning for performance
- Amazon Redshift SQL
- User-Defined Functions (UDFs)
- Factors that affect query performance
- The EXPLAIN command and query plans
- Workload Management (WLM)
- Hands-on lab 6: Configuring workload management
Module 8: Amazon Redshift Spectrum
- Amazon Redshift Spectrum
- Configuring data for Amazon Redshift Spectrum
- Amazon Redshift Spectrum Queries
- Hands-on lab 7: Using Amazon Redshift Spectrum
Module 9: Maintaining clusters
- Audit logging
- Performance monitoring
- Events and notifications
- Lab 8: Auditing and monitoring clusters
- Resizing clusters
- Backing up and restoring clusters
- Resource tagging and limits and constraints
- Hands-on lab 9: Backing up, restoring and resizing clusters
Module 10: Analyzing and visualizing data
- Power of visualizations
- Building dashboards
- Amazon QuickSight editions and features
Why choose Cloud Wizard
- Advanced Tier Training Partner
- Amazon Authorised Instructors
- Official AWS Content
- Hands-on Labs
Class Deliverables
- E-Content kit by AWS
- Hands-on labs
- Class completion certificates
- Exam Prep sessions
Dates Available
Choose a date that works for you and click on Book Now to proceed with your registration.
Don't see a date that works for you?
Fill in the form below to let us know.
Related courses
Related products
-
AWS Training
Building Data Lakes on AWS
In this course you will learn how to build an operational data lake which supports analysis of both structured and unstructured data. You will get to learn the parts and the functionality of the services that are involved in the creation of a data lake. You will learn to use AWS lake formation to build a data lake, also use AWS Glue to build a data catalog and Amazon Athena to analyze data.
The course is best suited for Data platform engineers, solution architects and IT professionals. We recommend that you should have completed the AWS Technical Essentials classroom course or have at least one year of experience in building data analytics pipelines. An expert AWS instructor delivers this course with the help of presentations, lectures, hands-on labs and group exercises
-
AWS Training
Running Containers on Amazon Elastic Kubernetes Service
This three day course is focused on container management and orchestration for Kubernetes using Amazon EKS. You will learn how to build Amazon EKS cluster, configure the environment, deploy and add applications to the cluster. You will understand how to deploy applications using the CI/CD tools along with monitoring and scaling your environment by using metrics. Additionally, you’ll find out how to configure AWS networking services to support the cluster and secure your Amazon EKS environment.
The course is suitable for DevOps engineers and system administrators along with anyone who works around providing container orchestration management in the AWS cloud. Before enrolling for this course you are recommended to have completed AWS Cloud Practitioner Essentials and have basic knowledge of containers, microservices and linux administration.
-
AWS Training
AWS Cloud Financial Management for Builders
Under this course you will learn how to manage, optimize and estimate costs of AWS workloads. You will understand how to implement Architectural best practices, optimize costs and design patterns to architect cost-efficient solutions on the AWS Cloud.
Moreover, you’ll explore the costs of core AWS Services, including those associated with current and future cloud workloads. You’ll also learn key practices for reducing overall AWS cloud costs and utilizing AWS tools to manage, monitor, and optimize spending on the AWS cloud.
The course is best suited to the following individuals – Solution Architects, Developers, System Administrators, cost-optimization leads and other technical users who are interested in learning to build and operate cost-efficient cloud architectures
-
AWS Training
AWS Technical Essentials
This introductory course is designed to teach you AWS products, services and common solutions. You will understand the basics of identifying appropriate AWS services to make conscious decisions based on your business requirements
You will learn several terms and concepts related to the AWS Cloud along with navigating the AWS Management console, AWS Security measures and AWS Identity and Access Management
If you work with customers to share the technical benefits of the AWS Cloud with them, this course is for you. SysOps administrators, Solution Architects and developers along with Individuals who are keen to learn the AWS cloud can also join. The course is delivered by AWS Instructors with a mix of theoretical and practical exercises
