Welcome to Trevor.io! πŸ‘‹

Here are a few quick points to help you hit the ground running. πŸƒ

Your Database

  • Your database is a rich store of info separated into multiple tables.Β 
  • Each table is made up rows and columns, just like in Google Sheets / Excel.
  • Table rows represent instances of what the table itself represents (e.g. each row in a Users table is a user).Β 
  • Each column represents a related value (e.g. email_address, sign_up_date).

Data Types

  • Each column has a data type.
  • The main data types you'll come across are:
  1. String = text (e.g. "Hello to you")Β 
  2. Int = a whole number (e.g. 10, 20, 30)
  3. Timestamp = date and time of day (e.g. 01/01/2019 14:25:03)
  4. Float = a number with a fractional part (e.g. 4.7)
  5. Bool = a value of either true or false.
  6. JSON = a data type used for storing and transporting data. JSON is made up of key-value pairs between curly brackets (e.g. {"Book Title": "Ready Player One"}).
  7. Array = a data type used for storing multiple values, enclosed in square brackets (e.g. ["Ready Player One", "Ender's Game", "Children of Time"]).Β 

Exploring

  • Data in different tables can be connected (e.g. an order in an Orders table might belong to a customer in a Customers table). Learn more here.
  • You’ll see the word NULL frequently - this simply means no value exists.Β 
  • You can perform calculations on your data and build charts by clicking the Summarize button.Β 
  • You can add new columns to do things like perform arithmetic, manipulate and compare columns, create if then else statements, use now() to return the present date, and lots more. There’s a cheatsheet here.

That's it for now!

Go ahead and dive in, and let us know if you need anything - we're here to help, every step of the way! πŸ˜ƒ

Did this answer your question?