Amazon Redshift Training Course
Amazon Redshift is a petabyte-scale cloud-based data warehouse service in AWS.
In this instructor-led, live training, participants will learn the fundamentals of Amazon Redshift.
By the end of this training, participants will be able to:
- Install and configure Amazon Redshift
- Load, configure, deploy, query, and visualize data with Amazon Redshift
Audience
- Developers
- IT Professionals
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
Course Outline
Introduction to Data Warehousing
Overview of Amazon Redshift Features and Architecture
Installing and Configuring Amazon Redshift
Benefits of Using Amazon Redshift
Creating, Resizing, and Launching an Amazon Redshift Cluster
Data Loading in Amazon Redshift
- Introduction to Data Loading
- Designing and Creating Tables
- Loading Sample Data Set into RedShift
- Data Distribution in Redshift
- Data Loading Best Practices
Querying Data within Redshift
- Designing Queries
- Tuning Query Performance
Data Integration, Analysis, and Visualization with Redshift
- Connecting and Using Data Integration (ETL) Tools with Redshift
- Connecting and Using Business Intelligence (BI) Tools with Redshift
Troubleshooting
Summary and Conclusion
Requirements
- Basic experience with Amazon Web Services (AWS)
- Familiarity with database concepts
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €6840 online delivery, based on a group of 2 delegates, €2160 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Need help picking the right course?
opleidingen@nobleprog.com or +31 208 080 666
Amazon Redshift Training Course - Enquiry
Amazon Redshift - Consultancy Enquiry
Consultancy Enquiry
Testimonials (3)
Everything in general.
Bruno - Verizon Connect
Course - Amazon Redshift
The general topic itself
- Verizon Connect
Course - Amazon Redshift
Trainer had good grasp of concepts
Josheel - Verizon Connect
Course - Amazon Redshift
Provisional Upcoming Courses (Contact Us For More Information)
Related Courses
SQL Advanced
14 HoursThis instructor-led, live training in the Netherlands (online or onsite) is aimed at intermediate-level database administrators, developers, and analysts who wish to master advanced SQL functionalities for complex data operations and database management.
By the end of this training, participants will be able to:
- Perform advanced querying techniques using unions, subqueries, and complex joins.
- Add, update, and delete data, tables, views, and indexes with precision.
- Ensure data integrity through transactions and manipulate database structures.
- Create and manage databases efficiently for robust data storage and retrieval.
Advanced Amazon Web Services (AWS) CloudFormation
7 HoursThis instructor-led, live training in the Netherlands (online or onsite) is aimed at cloud engineers and developers who wish to use CloudFormation to manage infrastructure resources within the AWS ecosystem.
By the end of this training, participants will be able to:
- Implement CloudFormation templates to automate infrastructure management.
- Integrate existing AWS resources into CloudFormation.
- Use StackSets to manage stacks across multiple accounts and regions.
Advanced Apache Iceberg
21 HoursThis instructor-led, live training in the Netherlands (online or onsite) is aimed at advanced-level data professionals who wish to optimize data processing workflows, ensure data integrity, and implement robust data lakehouse solutions that can handle the complexities of modern big data applications.
By the end of this training, participants will be able to:
- Gain an in-depth understanding of Iceberg’s architecture, including metadata management and file layout.
- Configure Iceberg for optimal performance in various environments and integrate it with multiple data processing engines.
- Manage large-scale Iceberg tables, perform complex schema changes, and handle partition evolution.
- Master techniques to optimize query performance and data scan efficiency for large datasets.
- Implement mechanisms to ensure data consistency, manage transactional guarantees, and handle failures in distributed environments.
Apache Iceberg Fundamentals
14 HoursThis instructor-led, live training in the Netherlands (online or onsite) is aimed at beginner-level data professionals who wish to acquire the knowledge and skills necessary to effectively utilize Apache Iceberg for managing large-scale datasets, ensuring data integrity, and optimizing data processing workflows.
By the end of this training, participants will be able to:
- Gain a thorough understanding of Apache Iceberg's architecture, features, and benefits.
- Learn about table formats, partitioning, schema evolution, and time travel capabilities.
- Install and configure Apache Iceberg in different environments.
- Create, manage, and manipulate of Iceberg tables.
- Understand the process of migrating data from other table formats to Iceberg.
Amazon DynamoDB for Developers
14 HoursThis instructor-led, live training in the Netherlands (online or onsite) is aimed at developers who wish to integrate a DynamoDB NoSQL database into a web application hosted on AWS.
By the end of this training, participants will be able to:
- Set up the necessary development environment to start integrating data into DynamoDB.
- Integrate DynamoDB into web applications and mobile applications.
- Move data in AWS with AWS services.
- Implement operations with AWS DAX.
AWS IoT Core
14 HoursThis instructor-led, live training in the Netherlands (onsite or remote) is aimed at engineers who wish to deploy and manage IoT devices on AWS.
By the end of this training, participants will be able to build an IoT platform that includes the deployment and management of a backend, gateway, and devices on top of AWS.
Amazon Web Services (AWS) IoT Greengrass
21 HoursThis instructor-led, live training in the Netherlands (online or onsite) is aimed at developers who wish to install, configure, and manage AWS IoT Greengrass capabilities to create applications for various devices.
By the end of this training, participants will be able to use AWS IoT Greengrass to build, deploy, manage, secure, and monitor applications on intelligent devices.
AWS Lambda for Developers
14 HoursThis instructor-led, live training in the Netherlands (onsite or remote) is aimed at developers who wish to use AWS Lambda to build and deploy services and applications to the cloud, without needing to worry about provisioning the execution environment (servers, VMs and containers, availability, scalability, storage, etc.).
By the end of this training, participants will be able to:
- Configure AWS Lambda to execute a function.
- Understand FaaS (Functions as a Service) and the advantages of serverless development.
- Build, upload and execute AWS Lambda functions.
- Integrate Lambda functions with different event sources.
- Package, deploy, monitor and troubleshoot Lambda based applications.
Big Data Consulting
21 HoursThis instructor-led, live training in the Netherlands (online or onsite) is aimed at intermediate-level IT professionals who wish to enhance their skills in data architecture, governance, cloud computing, and big data technologies to effectively manage and analyze large datasets for data migration within their organizations.
By the end of this training, participants will be able to:
- Understand the foundational concepts and components of various data architectures.
- Gain a comprehensive understanding of data governance principles and their importance in regulatory environments.
- Implement and manage data governance frameworks such as Dama and Togaf.
- Leverage cloud platforms for efficient data storage, processing, and management.
AWS CloudFormation
7 HoursThis instructor-led, live training in the Netherlands (online or onsite) is aimed at engineers who wish to use AWS CloudFormation to automate the process of managing AWS cloud infrastructure.
By the end of this training, participants will be able to:
- Enable AWS services to get started managing infrastructure.
- Understand and apply the principle of "infrastructure as code".
- Improve quality and lower the costs of deploying infrastructure.
- Write AWS CloudFormation Templates using YAML.
Data Vault: Building a Scalable Data Warehouse
28 HoursIn this instructor-led, live training in the Netherlands, participants will learn how to build a Data Vault.
By the end of this training, participants will be able to:
- Understand the architecture and design concepts behind Data Vault 2.0, and its interaction with Big Data, NoSQL and AI.
- Use data vaulting techniques to enable auditing, tracing, and inspection of historical data in a data warehouse.
- Develop a consistent and repeatable ETL (Extract, Transform, Load) process.
- Build and deploy highly scalable and repeatable warehouses.
Mastering DevOps with AWS Cloud9
21 HoursThis instructor-led, live training in the Netherlands (online or onsite) is aimed at advanced-level professionals who wish to deepen their understanding of DevOps practices and streamline development processes using AWS Cloud9.
By the end of this training, participants will be able to:
- Set up and configure AWS Cloud9 for DevOps workflows.
- Implement continuous integration and continuous delivery (CI/CD) pipelines.
- Automate testing, monitoring, and deployment processes using AWS Cloud9.
- Integrate AWS services such as Lambda, EC2, and S3 into DevOps workflows.
- Utilize source control systems like GitHub or GitLab within AWS Cloud9.
Developing Serverless Applications on AWS Cloud9
14 HoursThis instructor-led, live training in the Netherlands (online or onsite) is aimed at intermediate-level professionals who wish to learn how to effectively build, deploy, and maintain serverless applications on AWS Cloud9 and AWS Lambda.
By the end of this training, participants will be able to:
- Understand the fundamentals of serverless architecture.
- Set up AWS Cloud9 for serverless application development.
- Develop, test, and deploy serverless applications using AWS Lambda.
- Integrate AWS Lambda with other AWS services such as API Gateway and S3.
- Optimize serverless applications for performance and cost efficiency.
Industrial Training IoT (Internet of Things) with Raspberry PI and AWS IoT Core 「4 Hours Remote」
4 HoursSummery:
- Basics of IoT architecture and functions
- “Things”, “Sensors”, Internet and the mapping between business functions of IoT
- Essential of all IoT software components- hardware, firmware, middleware, cloud and mobile app
- IoT functions- Fleet manager, Data visualization, SaaS based FM and DV, alert/alarm, sensor onboarding, “thing” onboarding, geo-fencing
- Basics of IoT device communication with cloud with MQTT.
- Connecting IoT devices to AWS with MQTT (AWS IoT Core).
- Connecting AWS IoT core with AWS Lambda function for computation and data storage.
- Connecting Raspberry PI with AWS IoT core and simple data communication.
- Alerts and events
- Sensor calibration
Industrial Training IoT (Internet of Things) with Raspberry PI and AWS IoT Core 「8 Hours Remote」
8 HoursSummary:
- Basics of IoT architecture and functions
- “Things”, “Sensors”, Internet and the mapping between business functions of IoT
- Essential of all IoT software components- hardware, firmware, middleware, cloud and mobile app
- IoT functions- Fleet manager, Data visualization, SaaS based FM and DV, alert/alarm, sensor onboarding, “thing” onboarding, geo-fencing
- Basics of IoT device communication with cloud with MQTT.
- Connecting IoT devices to AWS with MQTT (AWS IoT Core).
- Connecting AWS IoT core with AWS Lambda function for computation and data storage using DynamoDB.
- Connecting Raspberry PI with AWS IoT core and simple data communication.
- Hands on with Raspberry PI and AWS IoT Core to build a smart device.
- Sensor data visualization and communication with web interface.