Course
Resources
About
Database
Learning Outcomes
Schedule
Learnings
Project
Resources
Topic Intro
Databases
Design and document a database schema
Normalize our data to reduce duplication
Create a relational database using SQLite
Create tables within the database
Link a record in one table to a record in another
Link a record in one table to multiple records in another
Link multiple records in one table to multiple records in another
Deploy a SQLite database to a live server
Set up separate environments for production and testing
SQL
Create, read update and delete from our database using SQL queries
Sort and filter data using SQL queries
Use joins to access related data in different tables
Use query parameters to avoid SQL-injection vulnerabilities
Node
Set enviroment variables and understand their use case
Handle database errors on our server without crashing
Software Architecture
Draw a diagram representing the flow of our application
Follow a consistent pattern for naming our folders, files and variables
Testing
Create a separate database for testing
Test that our database access works correctly