Compiled Learning Objectives

Using Aggregate Functions

• Aggregate data over multiple rows and use aggregate values to restrict the results

Inserting, Updating and Deleting Rows

• Insert, Update and Delete rows in a pre-existing table using INSERT, UPDATE and DELETE

Joining Tables

• Combine tables together using `INNER JOIN`

Creating a table

• Aggregate data over multiple rows and use aggregate values to restrict the results

Defining Primary and Foreign Keys

• Aggregate data over multiple rows and use aggregate values to restrict the results

Integration with NodeJS

• Connect a PostgreSQL database to a NodeJS application
• Retrieve data from a PostgreSQL database in a NodeJS application

Find and analyse a Job Description - Prep

• List four things that help you understand whether a job posting is worth applying for

🎡 Morning orientation

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

Job Descriptions and Questions for Employers

• Review job descriptions in groups and come up with good questions to ask employers or recruiters before applying for a job

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