Skip to content
Back to Data Analytics
PricingLog in

Data Analytics

SQL field transformations

Prepare useful analytical fields directly in SQL query results.

With Zoonk, your plan starts at this chapter and fits your schedule.

Build my plan

Start free, no account needed.

Where this chapter sits in the course

Lessons

Chapter 18 of 30 · 7 short lessons · 30 min
  1. 1Conditional fields with CASE4 min
  2. 2SQL null handling4 min
  3. 3SQL text functions4 min
  4. 4SQL date transformations4 min
  5. 5SQL timestamp arithmetic4 min
  6. 6SQL type conversion4 min
  7. 7Challenge: SQL field transformations6 min

What you'll learn

  • Create conditional and standardized SQL fields
  • Handle nulls and data type conversions
  • Derive dates, periods, and durations

Your plan from this chapter

It follows the course from here, at your pace, with reviews before you forget.

Build my plan

Start free, no account needed.