SQL Lab: SQLite + Node.js

Free Review to certify

SQL Lab: SQLite + Node.js

Design tables, write JOINs, and query internship data safely with parameterized SQL.

Skills you'll learn

SQL queries Data modeling JOIN / aggregates Node + DB Data validation

~110 min · +50 pts

JSON files are fine for demos — interviews ask for SQL.

Starter: /assets/templates/node-sql-lab/ (Node.js + better-sqlite3)

You will:
1) Create companies + applications tables (with a foreign key)
2) Seed sample rows
3) Write SELECT / JOIN / GROUP BY queries
4) Expose read APIs that use parameterized statements (no string concat)
5) Complete the practice queries in queries/practice.sql

Submit: repo or demo notes + reflection (120+ chars) including one JOIN example.

Environment setup (start here)

Node.js project using SQLite. On Windows, native module better-sqlite3 may need extra build tools once.

Node.js required

Pick your OS and follow from step 1:

Windows macOS

1) Install Node.js LTS (same as job tracker).
2) Download node-sql-lab starter into C:\Users\YourName\node-sql-lab
3) PowerShell: cd to folder → npm install
   If install fails on better-sqlite3:
   • Install “Desktop development with C++” via Visual Studio Build Tools, OR
   • Use WSL (Ubuntu) and run npm there.
4) npm run db:init
5) npm start → open http://localhost:3001

1) Install Node.js LTS.
2) Copy starter to ~/Documents/node-sql-lab
3) cd ~/Documents/node-sql-lab && npm install
4) npm run db:init && npm start
5) Open http://localhost:3001
   (If Xcode tools missing: xcode-select --install)

How do I know it worked?

db:init creates data/lab.db. API endpoints return application rows; practice.sql queries run without syntax errors.

Common issues

better-sqlite3 build fail on Windows → VS Build Tools or WSL (document which you used in your report).

Starter pack

Practice schema, JOIN, GROUP BY, and parameterized queries with SQLite + Node (npm run db:init && npm start).

README schema.sql practice.sql server.js package.json

/assets/templates/node-sql-lab/ · npm run db:init && npm start