Node Local SQLite Database with Node for beginners

Name: Node Local SQLite Database with Node for beginners
Rating: 4.4 (42 reviews)

Explore how to apply NodeJS to make your web content come to life - explore how to create a local database

Created byLaurence Svekis

Last updated 11/2024

English

What you'll learn

how to write NodeJS
Explore how nodeJS works
Explore various useful package for node
See how to setup a localhost server
Setup a local SQLlite instance running a database

Course content

3 sections • 28 lectures • 1h 11m total length

Introduction to Local Database3:52
Explore building a local database with node and sequel light, using express and ajax to create, read, and insert user data from the front end to the back end.
NODE DB Introduction1:32
Course Source files and Downloadable Guide0:05
Setup Node create app file4:14
Create the core app.js file, verify node and npm are installed, and use the terminal and editor to navigate directories, install tools, and prepare for the upcoming lessons.
NPM express install5:05

localserver setup5:19
Source Code0:04
nodemon package2:30
Learn to use nodemon to automatically restart a node server during development, installing globally with npm and sudo, and running it to monitor app.js for changes.
install SQLite.6:17
Install the sqlite3 package with npm to set up a local sqlite database in node, create a users table with id, first, last, email, and password, and run queries.
Source Code0:03
Insert Data3:48
Create an insert.js file, connect to the sqlite3 database, and execute an insert into the users table with email and password, logging the inserted id or any errors.
Source Code0:06
DB connection2:23
Source Code0:02
query the database2:23
Source Code0:05
list users on webpage3:41
Source Code0:05
User by ID.2:49
Source Code0:07
Create New User5:08
Build a frontend form that submits data to a Node backend using Ajax, parse the request with body-parser, and post to a route to insert into the database.
Create New User 28:30
Add new User4:13
Source Code0:41
Code review6:42

Requirements

JavaScript
HTML,CSS
Web development experience

Description

Are you looking for how to setup a local database using node - this is the course for you.

Easy step by step instructions on how to use node to install packages and setup a local SQLite database to use for your web applications. See how easy it can be to get data and add data to the database. - Please note that there are prerequisites to the course - JavaSCript - HTML and CSS

Source Code is included to get you started quickly

Step by step learning - starting with the basics and moving through to combining fundamentals and writing code.

Bonus - 25 page downloadable resource and course guide included. With source code, useful code snippets and resources.

Course covers

setup of express to run local machine on your computer
download and setup of SQLite database
useful packages like nodemon and MD5
inserting data to your local database
query database for results
setup of paths for files
use of body parser to get post data
submitting of form data to database
setup of basic app to interact with database

HTML,CSS JavaScript knowledge is essential as scope of this course is all NodeJS focused.

Step by step learning with all steps included.

Along with friendly support in the Q&A to help you learn and answer any questions you may have.

Try it now you have nothing to lose, comes with a 30 day money back guarantee.

Start coding with Node JS today!!!!!

Who this course is for:

Anyone who wants to learn more about NodeJS
JavaScript developers
Application developers
Web developers
Anyone who wants to learn about setting a SQLlite database locally

Node Local SQLite Database with Node for beginners

What you'll learn

Explore related topics

Course content

Local Database Local host with Express5 lectures • 15min

Introduction to setting up a local machine database20 lectures • 55min

Bonus Section3 lectures • 2min

Requirements

Description

Who this course is for: