Level Up: PostgreSQL

Focused View

Sarah Conway Schnurr

48:38

16 View

01 - Introduction

01 - PostgreSQL code challenges.mp4

00:38

02 - Using GitHub Codespaces with this course.mp4

01:10

02 - 1. The Basics

01 - Creating a table.mp4

02:37

02 - Inserting database records.mp4

02:02

03 - Altering database records.mp4

01:09

04 - Locating database records.mp4

01:10

05 - Sorting database records.mp4

02:18

06 - Deleting database records.mp4

02:09

07 - Creating a new read-only user.mp4

01:37

03 - 2. Leveling Up

01 - Creating a table using a foreign key.mp4

02:40

02 - Identifying transaction totals per customer.mp4

01:45

03 - Using subqueries to insert records.mp4

01:56

04 - Handling duplicate records.mp4

03:00

05 - Using inner joins.mp4

01:24

06 - Using outer joins.mp4

02:01

07 - Creating a temporary table.mp4

01:32

04 - 3. Just for Fun

01 - Pattern matching.mp4

02:45

02 - Filtering sensitive data.mp4

02:01

03 - Updating order status.mp4

01:52

04 - Data cleanup.mp4

02:28

05 - Generating fictitious data.mp4

01:47

06 - Encrypting a password.mp4

04:15

07 - Canceling running queries.mp4

03:20

05 - Conclusion

01 - Conclusion.mp4

01:02

Description

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!

This course is integrated with GitHub Codespaces, an instant cloud developer environment that offers all the functionality of your favorite IDE without the need for any local machine setup. With GitHub Codespaces, you can get hands-on practice from any machine, at any time—all while using a tool that you’ll likely encounter in the workplace.

Each installment of the Level Up series offers at least 15 bite-sized opportunities to practice programming at various levels of difficulty, so you can challenge yourself and reinforce what you’ve learned. Check out the “Using GitHub Codespaces with this course” video to learn how to get a codespace up and running.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

PostgreSQL

Database Programming

Sarah Conway Schnurr

Instructor's Courses

Senior software engineer, frontend web developer, project manager, technology consultant, IT administrator, technical support engineer, developer advocate, conference organizer, diversity committee chair, program organizer, social media manager, and copy editor are just some of the technical hats I've worn in 10+ years of professional experience working solo as well as in collaboration with hybrid/remote, distributed, & global teams. I have specific extensive experience working in the world of open source and enterprise PostgreSQL in almost all of these roles. Always interactive and engaged externally in developer communities, I've been recognized as being in the top 100 most influential in the database community in 2022 by the Redgate 100. https://www.red-gate.com/hub/redgate-100/ For a personal look into who I am and my involvement in the open source community, check out my interview featured in #PostgresFriends “PostgreSQL Person of the Week”. https://postgresql.life/post/sarah_conway_schnurr/

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.