We can design and document a database schema
We can normalize our data to reduce duplication
We can create a relational database
We can create tables within the database
We can link a record in one table to a record in another
We can link a record in one table to multiple records in another
We can link multiple records in one table to multiple records in another
We can deploy a PSQL database locally on our own machine
We can deploy a PSQL database to a live server
We can set up separate environments for production and testing
We can use PSQL to manage Postgres from the command line
We can create, read update and delete from our database using SQL queries
We can sort and filter data using SQL queries
We can use joins to access related data in different tables
We can use query parameters to avoid SQL-injection vulnerabilities
We can handle database errors on our server without crashing
We can draw a diagram representing the flow of our application
We can follow a consistent pattern for naming our folders, files and variables
We can create a separate database for testing
We can test that our database access works correctly
Last updated 5 years ago
Was this helpful?