To learn about Structured Query Language (SQL), we created the back end for a voting application, called U Vote It. It consists of an Express.js API and a relational database using SQLite.
- How to configure a Node.js application to connect to an SQL instance
- Creating and dropping databases and tables
- Executing CRUD methods
- Creating schema and seed files for development and production
- How to write join statements to establish relations between data in one or more tables using primary and foreign keys
- The use and importance of prepared statements
- Node.js
- Express.js
- SQLite