Chapter 43: Database Fundamentals and SQL

Complete Python lesson for very beginners. Technical words are explained in simple language, and every outline topic includes a practical example, expected output, steps, and practice.

Python CourseVery Beginner Friendly15 TopicsExamples + Output20 Q&A

Chapter 43 · 15 topics

Language

100%

Chapter Overview

This Python tutorial chapter covers Database Fundamentals and SQL through 15 connected topics. Work through the examples in order, check the expected output, and complete the practice after each topic.

43.1 Databases
43.2 Relational Databases
43.3 Tables
43.4 Rows and Columns
43.5 Primary Keys
Plus 10 additional Python topics in this chapter.

43.1 Databases

Databases is part of Database Fundamentals and SQL. In simple language, it means organized persistent data.

It connects Python programs to external data, services, users, or other computers in a structured way. For a very beginner, focus first on what goes in, what Python does, and what comes out; details become easier after you run a small example.

Technical words in simple language: Databases (organized persistent data).

Python / Practical Example

print("SELECT name FROM users WHERE id = ?")

Expected Output

SELECT name FROM users WHERE id = ?

Step-by-Step Explanation

Read the example from top to bottom.
Identify the value, object, or operation related to this topic.
Change one small input and predict the result before running it.

Practice: Re-type the example for “Databases”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

43.2 Relational Databases

Relational Databases is part of Database Fundamentals and SQL. In simple language, it means organized persistent data.

Technical words in simple language: Relational Databases (organized persistent data).

Python / Practical Example

print("SELECT name FROM users WHERE id = ?")

Expected Output

SELECT name FROM users WHERE id = ?

Step-by-Step Explanation

Read the example from top to bottom.
Identify the value, object, or operation related to this topic.
Change one small input and predict the result before running it.

Practice: Re-type the example for “Relational Databases”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

43.3 Tables

Tables is part of Database Fundamentals and SQL. In simple language, it means a Python idea used while learning database fundamentals and sql.

It is one building block of database fundamentals and sql and helps you write clearer, more predictable Python programs. For a very beginner, focus first on what goes in, what Python does, and what comes out; details become easier after you run a small example.

Technical words in simple language: Tables (a Python idea used while learning database fundamentals and sql).

Python / Practical Example

print("SELECT name FROM users WHERE id = ?")

Expected Output

SELECT name FROM users WHERE id = ?

Step-by-Step Explanation

Read the example from top to bottom.
Identify the value, object, or operation related to this topic.
Change one small input and predict the result before running it.

Practice: Re-type the example for “Tables”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

43.4 Rows and Columns

Rows and Columns is part of Database Fundamentals and SQL. In simple language, it means a Python idea used while learning database fundamentals and sql.

Technical words in simple language: Rows and Columns (a Python idea used while learning database fundamentals and sql).

Python / Practical Example

print("SELECT name FROM users WHERE id = ?")

Expected Output

SELECT name FROM users WHERE id = ?

Step-by-Step Explanation

Read the example from top to bottom.
Identify the value, object, or operation related to this topic.
Change one small input and predict the result before running it.

Practice: Re-type the example for “Rows and Columns”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

43.5 Primary Keys

Primary Keys is part of Database Fundamentals and SQL. In simple language, it means a Python idea used while learning database fundamentals and sql.

Technical words in simple language: Primary Keys (a Python idea used while learning database fundamentals and sql).

Python / Practical Example

print("SELECT name FROM users WHERE id = ?")

Expected Output

SELECT name FROM users WHERE id = ?

Step-by-Step Explanation

Read the example from top to bottom.
Identify the value, object, or operation related to this topic.
Change one small input and predict the result before running it.

Practice: Re-type the example for “Primary Keys”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

43.6 Foreign Keys

Foreign Keys is part of Database Fundamentals and SQL. In simple language, it means a Python idea used while learning database fundamentals and sql.

Technical words in simple language: Foreign Keys (a Python idea used while learning database fundamentals and sql).

Python / Practical Example

print("SELECT name FROM users WHERE id = ?")

Expected Output

SELECT name FROM users WHERE id = ?

Step-by-Step Explanation

Read the example from top to bottom.
Identify the value, object, or operation related to this topic.
Change one small input and predict the result before running it.

Practice: Re-type the example for “Foreign Keys”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

43.7 SQL

SQL is part of Database Fundamentals and SQL. In simple language, it means a language for working with relational databases.

Technical words in simple language: SQL (a language for working with relational databases).

Python / Practical Example

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)")
con.execute("INSERT INTO users(name) VALUES (?)", ("Ava",))
print(con.execute("SELECT name FROM users").fetchone()[0])
con.close()

Expected Output

Ava

Step-by-Step Explanation

Open an in-memory SQLite database.
Use parameters instead of constructing SQL with untrusted values.
Fetch a row and close the connection.

Practice: Re-type the example for “SQL”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

43.8 SELECT

SELECT is part of Database Fundamentals and SQL. In simple language, it means a Python idea used while learning database fundamentals and sql.

Technical words in simple language: SELECT (a Python idea used while learning database fundamentals and sql).

Python / Practical Example

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)")
con.execute("INSERT INTO users(name) VALUES (?)", ("Ava",))
print(con.execute("SELECT name FROM users").fetchone()[0])
con.close()

Expected Output

Ava

Step-by-Step Explanation

Open an in-memory SQLite database.
Use parameters instead of constructing SQL with untrusted values.
Fetch a row and close the connection.

Practice: Re-type the example for “SELECT”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

43.9 INSERT

INSERT is part of Database Fundamentals and SQL. In simple language, it means a Python idea used while learning database fundamentals and sql.

