What is a Relational Database?

Relational Databases have been a key part of application development for fifty years. In this video, Jamil Spain with IBM, explains what a relational database is, how it works, how to maximize performance and query your data.

#RelationalDB #Databases #SQL #watsonx

[faandersen]

Just gotta say - the longer I got into the video the more I thought about how you write backwards and less about databases haha. But great explanation. Thank you:)

[simongh]

props to this guy for learning to write backwards just for us

[josiahball]

I thought maybe he recorded this writing normally and afterward they flip the video, but his wedding ring is on his left hand so I think he really is writing backwards. That's crazy! Great video :)

[stribumarian]

Simple and easy to understand. I also like the examples as it makes more sense of the benefits of a relational database. Much appreciated!

[Dominic-bjls]

04:18 nice AI smoothing transition you got there

[cristiangutierrez]

Duuuude. I never thought i could say this kinda videos could get into one of my favorite cathegory .... Thank you ... great job

[danielcrompton]

Thank you, one of the best videos I have seen on this topic!

[captainkeyboard]

Blessed Day to you, Jamil Spencer! I am a keyboard specialist who is also a fan of modern microcomputer technology. Believe it or not, Microsoft Access is my favorite kind of program. I have been using it, since I used the 2002 edition in the Microsoft Office XP Professional suite with my first microcomputer. Microsoft Word has been my springboard because I practice my old-fashioned typewriting skill which is keyboarding, since I learned typewriting when I was 12 years old. Today, in the year 2024, I have Microsoft Office 2021 Professional with a Dell OptiPlex microcomputer that works Microsoft Windows 11 Professional. I do not know many people who use Microsoft 11 Professional, let alone Microsoft 365 or Microsoft Office 2021 Professional. Also, I print some work on laser paper with a Canon color laser printer, and some lists that from my Access databases are put forth into a label making program in my Brother P-touch label tape printer that I use to print professional-looking laminated label tapes. Yes, Microsoft Access is a relational kind of database program. I believe that Microsoft Excel makes an excellent flat file database set, but Microsoft Access makes the best relational database program as my favorite. I am pleased to watch your show, even though it is too brief for me.💙

[JourneywithRaquel]

Very helpful. You explained relational databases excellently. Thank you.

[Songfugel]

Great introduction to the very basic concepts of relational databases

[PrasannaDharshan-lepm]

Thank you sir for your work. By your explanation I understood what is relational database easily 👍.

[MarkovChains]

I'm genuinely torn on whether or not I love that you didn't mention many-to-many relationships! Lol

Because, on the one hand, if you build your database ***right*** you should almost *never* have many-to-many relationships, so it may be wise not to even mention as an option.

On the other hand, many-to-many relationships are extraordinarily common, so it may instead be wise to acknowledge their existence, even if for no other purpose than as a warning.

Even in your example, books and authors DO have a many-to-many relationship (a person can be an author of multiple books, and a book can have multiple authors).

In such a case, the only way to avoid having a many-to-many relationship in your database, you must first recognize that the objects your storing DO have, conceptually, a many-to-many relationship!

Anyways, great video!

[biomagician]

Thank you for this great video. I understand that building an index of a table will save time for querying. Is there any downside to this? Like the cost of storing the index? Is there any rule of thumb of how much space an index takes in relation to the size of the table? Thanks!

[jaimineetyagi]

Thank you sir .... It was very helpful and there were so many information in it Nice explanation 💜😊

[Bubbalubagus]

How are you drawing/writing backwards so easily?

[TheShipeng]

select * from books; can not be interpreted as select all books from books. It acatully means select all fields of book from books.

[jouleSansLoi]

So, he's either left-handed or he wears his watch on the right wrist which is odd.

[scdecade]

The follow up stoary: And how iBM squandered the biggest opportunity in the history of the world

[philosyche]

not only did he learn to write backwards but he's also left-handed

[klistoffequipmentmachinery]

Jamil, where did you learn to write backwards like that? It's awesome.