I just love the way you break down the hardest topics & concepts so clear , easy to understand with simple examples . Thank you so much. ❤❤❤❤

@DatabaseStar

11 ай бұрын

Thanks! I’m glad you enjoyed the video and we’re able to understand the concepts from it.

Extra thanks for the subtitles! Even if I don't have a listening issue, they help understanding better

@DatabaseStar

Жыл бұрын

Thanks! Glad to hear they are helpful for you.

Clear and to the point

@DatabaseStar

Жыл бұрын

Thanks!

This video was so helpful. Thank you!

@DatabaseStar

10 ай бұрын

Glad it was helpful!

Damn im learning selftaught full stack development and already learned MERN stack but felt the need to learn SQL, and im loving it, this channel is so crystal clear with all the topics that i encounter when practicing with my project and want to learn. A great thing about SQL is that is an ancient concept and will prevail even longer so all this information will be valuable for years to come :)

@DatabaseStar

Жыл бұрын

Thanks for the kind words, and I'm glad to hear my videos are helpful. Yeah, SQL has been around for a while and the fundamentals don't change.

Thanks keep making content like this

@DatabaseStar

2 жыл бұрын

Will do! Glad you like it.

Thank you.

@DatabaseStar

Жыл бұрын

You're welcome!

Thanks!

@DatabaseStar

Жыл бұрын

No problem!

helpful, keep it up

@DatabaseStar

2 жыл бұрын

Thanks, will do!

can we do joins without foreignkey?

@DatabaseStar

2 жыл бұрын

Yes, you can. As long as the fields in both tables represent the same thing, you can do a join and there does not have to be a foreign key created.

Thank you sorry I didn't find a link of the video that contains join three tables or more

@DatabaseStar

3 ай бұрын

No problem, the link is here: kzread.info/dash/bejne/hnuolNqaZ6jgpqw.html

super awesome

@DatabaseStar

Жыл бұрын

Thanks!

can we really join without foreign key -- primary key relation?

@DatabaseStar

Жыл бұрын

Yeah, you can. You would usually join between PK and FK, but you don't need to have those constraints to make the join work. If both columns represent the same thing then you can join. You can actually join on two columns that have two different sets of data, but your results will not be meaningul.

So correct me if I'm wrong these two tables break referential integrity rules, but joins still possible?

@DatabaseStar

Жыл бұрын

What about these tables breaks referential integrity rules? In general, you can still join tables if they break rules like that, as long as the data being joined is the same (e.g. both IDs or names or values represent the same thing)

@parko1965

Жыл бұрын

@@DatabaseStar So I can create a record in a child table not related to to a parent table record.

@DatabaseStar

Жыл бұрын

Yes, that's right, you can. If you leave the foreign key empty the row will still be inserted. You could put a Not Null constraint on it to prevent that though.