Become an Airtable Champion
The world's most comprehensive course on Airtable
Build on your existing Airtable skills and learn to design, create, and manage Airtable Bases that adhere to the highest industry standards.
- 6 Course Modules
- 100 Video Lessons
- 10+ Hours of Course Material
- 40+ Airtable Templates
BECOME AN AIRTABLE CHAMPION
A Course Designed for those who want to learn Airtable the right way.
Excellence in Airtable is a course designed for those looking to work and use Airtable professionally in their their career.
Throughout the course, students will learn everything they need to manage and grow the Airtable bases they work with each day. The course will start with fundamentals, but quickly dive into advanced topics like database schema design, data management, custom fields and formulas, advanced interfaces/views, and automations.
The course is instructed by award winning, Airtable certified instructor Cherry Yang - who will be there each step of the way as you grow your skills as an Airtable developer.
Module 1: Database Design
Module 1 explores the concept of scalable database design and the fundamental principles of implementing modular, maintanable, and scalable Airtable bases. In Module 1 we'll cover: ➣ Defining database scope ➣ Relational database principles ➣ How to define business needs ➣ How to define Airtable base requirements ➣ Designing Airtable base architecture ➣ Creating an Airtable base
Module 2: Implementation
In Module 2 we take a deep dive into Airtable and create an Airtable base from scratch - exploring all the features available to you when building a base. In Module 2 we'll cover: ➣ Fields and tables (All 28 types) ➣ Formulas (Text, Numeric, Date/Time, Arrays, Record Functions) ➣ Views (Grid, Form, Calendar, Kanban, Timeline, Gantt, Gallery) ➣ Automations (Triggers & Actions, Tools, Email, Time Based, Zapier, Conditionals, 3rd Party Integrations) ➣ Reporting (Rollup Fields, Pivot Tables, Quarterly/Annual Reporting, Charts/Graphs) ➣ Interfaces & Portals
Module 3: Support
Module 3 wraps up the course by exploring the various third-party tools available to supercharge an Airtable database. In Module 3 we'll cover: ➣ Useful 3rd Party Tools (On2Air, MiniExtensions, Pory, Stacker, and more!) ➣ Permission Management ➣ Data Integrations ➣ Data Synchronization ➣ Ongoing training & team onboarding ➣ Best practices for maintaining your database
WHAT WILL I KNOW BY THE END OF THE COURSE
Course Outcomes
We've designed our course with two primary learning objectives in mind:
1) We want to our students to internalize good principles of database design
We want to help our students understand the fundamental principles that make up good database design. Databases that are organized, structured, and planned right the first time lead to cleaner, easier to manage, and modular Airtable applications.
and;
2) We want our students to leave with extrordinarily usable skills
We want our students to develop the intermediate/advanced skills they'll need to manage, extend, and improve the bases they build and work with on the daily. We want our students to leave the course comfortable bringing the skills they've learned back to their organizations; implementing their own new ideas with confidence and creativity.
Preview a Sample Lesson
Module 1 - Lesson 5 - What is Design
Custom Airtable Database Implementation
Harness the power of your data to transform your organization.
Databases to Write Home About
AirOps Consulting creates bespoke, streamlined Airtable solutions that let you connect information, collaborate, and build powerful databases to help your business reach its potential.
Design
How to scope your project Understanding and analyzing the business needs Architecting your base
Implementation
- configuring fields and tables - Automations - Implementations
Support
Ongoing training Onboarding your team Best practices for maintaining your database
6
Course Modules
100+
Video Lessons
40+
Airtable Templates
10+
Hours of Content
Customizable
All of our databases are built from the ground up to fit the needs of your organization and team.
Scalable
Our Airtable solutions are designed to grow alongside the success of your business.
Simple
All of our databases are streamlined, intuitive, and easy to use.
Course Curriculum
Our approach is named The AirOps Advantage.
The AirOps Advantage contains 3 steps:
- Database Strategy and Design – The first step allows our client’s internal team and AirOps Consulting to be entirely aligned on the process and what the outcome of the project will look like. The deliverable for this phase is the mockup of your database so the client can know how it will be set up.
- Database Implementation – The second step is for the AirOps Consulting consulting team to build the database by configuring fields, setting up automation, and implementing views and interfaces for various team members. The client team and AirOps team will have periodic meetings to communicate on the progress and clarifying questions
- Team Training and Support – The third step of our projects is to train the client team on how to use their database. AirOps Consulting can also provide ongoing support to the client through a monthly retainer.
Our approach is named The AirOps Advantage.
The AirOps Advantage contains 3 steps:
- Database Strategy and Design – The first step allows our client’s internal team and AirOps Consulting to be entirely aligned on the process and what the outcome of the project will look like. The deliverable for this phase is the mockup of your database so the client can know how it will be set up.
- Database Implementation – The second step is for the AirOps Consulting consulting team to build the database by configuring fields, setting up automation, and implementing views and interfaces for various team members. The client team and AirOps team will have periodic meetings to communicate on the progress and clarifying questions
- Team Training and Support – The third step of our projects is to train the client team on how to use their database. AirOps Consulting can also provide ongoing support to the client through a monthly retainer.
Airtable is a customizable database solution. Since 2019, we have worked with over 100 organizations from many industries. The list below contains common industries that our clients are from:
- Retail
- Entertainment and Media production
- Event Management
- Technology
- Manufacturing
- Real Estate
- Non-profit organizations
- Government organizations
- Professional Services and Agencies
Our projects typically take 5 – 12 weeks to complete depending on the size of the project. Larger and more complex projects could take up to 6 months.
AirOps Consulting can provide ongoing support to the client through a monthly hourly retainer. Clients use this retainer for many purposes like ongoing training, technical support, feature updates, and other database inquiries.
We integrate with a wide array of third-party apps through various methods. Airtable is constantly adding new integrations with different tools like Twilio, Outlook, Gmail, and Google Calendar. We also integrate with thousands of other apps using Zapier and Integromat like Quickbooks, SignNow, Shopify, and Mailchimp. If you need special integration requests, we can also create custom scripts to connect your Airtable.
We also have extensive knowledge of the apps listed below:
- On2Air
- Pory
- Stacker
- AirPower
- MiniExtensions
- Zapier
We work with many large teams and have built databases that enable collaboration with many stakeholders. Typically, we will use a combination of forms, portals, and automation to help our clients save on costs and properly configure the view and editing capabilities of various stakeholders.
“
Consistent, smart, thinks up stuff you never thought about.
Cherry is a consummate professional when it comes to Airtable and business in general. She has been working as a part of my team for several months now to create and launch an amazing new CRM for my business. I am thrilled with her results.
Jason Ford
Owner, Property Problem Solvers
About the Instructor
I’m Cherry Yang, founder of AirOps Consulting - As a Airtable Consultant Partner and certified Zapier expert, I’ve been building databases and workflows using Airtable and Zapier for over 100 clients; helping corporations untangle complex processes and streamline operations.
Course Overview
A deep dive into the content.
- Intro – Goal of the course
- Intro – Who this is for
- Intro – Structure of the course
- Intro – What is Airtable
- Design – Types of Relationships
- Design – Airtable taxonomy
- Design – Demo Relationships in Airtable base
- Design – Example 1
- Design – Example 2
- Design – Example 3
- Design – Setting up the base
- Design – Base Schema Extension
- Design – Extra Credit – Airtable Pricing
- Design – Extra Credit – Airtable Sharing
- Design – Extra Credit – Airtable Permissions
- Design – Extra Credit – How to get help on Airtable
- Design – Extra Credit – Start with a template
- Design – What is Design?
- Implementation – Base – Intro 1
- Implementation – Base – Field Types
- Implementation – Base – Formulas – Intro
- Implementation – Base – Formulas – Text Formulas
- Implementation – Base – Formulas – Numeric
- Implementation – Base – Formulas – Date and Time
- Implementation – Base – Formulas – Arrays
- Implementation – Base – Formulas – Record functions
- Implementation – Base – Views – Intro
- Implementation – Base – Views – Grid View
- Implementation – Base – Views – Form View
- Implementation – Base – Views – Calendar View
- Implementation – Base – Views – Kanban View
- Implementation – Base – Views – Timeline View
- Implementation – Base – Views – Gantt View
- Implementation – Base – Views – Gallery View
- Implementation – Base – Views – Wrap Up
- Implementation – Base – Organizing Views
- Implementation – Automation & Integration – Automations – Intro
- Implementation – Automation & Integration – Automations – Triggers and Actions
- Implementation – Automation & Integration – Automations – tools for automation
- Implementation – Automation & Integration – Automations – Email Example
- Implementation – Automation & Integration – Automations – Gmail Example
- Implementation – Automation & Integration – Automations – Time based trigger
- Implementation – Automation & Integration – Automations – Zapier automations
- Implementation – Automation & Integration – Automations – Conditionals
- Implementation – Automation & Integration – Automations – Zapier: Calendly Demo
- Implementation – Automation & Integration – Automations – Zapier: Create or Update Contact
- Implementation – Automation & Integration – Automations – Zapier: Wrap Up
- Implementation – Reporting – Reporting – Introduction
- Implementation – Reporting – Understanding your reporting needs
- Implementation – Reporting – Reporting with Roll up fields
- Implementation – Reporting – pivot tables
- Implementation – Reporting – quarterly or annual reporting
- Implementation – Reporting – Charts & graphs
- Implementation – Permissions and Sync Tables – Permissions
- On…
- a
- a
- a
- a
- a
- a
- On…
- a
- a
- a
- a
- a
- a
Frequently Asked Questions
Answers to our most common Database Implementation questions.
Our approach is named The AirOps Advantage.
The AirOps Advantage contains 3 steps:
- Database Strategy and Design – The first step allows our client’s internal team and AirOps Consulting to be entirely aligned on the process and what the outcome of the project will look like. The deliverable for this phase is the mockup of your database so the client can know how it will be set up.
- Database Implementation – The second step is for the AirOps Consulting consulting team to build the database by configuring fields, setting up automation, and implementing views and interfaces for various team members. The client team and AirOps team will have periodic meetings to communicate on the progress and clarifying questions
- Team Training and Support – The third step of our projects is to train the client team on how to use their database. AirOps Consulting can also provide ongoing support to the client through a monthly retainer.
Airtable is a customizable database solution. Since 2019, we have worked with over 100 organizations from many industries. The list below contains common industries that our clients are from:
- Retail
- Entertainment and Media production
- Event Management
- Technology
- Manufacturing
- Real Estate
- Non-profit organizations
- Government organizations
- Professional Services and Agencies
Our projects typically take 5 – 12 weeks to complete depending on the size of the project. Larger and more complex projects could take up to 6 months.
AirOps Consulting can provide ongoing support to the client through a monthly hourly retainer. Clients use this retainer for many purposes like ongoing training, technical support, feature updates, and other database inquiries.
We integrate with a wide array of third-party apps through various methods. Airtable is constantly adding new integrations with different tools like Twilio, Outlook, Gmail, and Google Calendar. We also integrate with thousands of other apps using Zapier and Integromat like Quickbooks, SignNow, Shopify, and Mailchimp. If you need special integration requests, we can also create custom scripts to connect your Airtable.
We also have extensive knowledge of the apps listed below:
- On2Air
- Pory
- Stacker
- AirPower
- MiniExtensions
- Zapier
We work with many large teams and have built databases that enable collaboration with many stakeholders. Typically, we will use a combination of forms, portals, and automation to help our clients save on costs and properly configure the view and editing capabilities of various stakeholders.
Explore Our Services
See what we offer and how we deliver customized services that make your data work for you.
About AirOps Consulting
Get to know our company, our values, and why we’re the right partner for you.