This learning path gives you a solid understanding of the pros and cons of spreadsheets vs. databases and when to choose one over the other, and what to do in order to make the change.

This learning path discusses some of the fundamental concepts of data management and looks at the differences between spreadsheets and databases for managing data. We'll look at some specific examples to understand when spreadsheets make sense and when it makes sense to switch over to a database, which is sometimes a much better option for more complex datasets. 

You'll then try it out for yourself with our hands-on labs. You'll have a go at migrating data to a database and then you'll learn how to change the database schema requirements of a bug tracking application and how to handle them.

If you have any feedback relating to this course, please contact us at support@cloudacademy.com. 

Learning Objectives

• Understand the differences between spreadsheet and databases and their use cases
• Learn when it's best to transition from spreadsheets to databases
• Get practical experience of migrating to a database
• Evolve MySQL tables to handle schema changes
• Learn how to update data models to meet changing requirements

Intended Audience

This learning path is intended for:

• Data engineers and database administrators
• Anyone interested in migrating to a database

Prerequisites

To get the most from the learning path, you should already have a basic understanding of data engineering concepts.