Storage Layer

Input Transactional Data you own this product

This project is part of the liveProject series A Storage Layer for Big Data in AWS
prerequisites
Basic knowledge of on-premises infrastructure and database systems • Basic networking concepts and configurations • Understanding of security measures and best practices, including AWS IAM roles and policies • Basic knowledge of database replication and synchronization processes, and the AWS Database Migration Service value proposition • Familiarity with Amazon RDS for Postgres and CDC concepts and configurations • Basic understanding of database migration processes and tools
skills learned
Using AWS Database Migration Service to move transactional data from on-premise to the cloud • Automating infrastructure using CloudFormation • Enabling on-premise to cloud connectivity • Setting up Database Migration Service replication instances and tasks • Configuring Change Data Capture (CDC) on Amazon RDS for Postgres • Using the Schema Conversion Tool • Validating a migration
Gianluigi Mucciolo
1 week · 4-6 hours per week · INTERMEDIATE
Included with a Manning Online subscription
try now

pro $24.99 per month

  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose one free eBook per month to keep
  • exclusive 50% discount on all purchases

lite $19.99 per month

  • access to all Manning books, including MEAPs!

team

5, 10 or 20 seats+ for your team - learn more

Look inside

Nextstellar Corp is a media company with huge amounts of data to analyze. Some of that data is sitting in a PostgreSQL database, which is used for both authentication management and decision-making, as well as maintaining user preferences and feedback. Your boss doesn’t want that data sitting in the database—he wants it in the cloud! Moving it is exactly what you’ll be doing in this liveProject. You’ll use AWS Database Migration Service to enrich Nextstellar’s data lake with the PostgreSQL database so it can take full advantage of both modern data architecture and the AWS ecosystem.

This project is designed for learning purposes and is not a complete, production-ready application or solution.

book resources

When you start your liveProject, you get full access to the following books for 90 days.

project author

Gianluigi Mucciolo
Gianluigi Mucciolo specializes in AWS technologies and Agile methodologies. As an AWS Authorized Instructor and Cloud Technical Principal, he is dedicated to advancing cloud professionals' knowledge and participates in community-building initiatives. With a strong background in Artificial Intelligence and Big Data, Gianluigi constantly seeks growth opportunities.

prerequisites

This liveProject is for engineers who want to build a data lake lambda architecture using AWS fully managed services. You will need to know:


TOOLS
  • Basics of the Linux console
  • Basics of AWS
  • Basics of the AWS console
  • Basics of the AWS CLI

TECHNIQUES
  • Basics of infrastructure automation
  • Basics of big data Lambda architecture

you will learn

You will learn In this liveProject, you’ll learn how to effectively move transactional data from a database to the cloud.


  • Handling transactional data generated by web servers or applications
  • Enabling change data capture in on-premise databases and utilizing AWS
  • Database Migration Service
  • Implementing Infrastructure-as-Code for automated infrastructure creation

features

Self-paced
You choose the schedule and decide how much time to invest as you build your project.
Project roadmap
Each project is divided into several achievable steps.
Get Help
While within the liveProject platform, get help from other participants and our expert mentors.
Compare with others
For each step, compare your deliverable to the solutions by the author and other participants.
book resources
Get full access to select books for 90 days. Permanent access to excerpts from Manning products are also included, as well as references to other resources.

choose your plan

pro

monthly
annual
$24.99
$249.99
only $20.83 per month
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • Input Transactional Data project for free

team

monthly
annual
$49.99
$499.99
only $41.67 per month
  • five seats for your team
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • Input Transactional Data project for free