Course Description
Data Warehousing on AWS introduces professionals to concepts, strategies, & ideal 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, & prepare data for the data warehouse using AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, & Amazon S3. This course demonstrates how to use Amazon QuickSight to analyze your data.
Prerequisites
We recommend that participants of this course have the following:
- Taken AWS Technical Essentials (or equivalent experience with AWS)
- Familiarity with relational databases & database design concepts
Target Audience
This course is intended for:
- Database Architects
- Database Administrators
- Database Developers
- Data Analysts
- Data Scientists
Course Objectives
In this course, you will:
- Discuss the core concepts of data warehousing, & the intersection between data warehousing & big data solutions
- Launch an Amazon Redshift cluster & use the components, features, & functionality to implement a data warehouse in the cloud
- Use other AWS data & analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, & Amazon S3, to contribute to the data warehousing solution
- Architect the data warehouse
- Identify performance issues, optimize queries, & 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 & visualization tasks against the data warehouse
Content Outline
- Relational databases
- Data warehousing concepts
- The intersection of data warehousing & big data
- Overview of data management in AWS
- Hands-on lab 1: Introduction to Amazon Redshift
- Conceptual Overview
- Real-world use cases
- Hands-on lab 2: Launching an Amazon Redshift cluster
- Building the cluster
- Connecting to the cluster
- Controlling access
- Database security
- Load data
- Hands-on lab 3: Optimizing database schemas
- Schemas & data types
- Columnar compression
- Data distribution styles
- Data sorting methods
- 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
- Preparing Data
- Loading data using COPY
- Maintaining tables
- Concurrent write operations
- Troubleshooting load issues
- Hands-on lab 5: Loading data with the COPY command
- Amazon Redshift SQL
- User-Defined Functions (UDFs)
- Factors that affect query performance
- The EXPLAIN command & query plans
- Workload Management (WLM)
- Hands-on lab 6: Configuring workload management
- Amazon Redshift Spectrum
- Configuring data for Amazon Redshift Spectrum
- Amazon Redshift Spectrum Queries
- Hands-on lab 7: Using Amazon Redshift Spectrum
- Audit logging
- Performance monitoring
- Events & notifications
- Power of visualizations
- Building dashboards
- Amazon QuickSight editions & features
FAQs
A data lake is a centralized & secured repository that collects all your data, both in its original form & prepared for analysis.
There are three methods of data storage, namely: –
- Object storage
- File storage
- Block storage
EC2 is a service that enables business clients to run application programs in the computing environment.
AWS security provides opportunities to protect the data, check out security-related activity & receive automated responses.
Radiant believes in a practical & creative approach to training & development, which distinguishes it from other training & development platforms. Moreover, training courses are undertaken by some experts with a vast range of experience in their domain.
Radiant team of experts will be available at e-mail support@radianttechlearning.com to answer your technical queries after the training program.
Yes, Radiant will provide you most updated, high, value & relevant real-time projects & case studies in each training program.
Technical issues are unpredictable & might occur with us as well. Participants must ensure access to the required configuration with good internet speed.
Radiant Techlearning offers training programs on weekdays, weekends & combination of weekdays & weekends. We provide you with complete liberty to choose the schedule that suits your needs.