Compiled Learning Objectives

Introduction to databases (Prep)

• Explain why databases are needed in Web Development

Introduction to PostgreSQL (Prep)

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

Communicating with the database using SQL (Prep)

• 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