Amazon Redshift: Best Practices

Focused View

Anthony Sequeira

3:08:53

21 View

01. Course Overview

01. Course Overview.mp4

02:26

02. Designing and Deploying AWS Redshift

02. Introduction.mp4

02:51

03. The Redshift Architecture.mp4

07:34

04. Deploying AWS Redshift.mp4

07:02

05. Generating Test Data.mp4

10:46

06. Copying the Data.mp4

04:41

07. Creating the Cluster.mp4

07:11

08. Pausing the Cluster.mp4

02:52

09. Accessing Redshift.mp4

08:43

10. Basic Data Import.mp4

09:31

11. Cluster Management Best Practices.mp4

07:35

12. Designing Test Environments.mp4

02:28

13. Automating Redshift.mp4

02:56

14. Summary.mp4

01:45

03. Preparing and Migrating Data to AWS Redshift

15. Introduction.mp4

02:56

16. Database Migration Strategies.mp4

08:06

17. Execute and Validate Migration.mp4

06:27

18. Migrate from On-prem to the Cloud.mp4

03:17

19. Backup and Restore.mp4

08:50

20. Summary.mp4

01:36

04. Managing and Optimizing AWS Redshift

21. Introduction.mp4

01:47

22. Determine Maintenance Tasks.mp4

08:43

23. Resizing.mp4

04:47

24. Summary.mp4

00:42

25. AWS Redshift Spectrum.mp4

03:47

05. Securing AWS Redshift

26. Introduction.mp4

03:33

27. Security at Four Levels.mp4

07:02

28. Data Encryption and Tokenization.mp4

04:43

29. Configuration and Vulnerability Analysis.mp4

03:03

30. Summary.mp4

02:09

06. Monitoring and Auditing AWS Redshift

31. Introduction.mp4

02:09

32. CloudWatch and Redshift.mp4

04:40

33. Performance Data for QUERY LOADs.mp4

02:17

34. Event Notifications and Redshift.mp4

02:13

35. CloudTrail and Redshift.mp4

03:21

36. Summary.mp4

01:15

07. Troubleshooting AWS Redshift

37. Introduction.mp4

01:13

38. Data Loading Issues.mp4

07:52

39. Connection Issues.mp4

07:01

40. Query Issues .mp4

06:17

41. Summary.mp4

00:46

Description

Organizations want to develop a data warehouse solution that can meet the needs of the massive amount of data. This course will teach you how to make the most of AWS Redshift for the storage and retrieval of vast amounts of data.

What You'll Learn?

While many AWS Solutions Architects and SysOps administrators understand the RDBMS systems, they have little experience with data warehouse solutions. In this, course, AWS Redshift: Best Practices, you’ll learn to design, deploy, and maintain AWS Redshift solutions. First, you’ll explore the basic components and architectures of Redshift. Next, you’ll discover the many best practices associated with querying and operating Redshift. Finally, you’ll learn how to secure and monitor AWS Redshift. When you’re finished with this course, you’ll have the skills and knowledge of the best practices of AWS Redshift. These skills are needed to ensure your Redshift solution is performance, operationally sound, highly available, secure, and cost effective.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Amazon AWS

Anthony Sequeira

Instructor's Courses

Anthony Sequeira (CCIE No. 15626) began his IT career in 1994 with IBM in Tampa, Florida. He quickly formed his own computer consultancy, Computer Solutions, and then discovered his true passion - teaching and writing about Information Technology. Anthony has lectured to massive audiences around the world while working for Mastering Computers. Anthony has never been happier in his career as a freelance author and trainer. Of course, Pluralsight is one of his favorite engagements! He is an avid tennis player, a private pilot, a semi-professional poker player, and enjoys many other hobbies.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.