All Courses Power Up Your Data Analysis with Redshift
Power Up Your Data Analysis with Redshift
Understand the core concepts and architecture of Amazon Redshift. Learn how to set up and configure a Redshift cluster. Master data loading and ETL processes in Redshift. Gain proficiency in writing SQL queries and performing complex data analysis. Optimize query performance and manage Redshift resources effectively. Utilize Redshift's integration with other AWS services.
Instructors:
SJ Sushmitha J
Start Learning
You have opted to be notified for this course. You will receive an email when the course becomes available.
5 Enrolled
32 Lessons

This self-paced course on Amazon Redshift provides comprehensive training for data warehousing and analytics using Amazon's powerful cloud-based data warehouse service. This course covers everything from setting up your Redshift cluster to performing advanced data analysis. You will learn how to efficiently load, query, and manage your data, ensuring optimal performance and security. By the end of this course, you'll have the skills to leverage Amazon Redshift for your organization's data warehousing needs, integrating seamlessly with other AWS services for a robust data solution.

Course Content
AWS Redshift
Launching a Cluster
Columnar Storage Vs Row Oriented Storage
Folder creation, Redshift Schema and Table Creation
SQL SELECT, DISTINCT statement
SQL WHERE predicate examples
Sort in database
Aggregate Functions
Database Joins
Database Union, Union all, Intersect and Except
Having in Database
Subquery
ALTER TABLE and UPDATE
Data Movement
Type casting
COALESCE or NVL
Window functions
User Defined functions
Sort and Dist Keys
Table distribution
Distribution styles
Implementing Dist key and Sort key
DB Views and Primary Key
Encoding Techniques
Workload Management
WLM Query Queues
WLM User groups
WLM Memory percent
WLM Timeout
WLM Query Queue Hopping
Implementing WLM Redshift
RedShift Skills Review
Reviews
Review the course
Help us improve our course material.
Write a review