Introduction to Databases - Moving from Spreadsheets

Developed with Calculated Systems
OverviewStepsAuthor
Calculated Systems
This content is developed in partnership with Calculated Systems
DifficultyBeginner
AVG Duration2h
Students288
Ratings
5/5
starstarstarstarstar
Content
112

Description

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.

Certificate

Your certificate for this learning path
lock

Training Content

1
Course - Intermediate - 42m
Moving Beyond Spreadsheets
This course discusses some of the fundamental concepts of data management and looks at the differences between spreadsheets and databases for managing data.
2
Hands-on Lab - Beginner - 1h 10m
FREE
Moving From Spreadsheet to Database
This lab is aimed at beginners who want to move beyond spreadsheets and migrate their data into a database.
3
Hands-on Lab - Intermediate - 1h
Dealing With Schema Changes in a Data Service
This lab will walk you through the changing database schema requirements of a bug tracking application and how to handle them.
4
Exam - 20m
Knowledge Check: Introduction to Databases - Moving Beyond Spreadsheets
Knowledge Check: Introduction to Databases - Moving Beyond Spreadsheets
About the Author
Students9489
Labs31
Courses13
Learning paths21

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.