Skip to main content

Planning and Designing Databases on AWS

Planning and Designing Databases on AWS

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

Course description

In this course, you will learn about the process of planning and designing both relational and nonrelational databases. You will learn the design considerations for hosting databases on Amazon Elastic Compute Cloud (Amazon EC2). You will learn about our relational database services including Amazon Relational Database Service (Amazon RDS), Amazon Aurora, and Amazon Redshift. You will also learn about our nonrelational database services including Amazon DocumentDB, Amazon DynamoDB, Amazon ElastiCache, Amazon Neptune, and Amazon QLDB. By the end of this course, you will be familiar with the planning and design requirements of all 8 of these AWS databases services, their pros and cons, and how to know which AWS databases service is right for your workloads.

Course objectives

In this course, you will learn to:

  • Apply database concepts, database management, and data modeling techniques
  • Evaluate hosting databases on Amazon EC2 instances
  • Evaluate relational database services (Amazon RDS, Amazon Aurora, and Amazon Redshift) and their features
  • Evaluate nonrelational database services (Amazon DocumentDB, Amazon DynamoDB, Amazon ElastiCache, Amazon Neptune, and Amazon QLDB) and their features
  • Examine how the design criteria apply to each service
  • Apply management principles based on the unique features of each service

Intended audience

This course is intended for:

  • Data platform engineers
  • Database administrators
  • Solutions architects
  • IT professionals

Prerequisites

We recommend that attendees of this course have previously completed the following AWS courses:

Activities

This course includes:

  • Training with instructor
  • Practical exercises

Course duration / Price

  • 3 days / € 2,095.00 (excl. tax) per person (DE)

Course outline

Day 1:

Module 0: Planning and Designing Databases on AWS

Module 1: Database Concepts and General Guidelines

  • Topic A: Databases in the cloud
  • Topic B: Database design principles
  • Topic C: Transactional compliance

Module 2: Database Planning and Design

  • Topic A: Workload requirements
  • Topic B: Design considerations

Module 3: Databases on Amazon EC2

  • Topic A: Amazon EC2 for hosting databases-

Module 4: Purpose-Built Databases

  • Topic A: The journey to AWS
  • Topic B: Data modeling basics

Module 5: Databases on Amazon RDS

  • Topic A: Amazon RDS databases
  • Topic B: Amazon RDS distinguishing features
  • Topic C: Amazon RDS Design considerations
  • Lab 1: Working with Amazon RDS databases

Module 6: Databases in Amazon Aurora

  • Topic A: Amazon Aurora databases
  • Topic B: Aurora distinguishing features
  • Topic C: Aurora design considerations

Day 2:

Module 6: Databases in Amazon Aurora (continued)

  • Lab 2: Working with Amazon Aurora databases

Module 7: Databases in Amazon DocumentDB (with MongoDB compatibility)

  • Topic A: Amazon DocumentDB
  • Topic B: Amazon DocumentDB design considerations
  • Lab 3: Working with Amazon DocumentDB databases

Module 8: Amazon DynamoDB Tables

  • Topic A: Amazon DynamoDB
  • Topic B: DynamoDB data modeling
  • Topic C: DynamoDB distinguishing features
  • Topic D: DynamoDB design considerations
  • Lab 4: Working with Amazon DynamoDB Tables

Day 3:

Module 9: Databases in Amazon Neptune

  • Topic A: Amazon Neptune
  • Topic B: Neptune design considerations

Module 10: Databases in Amazon Quantum Ledger Database (Amazon QLDB)

  • Topic A: Amazon Quantum Ledger Database (Amazon QLDB)
  • Topic B: Amazon QLDB Design Considerations

Module 11: Databases in Amazon ElastiCache

  • Topic A: Amazon ElastiCache
  • Topic B: ElastiCache for Memcached
  • Topic C: ElastiCache for Redis

Module 12: Data Warehousing in Amazon Redshift

  • Topic A: Amazon Redshift
  • Topic B: Amazon Redshift distinguishing features
  • Topic C: Amazon Redshift data modeling
  • Topic D: Amazon Redshift design considerations
  • Lab 5: Working with Amazon Redshift Clusters

 

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.

Practical Data Science with Amazon SageMaker

Practical Data Science with Amazon SageMaker

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

Course description

In this course, learn how to solve a real-world use case with machine learning and produce actionable results using Amazon SageMaker. This course teaches you how to use Amazon SageMaker to cover the different stages of the typical data science process, from analyzing and visualizing a data set, to preparing the data and feature engineering, down to the practical aspects of model building, training, tuning and deployment.

Course objectives

In this course, you will learn to:

  • Prepare a dataset for training.
  • Train and evaluate a machine learning model.
  • Automatically tune a machine learning model.
  • Prepare a machine learning model for production.
  • Think critically about machine learning model results.

Intended audience

This course is intended for:

  • A technical audience at an intermediate level

Prerequisites

We recommend that attendees of this course have:

  • Working knowledge of a programming language

Activities

This course includes:

  • Training with instructor
  • Practical exercises

Course duration / Price

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

Course outline

  • Business problem: Churn prediction
  • Load and display the dataset
  • Assess features and determine which Amazon SageMaker algorithm to use
  • Use Amazon Sagemaker to train, evaluate, and automatically tune the model
  • Deploy the model
  • Assess relative cost of errors

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 Cloud Practitioner Essentials Training

