Live Online (VILT) & Classroom Corporate Training Course
In this course, you'll learn concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. The course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis Firehose, and Amazon Simple Storage Service (Amazon S3).
How can we help you?
CloudLabs
Projects
Assignments
24x7 Support
Lifetime Access
Overview
Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data.
Activites
This course includes presentations, group exercises, and hands-on labs.
Objectives
In this Data Warehousing on AWS course, , participants will be able to:
Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions
Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud
Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3, to contribute to the data warehousing solution
Architect the data warehouse
Identify performance issues, optimize queries, and tune the database for better performance
Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket
Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse
Prerequisites
We recommend that attendees of Advanced Developing on AWS course have the following prerequisites:
Taken AWS Technical Essentials (or equivalent experience with AWS)
Familiarity with relational databases and database design concepts
Course Outline
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
Introduction to Amazon Redshift
Conceptual overview
Real-world use cases
Hands-on lab 2: Launching an Amazon Redshift cluster
Launching clusters
Building the cluster
Connecting to the cluster
Controlling access
Database security
Load data
Hands-on lab 3: Optimizing database schemas
Designing the database schema
Schemas and data types
Columnar compression
Data distribution styles
Data sorting methods
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
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
s-on lab 4: Loading real-time data into an Amazon Redshift database
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
Amazon Redshift Spectrum
Amazon Redshift Spectrum
Configuring data for Amazon Redshift Spectrum
Amazon Redshift Spectrum Queries
Hands-on lab 7: Using Amazon Redshift Spectrum
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
Analyzing and visualizing data
Power of visualizations
Building dashboards
Amazon QuickSight editions and features
AWS Discovery Days
Supercharge your workforce’s AWS skills with our complimentary Privately Hosted AWS Discovery Day. Delivered by our team of renowned AWS Authorized Instructors, this tailored experience will propel your organization’s technological capabilities to new heights.
Testimonials
Synergific Software Team has been very supportive, and working with them has been a best decision that we
could ever made, They are just a call away. You guys are AWESOME, Thank You, Keep up the Good Work!!!
Shamsudeen Bawa
Vice President, J.P Morgan, CIS, USA
Synergific Software has been of great help and I plan to continue to use your services in the future for
my business needs.
Farhan Hafiz
Data Architect, Fiserv
I think Synergific Software is great. I liked that it was hassle free and easy to set up. Again, it's a great feature for a fast and cheap set up, which gives me peace of mind, as I know have a terms of use agreement.
Dr. Sahdev Singh
Under Secretary, Ministry of Law & Justice, Govt. of India
I liked using Synergific Software very much. I thought the website was easy to navigate and the instructions for generating the terms was clear. I even recommended you on a Facebook Group I am a member of.
