Introduction

Hi there, in this article I'll share with you the approach I use to solve backend or technical related challenge(s) when developing digital solutions.

Challenge Encountered

In recent times in the course of building digital solutions as a daily exercise. I've come across several challenges such as writing SQL queries that involves joining multiple tables with conditions, implementing features with deep logical requirements, integrating or consuming data from a third party service that is not widely in use for ease of unblocking etc. The most recent one is a logical implementation which involves checking in the database for if the user meets certain criteria and perform modifications before displaying the data to the frontend.

There's an article on my blog titled: 7 recommended debugging skills you should know as a software developer where I explained debugging skills every developer should have when developing digital solutions and recently published an improved version on my Youtube channel.

Complex SQL Query Challenge

I'd a project in Laravel with need to fetch data from multiple tables based on conditions in each table. What i did hear was the employ the skills i mentioned below especially the pen and paper skill which helped me to figure out how to connect the tables while performing the checks for the conditions on columns in the tables.

How i solve backend or technical challenge

The following are the approaches are using in no particular order to solve backend and technical challenge(s):

• Patience (i've come to terms with seeing challenges as a way to grow so i try to be calm and patient to walk through fixing the problem)

• Paying close attention to the error message or the requirement of the feature to be implemented.

• Using pen and paper to write down what i'm trying to achieve.

• Reaching out for in a developer's group chat or using Google search Engine or Chatgpt.

• Taking rest from my workspace (maybe lunch or dinner, walkout, soccer exercise etc.)

• Ask myself a question. For example: what i'm trying to achieve? When was the last time the code worked fine? What page could this error be from?

Advancing Technical Skills and Opportunities with HNG 11

As a software engineer and technical writer I'm excited when I come across challenges because it broadens my perspective and improves my technical skills with opportunities to document and share knowledge as a practice.

As a way of staying consistent with growing my technical skills, network, character building, i'm glad to be part of the HNG 11 internship 2024 that commenced with this writing task you can sign up here for the internship and if you get on as HNG finalist you stand a chance to be connected to job opportunities here.

Conclusion

In this article, I've shared with you the skills and resources to leverage on to overcome any backend or technical challenge(s). In the process of building digital solutions as contribution to sustainable development goals lies several technical challenges to be conquered.