HOW MY JOURNEY HAS BEEN INTO UNDERSTANDING SQL.

#beginners #codenewbie #database #sql

INTRODUCTION

The first week on the introduction of SQL, honestly i was lost, the topic seems simple but trying to connect on how MAIN WORDS are used was not that simple. It was my first time hearing the word SQL but since am always eager to learn new things i knew it will not be a big issue.

After the introduction, i was able to recognize words such as SELECT,FROM,WHERE whereby these words help us solve real-life problems. An example on how the above commands are used. I will use SELECT.

In SQL, SELECT is a command used to retrieve data from a database.
select * from books;

SELECT means get all columns
FROM books means from the books table

SELECT * FROM books;
means: Show me everything inside the books dataset.

THEN I ENCOUNTERED JOINs.

I would read explanations, watch tutorials, and even try examples but nothing clicked. It felt like trying to solve a puzzle without seeing the full picture. I didn’t understand how tables related to each other, so combining them felt like guesswork.

WINDOW FUNCTIONS WERE EVEN WORSE.

I remember thinking,Why not just use GROUP BY for everything? It seemed easier, familiar, and safe. Window functions looked complicated, unnecessary, and honestly intimidating.

And those SQL functions every beginner should know
They were not easy.

The Turning Point: Slowing Down

What changed everything wasn’t a new tutorial or a magic explanation.

It was slowing down.
Instead of trying to understand everything at once, I started breaking things into small pieces:

I focused on one JOIN at a time
I used simple datasets — nothing complex
I asked myself why each query worked, not just how

One day, something clicked.

JOINs stopped being abstract. I began to see them as conversations between tables — each one contributing its own piece of information. Instead of confusion, I started seeing patterns. When Things Started Making Sense. The moment I understood JOINs, everything else became easier.

Window functions? They suddenly felt powerful instead of scary. I realized they weren’t replacing GROUP BY — they were solving a different problem. GROUP BY summarizes data, but window functions let you keep the details and analyze them at the same time.

That was a game changer.

And those basic SQL functions I once struggled with? They became tools I could confidently use — not things I had to memorize blindly.

RIGHT NOW

I won’t say I know everything BUT am somewhere, am no longer stuck, because i can write queries and actually understand what they’re doing. I can debug my own mistakes. I can explore data without feeling overwhelmed. Most importantly, I’m not afraid of SQL anymore.

LESSONS LEARNT.

If there’s one thing this journey taught me,
I don't need to understand everything at once.
At times i feel confused, but i know am learning.

I will take every concept at a time. practice, and be patient with myself. because one day things will flow like a pro, and when they do i will realize how far I have come from.