London College Of Online Learning

HOME >> IT CERTIFICATIONS >> CLOUD SERVICES & VIRTUALISATION >> AWS Redshift Fundamentals

£99.00

Duration: 1 Hour 43 Minutes

43 Course Videos

AWS Redshift Fundamentals

Welcome to the AWS Redshift Fundamentals course, where you will embark on a comprehensive journey to master Amazon Redshift, one of the leading cloud-based data warehousing solutions. This course is designed to equip you with the foundational knowledge and practical skills necessary to effectively utilize Redshift for data analytics. You will explore the core concepts of data warehousing, understand AWS’s unique benefits and limitations, and learn how to deploy and manage Redshift clusters. With hands-on exercises and real-world applications, you will gain the expertise needed to optimize query performance and manage workloads efficiently.

Throughout the course, you will delve into advanced capabilities such as multi-AZ deployment, backup and recovery strategies, and data ingestion techniques. By the end of your learning experience, you will be well-prepared to handle the complexities of data warehousing in the cloud environment and make informed decisions about deploying and managing Amazon Redshift. This course is ideal for IT professionals looking to enhance their data management skills and for those preparing for AWS certification exams related to data warehousing and analytics.

Course Objectives

Understand the fundamentals of data warehouses and Amazon Redshift.
Identify AWS benefits and limitations in the context of data warehousing.
Learn about Redshift pricing and cost optimization strategies.
Deploy and manage Amazon Redshift clusters effectively.
Implement workload management and query optimization techniques.
Explore advanced capabilities, including multi-AZ deployments and data ingestion.
Monitor and maintain performance in Amazon Redshift environments.

Who Will Benefit from This Course

This course is ideal for data analysts, database administrators, data engineers, and IT professionals who are looking to deepen their understanding of cloud data warehousing solutions. It is also suitable for individuals preparing for AWS certifications, particularly those focused on data analytics and cloud architecture.

Potential Job Titles and Certifications

Data Analyst
Database Administrator
Data Engineer
AWS Certified Data Analytics – Specialty
AWS Certified Solutions Architect – Associate

Introduction - AWS Redshift Fundamentals

Course Welcome
Course Overview
Course PreRequirements

Section 1: AWS Redshift Fundamentals

1.1 Fundamentals of data warehouses and Amazon Redshift
1.2 AWS Benefits and Limitations
1.3 AWS Redshift Pricing
1.4 Enterprise Use Cases
1.5 Node Types
1.6 Cluster Options
1.7 Demo – Free Tier- Startup Credits
1.8 Hands on Exercise 1 – Deploy a Cluster
1.9 Whiteboard- Redshift Architecture
1.10 Life of a Query
1.11 Query and Cost Optimization
1.12 Workload Management
1.13 Whiteboard- Redshift WLM
1.14 Redshift Performance Notes
1.15 Column Oreiented structures
1.16 Section Review
1.17 Review Questions

Section 2: Advanced Capabilities

2.1 Advanced Capabilities
2.2 Deployment Options (node types, cluster options, etc.)
2.3 Multi-AZ deployment with Amazon Redshift
2.4 Backup and Recovery
2.5 Demo -Deploy Cluster
2.6 Demo – Resize Cluster
2.7 Networking and Security
2.8 Demo – Networking and Security
2.9 HOE – Setup IAM and Deploy Cluster
2.10 Whiteboard – Networking
2.11 Demo – Connect to Database
2.12 HOE – SQLWB
2.13 Excel Connections
2.14 Setting up and managing data ingestion with Amazon Redshift
2.15 HOE – AWS S3 Data Load
2.16 Monitoring Redshift
2.17 Demo – Monitor Redshift
2.18 HOE – Deploy an Amazon Redshift data warehouse cluster, load data into the cluster
2.19 Amazon Redshift Spectrum
2.20 Section Review
2.21 Review Questions
2.22 Resources
2.23 Course Closeout

Our Learning System Includes

Instructor Led Lectures

All of our IT Courses recreate a real time class experience with a highly qualified and experienced instructor delivering the course’s theories and concepts on screen. All of our lectures are pre-recorded and available to the user 24/7. They can easily be paused, repeated, rewound and fast-forwarded.

Visual Presentations

We understand that all students are different when it comes to learning, therefore different types of delivery mediums are needed in order to achieve success for students. Taking that into account, we deliver our content in a variety of different ways to ensure that students stay engaged and productive throughout their courses.

Mobile Optimisation & Progress Tracking

Our courses are optimised for all mobile devices allowing users to learn on the go whenever they have spare time and wish to do so. Users can access their courses from anywhere and their progress is completely tracked and recorded delivering peace of mind to each and every user.

Practice Quizzes and Exams

Our custom practice exams prepare students for their exams differently and more effectively than the traditional exam preps on the market. Students will have practice quizzes after each module to ensure that they are confident on the topic they are learning.

World Class Learning Management System

We provide the next generation Learning Management System (LMS) to all of our students. This is an experience that combines the feature set of traditional LMS with advanced functionality designed to make learning management easy and online learning engaging from the student’s perspective.