|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/aws-redshift/
课程评论：没有评论
课程名称：亚马逊红移开发者指南 课程概述：本课程涵盖了红移的架构、列式与行式数据库的区别，并介绍了AWS VPC、IAM角色及S3存储桶的创建。您将掌握SQL的最佳实践，并学习一些有助于建立有效数据仓库的管理活动。此外，本课程还介绍了压缩/编码技术，让您能够实现工作负载管理，并监控和调整长时间运行的查询。许多数据工程师对如何从数据库中检索数据可能感到困惑，因此在处理大数据时，编写优化查询是必不可少的，了解架构和数据的流动对于撰写最佳查询至关重要。即使没有SQL的基础知识，您也可以在这门短短2小时的教程中掌握SQL，成为专业人士。
This course covers the Architecture of Redshift, Columnar vs Row oriented databases, Introduce you to the AWS VPC, IAM role, and S3 bucket creation. You can master the SQL with best practices and learn a few admin activities which help to build an effective data warehouse. This course introduces compression/encoding techniques. You can learn to implement Workload management and monitor and tune long-running queries. I always noticed most of the data engineers are clueless about how data is retrieved from the database. Writing an optimized query is a must when dealing with big data, understanding the architecture and the movement of the data is very important to write the best query. Without prior knowledge on SQL, you can master the SQL and become a pro with this short 2 Hour tutorial.
