035.3 SQL Basics

Establish a database connection from NodeJS

Retrieve data from the database in NodeJS

Execute SQL queries from NodeJS

Create simple SQL queries excluding joins

Understand primary keys

Escape variables used in SQL queries

Awareness of SQL injections

sqlite3 NPM module

Database.run(), Database.close(), Database.all(), Database.get(), Database.each()

CREATE TABLE

INSERT, SELECT, DELETE, UPDATE