Module 1: Introduction to Data Warehousing.
• Relational databases.
• Data warehousing concepts.
• The intersection of data warehousing and big data.
• Overview of data management in AWS.
• Hands-on lab: Introduction to Amazon Redshift.
Module 2: Introduction to Amazon Redshift.
• Conceptual overview.
• Real-world use cases.
• Hands-on lab: Launching an Amazon Redshift cluster.
Module 3: Launching clusters.
• Building the cluster.
• Connecting to the cluster.
• Controlling access.
• Database security.
• Load data.
• Hands-on lab: Optimizing database schemas.
Module 4: Designing the database schema.
• Schemas and data types.
• Columnar compression.
• Data distribution styles.
• Data sorting methods.
Module 5: Identifying data sources.
• Data sources overview.
• Amazon S3.
• Amazon DynamoDB.
• Amazon EMR.
• Amazon Kinesis Data Firehose.
• AWS Lambda Database Loader for Amazon Redshift.
• Hands-on lab: Loading real-time data into an Amazon Redshift database.
Module 6: Loading data.
• Preparing Data.
• Loading data using COPY.
• Maintaining tables.
• Concurrent write operations.
• Troubleshooting load issues.
• Hands-on lab: Loading data with the COPY command.
Module 7: Writing queries and tuning for performance.
• Amazon Redshift SQL.
• User-Defined Functions (UDFs).
• Factors that affect query performance.
• The EXPLAIN command and query plans.
• Workload Management (WLM).
• Hands-on lab: Configuring workload management.
Module 8: Amazon Redshift Spectrum.
• Amazon Redshift Spectrum.
• Configuring data for Amazon Redshift Spectrum.
• Amazon Redshift Spectrum Queries.
• Hands-on lab: Using Amazon Redshift Spectrum.
Module 9: Maintaining clusters.
• Audit logging.
• Performance monitoring.
• Events and notifications.
• Labs: Auditing and monitoring clusters.
- Resizing clusters.
- Backing up and restoring clusters.
- Resource tagging and limits and constraints.
• Hands-on lab: Backing up, restoring and resizing clusters.
Module 10: Analyzing and visualizing data.
• Power of visualizations.
• Building dashboards.
• Amazon QuickSight editions and features.
|