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

1 - Introduction to SQL2 - SQL with Node3 - CRUD with SQL and Node

Last updated