egghead.io
  1. 1
    Introduction to Advanced SQL for Professional Developers
    3m 17s
  2. 2
    Bulk Insert and Export Data with csv Files with Postgres copy Command
    2m 35s
  3. 3
    On conflict Do Something Clause in Postgres
    3m 25s
  4. 4
    Casting Types in SQL
    2m 34s
  5. 5
    Create a Custom SQL Enum Type
    2m 32s
  6. 6
    Profiling Queries with SQL Explain Analyze
    4m 48s
  7. 7
    Common Table Expressions in SQL
    4m 8s
  8. 8
    Conditional Returns with SQL case / then
    1m 55s
  9. 9
    Create Variables and Blocks with Do / Declare in SQL
    4m 54s
  10. 10
    Perform Multiple Steps in One with SQL Transactions
    3m 17s
  11. 11
    Filter Grouped and Aggregated Data with SQL Having
    2m 37s
  12. 12
    Create and Safely Handle Nulls in SQL
    2m 10s
  13. 13
    Aggregate Inline filters in SQL
    2m 9s
  14. 14
    Work with JSON Data in SQL
    3m 20s
  15. 15
    Pattern Matching and Regular Expressions in SQL
    4m

Create and Safely Handle Nulls in SQL

Tyler Clark
InstructorTyler Clark
  • postgres
    PostgreSQL

Share this video with your friends

Send Tweet

Nulls can be a huge burden if not handled correctly. Conditional logic is tricky and joining tables with null columns requires cognitive recognition. Similar to many popular programming languages, we can conditionally change values within SQL if the returning value is null.

illustration for Advanced SQL for Professional Developers

Course

Advanced SQL for Professional Developers

Build your Developer Portfolio and climb the engineering career ladder.
  • Search
  • Talks
  • Podcasts
  • Machine
  • Pricing
  • Store
©egghead.io
Terms & Conditions