Description
Stone River Elearning – Local SQLite Database with Node for beginners
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.
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.
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
Requirements:
- JavaScript
- HTML,CSS
- Web development experience
Course Curriculum
Local Database Local host with Express
- Introduction to Local Database (3:52)
- NODE DB Introduction (1:32)
- Setup Node create app file (4:14)
- NPM express install (5:05)
Introduction to setting up a local machine database
- localserver setup (5:19)
- nodemon package (2:30)
- install SQLite (6:17)
- Insert Data (3:48)
- DB connection (2:23)
- query the database (2:23)
- list users on webpage (3:41)
- User by ID (2:49)
- Create New User (5:08)
- Create New User 2 (8:30)
- Add new User (4:13)
- Code review (6:42)
Sale Page: https://stoneriverelearning.com/p/local-sqlite-database-with-node-for-beginners
Archive: https://archive.ph/wip/VbNHV
Reviews
There are no reviews yet.