Skip to main content

πŸ—ƒοΈ Lesson 3.1: Your First Database β€” What a Database Really Is

This is the lesson where Notion goes from "a nicer notes app" to "a system you design." A database sounds technical and scary β€” it is neither. In Notion, a database is simply a collection of pages that share the same properties. Once that clicks, everything you've ever admired in someone's workspace becomes buildable. Let's build your first one today.

πŸ“š What You'll Learn

By the end of this lesson, you will be able to:

  • Explain what a Notion database actually is β€” and why every row is a real page, not just a spreadsheet cell
  • Create a database two ways: inline on a page and as a full-page database
  • Understand that the "table" you see is only one view of the underlying data
  • Add rows, use the mandatory title property, and open a row as a full page to add notes inside it
  • Decide confidently when to use a database vs. a plain page vs. nested subpages

⏱️ Estimated Time: 55 minutes

🎯 Project: Build a real "Reading List" database, add five books, and open one row to write notes inside the book's own page.

In This Lesson

The Big Idea: A Collection of Pages

Back in Lesson 1.1 we said databases are the idea that lifts Notion above every ordinary notes app. Here is the whole secret, in one sentence:

A Notion database is a collection of pages that all share the same properties.

That's it. No servers, no SQL, no scary jargon. If you can picture a stack of index cards where every card has the same labeled fields β€” Title, Status, Due Date β€” you already understand a Notion database. Each card is a page. The labels are properties. The stack is the database.

The magic is that because every item is structured the same way, Notion can show that one collection in many different shapes β€” a spreadsheet-like table, a kanban board, a calendar, a gallery of cards β€” and filter, sort, and connect them. You store the information once and look at it however the moment needs.

