Price: 4.00 USD | Size: 3.23 GB | Duration : 16.15 + Hours | ★★★★★  4.7 
 
Amazon Redshift Course Bundle
 
Modules
Amazon Redshift Features
001-Turn data into information with Redshift
002-When you need big data
003-How relational databases retrieve data
004-Database locks Gatekeepers of your data
005-Separating your old and new data
006-Data warehouse types
007-Challenge A proposal for a data warehouse
008-Solution A proposal for a data warehouse
009-What is Redshift
010-Creating a cluster
011-Querying the Redshift cluster
012-Getting your data into Redshift
013-Challenge Write your own query
014-Solution Write your own query
015-Make Redshift faster with data optimization
016-Distribute your data evenly across the cluster
017-Managing data storage and costs
018-Challenge Choose a distribution style
019-Solution Choose a distribution style
020-More Redshift features to explore
 
Amazon Redshift Tutorial - Best Practices
001-Course Overview
002-Introduction
003-The Redshift Architecture
004-Deploying AWS Redshift
005-Generating Test Data
006-Copying the Data
007-Creating the Cluster
008-Pausing the Cluster
009-Accessing Redshift
010-Basic Data Import
011-Cluster Management Best Practices
012-Designing Test Environments
013-Automating Redshift
014-Summary
015-Introduction
016-Database Migration Strategies
017-Execute and Validate Migration
018-Migrate from On prem to the Cloud
019-Backup and Restore
020-Summary
021-Introduction
022-Determine Maintenance Tasks
023-Resizing
024-Summary
025-AWS Redshift Spectrum
026-Introduction
027-Security at Four Levels
028-Data Encryption and Tokenization
029-Configuration and Vulnerability Analysis
030-Summary
031-Introduction
032-CloudWatch and Redshift
033-Performance Data for QUERY LOADs
034-Event Notifications and Redshift
035-CloudTrail and Redshift
036-Summary
037-Introduction
038-Data Loading Issues
039-Connection Issues
040-Query Issues
041-Summary
 
Amazon Redshift tutorial for data warehousing
001-The Course Overview
002-Do We Still Need a Data Warehouse
003-Data Technologies Compared Relational Data Warehouse NoSQL and Big Data
004-Providing Business Intelligence on Internet Scale Data
005-Cloud Native Data Warehousing
006-Launching a Redshift Data Warehouse on AWS
007-Launching a Redshift Data Warehouse Using Cloudformation
008-Redshift Technology Deep Dive Columnar Filesystem
009-Redshift Technology Deep Dive Massively Parallel Processing
010-Sourcing Appropriate Data Sets
011-Ingesting Various Sizes of Data Set into Redshift
012-Connecting to and Querying the Data Warehouse
013-Redshift Technology Deep Dive Query Caching
014-Ingesting Enormous Volumes of Data by Copying Directly from S3
015-Optimizing Redshift Data Types for Query Performance at Scale
016-Evenly Distributing Data Across Your Cluster to Improve Filters and Joins
017-Exploratory Analytics for Disconnected Data
018-Loading a Disconnected Dataset
019-Glue Data Catalog Creating a Schema for the External Dataset
020-The BI Use Case for Data Warehousing
021-Introducing Amazon Quicksight
022-What Is Spice and How Can It Be Used to Accelerate Analysis
023-Loading Data into SPICE
 
Hands-on with Amazon Redshift
01_01-Introduction
01_02-About The Author
01_03-What Is A Data Warehouse  Part 1
01_04-What Is A Data Warehouse  Part 2
01_05-What Is A Data Warehouse  Part 3
01_06-Shortcomings Of SelfOwned Data Warehouses
01_07-Benefits Of A Public Cloud Data Warehouse
01_08-Benefits Of Redshift  Part 1
01_09-Benefits Of Redshift  Part 2
01_10-Benefits Of Redshift  Part 3
01_11-How Companies Use Redshift  Part 1
01_12-How Companies Use Redshift  Part 2
01_13-Third Party Visualization Tools Overview
01_14-How Redshift Compares To Other Analytics Tools  Part 1
01_15-How Redshift Compares To Other Analytics Tools  Part 2
01_16-How To Use The Working Files
02_01-Architecture
02_02-Data Loading
02_03-Data Distribution Concepts
02_04-Basic Redshift Usage  Part 1
02_05-Basic Redshift Usage  Part 2
02_06-Lab Creating An AWS Account
02_07-Lab Creating A Redshift Cluster
02_08-Lab Configuring SQL Workbench
02_09-Lab Loading Data Into S3
02_10-Lab Loading Data Into A Redshift Cluster  Part 1
02_11-Lab Loading Data Into A Redshift Cluster  Part 2
02_12-Lab Loading Data Into A Redshift Cluster  Part 3
02_13-Lab Querying A Redshift Cluster  Part 1
02_14-Lab Querying A Redshift Cluster  Part 2
03_01-Data Loading Best Practices  Part 1
03_02-Data Loading Best Practices  Part 2
03_03-Tuning Query Performance  Part 1
03_04-Tuning Query Performance  Part 2
03_05-Lab Connecting Tableau
03_06-Lab Tableau Usage
04_01-Wrap Up
 
High-performance Data Warehousing with Amazon Redshift
01.Course Overview
02.Understanding What Makes Amazon Redshift Fast
03.Increasing Redshift Data Load Speeds
04.Designing Redshift Objects for Performance
05.Writing Lightening Fast Queries, Aggregates, and Reports
06.Monitoring and Troubleshooting Redshift Performance Issues
Exercise Files
 
Learning Path AWS RedShift