JAJessica Akiinmazinocodes.hashnode.dev·Jan 9 · 4 min readI Built a PostgreSQL User Analytics System — Here’s What I Learned About RealToday, I built a User Analytics Database in PostgreSQL. The goal was to simulate a real-world business scenario where we need to answer questions like: How many users registered in the last month? Which countries have the most users? How many user...00
JAJessica Akiinmazinocodes.hashnode.dev·Jan 9 · 4 min readLearning SQL Subqueries as a Beginner: What Made Sense and What Didn’tToday I stopped just watching SQL videos and finally went hands-on. Instead of passively following tutorials, I practiced SQL subqueries directly on SQLZoo, specifically the “SELECT in SELECT” section, which focuses on using subqueries to write more ...00
JAJessica Akiinmazinocodes.hashnode.dev·Jan 7 · 3 min readDay Three with SQL: Inserting Data, Querying Smarter, and Working with Real DatasetsDay three was all about reinforcing the basics, not rushing forward, but getting comfortable with SQL by practicing it repeatedly on real data. I spent most of today working through SQLZoo exercises, inserting data into PostgreSQL, and querying a rea...00
JAJessica Akiinmazinocodes.hashnode.dev·Jan 7 · 3 min readLearning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQLDay Two with SQL: From LeetCode Challenges to My First PostgreSQL Tables Today’s learning was a mix of practice and setup and honestly, it was one of the most enjoyable days so far. I worked through SQL challenges on LeetCode and then set up PostgreS...00
JAJessica Akiinmazinocodes.hashnode.dev·Jan 6 · 3 min readDatabases 101: My First Real Step into SQLDatabases & SQL Basics: What I Learned on Day One Today I officially started my journey into databases and SQL. Instead of rushing into complex queries, I focused on understanding what databases actually are, how they’re managed, and how SQL is used ...00