Build a Data Warehouse

Extract Data from MySQL you own this product

This project is part of the liveProject series Build a Data Warehouse in the Multi Cloud
prerequisites
basics of cloud computing • basics of shell scripting
skills learned
setting up a AWS Account • create a MySQL database instance • create an AWS Lambda function
Mike Shakhomirov
1 week · 6-8 hours per week · INTERMEDIATE
filed under
try now

placing your order...

Don't refresh or navigate away from the page.
liveProject This project is part of the liveProject series Build a Data Warehouse in the Multi Cloud liveProjects give you the opportunity to learn new skills by completing real-world challenges in your local development environment. Solve practical problems, write working code, and analyze real data—with liveProject, you learn by doing. These self-paced projects also come with full liveBook access to select books for 90 days plus permanent access to other select Manning products. $19.99 $29.99 you save $10 (33%)
Extract Data from MySQL (liveProject) added to cart
continue shopping
adding to cart

choose your plan

pro

monthly
annual
$24.99
$249.99
only $20.83 per month
  • share your subscription with one other person
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free eBook every time you renew
  • choose twelve free eBooks per year
  • exclusive 50% discount on all purchases
  • Extract Data from MySQL eBook 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 eBook every time you renew
  • choose twelve free eBooks per year
  • exclusive 50% discount on all purchases
  • Extract Data from MySQL eBook for free
Look inside
In this liveProject, you’ll build an extraction pipeline to transfer data from a legacy server-side database in AWS MySQL into your new cloud platform. You’ll learn how to create an integration data layer, and develop a maintainable and flexible data intrastate that is both easy to work with and easy to scale.
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

Mike Shakhomirov
Mike Shakhomirov is a lead data engineer at The World's Online Festival. He has an MBA and MIT diploma in big data and social analytics and is a Google Cloud Certified Professional Data Engineer. He is a passionate and digitally focused individual with an abundance of drive and enthusiasm, loving the challenges the full mix of digital marketing can offer. He is also an official writer for publications such as Towards Data Science and The Startup, with more than 20 published articles on various topics. He writes about data engineering, machine learning and AI in digital marketing.

prerequisites

This liveProject is for complete beginners to data engineering, who have never worked with Google Cloud Platform before.

TECHNIQUES
  • Basics of cloud computing
  • Basics of shell scripting

you will learn

In this liveProject, you’ll learn how to utilize an effective cloud data warehouse as the heart of your data architecture.

  • Set up an AWS account
  • Create a MySQL database instance
  • Create an AWS Lambda function

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.
RECENTLY VIEWED