My Journey Learning SQL with PostgreSQL: Leveling Up My Backend Skills

Vincent Mugondora — Wed, 20 Aug 2025 11:09:28 +0000

Starting something new is always exciting—and a bit daunting! As a developer with experience in React and FastAPI, I recently decided to dive into the world of databases by learning SQL using PostgreSQL. My main goal is to bridge the gap in my backend skills and better understand how databases power the applications we build.

Why PostgreSQL?

With its open-source nature, strong community, and powerful features, PostgreSQL is a natural fit for those looking to expand their backend capabilities. It’s widely used in both small projects and large-scale production systems, making the skills transferable and future-proof.

My Starting Point

So far, I’ve covered the fundamentals:

Installing PostgreSQL on my machine and setting up my first database
Learning and practicing essential SQL commands like:
- CREATE TABLE
- INSERT
- SELECT
Writing simple queries to filter and sort data, exploring how different clauses interact

These basics form the bedrock for any meaningful database interaction, and getting comfortable here sets a solid foundation for more advanced concepts.

What’s Next?

Here’s how I’m planning to strengthen my skills:

Deepen my query knowledge: Practice more complex SELECT statements, using JOIN, GROUP BY, and aggregate functions.
Understand relationships: Learn how to design schemas that use foreign keys, explore data normalization, and practice building relationships between tables.
Indexing and performance: Begin to understand how indexing works and why it matters.
Integrate with full-stack apps: Leverage my React and FastAPI experience to build full-stack projects, using PostgreSQL to store, manage, and query data.

How I’m Documenting My Progress

I’m a firm believer in learning by doing—and sharing!

I’ll be writing about each step, what I learn, and the roadblocks I encounter.

Expect posts on beginner tips, mistakes to avoid, and small projects or challenges I tackle along the way.

Resources & Tips

If you’re also learning SQL or PostgreSQL, here are some strategies that helped me:

Practice, practice, practice: Use sample datasets (like Sakila or Chinook) to write real queries.
Break projects into small pieces: Build simple data models, like to-do lists or recipe managers, to get used to CRUD operations.
Read the docs: The PostgreSQL official documentation is surprisingly readable!
Learn ER diagrams: Visualizing table relationships makes complex schemas much easier to design.
Don’t just memorize: Focus on understanding how queries work and why.

Join The Learning Journey!

Whether you’re new to SQL or a seasoned backend dev, I’d love to connect, exchange resources, and learn together. Drop your favorite tips, resources, or questions below—let’s grow as a community!

Stay tuned for regular updates, beginner-friendly tips, and honest reflections on this learning adventure. Onward to full-stack mastery with PostgreSQL!

My Journey into Learning PHP

Vincent Mugondora — Thu, 14 Nov 2024 11:03:56 +0000

Hello dev.to community!
I am excited to share that I have just started my journey into learning PHP! As someone who is passionate about software development I believe that mastering PHP will enhance my skills and open up new opportunities in web development.

Why PHP?
PHP is a powerful server-side scripting language that is widely used for web development. Many popular content management systems (CMS) like WordPress, Joomla, and Drupal are built on PHP, which makes it a valuable skill for any developer looking to work in the web space. I am particularly interested in how PHP can be used to create dynamic web applications and manage databases effectively.

My Learning Resources
To kick off my learning process I have been exploring various resources:

Online Courses: I enrolled in a few online courses that cover the basics of PHP programming. Platforms like Udemy and Coursera have some great options.
Documentation: The official PHP documentation is an excellent resource for understanding the language's syntax and functions.
Books: I picked up "PHP & MySQL: Novice to Ninja," which provides practical examples and projects to work on.

What I Hope to Achieve
My goal is to become proficient in PHP so that I can build robust web applications and contribute to open-source projects. I also want to deepen my understanding of how PHP interacts with databases especially MySQL as this knowledge will be crucial for developing data-driven applications.

As I continue this journey I plan to share my progress, challenges and any tips I pick up along the way. If you have any recommendations for resources or advice for a beginner like me please feel free to share!

Thank you for reading and I'm looking forward to connecting with others who are also learning or are experienced in PHP!

DEV Community: Vincent Mugondora