I've finished learning JavaScript and Express, but I'm unsure what to study next. I want to understand relational databases, learn how to use PostgreSQL in practice, and eventually apply it to backend projects. I've been stuck for about two weeks and would appreciate advice on learning resources and a practical path forward. I'd also welcome general feedback on the code quality and file structure of a backend project I built after learning Express.
3 Answers
A practical way to learn is to replace the in-memory arrays or JSON data in an existing Express project with a real PostgreSQL table. Install the `pg` package, connect your Node application to the database, and write raw SQL queries for your existing endpoints. Start with a SELECT and INSERT, then add updates, deletes, relationships, and validation as the project grows. You don’t need to begin with an ORM or a complicated framework—the feedback from running SQL through your own backend will teach you quickly.
Don’t wait for the perfect PostgreSQL course before building something. Take the Express project you already have, identify where it stores data in variables or files, and migrate one feature at a time. Use a PostgreSQL client library such as `node-postgres`, consult SQL documentation when you get stuck, and gradually learn topics like schema design, primary and foreign keys, indexes, transactions, and environment-based connection settings. Rebuilding your existing endpoints with a database is usually more effective than only watching tutorials.
First figure out whether you’re trying to learn general relational database concepts, PostgreSQL itself, or both. Start with SQL fundamentals such as tables, relationships, SELECT, INSERT, UPDATE, DELETE, joins, and basic constraints. PostgreSQL tutorials and beginner SQL resources can help with the syntax, but the concepts matter more than the specific tool.
That makes sense. I had assumed I needed to work through a database administration tool first, but I’ll try storing something practical, such as the courses entered into my GPA calculator, and access them directly from my Express routes.