A 2022 Introduction to SQL
A beginner-friendly 2022 introduction to SQL, covering its basics, use cases, and hands-on practice with SQLite3.
Alex Merced — Developer and technical writer sharing in-depth insights on data engineering, Apache Iceberg, data lakehouse architectures, Python tooling, and modern analytics platforms, with a strong focus on practical, hands-on learning.
333 articles from this blog
A beginner-friendly 2022 introduction to SQL, covering its basics, use cases, and hands-on practice with SQLite3.
A step-by-step tutorial on building a full-stack Todo application using Express.js, EJS, and Mongoose, from initial setup to deployment.
A comprehensive cheatsheet and guide for using MongooseJS, an ODM for MongoDB in Node.js applications, covering setup, models, and connections.
A comprehensive 2022 cheatsheet for ExpressJS covering project setup, middleware, routing, and server configuration.
A beginner-friendly tutorial on building a Todo List web application using Express.js and Node.js, covering setup, routing, templating, and deployment.
Explains the Web Storage API, focusing on synchronous key/value storage using localStorage and sessionStorage for browser-based data.
A tutorial on building a static markdown blog using Next.js, covering setup, components, and rendering posts.
A comprehensive cheatsheet for JavaScript DOM manipulation and jQuery, comparing vanilla JS and jQuery syntax for common web development tasks.
A beginner's guide to Scala 3, covering installation, project setup, and basic syntax like variables and the main function.
Explains SSH (Secure Shell), its purpose for secure remote computer connections, and how to generate and use SSH keys.
A technical guide exploring API protocols like REST, GraphQL, and RPC, with a practical walkthrough of building an RPC API using gRPC and Node.js.
Explains why Markdown is an essential skill for developers, covering its uses, basic syntax, and benefits for productivity.
A tutorial on using Docker and Docker Compose to create a consistent, multi-language development environment with databases and VSCode integration.
A guide outlining a realistic path to becoming a web developer in 2022, covering foundational learning, education options, and job hunting.
A tutorial on implementing a one-to-many database relationship with user authentication using the Masonite framework in Python.
A tutorial on implementing JWT authentication in an Express.js API, with examples using both MongoDB and PostgreSQL databases.
A tutorial on implementing a simple, custom global state management solution in React using Context API and hooks.
A technical guide to modeling one-to-one, one-to-many, and many-to-many relationships in MongoDB using the Mongoose ODM in Node.js.
A technical guide explaining how to implement authentication and authorization in any backend language or framework, covering user models, signup/login routes, and session vs JWT auth.
A tutorial on building a habit tracker using GraphQL, Hasura for the backend API, and React for the frontend.