Welcome to Trevor.io! πŸ‘‹

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

  • Your database is a rich store of info separated into multiple tables.Β 
  • Table rows represent instances of what the table itself represents (e.g. In your Users table, each row represents a different user).Β 
  • Table columns represent values attributed to each instance.Β 
  • 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"]).Β 
  • Data in different tables can be connected.
  • You’ll see the word NULL frequently - this simply means no value exists.Β 
  • You can perform calculations on your data, clicking the Calculate 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! πŸ‘¨πŸ½β€πŸš€

If you have any questions, at any time, just ask πŸ˜ƒ

Did this answer your question?