learning path

Introduction to Databases - Moving from Spreadsheets

Beginner
Up to 3h 17m
965
4.5/5
Enhance your skill setDevelop essential skills for thriving in real-world scenarios.
Stay focused, stay committedBoost your learning journey by enrolling: stay focused, consistent and achieve your goals with ease.
Earn a certificate of completionShow your skills and build your credibility when you include them in your resume and LinkedIn profile.

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.

Your certificate for this learning path
Calculated Systems
This content is developed in partnership with Calculated Systems
Learn more

About the Author

Students
32,953
Labs
31
Courses
13
Learning paths
42

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.

Covered Topics