Database Relationships

Let this course take you from knowing nothing about databases all the way to structuring tables like a professional!
4.4 (55 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
4,078 students enrolled
Instructed by Caleb Curry Design / Other
$19
$20
5% off
Take This Course
  • Lectures 22
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2015 English

Course Description

The hardest part about databases is that there is a huge mountain of knowledge needed before even beginning to understand how to design and create them. It doesn't have to be this way. This course will take you from knowing nothing about databases to being able to decisively design relationships between tables. Now, if you're a beginner, you might be asking..."What are database relationships and why do they matter?" The answer is simple, every database is built off the fundamentals of database relationships.

If you want to really understand what a database is, how it works, and how to design your very first set of database tables, this course is for you.

Every lecture is taught in an easy to follow method using on-screen illustrations, drawings, and examples. This course will bring you to a level of understanding that will allow you to develop skills quickly and use them at home, in school, and even in the work setting. These are practical skills. The skills learned in this course are skills that can help you get a job in IT or Database design.

Do you want even better news? These skills are easy. No more confusion, no more fright, no more being a step behind everybody else in database technology. Here is just some of the information you will learn in this course:

  • The basics of databases - what they are, how they work, and how they structure data.
  • Data management - How do we keep millions of pieces of information organized and up-to-date?
  • Data structure - How do we organize data so that our database is protected from anomalies?
  • How to structure the three types of relationships between tables - one-to-one, one-to-many, and many-to-many. Each with practical examples.

I didn't create this course to sell you something that's going to waste your time. I created this course because I have a passion for databases and I love teaching in a fun way. This course is fun, easy to follow, and worth every penny.

What are the requirements?

  • A notepad and pencil for drawing out database designs and taking notes

What am I going to get from this course?

  • Create correct Database Relationships
  • Design databases with referential integrity
  • Design primary keys and foreign keys
  • Use gained skills to correct bad designs in database structures
  • Decide which tables should be parents and which tables should be children

What is the target audience?

  • This Database Design course is for beginners who have no prior experience with databases or database design. This course will only go over designing. Avoid this course if you are more experienced or are looking to actually use SQL to program a database.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
00:50

Welcome to this course! It will be an introductory course to database concepts! Don't expect to be a master after this course. On the bright side though, this course will have a lot of useful content!

Section 2: Introduction to Database Concepts
03:16

Entities are what we store Data about, Attributes are the things we store about the entity.
Every type of entity in a database will have its own table. Each attribute about that entity will have its own column.

05:31

Relations are tables. This comes from algebra, but we don't need to worry too much about that for beginning database design.

04:46

It is important to have data integrity within our database. Data integrity is protecting the structure of our database and keeping our data up-to-date and accurate.

01:24

When things are atomic they only contain one thing. They can no longer be broken up into smaller groups of data.
In our database we want our tables, columns, and data to be atomic.

Primary and Foreign Keys
04:25
03:02

A relationship is when we have a foreign key in one table that references a primary key in another table.

Keep in mind that a relational database management system is not called relational because it has relationships, it's called relational because tables are known as relations (see previous video).

Section 3: Let's Conceptualize!
02:13

There is a difference between conceptual and physical relationship design.

When we design conceptually, we are thinking of how the entities are related in real world situations.
When we design physically, we are thinking of how we take that real world relationship and turn it into tables with primary keys and foreign keys.

03:28

A one-to-one relationship exists when an entity is in an exclusive relationship with one other entity. No other entities allowed.

The example given was of a marriage where the husband and wife were not allowed to marry anybody else.

04:27

A one-to-many relationship exists when an entity can be in a relationship with multiple other entities but each of the other entities can only be in a relationship with the original entity exclusively.

The example I gave was a jelous king we marries unlimited wives but each wife was to only be in a relationship with that king.

02:40

A many-to-many relationship exists when any number of entities have relationships with any number of entities. There is no limit.

There is no practical way to store this in a database so we'll learn a trick in future videos.

02:39

Sometimes you will have to decide the relationship.

Relationships are not always set in stone. You must decide the best way to design a database. This could either be by your own intellect or rules given to you by a boss or team leader. These rules are called business rules.

Section 4: Foreign keys in More Detail
09:51

Referential integrity goes hand in hand with data integrity. In fact, referential integrity is only one kind of data integrity. There are many more types!

05:13

Whenever you have a foreign key referencing a primary key you will have a parent table and a child table. The primary key is the parent and the foreign key is the child.

05:46

NOT NULL is a column characteristic that prevents that column from being left empty.

Section 5: The Relationships!
09:03

To model one-to-one relationships we have two tables where one is given the foreign key that references the other table. It usually will not matter which one you put the foreign key in because the relationship is exclusive.

06:06

If you are struggling to understand these examples, watch the previous video or do some extra research.

08:13

To model one-to-many relationships we will give a foreign key to each row in the child table that references the parent. We will not put any information about the child in the parent table.

06:17

If you are struggling to understand these examples, watch the previous video or do some extra research.

06:07

To structure many-to-many relationships we need to break the relationship up into 2 one-to-many relationships. This means that we will have a total of 3 tables, 2 parents and 1 child (the intermediary table).

Each connection between the two parents within the intermediary table will be the primary key. So they will have to be unique.

07:07

If you are struggling to understand these examples, watch the previous video or do some extra research.

9 questions

This is a quick quiz that will give you some questions on structuring the 3 types of relationships. Good luck!

Section 6: Conclusion
01:24

Thank you for using my course as a learning tool! We've covered a lot in this quick course. If you have any questions do not hesitate to contact me. I'm sure that the content you learned in this course will help you advance on to more advanced database concepts.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Caleb Curry, Educator, YouTube Partner.

My name is Caleb Curry and I have a passion for video and education. I have been creating videos for many years. I first started creating classes 5 years ago. I created some here and there over the years but it has been my primary focus for nearly a year now.
June 4th, 2012. I decided to take my skill set to the next level and learn how to professionally program databases as well as websites. After just graduating my Junior year of high school, I did not have a typical summer vacation. Rather, I studied daily and prepared for this new goal of mine. By July 23rd, I uploaded my first class in this new mindset of determination. Since then, I have created over 500 educational classes over database Design, programming, web development, and more. I have also done classes over Audio Production, social networking, Music theory, and a wide variety of interesting topics. On top if this, I continued to create my comedy videos as I have my entire life. I believe I have come a long way in such a short period of time and I would now like to offer payed classes for viewers to download or watch ad free.

Ready to start learning?
Take This Course