Welcome to Agilewing
Careers Shopping cart ( 0 )
语言

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

Recommended for you

[Elementary Course] Business Essentials

Agilewing

[Elementary Course] Business Essentials

0

683 Views

$2100

[Elementary Course]Cloud Practitioner Essential

Agilewing

[Elementary Course]Cloud Practitioner Essential

0

910 Views

$2100.00

[Intermediate courses] Systems Operations

Agilewing

[Intermediate courses] Systems Operations

0

1,979 Views

$6300.00

[Special courses] Migrating

Agilewing

[Special courses] Migrating

0

2,170 Views

$4200.00

[Advanced Course] DevOps Engineering

Agilewing

[Advanced Course] DevOps Engineering

0

1,594 Views

$6300.00

[Intermediate courses] Developing

Agilewing

[Intermediate courses] Developing

0

1,497 Views

$6300.00

[Intermediate courses] Architecting

Agilewing

[Intermediate courses] Architecting

0

1,355 Views

$6300.00

[Special courses] Building a Serverless Data Lake

Agilewing

[Special courses] Building a Serverless Data Lake

0

1,433 Views

$2100.00

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.

Contact Us

Contact Us

About us

Cloud Services

CloudFront Service

Partner Network

Security & Compliance

Training

Support Center

Careers

Copyright © 2011-2022 Agilewing Technology Co. Limited

  • Follow us