markdown4.md

Week-4

To Do Checklist

• Watch Week-4 Video

Video Content Link

Class Summary

• Create week-4 branch and go ahead
• Provision an RDS instance
• Temporarily stop an RDS instance
• Remotely connect to RDS instance
• Programmatically update a security group rule
• Write several bash scripts for database operations
• Operate common SQL commands
• Create a schema SQL file by hand
• Work with UUIDs and PSQL extensions
• Implement a postgres client for python using a connection pool
• Troubleshoot common SQL errors
• Implement a Lambda that runs in a VPC and commits code to RDS
• Work with PSQL json functions to directly return json from the database
• Correctly sanitize parameters passed to SQL to execute

Homework Challenges

speeding up until next week

• Homework Submissions

• Knowledge Chalenges