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
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
Set enviroment variables and understand their use case
Handle database errors on our server without crashing
Draw a diagram representing the flow of our application
Follow a consistent pattern for naming our folders, files and variables
Create a separate database for testing
Test that our database access works correctly
Understand the difference between SQL and NoSQL databases
Understand and apply best practices for securing database access
Customise deployment using deployment scripts
Set up fly.io volumes
Last updated 6 months ago
