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
Need help picking the right course?
Amazon Redshift Training Course - Booking
Amazon Redshift Training Course - Enquiry
Amazon Redshift - 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
Upcoming Courses
Related Courses
Data Vault: Building a Scalable Data Warehouse
28 HoursIn this instructor-led, live training in the UAE, 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.
Amazon DynamoDB for Developers
14 HoursThis instructor-led, live training in the UAE (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 CloudFormation
7 HoursThis instructor-led, live training in the UAE (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.
Advanced Amazon Web Services (AWS) CloudFormation
7 HoursThis instructor-led, live training in the UAE (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.
AWS IoT Core
14 HoursThis instructor-led, live training in the UAE (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.
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.
Amazon Web Services (AWS) IoT Greengrass
21 HoursThis instructor-led, live training in the UAE (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 UAE (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.
Advanced AWS Lambda
14 HoursThis instructor-led, live training in the UAE (online or onsite) is aimed at developers who wish to integrate AWS Lambda applications and services with other services (API Gateway, Kinesis Streams, etc.). The training demonstrates how to use the browser-based AWS Cloud9 IDE to develop software collaboratively.
By the end of this training, participants will be able to:
- Collaboratively develop functions, applications and services using AWS Cloud9 IDE.
- Integrate AWS Lambda functions with other AWS services.
- Create and manage APIs.
- Set up an AWS Lambda function to read and process real-time streaming data.
- Create and manage a continuous integration pipeline for building, testing and deploying a AWS Lambda functions and applications.
Big Data & Database Systems Fundamentals
14 HoursThe course is part of the Data Scientist skill set (Domain: Data and Technology).
Apache Druid for Real-Time Data Analysis
21 HoursApache Druid is an open-source, column-oriented, distributed data store written in Java. It was designed to quickly ingest massive quantities of event data and execute low-latency OLAP queries on that data. Druid is commonly used in business intelligence applications to analyze high volumes of real-time and historical data. It is also well suited for powering fast, interactive, analytic dashboards for end-users. Druid is used by companies such as Alibaba, Airbnb, Cisco, eBay, Netflix, Paypal, and Yahoo.
In this instructor-led, live course we explore some of the limitations of data warehouse solutions and discuss how Druid can compliment those technologies to form a flexible and scalable streaming analytics stack. We walk through many examples, offering participants the chance to implement and test Druid-based solutions in a lab environment.
Format of the Course
- Part lecture, part discussion, heavy hands-on practice, occasional tests to gauge understanding
Apache Kylin: From Classic OLAP to Real-Time Data Warehouse
14 HoursApache Kylin is an extreme, distributed analytics engine for big data.
In this instructor-led live training, participants will learn how to use Apache Kylin to set up a real-time data warehouse.
By the end of this training, participants will be able to:
- Consume real-time streaming data using Kylin
- Utilize Apache Kylin's powerful features, rich SQL interface, spark cubing and subsecond query latency
Note
- We use the latest version of Kylin (as of this writing, Apache Kylin v2.0)
Audience
- Big data engineers
- Big Data analysts
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
MemSQL
28 HoursMemSQL is an in-memory, distributed, SQL database management system for cloud and on-premises. It's a real-time data warehouse that immediately delivers insights from live and historical data.
In this instructor-led, live training, participants will learn the essentials of MemSQL for development and administration.
By the end of this training, participants will be able to:
- Understand the key concepts and characteristics of MemSQL
- Install, design, maintain, and operate MemSQL
- Optimize schemas in MemSQL
- Improve queries in MemSQL
- Benchmark performance in MemSQL
- Build real-time data applications using MemSQL
Audience
- Developers
- Administrators
- Operation Engineers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Pivotal Greenplum for Developers
21 HoursThis instructor-led, live training in the UAE (online or onsite) is aimed at developers who wish to set up a multi-node Greenplum database.
By the end of this training, participants will be able to:
- Install and configure Pivotal Greenplum.
- Model data in accordance to current needs and future expansion plans.
- Carry out different techniques for distribute data across multiple nodes.
- Improve database performance through tuning.
- Monitor and troubleshoot a Greenplum database.