Compiled Learning Objectives

Communicating with the database using SQL

• Check the database connection
• Get query results from the database with Postman

Being More Selective

• Create an API endpoint that can add data to a database
• Validate data before adding it to a database
• Identify a risk of SQL injection attacks, and define one defence
• Create an API endpoint that retrieves data from a database with multiple parameters

CRUD operations with NodeJS and PostgreSQL

• Create an API endpoint that can create data in a database
• Create an API endpoint that can delete data from a database
• Create tables with a variety of column types and primary and foreign keys
• Define CRUD operations

Prep Job Hunting and Mock Interview

• In 3 sentences, explain what competency-based questions are

Job Hunting and Mock Interview

• Identify key elements of a job description for a software engineer role, including required skills, qualifications, and responsibilities
• Recognize the importance of tailoring a resume to match the requirements and priorities outlined in a job description
• Apply the STAR method to effectively answer competency-based interview questions related to the software engineer role