Data Warehousing on AWS

Written by wamrhein on 23. June 2016. Posted in AWS Training, Training.

Aws Advanced Training Partner
Aws Premium Consuting Partner
Cert 200

Data Warehousing on AWS

Current course dates can be found at the bottom of this page… company training available on request!

COURSE DESCRIPTION

Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift. This course demonstrates how to ingest, store, and transform data in the data warehouse. Topics covered include: the purpose of Amazon Redshift, how Amazon Redshift addresses business and technical challenges, features and capabilities of Amazon Redshift, designing a Data Warehousing Solution on AWS by applying best practices based on the Well-Architected Framework, integration with AWS and non-AWS products and services, performance tuning, orchestration, and securing and monitoring Amazon Redshift.

COURSE OBJECTIVES

In this course, you will learn to:

Describe Amazon Redshift architecture and its roles in a modern data architecture
Design and implement a data warehouse in the cloud using Amazon Redshift
Identify and load data into an Amazon Redshift data warehouse from a variety of sources
Analyze data using SQL QEV2 notebooks
Design and implement a disaster recovery strategy for an Amazon Redshift data warehouse
Perform maintenance and performance tuning on an Amazon Redshift data warehouse
Secure and manage access to an Amazon Redshift data warehouse
Share data between multiple Redshift clusters in an organization
Orchestrate workflows in the data warehouse using AWS Step Functions state machines
Create an ML model and configure predictors using Amazon Redshift ML

INTENDED AUDIENCE

This course is intended for:

Data engineers
Data architects
Database architects
Database administrators
Database developers

PREREQUISITES

We recommend that attendees of this course have:

Building Data Lakes on AWS
Building Data Analytics Solutions Using Amazon Redshift
Familiarity with relational databases and database design concepts

ACTIVITIES

This course includes:

presentations
hands-on labs
demonstrations

COURSE DURATION / PRICE

3 days
€ 2,685.00 (excl. tax) per person (DE)

Course outline

Day 1
- Module 1: Data Warehouse Concepts
  - Modern data architecture
  - Introduction to the course story
  - Data warehousing with Amazon Redshift
  - Amazon Redshift Serverless architecture
  - Hands-On Lab: Launch and Configure an Amazon Redshift Serverless Data Warehouse
- Module 2: Setting up Amazon Redshift
  - Data models for Amazon Redshift
  - Data management in Amazon Redshift
  - Managing permissions in Amazon Redshift
  - Hands-On Lab: Setting up a Data Warehouse using Amazon Redshift Serverless
- Module 3: Loading Data
  - Overview of data sources
  - Loading data from Amazon Simple Storage Service (Amazon S3)
  - Extract, transform, and load (ETL) and extract, load, and transform (ELT)
  - Loading streaming data
  - Loading data from relational databases
  - Hands-On Lab: Populating the data warehouse
Day 2
- Module 4: Deep Dive into SQL Query Editor v2 and Notebooks
  - Features of Amazon Redshift Query Editor v2
  - Demonstration: Using Amazon Redshift Query Editor v2
  - Advanced queries
  - Hands-On Lab: Data Wrangling on AWS
- Module 5: Backup and Recovery
  - Disaster recovery
  - Backing up and restoring Amazon Redshift provisioned
  - Backing up and restoring Amazon Redshift Serverless
- Module 6: Amazon Redshift Performance Tuning
  - Factors that impact query performance
  - Table maintenance and materialized views
  - Query analysis
  - Workload management
  - Tuning guidance
  - Amazon Redshift monitoring
  - Hands-On Lab: Performance Tuning the Data Warehouse
- Module 7: Securing Amazon Redshift
  - Introduction to Amazon Redshift security and compliance
  - Authentication with Amazon Redshift
  - Access control with Amazon Redshift
  - Data encryption with Amazon Redshift
  - Auditing and compliance with Amazon Redshift
  - Hands-On Lab: Securing Amazon Redshiftmazon Redshift
Day 3
- Module 8: Orchestration
  - Overview of data orchestration
  - Orchestration with AWS Step Functions
  - Orchestration with Amazon Managed Workflows for Apache Airflow (MWAA)
  - Hands-On Lab: Orchestrating the Data Warehouse Pipeline
- Module 9: Amazon Redshift ML
  - Machine Learning Overview
  - Getting started with Amazon Redshift ML
  - Amazon Redshift ML workflow scenarios
  - Amazon Redshift ML Usage
  - Hands-On Lab: Predicting customer churn with Amazon Redshift ML
