00: Introducing SQL

This module is a short introduction to SQL, SQLite3, and knex.js. It's intended to get you started using knex.js to craft SQL, and using SQLite3 for storage. If you already know SQL then knex.js will be easy to work with and you can skim most of this module. If you've never used SQL before then this module will teach you enough to work with the later projects.

This module won't teach you deep database design, as that's an incredibly complicated topic. You'll learn enough theory to make reasonable databases, and then how that translates to JavaScript objects later.

The Setup

You'll need to install SQLite3 and knex.js before you continue. SQLite3 might be on your computer already but if not you can download it and install it easily. Instructions go here.

Learn JavaScript Today

Register today for the Beginner Basics course and get the new releases by just paying the difference. There's also special discounts for existing customers when new courses are released.


Still Not Sure? Check out more curriculum!