1. Home
  2. Training Library
  3. Amazon Web Services
  4. Courses
  5. Loading Data into Amazon Redshift

Loading Data into Amazon Redshift

Contents

keyboard_tab
Loading Data into Amazon Redshift
1
Introduction
PREVIEW1m 52s
2
Amazon Redshift
PREVIEW3m 16s
6
Summary
1m 34s
Introduction
Overview
Difficulty
Intermediate
Duration
23m
Students
129
Ratings
5/5
starstarstarstarstar
Description

This course covers how to load your data efficiently using the COPY command in Amazon Redshift. You'll learn how it can be used to load multiple or a single large file into Amazon Redshift, as well as the different features that the COPY command has to offer and what data upserting is.

Learning Objectives

  • Understand the essentials of the COPY command in Redshift and its features
  • Learn how to load single or multiple large files into Redshift
  • Learn what upserting is and why it's important

Intended Audience

This course is intended for people that want to learn more about how to load their data efficiently using the COPY command.

Prerequisites

To get the most from this course, you should have a basic understanding of Amazon Redshift and Data Analytics concepts.

Transcript

Hello and welcome to this course on how to load data in Amazon Redshift 

My name is Stephen Cole and I’ll be your instructor for this course.  I’ve been working in the cloud for several years and currently hold many active AWS certifications.

My contact information is shown on the screen.  Please feel free to reach out to me with any questions, comments, or concerns.  

Alternatively, you can always get in touch with us here at Cloud Academy by sending an email to support@cloudacademy.com and one of our cloud experts will follow up with you.

This course is intended for people that want to learn more about how to load your data efficiently using the COPY command.

By the end of this course you will have a greater understanding of the COPY command and how it can be used to load multiple or a single large file into Amazon Redshift.  I will also be discussing the different features that the COPY command has to offer, and what upserting data is and why it’s important to understand.

To get the most from this course you should have a basic understanding of Amazon Redshift and Data Analytics concepts.

Feedback on our courses here at Cloud Academy is valuable to both us as trainers and any students looking to take the same course in the future. If you have any feedback, positive or negative, it would be greatly appreciated if you could contact support@cloudacademy.com.

Please note that, at the time of writing this content, all course information was accurate.  AWS implements hundreds of updates every month as part of its ongoing drive to innovate and enhance its services. As a result, minor discrepancies may appear in the course content over time.  Here at Cloud Academy, we strive to keep our content up to date in order to provide the best training available. So, if you notice any information that is outdated, please contact support@cloudacademy.com.  This will allow us to update the course during its next release cycle.

Thank you! 

About the Author
Avatar
Stephen Cole
AWS Certification Specialist
Students
17151
Courses
18
Learning Paths
5

Stephen is the AWS Certification Specialist at Cloud Academy. His content focuses heavily on topics related to certification on Amazon Web Services technologies. He loves teaching and believes that there are no shortcuts to certification but it is possible to find the right path and course of study.

Stephen has worked in IT for over 25 years in roles ranging from tech support to systems engineering. At one point, he taught computer network technology at a community college in Washington state.

Before coming to Cloud Academy, Stephen worked as a trainer and curriculum developer at AWS and brings a wealth of knowledge and experience in cloud technologies.

In his spare time, Stephen enjoys reading, sudoku, gaming, and modern square dancing.