AWS Cloud Practitioner Essentials

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

Course description

This fundamental-level, one-day, instructor-led classroom course is intended for individuals who seek an overall understanding of the AWS Cloud, independent of specific technical roles. It provides a detailed overview of cloud concepts, AWS services, security, architecture, pricing, and support to enable you to build your cloud skills and grow your professional credibility. It includes hands-on lab exercises reinforcing some of the core concepts of the course’s lecture. This course also helps you prepare you for the AWS Certified Cloud Practitioner exam.

Course objectives

In this course, you will learn to:

  • Define what the cloud is and how it works
  • Differentiate between cloud computing and deployment models
  • Describe the AWS Cloud value proposition
  • Describe the basic global infrastructure of the cloud
  • Compare the different methods of interacting with AWS
  • Describe and differentiate between AWS service domains
  • Given a scenario, identify an appropriate solution using AWS Cloud services
  • Describe the Well-Architected Framework
  • Describe basic AWS Cloud architectural principles
  • Explain the Shared Responsibility model
  • Describe security services with the AWS cloud
  • Define the billing, account management, and pricing models for the AWS platform
  • Identify future services and developments built on the cloud

Intended audience

This course is intended for:

  • Sales
  • Legal
  • Marketing
  • Business analysts
  • Project managers
  • AWS Academy Students
  • IT-related professionals

Course duration / Price

  • 1 day
  • € 775.00 (excl. tax) per person (DE)
  • CHF 900.00 (excl. tax) per person (CH)

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.

Advanced Developing on AWS

Advanced Developing on AWS

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

Course description

The Advanced Developing on AWS course uses the real-world scenario of taking a legacy, on-premises monolithic application and refactoring it into a serverless microservices architecture. This three-day advanced course covers advanced development topics such as architecting for a cloud-native environment; deconstructing on-premises, legacy applications and repackaging them into cloud-based, cloud-native architectures; and applying the tenets of the Twelve-Factor Application methodology.

Course objectives

In this course, you will learn to:

  • Analyze a monolithic application architecture to determine logical or programmatic break points where the application can be broken up across different AWS services.
  • Apply Twelve-Factor Application manifesto concepts and steps while migrating from a monolithic architecture.
  • Recommend the appropriate AWS services to develop a microservices based cloud native application.
  • Use the AWS API, CLI, and SDKs to monitor and manage AWS services.
  • Migrate a monolithic application to a microservices application using the 6 Rs of migration.
  • Explain the SysOps and DevOps interdependencies necessary to deploy a microservices application in AWS

Intended audience

This course is intended for:

  • Experienced software developers who are already familiar with AWS services

Prerequisites

We recommend that attendees of this course have:

  • In-depth knowledge of at least one high-level programming language
  • Working knowledge of core AWS services and public cloud implementation
  • Completion of the Developing on AWS course, and then a minimum of 6 months of application of those concepts in a real world environment.

Activities

This course includes:

  • Training with instructor
  • Practical exercises

Course duration / Price

  • 3 days
  • € 2,095.00 (excl. tax) per person (DE)
  • CHF 3,200.00 (excl. tax) per person (CH)

Course outline

This course covers the following concepts:

  • Interfacing with AWS Services
  • Deconstructing a monolithic architecture
  • Migrating to the cloud
  • Creating an infrastructure
  • Declare and isolate dependencies
  • Storing configuration in the cloud
  • Establish a build, release, run model
  • Creating the codebase
  • Deploying an application
  • Evolution of architecture
  • Design patterns
  • I/O explosion and preventing it
  • Microservices

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 Advanced Networking – Specialty Workshop

AWS Certified Advanced Networking – Specialty

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

Course description

The AWS Certified Advanced Networking ‒ Specialty exam validates advanced technical skills and experience designing and implementing AWS and hybrid IT network architectures at scale. As a networking specialist, you will design a secure, scalable, and highly available network infrastructure on AWS while addressing requirements like network security, hybrid IT connectivity, network integration with other AWS services, routing techniques, and network troubleshooting.

Workshop objectives

In this course, you will learn to:

  • Navigate the AWS Certified Advanced Networking ‒ Specialty exam
  • Understand advanced networking concepts in AWS so you can design well-architected networking frameworks for your workloads in Amazon Virtual Private Cloud (Amazon VPC)
  • Connect on-premises data centers to Amazon VPC (AWS Direct Connect, AWS VPN), enabling AWS to function as an extension of the data center
  • Leverage network automation to accelerate workload deployments and app migration
  • Incorporate individual application networking requirements that use different AWS services into the overall network design
  • Practice network security and network troubleshooting best practices

Intended audience

This course is intended for:

  • Data engineers
  • Solutions architects
  • Network engineers
  • Infrastructure engineers who are preparing to take the AWS Certified Advanced Networking ‒ Specialty exam

Prerequisites

We recommend that attendees of this course have:

  • A current AWS Certified Cloud Practitioner or Associate-level AWS Certification
  • Two or more years of hands-on experience in maintaining and implementing large-scale networks

Activities

This course includes:

  • Classroom training
  • Group discussion
  • Sample exercise questions

Course duration / Price

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

Course outline

This course covers the following concepts:

  • Testing center information and expectations
  • Exam overview and structure
  • Content domains and question breakdown
  • Topics and concepts with 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.