Welcome to Agilewing

Training

[Special courses] Data Warehousing
  • Lecturer

    Agilewing

  • Course Level

    Solution-based Training

  • ¥6,300.00

    Add to cart
  • Course description
  • Syllabus
  • Data 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.

  •  Course targets

    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.

     

    Target population

    This course applies to:

     Database architect
     Database administrator
     Database developer
     Data analysts and scientists

     

    prerequisites

    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

     

    The way to teach

    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

     

    Course Outline

    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

Comment

There are no reviews yet.

Be the first to review “[Special courses] Data Warehousing”

Your email address will not be published. Required fields are marked *

[Special courses] Data Warehousing

Please note: the number of students and information cannot be modified after submission.