1. Home
  2. Training Library
  3. Big Data
  4. Courses
  5. Moving Beyond Spreadsheets

Moving Beyond Spreadsheets

Developed with
Calculated Systems
play-arrow
Moving Beyond Spreadsheets - Introduction
Overview
DifficultyIntermediate
Duration42m
Students63
Ratings
5/5
starstarstarstarstar

Description

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 makes sense and when it makes sense to switch over to a database, which is sometimes a much better option for more complex datasets. 

Specifically, this course aims to give students a practical hands-on introduction to database concepts. In addition, we'll gain an understanding of how to select the right database and we'll go through the basics of setting up an RDS instance on Amazon. This course includes a practical example of a company that is looking to choose a database, to give you an understanding of how databases work in the real world.

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

Learning Objectives

  • Understand the difference between spreadsheets and databases and when to use one or the other
  • Learn about the different types of database available and the various features and characteristics to consider
  • Learn how to choose the right database
  • Learn how to deploy an Amazon Aurora instance

Intended Audience

This course is designed for anyone who wants to improve their knowledge of databases and understand when it makes sense to use them as opposed to a spreadsheet.

Prerequisites

To get the most out of this course, you should already have a basic understanding of simple data structures such as comma-separated values, as well as an understanding of cloud concepts in general.

Transcript

Hey everyone, welcome to Moving Beyond Spreadsheets, An Introduction to Databases. In this course, we'll discuss some fundamental concepts of data management with a particular focus on understanding the differences between, using spreadsheets to manage your data, and databases to manage the same data. We'll look at some specific examples to understand when spreadsheets makes sense. Perhaps you're already using them, perhaps you're gonna keep using them, or when it makes sense to switch over to a database, which has a little more setup, but as sometimes a much better option to managing your complex data set.

Specifically, this course aims to give students a practical hands-on introduction to database concepts. In addition, we'll gain an understanding of how to select the right database, for a particular application, because there are so many of them. And finally, we will go through the basics of setting up, an RDS instance on Amazon.

As this is an intermediate course, students taking it should have a basic understanding of some simple data structures such as comma-separated values or more colloquial CSVs, as well as an understanding of cloud concepts. You don't need to be an expert on the cloud, but you should have an understanding of what it means to host something in the cloud and some awareness, of what the different providers, such as Amazon, Google, and Azure bring to the table. Finally, some high-level familiarity with databases in general, such as their function and application, are strongly suggested in order to get the most from this course. And finally, if you're a little on the fence if this course is for you, if you're looking to gain a practical understanding of how databases work, and a holistic view of data management concepts, along with starting to take control and understanding your data.

So if you have a data problem, and you're considering a database, this course is ideal for you. And just to briefly introduce myself, my name is Chris Gambino. I'm one of the architects at Calculated Systems and one of the co-founders, and although I'm presenting today, I can't take all the credit. The team really put this together. And just so you know a little bit about our experience. I personally was a big data engineer at Google. The team has experienced from Hortonworks with Hadoop with and streaming hundreds of millions of events per day of social media data, being presented at trade shows, such as Battle of the Quants, which is an awesome name.

 

About the Author
Students1049
Labs14
Courses6
Learning paths8

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