Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Build dynamic web applications
·
Module 8
Database Management with PostgreSQL
1
Setting Up PostgreSQL Locally
Install and configure a local PostgreSQL server, database, and user.
2
Connecting Node.js to PostgreSQL with `pg`
Connect a Node.js application to PostgreSQL using a client library like `pg`.
3
Database Schema Design and Table Creation
Design a database schema and create tables with appropriate data types and constraints.
4
SQL CRUD Operations
Write SQL queries to perform CRUD operations (INSERT, SELECT, UPDATE, DELETE).
5
Filtering Data with WHERE
Filter query results using the `WHERE` clause.
6
Joining Related Tables with SQL
Retrieve data from multiple related tables using SQL `JOIN`s.
7
Prevent SQL Injection with Parameterized Queries
Write parameterized queries to prevent SQL injection vulnerabilities.
Previous module
Backend Foundations with Node.js & Express
Next module
Building a RESTful API