Catalogue · First steps in Python and SQL, with AI

Open a SQLite database and read a table

You open a database read-only and read the first rows of a table.

JupyterLiteBeginner0:29Capsule 8 of 12
SkillKapsul

Space: play · ← →: 5 seconds · M: sound · F: full screen

The steps

The exact sequence, in order.

  1. 01

    Drag the atlas_en.db database into the left panel.

  2. 02

    In the launcher, pick SQLite (xsqlite).

  3. 03

    Type %LOAD atlas_en.db r: r for read-only.

  4. 04

    Type SELECT * FROM sales LIMIT 5; then Shift + Enter.

The habit to keep

Read-only: no risk of changing the database.

Related capsules

You might also like

Newsletter

Monday's capsule

One skill a week, straight to your inbox. The easiest way to keep learning without thinking about it.

No spam, no reselling. One-click unsubscribe.

Your data stays in the EU. Never sold.

SkillKapsul