A few days ago, I decided to strengthen my SQL fundamentals by solving problems on HackerRank. Today, I'm happy to share that I've completed the SQL Basic Select module.
It may seem like a small milestone, but every milestone matters when you're building your skills from the ground up. This journey has taught me that learning isn't about rushing to the finish line—it's about understanding each concept before moving on.
What I Learned
During the Basic Select module, I practiced working with some of the most essential SQL concepts, including:
Retrieving data using SELECT
Filtering records with WHERE
Combining conditions using AND and OR
Sorting results using ORDER BY
Removing duplicate values with DISTINCT
Pattern matching using LIKE and wildcards (%)
These concepts form the foundation of SQL, and solving multiple problems helped me understand when and why to use each one.
Lessons Beyond SQL
While solving these problems, I realized a few important things:
Read the problem carefully.
Many mistakes came from misunderstanding the question rather than not knowing the SQL syntax.
Think before you type.
Understanding the requirement first made writing the query much easier.
Small details matter.
A single keyword like DISTINCT, AND, or OR can completely change the output.
Practice creates confidence.
The more problems I solved, the more naturally I could identify the right SQL approach.
Looking Ahead
Completing the Basic Select module is just one step in my learning journey.
Next, I'll be diving into SQL Aggregations, exploring more advanced concepts, and continuing to build my skills as I work toward becoming a Java Full Stack Developer.
I'm excited to keep learning, building, and documenting my progress—one milestone at a time.
SOCIAL SHARE CARD GENERATOR