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!