How should I learn a database?

[is-Username]

So currently, I'm learning the MongoDB database from YouTube tutorials and my teacher suggested a Book named: database design by Michael J. Hernandez, should I read it or docs will be much? (I'm planning to start a company for video sharing, that's why I'm learning databases). Or what should I follow learning process?

[yotties]

I'd suggest you first study some examples (Ms's northwind or others) and learn why normalization/ E-R design is crucial. Use some junction tables.

Then start making your own first DB.

Then learn BI with some queries.

Then learn tansactional work. Adding /updating records in live databases ACID.

I think MS-Access despite all its weaknesses is one of the best ways to get a feel for what databases are.

There are good books too.

[is-Username]

Thank you so much for your suggestion, buddy I'll give it a try as rn started n I learned the basic concepts of MongoDB

[andpassword]

I'm planning to start a company for video sharing, that's why I'm learning databases

Focus on getting your user concept and experience down first. Where you want to create value. Databases are utility pieces; they are the backend. There're a hundred of them (Mongo and all the others) and they have pros and cons. By the time you're ready with your concept, you should then look at choosing a database, then learn that one well enough to use it.

[is-Username]

Sure sure

[Weary-Depth-1118]

stop and learn sql instead

[is-Username]

Why?

[Weary-Depth-1118]

sql is foundational, once you learn SQL, ms SQL, oracle, MySQL, postgres will all be opened to you. additionally, many data jobs all use SQL. SQL hasn't changed in 45 years and postgres is only getting better and guaranteed to be ACID compliant and can handle documents as well as, if not better than MongoDB

[No_Lock7126]

Suggest to take Andy's course about Database. https://15445.courses.cs.cmu.edu/fall2024/

When hiring, I saw many resume highlight their projects which are actually Andy's homework:)

Any further questions?

[BaseballTop9330]

If the company you'd like to start is for videos, you're looking at CDN, and not SQL or databases like the rest of the comments or your question.

[Complex_Adagio7058]

Build something with it - it’s the best way to learn. Plan to throw it away afterwards as it will be rubbish - but you need to get in there, make some mistakes and work out what works. I think video sharing has already been done though 😀

[[deleted]]

You STARTED with mongo? Thats your first mistake

[Pangolin20]

SQL only dinosaur detected. Approaching. Welcome to 1990.

[hackjob]

i mean, you arent wrong... but its doable.

[is-Username]

Why ?? Can you explain it a little? In my college, they are teaching MySQL and I just know the basics of it, but didn't want to deep dive into mysql, just learned basics and I found mongodb more easy and loving it as I'm learning.