Summary  
This chapter demonstrates how to use Python’s sqlite3 library to execute SQL commands for creating tables with `cursor.execute`, and how to manage transactions by committing changes and closing the connection.  

General domain of usage  
Database management

A __table__ in a database is a __structured collection__ of data organized in __rows__ and __columns__. Each column represents a __specific type__ of information, and each row contains __specific data__. 

Tables are used for __storing and organizing data__ in a database, allowing __for various operations__, including searching, filtering, sorting, updating, and deleting information. Let's look at an example of creating a table:

## Executing SQL Queries 

The **`cursor.execute()`** function is used to execute an SQL query provided __as a string__. In this example, we pass an SQL query to the function to **create table**. The SQL query is enclosed in triple single quotes `(''' ''')` for easier reading. In the next section, we will look at other examples of using `cursor.execute()` function.

```python
cursor.execute('''
    CREATE TABLE IF NOT EXISTS users (
        id INTEGER PRIMARY KEY,
        name TEXT,
        age INTEGER
    )
''')
```
**Note** that in **SQL scripts**, extra **spaces** and **indentations** are used solely to improve **readability** and **code organization** without affecting execution. This differs from languages like **Python**, where spaces and indentation are **critical** and define the **program's structure**.


## Saving the Сhanges 

In this script, we connect to the database and create a table. An __essential final step__ when working with the `sqlite3` library is **committing** and **closes the connection**. Let's take a detailed look at how this is done.

import sqlite3  

# Establish a connection to the database (or create it if it doesn't exist)
conn = sqlite3.connect("my_database.db")  
# Create a cursor object to interact with the database
cursor = conn.cursor()  
# Execute an SQL query to create the `users` table if it doesn't already exist
cursor.execute("CREATE TABLE IF NOT EXISTS users (id INTEGER, name TEXT, age INTEGER)")  
print("The table was successfully created.")  

# Commit the transaction to save changes to the database
conn.commit()  
# Close the database connection
conn.close()  

`conn.commit()` is like **saving changes** in a database. Until you commit (call `commit`), your changes are not permanent and won't be visible to other users of the database. After committing, the changes become **permanent** and are accessible to everyone. It's like hitting the "save" button for your database changes.

`conn.close()` is an essential step when working with __SQLite__ database. This command __closes the connection__ to the database after you've finished your operations.

Why is `conn.commit()` important in database operations?

Master the essentials of working with databases in Python using sqlite3 and SQLAlchemy. Learn to store, modify, and retrieve data efficiently, build optimized queries, and connect your applications to databases. Gain practical experience in both SQL and ORM approaches to manage data through clean, Pythonic workflows.

Explore the fundamentals of SQLite, one of the most lightweight and widely used database systems. Learn how to connect, create tables, and manage data effectively using Python's sqlite3 library.

Develop a solid understanding of the four essential database operations - Create, Read, Update, and Delete. Practice building and modifying data entries directly through SQL commands and Python integrations.

Deepen your knowledge of SQLite by exploring advanced concepts like data types and primary keys. Strengthen your understanding of table design.

Learn to manage databases in Python using SQLAlchemy, a high-level Object-Relational Mapping (ORM) tool. Discover how to define models, connect to databases, and perform CRUD operations without writing raw SQL. Build maintainable, efficient, and scalable database solutions for real-world applications.

Creating a Simple Table

Executing SQL Queries

Saving the Сhanges