Advanced SQL for Professional Developers
Offered By: egghead.io
Course Description
Overview
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.
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.
Syllabus
- 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
Taught by
Tyler Clark
Related Courses
4ever-clojureIndependent Mastering Regular Expressions
A Cloud Guru Automate Cybersecurity Tasks with Python
Google via Coursera Building a Company’s database using MySQL and SQL
Coursera Project Network via Coursera Clinical Natural Language Processing
University of Colorado System via Coursera