This course is part of a larger series, which poses five common database problems to experts, who solve those problems using the database tool of their preference.
- Data defines our world. From the number of passengers in an airport to the count of paperclips in a store, we keep track of everything. We record what and how many things we have. Today, those records are kept in digital files called databases. Databases are nothing more than electronic lists of information. Some databases are simple and designed for small tasks. Others are powerful and designed for big data. But they all have commonalities and perform similar function.
Hi, I'm Rae Hoyt, and I'll be your host for Database Clinic. In this series, we'll explore various tools for data storage. We'll show you how to work with flat file databases such as Excel, relational databases such as MySQL, and NoSQL databases such as MongoDB. We've invited a collection of top instructors to employ their data management tools to address a common set of questions. You'll learn the strengths and weaknesses of each, and different approaches to solving tough data problems.
So, whether you are looking to learn in your first database, beef up your skills with a new database, or simply learn data storage concepts, Database Clinic will provide a way to compare and contrast the wide range of database tools. It's time to crunch some numbers in Database Clinic.
- Creating a database in Excel
- Joining two data sets
- Searching a database in Excel
- Importing and formatting text in an Excel database
- Creating a PivotTable from two data sources
- Calculating averages and percentages