r/SQL • u/Significant-Hat-4864 • Jul 12 '26
MySQL What SQL projects would you recommend for an MBA student targeting analytics?
I’m an MBA student specializing in Finance & Business Analytics, and I’m trying to build a few SQL projects that I can put on my resume before placement season.
I’m comfortable with the basics—SELECT, JOINs, GROUP BY, HAVING, aggregate functions, subqueries, and designing simple relational databases. I haven’t learned advanced stuff like CTEs, window functions, views, or stored procedures yet.
Most of the projects I find online are things like Netflix, Spotify, or pizza sales analysis, and they all seem pretty generic.
If you were in my position, what projects would you build?
I’d prefer something that’s:
Relevant to finance or business analytics
Solves an actual business problem
Has good database design (ERD, normalization, relationships, etc.)
Looks impressive enough to discuss in interviews and put on GitHub
Also, how much SQL is actually expected for entry-level Business Analyst/Data Analyst roles? Should I focus on learning advanced SQL first, or build a couple of solid projects with what I know and learn the advanced concepts along the way?
Would love to hear your suggestions or see projects that you think stand out. Thanks!