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 SQL

2 - SQL with Node

3 - CRUD with SQL and Node