Compiled Learning Objectives

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