Agenda

• Introduction to Tables
  • Table discovery
  • Table schema
• Types of Tables
  • How to identify whether a table is keyed or unkeyed
  • Unkeyed tables
    • A table is a list of dictionaries
    • A table is a flipped column dictionary
    • A table is a collection of lists of equal length (called columns)
  • Keyed tables
    • Differences from unkeyed tables
  • Keying and unkeying a table
• Creating tables
  • Unkeyed Tables
    • Creating a table with existing data
    • Creating an empty table
  • Keyed Tables
• Accessing tables
  • Accessing columns
    • Unkeyed tables
    • Keyed tables
  • Accessing rows
    • Unkeyed tables
    • Keyed table
  • Accessing a particular cell
• Inserting Data
  • Insert
    • Unkeyed tables
    • Keyed tables
    • Bulk inserts
  • Upsert
    • Unkeyed tables
    • Keyed tables
    • Bulk upserts