Summary  
This chapter covers how to add new records to an existing database table by executing parameterized INSERT queries through a database connection and cursor, then committing the transaction.  

General domain of usage  
Relational database management

__Creation operations__ in SQLite involve __adding__ new records to a database table. These operations allow you to __populate__ your tables with data. Let's explore how insertion operations work within the context of database creation.



## Inserting a  Record

This code snippet uses the SQL `INSERT INTO` statement to add a new record to the `"users"` table, inserting values for the `"username"` and `"email"` fields. The data is passed as a tuple, and the query is executed with the `execute()` method to insert the values.

```python
import sqlite3

# Connect to the database
conn = sqlite3.conn('my_database.db')
cursor = conn.cursor()

# SQL query to insert a record into the `users` table
insert_query = "INSERT INTO users (username, email) VALUES (?, ?)"
user_data = ('john_doe', 'john.doe@email.com')

# Execute the SQL query with data
cursor.execute(insert_query, user_data)

conn.commit()  # save the changes
conn.close()  # close the connection
```


Be careful because this code considers working on an __already existing table__. If you don't have a `users` table in your database, then you need to create one.

To avoid the __error__, you need to create a table in the database with the name `users` and fields `username` and `email`. Only after that can you add records to this table.

"Databases in Python" is a hands-on course designed to teach you the fundamentals of working with databases using Python, focusing on the sqlite3 library and SQLAlchemy. You’ll learn how to store, modify, and retrieve data, build efficient queries, and configure databases for your projects. The course covers both SQL basics and the ORM (Object-Relational Mapping) approach, which allows you to interact with databases through Python objects. This course is perfect for beginners looking to deepen their skills in data management, application development, and information handling.

Whether you're new to databases or want to master SQLite, this course will teach you the essentials. You'll learn data management, and how to use SQLite effectively.

CRUD (Create, Read, Update, Delete) are the foundational operations in working with databases. This section is your gateway to mastering these core database functions.

In the "CRUD Operations" section, we will delve into creating, retrieving, updating, and deleting data in a database. You will gain the skills needed to interact with databases effectively, making it an essential tool for your software development journey.

Congratulations on reaching the final section of this course! You've come a long way in your journey to learn and master the content covered.

In this concluding section, we'll summarize key takeaways, reinforce your knowledge, and provide guidance on what you can do next. You've acquired valuable skills and insights, and now it's time to reflect on your achievements and explore how to apply your newfound knowledge effectively.



Learn how to interact with databases in Python using SQLAlchemy, a powerful Object-Relational Mapping (ORM) tool. This section covers setting up connections, defining models, and performing essential CRUD operations (Create, Read, Update, Delete). You'll discover how to write cleaner, more efficient code without relying on raw SQL queries. Mastering SQLAlchemy will streamline database management and enhance the scalability of your Python applications.

Creation Operations

Inserting a Record

Løsning

Awesome!

Creation Operations

Inserting a Record

Løsning

Awesome!