Login Get started

Notion Databases - Full Course for Beginners

Thomas Frank Explains・48 minutes read

Notion databases are versatile tools that can create various systems like task managers and contact trackers, featuring project-based and action-oriented functions with different viewing options and customizable properties. They offer flexibility in data visualization and organization, recommending sorting tasks by due date for efficient management, utilizing rollups to track unfinished tasks, and using formulas for customizing data displays.

Insights

Notion databases are versatile tools that can create various systems like task managers, contact trackers, and game trackers, offering project-based, action-oriented features with structured records and customizable views for efficient data organization.
Utilizing properties like due dates and assignees, along with features like filters, relations, rollups, and formulas, enhances database functionality, enabling users to streamline content creation, manage tasks effectively, and customize data display for improved organization and productivity.

Get key ideas from YouTube videos. It’s free

Recent questions

How can Notion databases be utilized?
Notion databases create tools like task managers and trackers.
What are properties in Notion databases?
Properties store structured information on a per-record basis.
How do Notion databases differ from spreadsheets?
Notion databases offer more flexibility in data viewing.
What customization options are available for database views?
Customization options include layout, filtering, sorting, and grouping.
What are some advanced features of Notion databases?
Advanced features include relations, rollups, and formulas.

Related videos

Summary

00:00

Powerful Notion Databases for Task Management

Notion databases are a powerful feature that can be used to create various tools like task managers, note-taking systems, contact trackers, and even game trackers.
Databases in Notion are project-based and action-oriented, allowing users to build tools like a Simple Task Manager.
Notion databases consist of records, with each record being another page within the database.
Properties in databases store structured information on a per-record basis, created at the database level.
Databases in Notion resemble spreadsheets but offer more flexibility in viewing data, allowing for different views like table, board, or calendar.
Notion databases do not function like spreadsheets, as they do not have individual cells for formulas but offer advantages in data visualization and organization.
Creating databases in Notion can be done by typing "/database" and choosing between inline or full-page display options.
Database views in Notion allow for multiple views of the same database, enabling users to see different information based on filter and sort criteria.
Users can set up multiple views in a database by adding new views, renaming them, and customizing their display options.
The view options menu in Notion provides various customization options for database views, including layout, property display, filtering, sorting, grouping, and load limit.

11:20

"Efficient Database Management in Notion"

Initially, set the page to load only 10 or 25 pages, with a "load more" button available for additional content.
The view options menu includes lock database, copy link to view, duplicate, and delete options.
Various methods exist to add new rows to databases, including clicking the "new" button to add tasks.
Another way to add tasks is by using the plus syntax from within the Notion workspace.
Three ways to add new rows to databases are through the new button, opening a page, or using the plus syntax.
Properties like due dates, checkboxes, and assignees enhance database usefulness.
Different property types in Notion include number, select, dates, person, attachments, checkboxes, URLs, emails, phones, and advanced types like formulas and relations.
Sorting criteria can be added to views, such as sorting by due date in ascending or descending order.
Filters can be applied based on properties like the done checkbox or due date, with options for simple or advanced filters.
Adding a new row to a view with filter criteria automatically populates certain properties, like due dates or checked checkboxes, based on the filter rules.

22:32

"Creating Efficient Database Templates with Relations"

Forcing functions can be created around text or number properties, providing practical utility.
The Creator's Companion template is a project manager tool used for YouTube videos and blog posts.
The template includes filter criteria, such as rules for status and idea, to organize content effectively.
A forcing function ensures that the status property cannot be empty in the database view.
Adding a new row automatically assigns a status, like "planned," streamlining content creation.
Relations in databases link records within the same database or across different databases.
In a single database, relations can establish parent tasks and subtasks connections.
Across multiple databases, relations can connect tasks to larger projects for better organization.
Creating relations between databases allows for contextual data filtering and sorting.
Database templates set default content for new rows, while linked databases provide views of related databases with customizable filters.

35:06

Enhance Notion Projects with Filters and Formulas

Self-referential projects in Notion update filters automatically based on the page they are on, not just the template.
Check project filters to ensure all necessary changes are made, such as grouping tasks related to a specific project.
Utilize the grouping feature to focus on tasks related to a specific project.
Sorting tasks by due date is recommended for efficient task management.
Rollups in Notion allow users to see the number of unfinished tasks within each project.
Create a rollup property by selecting the relation and the property to be analyzed.
Rollups can display the count of undone tasks, providing valuable information for task management.
Formulas in Notion are powerful tools for customizing data display, such as showing the number of tasks left in a more user-friendly format.
Use the "format" function in formulas to convert numeric values into text for better readability.
Database locking in Notion prevents accidental changes to properties or formulas, ensuring data integrity and consistency.

47:13

YouTube Databases: Resources, Templates, and Tips

Find a table of contents in the description below to navigate through the complex topic of databases on YouTube, with companion resources available at thomasjfrank.com/fundamentals, offering written and video lessons for each course module, along with the option to subscribe to the Notion Tips newsletter for updates on new tutorials and templates.
Access three sample templates - a book tracker, simple contact tracker, and simple task tracker - to practice using databases, with the option to explore Ultimate Tasks for a more advanced task management system, including subtasks, recurring tasks, progress bars, and project management features, available in the description below or by contacting the creator on Twitter @tomfrankly.

Try it yourself — It’s free.