Level Up: PostgreSQL

49mIntermediate2023-10-05

Authors

Sarah Conway Schnurr

Open-Source Tech Evangelist, Software Engineer, Website Developer

Course details

Are you just starting out on your PostgreSQL journey and looking to see how your skills stack up? Join instructor Sarah Conway in this course for a series of challenges that are designed to take you from an introductory level of knowledge to a more advanced skill set. Test your skills at solving challenges on how to query, select, add, remove, alter, analyze, view, and monitor records while interacting with tables, databases, views, and indexes. Sarah also includes some exercises that show you how to filter sensitive data, encrypt passwords, cancel running queries, generate fictitious data, and more. If you’re ready to take your PostgreSQL skills to the next level, get started here!

Skills covered

PostgreSQLDatabase DevelopmentDatabase ManagementPersonaOpen SourceSoftware Development

Concepts

0. Introduction

01 - PostgreSQL code challenges
02 - Using GitHub Codespaces with this course

1. The Basics

03 - Creating a table
04 - Inserting database records
05 - Altering database records
06 - Locating database records
07 - Sorting database records
08 - Deleting database records
09 - Creating a new read-only user

2. Leveling Up

10 - Creating a table using a foreign key
11 - Identifying transaction totals per customer
12 - Using subqueries to insert records
13 - Handling duplicate records
14 - Using inner joins
15 - Using outer joins
16 - Creating a temporary table

3. Just for Fun

17 - Pattern matching
18 - Filtering sensitive data
19 - Updating order status
20 - Data cleanup
21 - Generating fictitious data
22 - Encrypting a password
23 - Canceling running queries

Conclusion

24 - Conclusion