Airtable Essentials
Data Organization Made Simple
37 LESSONS · 14 HANDS-ON PROJECTS
PRESENTED BY
Sahil Khosla
Founder & Chief Instructor at NoCode University
COURSE OVERVIEW
About This Course
Discover the transformative power of databases in organizing, automating, and simplifying complex business processes with the Airtable Essentials course. Here, we use Airtable as a medium to provide hands-on, practical learning, guiding you to build robust systems and lay the foundation for crafting apps without a coding background. Gain a newfound understanding and skill set that can forge a path in the no-code career landscape or boost your business/consultancy proficiency.
Who is This Course For
01
Aspiring no-code professionals, looking to build a robust foundation in databases.
02
Business owners striving to streamline data and automate processes with Airtable.
03
Individuals familiar with Excel but new to the world of databases and automation.
What You'll Learn
- Database Fundamentals: Grasp the foundational principles that govern databases, understanding why they play a pivotal role in data organization compared to traditional spreadsheets.
- Mastery of Airtable: Dive into the comprehensive features and functionalities of Airtable, including:
- Tables: Understand how to craft and manage tables effectively, which will host your vibrant data sets.
- Fields: Learn the variations in field types and the best practices for recording diverse data.
- Views: Get acquainted with creating tailored views to represent data beneficially for your workflow.
- Relations: Discover how to establish relations between tables to create a rich, interconnected database landscape.
- Rollups and Lookups: Acquire the skills to streamline data insight extraction through potent features like rollups and lookups.
- Formulas: Unravel the potential of the formula field to automate calculations and facilitate your data management processes.
- Extensions: Unveil the extended capabilities of Airtable through its extensions, enhancing your productivity and bringing versatility to your projects.
- Hands-On Project Experience: Engage in practical labs to:
- Build a Task Manager: Step-by-step guidance to construct a task manager ground up, defining tables, fields, and views that aid smooth operational flow.
- Design a Project Management System: Gain first-hand experience in crafting a database focusing on project management, inclusive of customized progress trackers.
- Assemble an Event Management System: Learn to forge a meticulous system for event planning and management, including details like attendee badge design.
- Develop an Invoice Generator: Conclude your learning journey with the creation of an invoice generator, emphasizing understanding many-to-many relationships through junction tables.
- By the end of this course, armed with knowledge and firsthand experience, you'll be set to tackle real-world projects, using Airtable to proficiently organize data and effectively automate business processes. You will form a solid foundation to start building apps, venture into the no-code career realm, or kickstart consulting in this space, with an edge.
Requirements
- A willingness to learn and a keen interest in no-code solutions.
- Access to a computer with a stable internet connection to navigate through Airtable.
- No previous experience with databases necessary — we start from scratch!
Curriculum
The course is divided into 5 modules and the lessons are a mix of text and video.
| # | Title | Length |
|---|---|---|
| 1 | ► What is a Database? | 02:14 |
| 2 | ► Real-World Use Cases of Databases | 01:56 |
| 3 | ► Spreadsheet vs Database | 03:36 |
| 4 | ► What is Airtable? | 00:34 |
| 5 | ► Intro to Airtable Dashboard | 13:53 |
| # | Title | Length |
|---|---|---|
| 1 | ► Lab 1: Build a Task Manager | Lab |
| 2 | ► Understanding Field Types in Databases | 01:52 |
| 3 | Sample Field Types in Airtable | Reading |
| 4 | ► Creating a Tasks Table | 11:47 |
| 5 | ► Lab 2: Done/Pending Tasks Filter | Lab |
| 6 | ► Creating Filtered Views | 09:51 |
| 7 | Working with Filters in Airtable | Reading |
| 8 | ► Lab 3: Display Tasks in a List | Lab |
| 9 | ► Creating a List View | 07:17 |
| # | Title | Length |
|---|---|---|
| 1 | ► Database Relationships | 03:35 |
| 2 | Lab 4: Design a Project Manager | Lab |
| 3 | ► What is an ERD | 05:52 |
| 4 | ► Create Project Manager ERD | 14:04 |
| 5 | Lab 5: Linking Projects and Tasks Tables | Lab |
| 6 | ► Implement the Project Manager in Airtable | 08:21 |
| 7 | Lab 6: Tracking Project Progress | Lab |
| 8 | ► Count Done and Total Tasks | 06:25 |
| 9 | Lab 7: Adding a Progress Score | Lab |
| 10 | ► Intro to Airtable Formulas | 02:07 |
| 11 | List of Basic Airtable Formulas | Reading |
| 12 | ► Calculate the Progress Score | 06:07 |
| 13 | ► Customizing the Project Manager | 09:21 |
| # | Title | Length |
|---|---|---|
| 1 | Lab 8: Event Management System (EMS) | Lab |
| 2 | ► Designing the EMS — Part 1 | 13:38 |
| 3 | ► Designing the EMS — Part 2 | 07:35 |
| 4 | ► Building the EMS | 09:10 |
| 5 | ► Testing the EMS | 08:48 |
| 6 | Lab 9: Calendar View | Lab |
| 7 | Lab 10: Create a Registration Form | Lab |
| 8 | ► Intro to Airtable Form View | 08:50 |
| 9 | Lab 11: Fetch Speaker Details | Lab |
| 10 | ► Intro to Lookups | 01:26 |
| 11 | ► Fetch Speaker Details | 05:02 |
| 12 | Lab 12: Event Metrics Table | Lab |
| 13 | ► Intro to Rollups | 01:42 |
| 14 | ► Create the Metrics Table — Part 1 | 09:35 |
| 15 | ► Create the Metrics Table — Part 2 | 13:34 |
| 16 | Lab 13: Design the Attendee Badges | Lab |
| 17 | ► Intro to Airtable Extensions | 08:00 |
| 18 | ► Using Page Designer | 10:12 |
| # | Title | Length or Type |
|---|---|---|
| 1 | Lab 14: Design the Invoice Generator | Lab |
| 2 | ► Intro to Junction Tables | 0:01:08 |
| 3 | ► Invoice ERD Walk-Through | 0:12:02 |
| 4 | ► Implementing Junction Table | 0:10:26 |
| 5 | ► Printing Invoices Using Page Designer | 0:09:10 |
In the Capstone Project Module, it's time to bring it all together. You've mastered database fundamentals, Airtable functionalities, and built multiple projects. Now, let's apply what you've learned.
You'll undertake a comprehensive project that combines various aspects of database design and Airtable tools.
It's a practical, hands-on experience that prepares you to use these skills in real-life scenarios. From conceptualizing to implementing and even testing your project, this module is the final checkpoint in your learning path.
Your completed project serves not just as a testament to your skills but as a portfolio piece for future opportunities.
Lifetime Access
This Course Includes
- 33 Video Lessons
- 13 Hands-On Labs
- Lesson Summaries
- Database Templates
- Lifetime Access
- Certificate of Completion
Stay Connected
Not Ready? Subscribe To Stay Connected
FAQ
General Questions
Got questions? We’ve got answers. Here are some of the most frequently asked questions about NoCode University, our courses, and the no-code movement. If you can’t find what you’re looking for, feel free to reach out to our support team.
This course is designed for individuals familiar with Excel but new to the database landscape. Whether you're looking to build a career in no-code, automate your business processes, or start consulting in this space, this course will equip you with the necessary skills and knowledge.
While no prior database experience is required, a basic understanding of spreadsheet tools like Excel would be beneficial to grasp the concepts more fluently.
Absolutely. The course encompasses hands-on lab sessions where you'll be tasked to create task managers, project and event management systems, and an invoice generator using Airtable. These projects aim to provide you with practical experience and a deep understanding of how to utilize Airtable effectively.
We offer steady support throughout the course to assist you in your learning journey. You'll have access to forums and community groups to discuss your queries and insights with peers and instructors.
Yes, once you've enrolled in the course, you will have lifetime access to the course material, allowing you to revisit the modules at your convenience.
Yes, upon successful completion of the course, you will receive a certificate acknowledging your proficiency in the mastered skills.
Airtable stands as a powerful tool facilitating data organization, a foundational skill in app development and automation projects. The course delves into the vital aspects of data structuring and management, setting a robust base for you to explore app-building and automation.
Understanding database fundamentals will not only enable you to organize data more efficiently but also lays the groundwork for venturing into more advanced database operations, including the creation and management of relational databases, which is pivotal in numerous tech-savvy roles today.
