Compiled Learning Objectives

At the end of the sprint, you should be able to do the following things. Make sure to check you can do them all, and if not, go back and keep practicing until you can.

Introduction to databases

• Explain why databases are needed in Web Development

Introduction to PostgreSQL

• Define what SQL is and what it is used for
• Define an RDBMS
• Validate a PostgreSQL installation

Communicating with the database using SQL

• Describe what tables, rows and columns are used for in a relational database
• Retrieve data from a table using PostgreSQL
• Use expressions to manipulate the results of queries
• Retrieve data from a table using conditionals in PostgreSQL
• Insert new data into existing tables