Mô tả

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.

Bạn sẽ học được gì

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

Yêu cầu

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

Nội dung khoá học

6 sections

Introduction

1 lectures
Introduction
00:50

Introduction to Database Concepts

6 lectures
Entities and Attributes
03:16
Relations
05:31
Data Integrity
04:46
Atomicity
01:24
Primary and Foreign Keys
04:25
What is a Relationship?
03:02

Let's Conceptualize!

5 lectures
Conceptual Vs. Physical Relationships
02:13
One-to-One Relationships (Conceptual)
03:28
One-to-Many Relationships (Conceptual)
04:27
Many-to Many-Relationships (Conceptual)
02:40
Sometimes You Decide on the Relationship
02:39

Foreign keys in More Detail

3 lectures
Referential Integrity
09:51
Parent and Child Tables
05:13
NOT NULL
05:46

The Relationships!

7 lectures
How to Structure One-to-One Relationships
09:03
One-to-One Examples
06:06
How to Structure One-to-Many Relationships
08:13
One-To-Many Examples
06:17
How to Structure Many-to-Many Relationships
06:07
Many-to-Many Examples
07:07
Think you can structure relationships?
9 questions

Conclusion

1 lectures
Conclusion
01:24

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.