Arena 1
- Show Message
- Show Letter
- Pixels
- Humidity and Pressure
- Temperature
- Orientation and Compass
Arena 2
- Gyroscope and Accelerometer
- Wait for Event and Get Events
- Directions
- Agent and Intents
- Small Talk
- Action and Parameters
Arena 3
- Extract Entities
- Developer Entities
- Manage state with contexts
- Integrations – Slack
- Rich Messages
- Fulfillment
Arena 4
- Intro to SQL and Creating a Database
- Creating a Table and Inserting Data
- Querying the Table
- Aggregating Data
- Complex Queries with AND/OR
- Querying IN subqueries
Arena 5
- Grouping results with HAVING
- Calculating results with CASE
- Splitting Data into related Tables
- JOINing related Tables
- Joining related tables with outer joins
- Joining tables to themselves
Arena 6
- Sequels in SQL
- Combining multiple joins
- Using SQL to update a Database
- Changing rows – UPDATE and DELETE
- Altering tables after creation
- Make your SQL safer