- Module 10: Amazon Redshift Data Sharing
  - Overview of data sharing in Amazon Redshift
  - Amazon DataZone for Data as a service
- Module 11: Wrap-Up
  - Hands-On Lab: End of course challenge lab

IMPORTANT: Please bring your notebook (Windows, Linux or Mac) to our training. If this is not possible, please contact us in advance.

Course materials are in English, on request also in German (if available).
The course language is German, on request also in English.

Neue Termine in Planung!

AWS Certified Solutions Architect – Professional Workshop Details

Written by wamrhein on 17. December 2015. Posted in AWS Training, Training.

Workshop AWS Certified Solutions Architect – Professional

current course dates can be found at the bottom of this page … company training available on request!

Course description

Designed to complement Advanced Architecting on AWS, this full-day workshop is intended for individuals preparing for the AWS Certified Solutions Architect – Professional exam. The workshop provides an overview of the concepts and knowledge areas covered on the exam and walks you through the exam structure and question formats. Labs provide hands-on practice with advanced use cases, while practice exam questions test your understanding of key architectural concepts.

Workshop objectives

In this course, you will learn to:

Understand the content domains and how AWS services map to them
Combine multiple AWS services to solve complex architectural requirements
Understand advanced concepts of core AWS services and associated use cases
Identify how questions are written to test AWS architectural concepts

Intended audience

This course is intended for:

Individuals who are preparing to take the AWS Certified Solutions Architect – Professional exam

Prerequisites

We recommend that attendees of this course have:

Attended the Advanced Architecting on AWS course (or have equivalent knowledge)
Two or more years hands-on experience designing and deploying cloud architecture on AWS

Activities

This course includes:

Training with instructor
Practical exercises
Group discussions
Sample Exam Questions

Course duration / Price

1 day / € 950.00 (excl. tax) per person (DE)

Course outline

This course covers the following concepts:

Introduction to content domains and exam structure
Detailed discussion of content domains
Hands-on labs to reinforce specific use cases
Example questions and scenarios for group discussion
Practice exam questions

IMPORTANT: Please bring your notebook (Windows, Linux or Mac) to our trainings. If this is not possible, please contact us in advance.

Course materials are in English, on request also in German (if available).
Course language is German, on request also in English.

AWS Certified Solutions Architect – Associate Workshop Details

Written by wamrhein on 17. December 2015. Posted in AWS Training, Training.

Workshop AWS Certified Solutions Architect – Associate

current course dates can be found at the bottom of this page … company training available on request!

Course description

Designed as a complement to Architecting on AWS, this half-day workshop is for attendees preparing for the AWS Certified Solutions Architect – Associate exam. In this workshop, we explain what to expect at the testing center and during the exam. We will introduce you to the structure of the exam, such as the format of the questions, the content areas, and the distribution of questions related to these areas. We will also instruct you on how to interpret the concepts tested by a question so that you can better avoid wrong answers. During the workshop, you will be able to demonstrate your knowledge and test concepts through a series of sample exercise questions.

Workshop objectives

In this course, you will learn to:

Navigate the logistics of the examination process
Understand the exam structure and question types
Identify how questions relate to AWS architectural concepts
Interpret the concepts being tested by an exam question
Allocate your time studying for the AWS Certified Solutions Architect – Associate exam

Intended audience

This course is intended for:

Solutions architects who are preparing to take the AWS Certified Solutions Architect – Associate exam

Activities

This course includes:

presentations
group discussion
sample exercise questions

Course duration / Price

1/2 day / € 750.00 (excl. tax) per person (DE)

Course outline

Testing center information and expectations
Exam overview and structure
Content domains and question breakdown
Topics and concepts within content domains
Question structure and interpretation techniques
Practice exam questions

IMPORTANT: Please bring your notebook (Windows, Linux or Mac) to our trainings. If this is not possible, please contact us in advance.

Course materials are in English, on request also in German (if available).
Course language is German, on request also in English.

AWS Technical Essentials

Written by wamrhein on 29. September 2015. Posted in AWS Training, Training.

AWS Technical Essentials

current course dates can be found at the bottom of this page … company training available on request!

Course description

AWS Technical Essentials introduces you to essential AWS services and common solutions. The course covers the fundamental AWS concepts related to compute, database, storage, networking, monitoring, and security. You will start working in AWS through hands-on course experiences. The course covers the concepts necessary to increase your understanding of AWS services, so that you can make informed decisions about solutions that meet business requirements. Throughout the course, you will gain information on how to build, compare, and apply highly available, fault tolerant, scalable, and cost-effective cloud solutions.

