MySQL in 25 Minutes | Primary and Foreign Keys | Database Terminology for Beginners

Nov 1st - Nov 21st: Get 100% FREE Access to 84 Data & AI courses

This tutorial for beginners will introduce you to Database Terminology.

Video Timestamps:

00:16 Relational Database Essentials
4:47 Database Terminology
13:28 Relational Schemas: Foreign Key
18:09 Relational Schemas: Unique Key and Null Values
21:15 Relationships

What is the first thing that comes to your mind when you hear the word “database”? For many people, this question is more challenging than it might seem at first. An answer like “a big file where much information is stored” is not satisfactory and would not please potential employers.
You should remember there are two main types of databases – relational and non-relational.
The former will be the focus of this course, while the latter regards more complex systems.
Although understanding non-relational databases requires a serious mathematical and programming background, some of the logic applied in its coding is the same as SQL. Likewise, relational databases have a few advantages on their own. A small bit of theory will explain why they are still the preferred choice in many companies and institutions. Databases’ main goal is to organize huge amounts of data that can be quickly retrieved upon users’ request.

365 Data Science is an online educational career website that offers the incredible opportunity to find your way into the data science world no matter your previous knowledge and experience. We have prepared numerous courses that suit the needs of aspiring BI analysts, Data analysts and Data scientists.

We at 365 Data Science are committed educators who believe that curiosity should not be hindered by inability to access good learning resources. This is why we focus all our efforts on creating high-quality educational content which anyone can access online.

#MySQL #DataScience #SQL

[젤린-tu]

I'm not a native English speaker
Usually don't leave comments
This is just perfect Crystal clear

[tomatocultivator]

Can't believe that I finally understood this lesson. Your channel is such a big help!

[stolensentience]

needs way more views. explained in 20 minutes what i couldnt figure out all day from all the top hits that came back when i searched primary/foreign keys

[davidlp]

From a computer science student here in Sydney Australia. Thank you for making this video. It was extremely helpful. Combined with the lectures from uni I now understand what a primary/foreign key is.

[miriamlira]

3 months in 25 minutes . Thank you !!!! I LOVE YOUR VIDEOS

[MrJrhzues]

THANK YOU, HUMBLED BY THIS KNOWLEDGE, I'M JUST EMBARKING ON MY NEW CAREER PATH AND AM LEARNING THIS GROUND UP.

[robertue]

Great video! Really well explained. The only part where I got a little bit lost was you explained about the symbols use to express the relation between the tables and the specified directions by the end of the video.

[elenaeftimita]

One of the best explanation I have seen after whole day of searching for someone to explain SQL for very biginners. Thank you very much!

[nyoreachoja]

This video is perfection! Thanks for making everything clear and simple.

[forestsunrise]

woow excellent explanation!!! Thank you so much!

[attiqurrehman]

Easily keep quiet catch your words there is no doubt P.key & F.key related is the best video in the whole youtube. hats off you sir 🥰

[reemdabees]

This video is very much helpful, clear and simple thank you a lot .

[mohamadmoradi]

it was the best explanation I ever see! thank you.

[cyberplayer]

Very detailed and awesome teaching method I enjoyed watching it :)

[AusticHardOfHearingSinger]

Great info and explanations. Please tell me more about Cardinality Constraints.

[DanielMejia]

16:37 Why is it possible not to register who made a purchase on the sales table? how can we leave the customer_id space in blank? if we dont have the customer_id on the sales table would the system know where to send the package? i dont get that part sorry guys

[tassiblezilundu]

I got the point but the thing is how do those foreign key get to access values from it's primary key table in the prepared statement

[testa]

is it possible to change the pk name of one table when writing it in the next table