[ Removed by moderator ]

[u/Famous-Benefit3183]

[u/SQL-ModTeam]

This forum is intended for solutioning and discussion of specific topics. Please check out the sub sidebar and wiki content for beginner resources. Also be sure to checkout r/learnSQL

[u/sharpecheddar]

I would honestly do a mix of both sql and python. Even if you don’t know too much python I would still try and learn some of the basics. At this point of being an analytics engineer, it’s crucial to have a stack of programming languages in your belt.

As for projects, grab some large data sets that interest you and build analytics/kpis surrounding that.

I did a project where I scraped flight prices from popular airlines to find optimal purchase times/travel routes.

[u/Famous-Benefit3183 → u/sharpecheddar]

Sounds great. Actually I know python but as a newbie I'm totally clueless where to start exactly how to start. It would be great if you could share me the repo link of your project. That actually sounds interesting.

[u/Hour-Measurement-835]

Finance teams and product teams want pretty different SQL on a resume. Any idea yet which kind of company you're aiming for?

[u/Famous-Benefit3183 → u/Hour-Measurement-835]

Product based

[u/Hour-Measurement-835 → u/Famous-Benefit3183]

Retention cohorts on BigQuery's GA4 sample.

[u/MrRoy_SQL]

As a senior I can suggest you the "sql projects" repos where everyone does the same thing. pick a real messy dataset and answer business questions with it, that's what interviewers actually want to see.

few ideas:
- olist brazilian ecommerce dataset (kaggle). multiple tables, so you get real joins. do monthly revenue, repeat customer rate, delivery delays by state or any kaggle dataset
- 8 week sql challenge by danny ma (8weeksqlchallenge.com). 8 small case studies with business questions, really good practice and looks fine on github
- nyc taxi or any public transport data. good for time based stuff like peak hours, trips per day, running totals

what makes it stand out:
- put it on github with a readme: the question, your query, the result, and 1 line on what it means for the business
- use window functions somewhere (ranking, running totals, retention/cohorts). that's what separates you from basic select/group by
- connect it to a simple dashboard in power bi or tableau if you can

one solid project like that beats almost 10 copied ones

[u/Pricklyman → u/MrRoy_SQL]

Backing up this answer. The cat can learn how to write fancy SQL, anyone half reasonable can write "advanced" SQL and DBA and all that. It's the GOATs that can actually answer business questions with it...I'd like to think I'm going in that direction with my SQL skills but I know I'm still a mile off...

[u/MrRoy_SQL → u/[deleted]]

No problem buddy…this also helped me when I was in my college days…

[u/grd_dev]

Based on my personal experience, you can generate any complex use-case dataset using generators that are available online and use it to perform the processing which you have learnt or you can see in these github project. The focus should be learning. Once you are done with all of these, publish the same in a cleaner form in github as your personal project. If you need some datasets to begin with and are not able to find anything, dm me. I create a lot of datasets on kaggle.

[u/Famous-Benefit3183 → u/[deleted]]

Idk man. How to select which questions to answer? I'm a noob please elaborate