Course objectives

In this course, you will learn to:

Describe terminology and concepts related to AWS services
Navigate the AWS Management Console
Articulate key concepts of AWS security measures and AWS Identity and Access Management (IAM)
Distinguish among several AWS compute services, including Amazon Elastic Compute Cloud (Amazon EC2), AWS Lambda, Amazon Elastic Container Service (Amazon ECS), and Amazon Elastic Kubernetes Service (Amazon EKS)
Understand AWS database and storage offerings, including Amazon Relational Database Service (Amazon RDS), Amazon DynamoDB, and Amazon Simple Storage Service (Amazon S3)
Explore AWS networking services
Access and configure Amazon CloudWatch monitoring features

Intended audience

This course is intended for:

Individuals responsible for articulating the technical benefits of AWS services to customers
Individuals interested in learning how to get started with AWS
SysOps administrators
Solutions architects
Developers

Activities

This course includes:

presentations
hands-on labs
demonstrations
videos
knowledge checks

This course provides activities that allow you to test new skills and apply knowledge through hands-on exercises.

Course duration / Price

1 day / € 775.00 (excl. tax) per person (DE)

Course outline

Module 1: Introduction to Amazon Web Services

Introduction to AWS Cloud
Security in the AWS Cloud
Hosting the employee directory application in AWS
Hands-On Lab: Introduction to AWS Identity and Access Management (IAM)

Modul 2: AWS Compute

Compute as a service in AWS
Introduction to Amazon Elastic Compute Cloud
Amazon EC2 instance lifecycle
AWS container services
What is serverless?
Introduction to AWS Lambda
Choose the right compute service
Hands-On Lab: Launch the Employee Directory Application on Amazon EC2

Modul 3: AWS Networking

Networking in AWS
Introduction to Amazon Virtual Private Cloud (Amazon VPC)
Amazon VPC routing
Amazon VPC security
Hands-On Lab: Create a VPC and Relaunch the Corporate Directory Application in Amazon EC2

Modul 4: AWS Storage

AWS storage types
Amazon EC2 instance storage and Amazon Elastic Block Store (Amazon EBS)
Object storage with Amazon S3
Choose the right storage service
Hands-On Lab: Create an Amazon S3 Bucket

Modul 5: Databases

Explore databases in AWS
Amazon Relational Database Service
Purpose-built databases
Introduction to Amazon DynamoDB
Choose the right AWS database service
Hands-On Lab: Implement and manage Amazon DynamoDB

Module 6: Monitoring, Optimization, and Serverless

Monitoring
Optimization
Alternate serverless employee directory application architecture
Hands-On Lab: Configure High Availability for Your Application

Module 7: Course Summary

IMPORTANT: Please bring your notebook (Windows, Linux or Mac) to our trainings. If this is not possible, please contact us in advance.

Course materials are in English, on request also in German (if available).
Course language is German, on request also in English.

Security Engineering on AWS

Written by wamrhein on 29. September 2015. Posted in AWS Training, Topseller, Training.

Aws Advanced Training Partner
Aws Premium Consuting Partner

Security Engineering on AWS

Please find our upcoming course dates at the end of this page!

COURSE DESCRIPTION

Security is a concern for both customers in the cloud, and those considering cloud adoption. An increase in cyberattacks and data leaks remains top of mind for most industry personnel. The Security Engineering on AWS course addresses these concerns by helping you better understand how to interact and build with Amazon Web Services (AWS) in a secure way. In this course, you will learn about managing identities and roles, managing and provisioning accounts, and monitoring API activity for anomalies. You will also learn about how to protect data stored on AWS. The course explores how you can generate, collect, and monitor logs to help identify security incidents. Finally, you will review detecting and investigating security incidents with AWS services.

COURSE OBJECTIVES

In this course, you will learn to:

State an understanding of AWS cloud security based on the CIA triad.
Create and analyze authentication and authorizations with IAM.
Manage and provision accounts on AWS with appropriate AWS services.
Identify how to manage secrets using AWS services.
Monitor sensitive information and protect data via encryption and access controls.
Identify AWS services that address attacks from external sources.
Monitor, generate, and collect logs.
Identify indicators of security incidents.
Identify how to investigate threats and mitigate using AWS services.

INTENDED AUDIENCE

