Planning and Designing Databases on AWS
This course will teach you how to use workload requirements to define database design considerations and explore the features and capabilities of the eight AWS database services. After completing this course, you will be able to determine the best AWS database service for your workloads and design the database to meet your requirements.
COD: AW-PD-DB
Categorie: AWS
Who should participate
- Data Engineers who are new to cloud or non-relational database design
- Solutions Architects who design services or architectures integrated with databases
- Developers who are building cloud database-enabled applications
Prerequisites
- Familiarity with AWS database services, equivalent to AWS Database Offerings digital training
- Familiarity with basic data analytics concepts, equivalent to Data Analytics Fundamentals digital training
- Familiar with the concepts of cloud computing, networking and cryptography
- Understanding of database design and/or data modeling concepts for relational or non-relational databases.
- Understanding the three Vs of data (volume, velocity, and variety)
In this course you will learn to:
- Apply database concepts, database management, and data modeling techniques.
- Consider hosting databases on Amazon EC2 instances.
- Evaluate AWS relational database services and their characteristics (Amazon RDS, Amazon Aurora, and Amazon Redshift).
- Evaluate AWS non-relational database services and their characteristics (Amazon DocumentDB, Amazon DynamoDB, Amazon ElastiCache, Amazon Neptune, and Amazon QLDB).
- Examine how the design criteria apply to each service.
- Apply management principles based on the unique characteristics of each service
Day 1
Module 1: Database concepts and general guidelines
- I database nel cloud
- Database design principles
- Transactional compliance
Module 2: Database planning and design
- Workload requirements
- Design considerations
Modulo 3: Database su Amazon EC2
- Amazon EC2 for hosting databases
Module 4: Custom built databases on Amazon EC2 and Amazon RDS
- The journey to AWS
- Basics of data modeling
Modulo 5: Amazon RDS
- Amazon RDS overview
- Amazon RDS distinguishing features
- Amazon RDS design considerations
- Hands-on Lab: Working with Amazon RDS Databases
Day 2
Modulo 6: Amazon Aurora
- Overview of Amazon Aurora
- Amazon Aurora distinguishing features
- Amazon Aurora design considerations
Module 7: Amazon Aurora (continued)
- Hands-on Lab: Working with Amazon Aurora Databases
Module 8: Amazon DocumentDB (with MongoDB compatibility)
- Overview of Amazon DocumentDB
- Amazon DocumentDB design considerations
- Amazon DocumentDB distinguishing features
- Hands-on Lab: Working with Amazon DocumentDB Databases
Modulo 9: Amazon DynamoDB
- Overview of Amazon DynamoDB
- Amazon DynamoDB data modeling
- Distinctive features of Amazon DynamoDB
- Amazon DynamoDB design considerations
- Hands-on Lab: Working with Amazon DynamoDB
Day 3
Modulo 10: Database in Amazon Neptune
- Overview of Amazon Neptune
- Amazon Neptune design considerations
Modulo 11: Database in Amazon Quantum Ledger Database (Amazon QLDB)
- Overview of Amazon QLDB
- Amazon QLDB design considerations
Modulo 12: Database in Amazon ElastiCache
- Overview of Amazon ElastiCache
- Amazon ElastiCache per Memcached
- Amazon ElastiCache per Redis
Module 13: Storing Data in Amazon Redshift
- Amazon Redshift overview
- Distinctive features of Amazon Redshift
- Data modeling in Amazon Redshift
- Amazon Redshift design considerations
- Hands-on Lab: Working with Amazon Redshift Clusters
Duration – 3 days
Delivery – in Classroom, On Site, Remote
PC and SW requirements:
- Internet connection
- Web browser, Google Chrome
- Zoom
Language
Instructor: English
Workshop: English
Slides: English