graph TD A["πŸ—ƒοΈ One database
(a collection of pages)"] --> B["πŸ“Š Shown as a Table"] A --> C["πŸ“‹ Shown as a Board"] A --> D["πŸ“… Shown as a Calendar"] A --> E["πŸ–ΌοΈ Shown as a Gallery"] B --> F["✨ Same data,
many views"] C --> F D --> F E --> F

🧠 Mindset

The word "database" scares a lot of newcomers away from the best part of Notion. If it helps, don't call it a database at all β€” call it a smart list. That's really all it is: a list where each item can carry a few labeled facts. You already make lists every day. You've got this.

Every Row Is a Page (Not a Cell)

This is the single most important thing to understand in this entire module, and it's the thing a spreadsheet can never do. In a spreadsheet, a row is just a line of cells. In Notion, every row is a full, openable page β€” with its own body where you can write paragraphs, add checklists, embed images, or nest more content.

So a row in your Reading List isn't just "Dune β€” Sci-fi β€” Reading." Open that row and you get a whole page about Dune, where you can jot your favorite quotes, a review, links, and notes β€” all while the row still shows its tidy properties in the table. The properties are the summary; the page is the depth.

Concept Spreadsheet Notion Database
A row is… A line of cells A full page you can open
A column is… A column of values A property with a defined type
A cell holds… Text or a number A typed value (date, status, person, checkbox…)
Where notes go Cram them into a cell Inside the row's own page body
Views One grid Table, board, calendar, gallery, list, timeline

πŸ“– Definition

Property: A labeled field that every page in the database shares β€” like Status, Rating, or Due Date. Properties are Notion's word for "columns," and each one has a type (text, number, date, select, and more) that we'll explore fully in the next lesson. The title property is special: every database has exactly one, it can never be deleted, and it's the name of each page.

Inline vs. Full-Page Databases

When you create a database, Notion asks β€” implicitly, by which command you use β€” whether you want it to live inside another page or to be its own page. Both hold identical data; the only difference is where the database sits.

πŸ“₯ Inline database

An inline database is embedded in a page alongside other blocks. You can have text above it, three databases stacked on one dashboard, a heading and a table and a callout all together. Inline is perfect when the database is part of a bigger page β€” like a "Projects" dashboard that shows a task table plus some notes.

πŸ—‚οΈ Full-page database

A full-page database is the page. It takes over the whole canvas and shows up in your sidebar as its own item, with no room for other blocks around it. Full-page is best when the database is a major thing in its own right β€” your master Tasks database, your whole Reading List.

βœ… Pro Tip

Don't agonize over the choice β€” you can convert either way later. Right-click an inline database and choose Turn into page to make it full-page, or on a full-page database use Turn into inline. Start inline if you're building a dashboard; start full-page if the collection is the star of the show.

Creating Your First Database

Everything in Notion starts with the slash command, and databases are no exception. Put your cursor on an empty line and type / to open the block menu, then pick the kind of database you want.

My Dashboard
πŸ“š My Dashboard
/table
Database
πŸ“Š Table view
πŸ“‹ Board view
πŸ“… Calendar view
πŸ–ΌοΈ Gallery view
πŸ“ƒ List view

Here are the commands worth memorizing:

  • /table β€” the classic spreadsheet-style view; the most common way to start.
  • /database β€” creates a database and lets you pick its first view.
  • /board, /calendar, /gallery, /list, /timeline β€” start the database directly in that view. (We cover every view in Lesson 3.3.)

When you pick one, Notion offers to create a new empty database or to show data from an existing one (that's a "linked view" β€” more in Lesson 3.3). For now, choose New database. You'll get a small table with a couple of starter columns and empty rows, ready to fill.

⚠️ Watch Out β€” a table block is not a database

Notion also has a plain Table block (under "Basic blocks", sometimes called a "simple table") for laying out static rows and columns, like a small comparison chart. It looks similar but it is not a database β€” its rows aren't pages, and it has no properties, views, filters, or sorting. If you want the power in this module, create a database (a Table view), not a simple table block.

πŸ‘οΈ The "table" is just one view

Here's a mindset shift that pays off all module: what you see is not "the database" β€” it's one view of it. The data lives underneath, invisible. A table view arranges it into rows and columns; a board view would arrange the exact same rows as cards. Changing the view never changes the data. This is why the same Reading List can be a checklist today and a visual shelf of covers tomorrow.

Reading List
πŸ“š Reading List
Aa Title Status Genre Rating
Dune Reading Sci-fi ⭐⭐⭐⭐
Atomic Habits Done Self-help ⭐⭐⭐⭐⭐
The Hobbit To Read Fantasy β€”

Notice the Aa icon on the Title column β€” that's Notion marking the mandatory title property. The colored pills are select and status properties, which you'll add in Lesson 3.2.

Opening a Row as a Page

Remember: every row is a page. To prove it, hover over any row and an OPEN button appears at the left edge of the title cell. Click it (or click the row's title) and the page opens. Notion gives you three ways to open a row, and you'll use all three:

Way to open What happens Best for
Side peek (default) The page slides in from the right; your table stays visible Quick edits without losing your place
Center peek Opens in a focused modal over the page Reading or writing a longer note
Full page Opens like any normal page, taking the whole canvas Deep work inside one item

You can set your preferred default with the β‹― menu at the top of the page, and switch on the fly from the icons at the top of the peek. Once open, a row page has two zones: its properties across the top (the values you'd see in the table) and its body below β€” a completely normal page where every block and skill from Module 2 works.

⚠️ Important: Adding blocks inside a row's page does not create a new database column. The body is free-form page content; the properties are the structured data. Keep the two straight: quick facts you'll filter or sort β†’ properties; longer freeform notes β†’ the page body.

βœ… Pro Tip β€” the title property is your friend

The title is the one property you can't remove, so make it carry weight. Name rows so they read well in every view: "Dune", not "book1". A good title is the label you'd want on an index card. You can rename the Title property itself (e.g. to "Book" or "Task") without losing its special role.

Database vs. Page vs. Subpages β€” a Clear Rule

The most common beginner question in all of Notion is: "should this be a database, a plain page, or a few subpages?" Here is a rule you can actually use.

🧭 The rule

If you have a collection of similar things you'll want to sort, filter, or view different ways β€” use a database. If it's one document β€” a note, a doc, an essay β€” use a plain page. If it's a few distinct pages that belong together but aren't really the same kind of thing β€” nest them as subpages.

Ask yourself two questions:

  1. Are these items alike? Books, tasks, contacts, recipes, expenses β€” many of the same kind. β†’ Leaning database.
  2. Will I ever want to sort, filter, or see them another way? "Show only unread," "sort by due date," "see this month on a calendar." β†’ Definitely a database.
What you have Best tool Why
A meeting note, an essay, a journal entry Plain page It's one document, not a collection
Home, About, Resources sections of a wiki Nested subpages A handful of distinct pages that belong together
Books, tasks, habits, contacts, expenses Database Many similar items you'll sort, filter, and view different ways

⚠️ Watch Out β€” the "everything is a database" trap

New converts sometimes turn everything into a database, including things that are just one page. A single running "Ideas" note doesn't need to be a database until you actually want to tag and filter those ideas. Reach for a database when the collection and the desire to slice it are both real, not before. A plain page is often the faster, calmer answer.

πŸ’‘ Good news on limits

The Free plan gives you unlimited databases with unlimited rows, so you never have to ration them. Paid plans mostly add team features, larger file uploads, and longer page history rather than "more database." Build as many as your system needs.

🎯 Project: Your Reading List Database

Time to build the real thing. This Reading List becomes your database sandbox for the whole module β€” in Lesson 3.2 you'll add proper properties, and in Lesson 3.3 you'll view it as a board, calendar, and gallery. (Prefer tasks to books? Build a "Tasks" database instead with the same steps β€” either works beautifully.)

πŸ‹οΈ Build a Reading List and write inside a row

Objective: Create a working database, add five rows, and prove to yourself that a row is a page by writing notes inside one.

Instructions (about 20 minutes):

  1. (2 min) Create a new page called Reading List (or use your practice page). On an empty line type /table and choose Table view β†’ New database.
  2. (2 min) Rename the database to Reading List by clicking its title. Notice it has a Name (title) column and one starter column β€” leave the extra for now.
  3. (6 min) Add five books as rows. Click the title cell of the first row, type a book name, press Enter, and repeat. Use the + New row button at the bottom if you run out of rows.
  4. (4 min) Hover over your favorite book and click OPEN to open it as a page (try the side peek). See the properties at the top and the empty body below.
  5. (4 min) Inside that row's page body, write a few real notes: why you want to read it, a favorite quote, or a mini-review. Add a to-do block for "Buy" or "Return to library." This is content that lives in the row's page, not in the table.
  6. (2 min) Close the peek and confirm your table still looks clean β€” the notes are tucked inside the page, not cluttering the row.
πŸ’‘ Hint β€” starter titles if your mind goes blank
Reading List

- Dune
- Atomic Habits
- The Hobbit
- Educated
- Project Hail Mary

Any five will do β€” the point is to feel the flow of adding rows and opening one as a page. You'll add real properties like Status and Rating next lesson.

βœ… Project Completion Checklist

  • You created a database using /table β†’ New database
  • You renamed it to "Reading List" (or "Tasks")
  • It has at least five rows, each with a title
  • You opened at least one row as a page (peek or full)
  • You wrote notes inside that row's page body
  • You can explain, out loud, why a row is a page and not just a cell

🎯 Quick Quiz

Question 1: What is a Notion database, most fundamentally?

Question 2: You have a growing list of recipes you'll want to filter by cuisine and by how long they take. What should you use?

Best Practices for Your First Database

βœ… Do's

  • Start small. One database, a few rows. You can always add properties and views later.
  • Write meaningful titles. The title shows in every view β€” make it the label you'd want on an index card.
  • Use the row's page body for long notes, and properties for facts you'll sort or filter.

❌ Don'ts

  • Don't confuse a simple Table block with a database. If you want views and filters, create a Table view database.
  • Don't make everything a database. One document is a page; a collection is a database.
  • Don't stuff notes into the title. That's what the page body is for.

πŸ““ Learning Journal

Keep a learning journal β€” the best place is inside your own Notion. After each lesson, take a few minutes to write down:

  • Key concepts you learned
  • Techniques that clicked for you
  • Questions or confusion points to revisit
  • Ideas you want to try
  • Your progress and feelings about learning this

✍️ This lesson's prompt: What "collection" in your own life β€” books, tasks, projects, recipes, contacts β€” do you most want to turn into a database? Why has a plain list not been enough for it so far?

πŸ“ Lesson Summary

πŸŽ“ Key Takeaways

  • A database is a collection of pages that share the same properties β€” think "smart list," not "spreadsheet."
  • Every row is a full page you can open and write inside; the properties are the summary, the page body is the depth.
  • Databases can be inline (embedded in a page) or full-page (their own sidebar item); you can convert between them.
  • Create one with /table or /database; what you see is just one view of the underlying data.
  • Use a database for a collection of similar things you'll sort or filter; use a plain page or subpages for one-off documents.

πŸŽ‰ What You've Accomplished

You built your first real database and β€” more importantly β€” you understand what it is. That "every row is a page" insight is the mental model most Notion users never quite articulate, and it's the foundation for every dashboard, tracker, and wiki you'll ever build. From here, databases only get more powerful, and you'll always know what's happening underneath.

❓ Common Questions at This Stage

Is a database different from the "Table" I saw under Basic blocks?

Yes. The simple Table block is just static rows and columns for layout β€” no properties, no views, no filtering, and its rows aren't pages. A database (created as a Table view) has all that power. If you want to sort, filter, or switch to a board or calendar, you want a database.

Do databases cost money or count against a limit?

No. The Free plan includes unlimited databases and unlimited rows. Paid plans (Plus, Business, Enterprise) mostly add team collaboration, bigger file uploads, and longer version history β€” not more database capacity. Build freely.

Can I move a database somewhere else after I create it?

Yes. Drag it in the sidebar, or use the β‹― menu to move it. You can also switch between inline and full-page (Turn into page / Turn into inline). Nothing you decide today is permanent.

πŸ”­ Looking Ahead

Your Reading List has titles but not much structure yet. Next up, Lesson 3.2: Properties β€” The Many Column Types, where you'll meet every property type β€” status, date, select, number, checkbox, and more β€” and learn which to reach for when. That's where your database gains real intelligence.

βœ… Before the Next Lesson

  • Keep your Reading List (or Tasks) database β€” you'll enrich it next lesson
  • Open at least one row as a page and notice the properties vs. body split
  • Write your Learning Journal entry for this lesson

πŸ“š Additional Resources

🌟 Encouragement for the Journey

You just crossed the line most people never do β€” you built a database and it wasn't scary at all. This is the heart of Notion, and you're now standing right in it. A few properties and views from here, your Reading List becomes a living system. Onward. πŸ—ƒοΈ