This course is intended for:

Security engineers
Security architects
Cloud architects
Cloud operators working across all global segments

PREREQUISITES

We recommend that attendees of this course have:

Completed the following courses:
- AWS Security Essentials or
- AWS Security Fundamentals and
- Architecting on AWS
Working knowledge of IT security practices and infrastructure concepts.
Familiarity with the AWS Cloud.

ACTIVITIES

This course includes:

presentations
demonstrations
group exercises
hands-on labs

COURSE DURATION / PRICE

3 days
€ 2,685.00 (excl. tax) per person (DE)
CHF 2,500.00 (excl. tax) per person (CH)

Course outline

Day 1
- Module 1: Security Overview and Review
  - Explain Security in the AWS Cloud.
  - Explain AWS Shared Responsibility Model.
  - Summarize IAM, Data Protection, and Threat Detection and Response.
  - State the different ways to interact with AWS using the console, CLI, and SDKs.
  - Describe how to use MFA for extra protection.
  - State how to protect the root user account and access keys.
- Module 2: Securing Entry Points on AWS
  - Describe how to use multi-factor authentication (MFA) for extra protection.
  - Describe how to protect the root user account and access keys.
  - Describe IAM policies, roles, policy components, and permission boundaries.
  - Explain how API requests can be logged and viewed using AWS CloudTrail and how to view and analyze access history.
  - Hands-On Lab: Using Identity and Resource Based Policies.
- Module 3: Account Management and Provisioning on AWS
  - Explain how to manage multiple AWS accounts using AWS Organizations and AWS Control Tower.
  - Explain how to implement multi-account environments with AWS Control Tower.
  - Demonstrate the ability to use identity providers and brokers to acquire access to AWS services.
  - Explain the use of AWS IAM Identity Center (successor to AWS Single Sign-On) and AWS Directory Service.
  - Demonstrate the ability to manage domain user access with Directory Service and IAM Identity Center.
  - Hands-On Lab: Managing Domain User Access with AWS Directory Service
Day 2
- Module 4: Secrets Management on AWS
  - Describe and list the features of AWS KMS, CloudHSM, AWS Certificate Manager (ACM), and AWS Secrets Manager.
  - Demonstrate how to create a multi-Region AWS KMS key.
  - Demonstrate how to encrypt a Secrets Manager secret with an AWS KMS key.
  - Demonstrate how to use an encrypted secret to connect to an Amazon Relational Database Service (Amazon RDS) database in multiple AWS Regions
  - Hands-on lab: Lab 3: Using AWS KMS to Encrypt Secrets in Secrets Manager
- Module 5: Data Security
  - Monitor data for sensitive information with Amazon Macie.
  - Describe how to protect data at rest through encryption and access controls.
  - Identify AWS services used to replicate data for protection.
  - Determine how to protect data after it has been archived.
  - Hands-on lab: Lab 4: Data Security in Amazon S3
- Module 6: Infrastructure Edge Protection
  - Describe the AWS features used to build secure infrastructure.
  - Describe the AWS services used to create resiliency during an attack.
  - Identify the AWS services used to protect workloads from external threats.
  - Compare the features of AWS Shield and AWS Shield Advanced.
  - Explain how centralized deployment for AWS Firewall Manager can enhance security.
  - Hands-on lab: Lab 5: Using AWS WAF to Mitigate Malicious Traffic
Day 3
- Module 7: Monitoring and Collecting Logs on AWS
  - Identify the value of generating and collecting logs.
  - Use Amazon Virtual Private Cloud (Amazon VPC) Flow Logs to monitor for security events.
  - Explain how to monitor for baseline deviations.
  - Describe Amazon EventBridge events.
  - Describe Amazon CloudWatch metrics and alarms.
  - List log analysis options and available techniques.
  - Identify use cases for using virtual private cloud (VPC) Traffic Mirroring.
  - Hands-on lab: Lab 6: Monitoring for and Responding to Security Incidents
- Module 8: Responding to Threats
  - Classify incident types in incident response.
  - Understand incident response workflows.
  - Discover sources of information for incident response using AWS services.
  - Understand how to prepare for incidents.
  - Detect threats using AWS services.
  - Analyze and respond to security findings.
  - Hands-on lab: Lab 7: Incident Response

IMPORTANT: Please bring your notebook (Windows, Linux or Mac) to our training. If this is not possible, please contact us in advance.

Course materials are in English, on request also in German (if available).
The course language is German, on request also in English.