Technical words in simple language: INSERT (a Python idea used while learning database fundamentals and sql).

Python / Practical Example

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)")
con.execute("INSERT INTO users(name) VALUES (?)", ("Ava",))
print(con.execute("SELECT name FROM users").fetchone()[0])
con.close()

Expected Output

Ava

Step-by-Step Explanation

Open an in-memory SQLite database.
Use parameters instead of constructing SQL with untrusted values.
Fetch a row and close the connection.

Practice: Re-type the example for “INSERT”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

43.10 UPDATE

UPDATE is part of Database Fundamentals and SQL. In simple language, it means a Python idea used while learning database fundamentals and sql.

Technical words in simple language: UPDATE (a Python idea used while learning database fundamentals and sql).

Python / Practical Example

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)")
con.execute("INSERT INTO users(name) VALUES (?)", ("Ava",))
print(con.execute("SELECT name FROM users").fetchone()[0])
con.close()

Expected Output

Ava

Step-by-Step Explanation

Open an in-memory SQLite database.
Use parameters instead of constructing SQL with untrusted values.
Fetch a row and close the connection.

Practice: Re-type the example for “UPDATE”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

43.11 DELETE

DELETE is part of Database Fundamentals and SQL. In simple language, it means a Python idea used while learning database fundamentals and sql.

Technical words in simple language: DELETE (a Python idea used while learning database fundamentals and sql).

Python / Practical Example

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)")
con.execute("INSERT INTO users(name) VALUES (?)", ("Ava",))
print(con.execute("SELECT name FROM users").fetchone()[0])
con.close()

Expected Output

Ava

Step-by-Step Explanation

Open an in-memory SQLite database.
Use parameters instead of constructing SQL with untrusted values.
Fetch a row and close the connection.

Practice: Re-type the example for “DELETE”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

43.12 WHERE

WHERE is part of Database Fundamentals and SQL. In simple language, it means a Python idea used while learning database fundamentals and sql.

Technical words in simple language: WHERE (a Python idea used while learning database fundamentals and sql).

Python / Practical Example

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)")
con.execute("INSERT INTO users(name) VALUES (?)", ("Ava",))
print(con.execute("SELECT name FROM users").fetchone()[0])
con.close()

Expected Output

Ava

Step-by-Step Explanation

Open an in-memory SQLite database.
Use parameters instead of constructing SQL with untrusted values.
Fetch a row and close the connection.

Practice: Re-type the example for “WHERE”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

43.13 JOINs

JOINs is part of Database Fundamentals and SQL. In simple language, it means a Python idea used while learning database fundamentals and sql.

Technical words in simple language: JOINs (a Python idea used while learning database fundamentals and sql).

Python / Practical Example

parts = ["2026", "09", "21"]
print("-".join(parts))

Expected Output

2026-09-21

Step-by-Step Explanation

Start with strings in a list.
Call join() on the separator.
A single combined string is returned.

Practice: Re-type the example for “JOINs”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

43.14 Transactions

Transactions is part of Database Fundamentals and SQL. In simple language, it means a Python idea used while learning database fundamentals and sql.

Technical words in simple language: Transactions (a Python idea used while learning database fundamentals and sql).

Python / Practical Example

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)")
con.execute("INSERT INTO users(name) VALUES (?)", ("Ava",))
print(con.execute("SELECT name FROM users").fetchone()[0])
con.close()

Expected Output

Ava

Step-by-Step Explanation

Open an in-memory SQLite database.
Use parameters instead of constructing SQL with untrusted values.
Fetch a row and close the connection.

Practice: Re-type the example for “Transactions”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

43.15 Database Design Basics

Database Design Basics is part of Database Fundamentals and SQL. In simple language, it means organized persistent data.

Technical words in simple language: Database Design Basics (organized persistent data).

Python / Practical Example

print("SELECT name FROM users WHERE id = ?")

Expected Output

SELECT name FROM users WHERE id = ?

Step-by-Step Explanation

Read the example from top to bottom.
Identify the value, object, or operation related to this topic.
Change one small input and predict the result before running it.

Practice: Re-type the example for “Database Design Basics”, change one safe input, predict the result before running it, and explain in one sentence why the result changed.

Common Beginner Mistakes

Copying code without predicting what each line does.
Ignoring the first useful error message or traceback location.
Mixing tabs/spaces or changing indentation accidentally.
Using data of the wrong type for an operation.
Trying to learn many advanced variations before mastering one small working example.

Chapter Practice

Choose three topics from this chapter and re-type their examples without copying and pasting.
For each example, change one input and predict the output first.
Explain five technical terms from this chapter in your own beginner-friendly words.
Create one small program that combines at least two chapter topics.
Keep notes about errors you made and what fixed them.

Mini Project / Challenge

Create a small Python exercise that combines at least three ideas from Database Fundamentals and SQL. Start with a tiny working version, test it, then improve it one step at a time.

Choose three topics from this chapter.
Write or adapt a small Python example using those topics.
Predict the output before running the code.
Test at least one different input.
Write two sentences explaining what the program does and what you learned.

20 Questions & Answers

1. What is the main goal of Chapter 43?

The goal is to understand database fundamentals and sql through small explanations, examples, and practice.

2. Should I memorize every command or method?

No. Understand the pattern, practice the common form, and learn how to read documentation when you need exact details.

3. Why are the examples small?

Small examples isolate one idea at a time, which makes errors easier to understand and fix.

4. What should I do when an example gives an error?

Read the last part of the traceback, check spelling and indentation, confirm the required package or file exists, and compare the input types with what the operation expects.

5. Why should I predict output before running code?

Prediction forces you to reason about the program instead of only copying it.

6. What should I remember about Databases?