Training
Lecturer
Agilewing
Course Level
Solution-based Training
¥6,300.00
Add to cartData Warehousing on cloud vendors introduces you to concepts, strategies, and best practices for designing cloud-based data warehouses using Redshift, a petabyte-scale data warehouse in cloud vendors. This course shows how to use other cloud vendors services such as DynamoDB, EMR, Kinesis Firehose, and S3 to collect, store, and prepare data for a data warehouse. In addition, this course will show how to perform analytics on data using business intelligence tools.
By taking this course, you will be able to:
Discuss the core concepts of a data warehouse.
Evaluate the relationship between Redshift and other big data systems.
Evaluate use cases for data warehouse workloads and review case studies that demonstrate the implementation of Cloud vendors big data and analytics services when designing data warehouse solutions.
Choose the appropriate Redshift node type and size based on your data needs.
Discuss security features related to Redshift, such as encryption, IAM permissions, and database permissions.
Launch an Redshift cluster and implement a data warehouse in the cloud using various components, features, and functions.
Use other Cloud vendors data and analytics services such as DynamoDB, EMR, Kinesis Firehose, and S3 to help design data warehouse solutions.
Evaluate the methods and methods used to design the data warehouse.
Identify data sources and evaluate requirements that affect the design of the data warehouse.
Design the data warehouse to effectively use compression, data distribution, and classification methods.
Load and unload data and perform data maintenance tasks.
Write queries and evaluate query plans to optimize query performance.
Configure the database to allocate resources such as memory to the query queue, and define criteria to route certain types of queries to the configured query queue to improve processing efficiency.
Use a variety of features and services (such as Redshift database audit logging, CloudTrail, CloudWatch, and Simple Notification Service [SNS]) to audit, monitor, and receive event notifications about activities in the data warehouse.
Prepare for operational tasks, such as sizing Redshift clusters and using snapshots to back up and restore clusters.
Zh
Use business intelligence (BI) applications to perform analysis and visualization tasks on the data.
This course applies to:
Database architect
Database administrator
Database developer
Data analysts and scientists
We recommend that those attending this course meet the following prerequisites:
Complete the following courses: Cloud vendors Technical Essentials (or equivalent Cloud vendors experience) Familiar with relational databases and database design concepts
This course will be taught in combination with:
Instructor-led training (ILT)
Hands-on lab
Hands-on activities
This course allows you to experiment with new technologies and apply what you have learned to your work environment through various practical exercises
Day 1
Course Introduction
Introduction to Data Warehouse
Introduction to Redshift
Understanding Redshift components and resources
Launch an Redshift cluster
Day 2
View data warehouse methods
Identify data sources and requirements
Designing a data warehouse
Load data into the data warehouse
3rd day
Write queries and optimize performance
Maintaining the data warehouse
Analyze and visualize data
Lesson summary
Recommended for you
[Special courses] Data Warehousing
Comment
There are no reviews yet.