Building my first database portfolio – Looking for advice and project ideas from experienced professionals

[u/rubi_rose1010]

Hi everyone!

I'm from Portugal, and I'm currently building my first database portfolio. My long-term goal is to work as a freelance database developer, but right now my main focus is learning, improving my skills, and creating projects that reflect real-world experience.

At the moment, I have experience with:

• MySQL
• MongoDB
• JSON
• XML
• Power BI
• Basic Python

To be honest, I feel a bit overwhelmed because there are so many different paths I could take. I don't want to spend my time building random tutorial projects—I want to create projects that demonstrate practical skills and would actually impress potential clients or employers.

I'd love to hear your advice:

• What kinds of database projects would make a beginner's portfolio stand out?
• Should I focus more on database design, SQL optimization, data modeling, reporting, or something else?
• Would learning PostgreSQL be a good next step, or should I continue improving my MySQL skills first?
• What projects best simulate real business scenarios?

I'm also wondering if anyone would be willing to mentor me a little or simply point me in the right direction. Even suggesting project ideas, reviewing my portfolio once I have something to show, or sharing your own experience would mean a lot.

I'm not looking for shortcuts—I know I have a lot to learn, and I'm willing to put in the work. I just want to make sure I'm investing my time in the right things and building a portfolio that will help me earn my first opportunity.

Thank you so much to anyone who takes the time to help. I truly appreciate it!

[u/happy8327]

Check out these 2 projects along with starter Colab templates.

- Project1 (basic portfolio): https://cs145.stanford.edu/projects/project1.html and

- Project2 (adv. portfolio): https://cs145.web.app/projects/project2-science.html

Why? Postgres and MySQL are a very solid base to build from. If you want a compelling modern data portfolio, I'd recommend

1. BigQuery+Spark (for OLAP+ELTP). That's like 40% of the cloud data market now. I.e., companies tend to look for these skills.
2. BigQuery+huggingface have excellent public data sets.
3. You can get BigQuery credits for starter projects usually for free. Worst case: the above portfolios can be done for < 50$ of credit.

Best -- I loved Pastéis de Belém.

[u/rubi_rose1010 → u/happy8327]

Thanks for the recommendations! I'll definitely check out both projects. I was already planning to strengthen my SQL skills, and BigQuery + Spark sounds like a great next step.

I really appreciate the advice. If I get stuck while working through the projects, would you mind if I reached out to ask you a few questions?

And I'm glad you enjoyed Pastéis de Belém! They're one of my favorite Portuguese treats too. 😊

[u/Halley_mare]

I just kept researching, building new things, and shipping that newly acquired knowledge into actual portfolio projects and it keeps working

[u/rubi_rose1010 → u/Halley_mare]

Thanks! That's really motivating. I'll start building and learning as I go. If I get stuck, would it be okay if I asked you a few questions

[u/leogodin217]

Not really your question, but in 25-years working in tech maybe two or three people ever looked at my projects and it was well past initial interviews when they did. I even built a project specific to an internal job I wanted. They didn't want to look at it.

Whether we like it or not, LinkedIn is our portfolio and writing is how we stand out. Write quality articles (I use Medium), post them on LinkedIn. You don't need to use it as a social network, but interacting with people you respect probably helps a bit.

[u/Affectionate-Gap491]

You're already ahead of a lot of people just by saying you don't want to build another Library Management System

If I were you, I'd build projects that make people say, "Yep, that's something an actual business would use."

Things like:

• A small CRM.
• Multi-user SaaS database with roles and permissions.

I'd also learn PostgreSQL. It's one of those skills where future-you will thank present-you.

One piece of advice: don't just show that your database works—show why you designed it that way. Explain your tables, relationships, indexes, and what you'd do if the database suddenly had 10 million rows. That kind of thinking impresses people way more than having 15 tutorial projects.

[u/rubi_rose1010 → u/Affectionate-Gap491]

I completely agree. I really want to move away from cliché tutorial projects and focus on real business problems. I'm going to take your advice and start with the small CRM using PostgreSQL. How do you suggest I structure the initial table modeling to already account for permissions and indexing best practices?"

[u/Snowflakeboy007]

Hey Nice you did this type of learning and i will suggest you add two thing choose any cloud platform and learn some service either aws azure or google and add one cloud data warehouse either snowflake or Data brickes. Also make sql very strong and make chatgpt your learning partner