Great Video, I am looking to start my own SQL Project that i can showcase to my resume, and this video should help me start a project Idea I had in mind.
Thank you, Database Star, for the awesome explanation. However, I have a question about choosing relational databases for e-commerce apps. What are the criteria for selecting relational databases over non-relational databases? Additionally, which relational database is best for an e-commerce app and why?
Good question. I don't know a lot about the benefits of non-relational databases so I can't really give any advice on that. Regarding the best relational database, I think any of them could work well. I personally recommend Postgres for most situations as it's free, performs well, and has a lot of features.
Great Video, I am looking to start my own SQL Project that i can showcase to my resume, and this video should help me start a project Idea I had in mind.
Glad it was helpful!
Thank you for your tutorials. I’m learning and watching something from a simple start to a full end product serves a lot. 😃👍
You're welcome! Glad you like them.
thank you for the video very helpful
Glad it was helpful!
why would use subqueries instead of CTEs
You can use either, but I prefer CTEs as they break up the query and make it easier to read.
Thank you, Database Star, for the awesome explanation. However, I have a question about choosing relational databases for e-commerce apps. What are the criteria for selecting relational databases over non-relational databases? Additionally, which relational database is best for an e-commerce app and why?
Good question. I don't know a lot about the benefits of non-relational databases so I can't really give any advice on that.
Regarding the best relational database, I think any of them could work well. I personally recommend Postgres for most situations as it's free, performs well, and has a lot of features.
Is it possible to import csv files to PostgreSQL without manually creating tables first?
Not that I know of, but I could be wrong!
thanks a lot
You're welcome!