I Built a PostgreSQL User Analytics System — Here’s What I Learned About RealLearn how to build a PostgreSQL-based User Analytics system from scratch. Hands-on SQL queries for demographics, registrations, email analysis, and age rang4 min read·mazinocodes.hashnode.devJan 9
Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’tA beginner-friendly walkthrough of SQL subqueries using real SQLZoo exercises. Includes SELECT-in-SELECT examples, common patterns, and where correlated sub4 min read·mazinocodes.hashnode.devJan 9
Day 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...3 min read·mazinocodes.hashnode.devJan 7
Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQLA beginner-friendly look at practicing SQL with LeetCode and setting up PostgreSQL, including table creation, constraints, and psql commands.3 min read·mazinocodes.hashnode.devJan 7
Databases 101: My First Real Step into SQLLearn database fundamentals and SQL basics from scratch. A beginner-friendly walkthrough of databases, DBMS, keys, and essential SQL queries.3 min read·mazinocodes.hashnode.devJan 6
