A brief introduction to Database Concepts

Hi! Today we’re going to cover something important especially if you want to start your career in data. Yeah, I’m talking about databases.

So in this post, you’re going to understand the structure of a database, the types of relationships of tables within a database, data types and naming conventions.

We’re also going to do a project where you will identify what’s wrong with a sample database that I’m going to provide you with. You’re going to normalize the database, identify foreign and primary keys. You’ll also be able to tell the relationships between each table and correct the naming conventions. 

Lots to do, so let’s get to it!

Watch the video below

Now, let’s practice!

To get you more familiar with databases, I’ve decided to create a project. Click the link below to view the template.

In this project, you will learn to:

  • Normalize a database

  • Name tables

  • Decide on primary and foreign keys

  • Ensure the correct naming conventions

I’ve also included answers, but make sure you attempt it by yourself first!

Project Brief Template

Project Answers

Previous
Previous

Tableau Data Analysis Bootcamp: Master Data Visualization

Next
Next

4 Main Types of Statistical Analysis you should use today!