Product Analytics. Part 1 JSON column types

141. JSON column types

Let’s recap what data types we’ve covered so far:

  • Boolean. TRUE or FALSE
  • Text. text values like emails, names, countries etc
  • Numeric. integer numbers like 1, 2, 99 or float 1.123, 129.33333
  • Date. Datetime, Interval for dealing with dates, timestamps and time intervals
  • NULL. No value

All these data types have one thing in common – they hold a single value.

Holding single value is great – it is easy to understand, easy to maintain. It’s a perfect choice for a column which will always have data (for example: email or book title). The price we pay...

“well worth the money”
Sign up and check out 37 free lessons and exercises.

Anatoli Makarevich, author of SQL Habit About SQL Habit

Hi, it’s Anatoli, the author of SQL Habit. 👋

SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst 📊 and solve real-life challenges from Business, Marketing, and Product Management.

SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work. 🚀

“well worth the money”

Fluent in SQL in a month

Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.
-- Type your query here, for example this one -- lists all records from users table: SELECT * FROM users
Loading chart... ⏳
Previous lesson: Validation of signup events consistency
Next lesson: Querying JSON columns