This database tutorial will help beginners understand the basics of database management systems. We use helpful analogies to explain a high-level overview of spreadsheets, tables, and database management systems. The logic and concepts in this tutorial will make it easier to understand the more technical aspects of database architecture and Entity Relationship Diagrams (ERD).
When it comes to organizing data, we often start by compiling everything into a single spreadsheet (or table). But that approach isn’t scalable. As more data floods the system, a single table will result in misleading information, duplicate data, and errors.
A better method is to split your data up into smaller tables that have a narrower focus. These tables organize your data in a more efficient way and come together via relationships to form a database. And a database management system is the software that handles the storage, retrieval, and updating of that database.
Database Management Systems are closely related to Entity Relationship Diagrams. If you’ve spent any time in a database management system, you know that they typically don’t give you the best options for visualizing your database. It’s all in the programming language and it’s hard to see where the connections are. That’s where Entity Relationship Diagrams come in. It’s a visual way of looking at your database structure. Each table translates into an entity. And your columns in each table are listed as attributes in their respective entity. Finally, the programmed connections between your tables are visualized through relationship lines.
Lucidchart is a visual productivity platform that can help you visualize your Database Management System. Our ERD import and export tool make it easy to translate your database into a diagram that helps you spot database errors, find potential improvements, and onboard others to your database.
Photos Requiring Attribution:
Cat Leash – by K B – http://bit.ly/2tDSE9a
Learn more and sign up:
47 replies on “Database Tutorial for Beginners”
i am probably stupid but i find it hard to follow , a little too fast for me lol
How i can give to an specific user the verified badge to my app?
What is the name of the program from 4:11?
copy paste thats low level 14 hours from scratch
this saved my ass cheers
This video basically answers all my questions about what is these things. My university gave me task to create entity relationship diagram but i don't even know what the hell is even that. how these tables are connected with my website. I recommend all students must watch this video before starting database. thanks man
I dont get why you call it an ERD its just a flow chart but takes longer to say and is more confusing. Also i think that the customer and products should have been up top and showing going down to the order it would make more sense to people who dont understand flow charts.
Other wise good job.
this capsule was great. thanks!
bruh an ad? for real?
Great picture of why should we use Database and how we should.
where is your email I sent you a database question
Om shanti k good
JaguarDB is fast
DataBases Simplified, the best video……..
اللي جاي من طرف الاستاذ بسام يقله لايك وشكرا
These tutorials are so good. I've subscribed 👍
Nice video and ad.
Sir how about user send to other user to text how to make data base
Practical SQL Book PDF : https://www.lunaticai.com/2020/10/practical-sql-nostarch-pdf.html
Nice video! I think a quick reference to primary and foreign keys would have been useful.
it's nice to have such a tool, but I'm here to actually learn to code this.. it was therefore only half helpful.. =/
not how my lecturer explained it.🤦♂️
Lol this ad was so good haha i learnt more than online school here
I was pondering for 3 days because I didn't understand this concept and you just explained me in just 5 minutes! thank you #Lucidchart
What software did you use to create a MYSQL?
thank yo very much …you know what you are talking about….
how do big company's deal with this
Guys, check out JaguarDB which is awesome.
when an ad is so good that your databases professor requires all the students to watch it
I neded treatment for myself not for cat :)!$&#. I don't care about cats …..that I had like a kid.
Good explanation. Already I'm using lucid chart and it's good tool.
this video is such helpful for me to understand concept of database.
Thank you so much Honey for your help.
I know it's pretty late for comments, but this video is very very helpful
i want to…
Really good video AND an ad – pretty impressive 🙂 I like Lucid Chart anyway but now I know why!
thank you very much sir..
what does database mean?
Wow! wow! WOW!
you speak fast and i dont understand anything.
I got to give it to Lucid didn't realize it was an ad but I love this type of ads
this is great. saw this last night, and will have this done by the end of the day. will help us visualise our current setup and how we can improve the design and workflows in our new solution. cheers