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 email@example.com.
- 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
This learning path is intended for:
- Data engineers and database administrators
- Anyone interested in migrating to a database
To get the most from the learning path, you should already have a basic understanding of data engineering concepts.
Learning Path Steps
This course discusses some of the fundamental concepts of data management and looks at the differences between spreadsheets and databases for managing data.
This lab is aimed at beginners who want to move beyond spreadsheets and migrate their data into a database.
This lab will walk you through the changing database schema requirements of a bug tracking application and how to handle them.
Knowledge Check: Introduction to Databases - Moving Beyond Spreadsheets
Calculated Systems was founded by experts in Hadoop, Google Cloud and AWS. Calculated Systems enables code-free capture, mapping and transformation of data in the cloud based on Apache NiFi, an open source project originally developed within the NSA. Calculated Systems accelerates time to market for new innovations while maintaining data integrity. With cloud automation tools, deep industry expertise, and experience productionalizing workloads development cycles are cut down to a fraction of their normal time. The ability to quickly develop large scale data ingestion and processing decreases the risk companies face in long development cycles. Calculated Systems is one of the industry leaders in Big Data transformation and education of these complex technologies.