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

Prep Working Software and Done

• Provide an example of a Definition of Done for a user story
• Provide an example of an Acceptance Criteria for a User Story

🎡 Morning orientation

• Introduce and welcome new volunteers
• Nominate a timekeeper
• Check the morning day plan and group structures

Working Software and Done

• Create a checklist that defines what’s needed for an increment to be releasable at the end of a Sprint

Full Stack: setting up, backing up, and restoring a database 🔗

• Set up your local development environment
• Initialize a new database.
• Remove a database.
• Re-initialize a database.
• Create a backup of your database.

Study Group

• Resolve blockers in your coursework
• Express and resolve problems effectively by writing tickets and asking questions
• Give and receive code review
• Develop your personal portfolio
• Pair programme
• Evaluate your progress with peers and mentors