Advanced SQL for Professional Developers

ClockIcon47m
postgresPostgreSQL
Star icon$$$
Star icon$$$
Star icon$$$
Star icon$$$
Star icon$$$
4.7
35 people completed
Tyler Clark
By

Tyler Clark

Developer, instructor, consultant, and speaker

You've got some practice with using SQL to select, update, and join database tables.

But perhaps you've found yourself with a sneaking suspicion that you could be more efficient with your PostgreSQL.

Does your query seem slow?

A lesson on how to profile queries will point you in the direction of a fix.

Are you performing multi-step operations one at a time that are susceptible to errors?

The "all or nothing" transaction is the cure.

These are just a couple of examples of the techniques, tips, and tricks that Tyler Clark has learned in his years of experience working on large scale production applications.

Other topics in this course include working with CSV files, different techniques for aggregating & filtering, and more!

Watch Tyler's course, and continue your journey toward SQL mastery.

Check out the Community Notes for this course.

What you'll learn

  • CheckIconCSV import & export
  • CheckIconCreating custom types
  • CheckIconQuery Performance
  • CheckIconTransactions
  • CheckIconPattern matching & regex

Prerequisites

  • ChevronRightIcon

    Familiarity with the CRUD actions in SQL

Tyler Clark
By

Tyler Clark

Developer, instructor, consultant, and speaker