SQL Data Analysis Project: eCommerce Site

[@goatstatusj5112]

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.

[@DatabaseStar]

Glad it was helpful!

[@julesnestt]

Thank you for your tutorials. I’m learning and watching something from a simple start to a full end product serves a lot. 😃👍

[@DatabaseStar]

You're welcome! Glad you like them.

[@GENESIS429-yx8im]

thank you for the video very helpful

[@DatabaseStar]

Glad it was helpful!

[@MohamedMontaser91]

why would use subqueries instead of CTEs

[@DatabaseStar]

You can use either, but I prefer CTEs as they break up the query and make it easier to read.

[@TsegazeabWuta]

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?

[@DatabaseStar]

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.

[@mrbartuss1]

Is it possible to import csv files to PostgreSQL without manually creating tables first?

[@DatabaseStar]

Not that I know of, but I could be wrong!

[@YacineBenjedidia-wm6pw]

thanks a lot

[@DatabaseStar]

You're welcome!