Advanced SQL for Professional Developers
Master advanced SQL techniques, optimize queries, and handle large-scale production applications with Tyler Clark’s course. Learn more now!
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.
Introduction to Advanced SQL for Professional Developers
Bulk Insert and Export Data with csv Files with Postgres copy Command
On conflict Do Something Clause in Postgres
Casting Types in SQL
Create a Custom SQL Enum Type
Profiling Queries with SQL Explain Analyze
Common Table Expressions in SQL
Conditional Returns with SQL case / then
Create Variables and Blocks with Do / Declare in SQL
Perform Multiple Steps in One with SQL Transactions
Filter Grouped and Aggregated Data with SQL Having
Create and Safely Handle Nulls in SQL
Aggregate Inline filters in SQL
Work with JSON Data in SQL
Pattern Matching and Regular Expressions in SQL