Databases

Learning Objectives

By the end of this lesson students should be able to
  • Explain why databases are needed in Web Development
  • Define what SQL is and what it is used for
  • Describe what table, rows and columns are used for in a relational database
  • Install and create a database using PostgreSQL
  • Create a table in a database using PostgreSQL
  • Insert data into a table using PostgreSQL
  • Retrieve data from a table using PostgreSQL
  • Retrieve data from a table using conditionals in PostgreSQL
  • List the different kinds of data that can be held in a PostgreSQL database
  • Add and remove columns in a pre-existing table using PostgreSQL using ALTER
  • Rename tables and columns in a pre-existing table using PostgreSQL using DELETE
  • Update rows in a pre-existing table using PostgreSQL using UPDATE
  • Combine tables together using PostgreSQL using INNER JOIN
  • Connect a PostgreSQL database to a NodeJS application
  • Retrieve data from a PostgreSQL database in a NodeJS application
  • Create an API endpoint that can add data to a database
  • Write code that effectively validates data before adding it to a database
  • Be aware of the dangers of SQL injection attacks, and how to avoid them
  • Create an API endpoint that can retrieve data from a database with multiple parameters
  • Create an API endpoint that can update data in a database
  • Create an API endpoint that can delete data in a database

Lessons

Export as PDF
Copy link