Agent Mode
English
    Listing Thumbnail

    Data Warehousing on AWS (AWS-DWAWS)

     Info
    Sold by: Adistec Corp. 
    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). You'll also explore how to use business intelligence (BI) tools to perform analysis on your data.

    Overview

    Try agent mode
    Create proposal
    Ask question

    Course description

    Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloudbased 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.

    Course level: Intermediate

    Duration 3 days

    Activities

    This course includes presentations, group exercises, and hands-on labs.

    Intended audience

    This course is intended for:

    • Database Architects
    • Database Administrators
    • Database Developers
    • Data Analysts
    • Data Scientists

    Prerequisites

    We recommend that attendees of this course have:

    • Taken AWS Technical Essentials (or equivalent experience with AWS)
    • Familiarity with relational databases and database design concepts

    Course Outline

    • Module 1: Introduction to Data Warehousing
    • Module 2: Introduction to Amazon Redshift
    • Module 3: Launching clusters
    • Module 4: Designing the database schema
    • Module 5: Identifying data sources
    • Module 6: Loading data
    • Module 7: Writing queries and tuning for performance
    • Module 8: Amazon Redshift Spectrum
    • Module 9: Maintaining clusters
    • Module 10: Analyzing and visualizing data

    Highlights

    • What you'll learn Evaluate the relationship between Amazon Redshift and other Big Data systems; Evaluate use cases for data warehousing workloads and review real-world implementation of AWS data and analytic services as part of a data warehousing solution; Choose an appropriate Amazon Redshift node type and size for your data needsUnderstand which security features are appropriate for Amazon Redshift, such as encryption, IAM permissions, and database permissions and much more.

    Details

    Sold by
    Adistec Corp. 
    Categories
    Education & Research 
    Training 
    Delivery method
    Deployed on AWS
    New

    Introducing multi-product solutions

    You can now purchase comprehensive solutions tailored to use cases and industries.

    Learn more 
    Explore multi-product solutions
    Multi-product solutions

    Pricing

    Custom pricing options

    Request private offer
    Pricing is based on your specific requirements and eligibility. To get a custom quote for your needs, request a private offer.

    How can we make this page better?

    We'd like to hear your feedback and ideas on how to improve this page.
    We'd like to hear your feedback and ideas on how to improve this page.

    Legal

    Content disclaimer

    Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.

    Resources

    Vendor resources

    Datasheet 

    Support

    Vendor support