Training content
This course 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 course 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 course is intended for:
- Data engineers and database administrators
- Anyone interested in migrating to a database
Prerequisites
To get the most from the course, you should already have a basic understanding of data engineering concepts.
About the Author
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.