Redshift入門

中級スキルレベル

更新日 2024/12

Amazon RedshiftのSQL、データ管理、最適化、セキュリティを習得しましょう。

コース説明

前提条件

Data Manipulation in SQL

Redshift, a data warehouse

Meet Redshift, a robust columnar data warehouse. We'll explore how columnar and typical data warehouses differ, what makes Redshift unique, how it fits into the AWS and data warehouse ecosystems, and what data types it supports.

Meet Redshift, a columnar database

50 XP

Columnar or Row-Based

100 XP

Find what schema a table is in

50 XP

Learning about Redshift data types and features

50 XP

Experimenting with compatible types

100 XP

Redshift types

50 XP

Explicitly converting types

100 XP

Inside the Redshift warehouse

50 XP

Node types and responsibilities

100 XP

Predicates

50 XP

Leader specific functions

100 XP

チャプターを開始

SQL on Redshift

Let's learn about some nuances with Redshift SQL syntax, a close cousin of PostgreSQL's syntax. We compare CTEs and subqueries before moving into mastering date and time, exploring window queries, and wrapping up learning how transactions affect some functions.

Using CTEs with Redshift

50 XP

Filtering with CTEs

100 XP

CTE Concepts

50 XP

Date and time functions

50 XP

Truncating dates

100 XP

Extracting date parts

100 XP

Find future dates

100 XP

Windowing in Redshift

50 XP

Windowing to the max

100 XP

Comparing periods with lag

100 XP

Transactions

50 XP

Transaction structure

100 XP

Consistent dates in a transaction

100 XP

チャプターを開始

Tables and working with semi-structured data

We'll explore how to create tables, the impact DISTKEY and SORTKEYs have on performance, external schemas/tables with Spectrum and wrap up with handling semi-structured data like JSON with Redshift.

Tables in Redshift

50 XP

Creating a table and setting properties

100 XP

Learning more about a table's columns

100 XP

External Schemas, File, and Table Formats

50 XP

Table formats vs file types

100 XP

Identifying internal and external schemas

100 XP

Finding the internal or external tables

100 XP

Semistructured data

50 XP

Extracting top level JSON keys

100 XP

Extracting nested JSON keys

100 XP

チャプターを開始

Optimization and Security

It is time to peak into the world of writing optimized queries and tools available to help optimize. Then, we turn our attention to Redshift security capabilities and how they can impact query output.

Writing optimal queries

50 XP

DISTKEY and SORTKEY

100 XP

Optimized GROUP BY and ORDER BY

100 XP

Understanding query performance

50 XP

Evaluating filter performance

50 XP

EXPLAINing query behavior

100 XP

Redshift security

50 XP

Checking for column-level security

100 XP

Checking for row-level security

100 XP

Identifying dynamic data masking

50 XP

Congratulations

50 XP

チャプターを開始

Redshift入門

コース完了

修了証明書を取得

この修了書をLinkedInや履歴書、CVに追加しましょう
ソーシャルメディアや人事評価で共有しましょう今すぐ登録

Redshift入門

チームのトレーニングを担当していますか？

コース説明

前提条件

Redshift, a data warehouse

SQL on Redshift

Tables and working with semi-structured data

Optimization and Security

修了証明書を取得

19百万人を超える学習者と共にRedshift入門を始めましょう！

DataCamp for Mobileでデータスキルを磨きましょう

コース説明

修了証明書を取得

.css-nklxlk{color:var(--wf-brand--main, #03EF62);}19百万人を超える学習者と共にRedshift入門を始めましょう！

無料アカウントを作成

DataCamp for Mobileでデータスキルを磨きましょう

19百万人を超える学習者と共にRedshift入門を始めましょう！