Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Creation Operations | CRUD
Databases in Python
course content

Course Content

Databases in Python

Databases in Python

1. Introduction to SQLite
SQLiteWhat is SQLite3 Library?Connecting to DatabaseCreating a Simple TableChallenge: First Table
2. CRUD
What is CRUD?Creation OperationsRead OperationsUpdate OperationsDelete Operations
3. More About SQLite
PRIMARY KEYData TypesChallenge: Table Design
4. SQLAlchemy
Object–Relational MappingGetting Started with SQLAlchemyData TypesCreating Your First ModelBuilding SQLAlchemy ObjectsReading from DBUpdating to DBDeleting from DB

bookCreation Operations

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.

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.

Task
test

Swipe to show code editor

  1. Write an SQL query to insert a new record into the articles table. The query should insert values into the title, content, and author columns. Store the query in the variable insert_query.

  2. Use the cursor method to execute the SQL query with the data stored in the article_data variable.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 2. Chapter 2
toggle bottom row

bookCreation Operations

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.

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.

Task
test

Swipe to show code editor

  1. Write an SQL query to insert a new record into the articles table. The query should insert values into the title, content, and author columns. Store the query in the variable insert_query.

  2. Use the cursor method to execute the SQL query with the data stored in the article_data variable.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 2. Chapter 2
toggle bottom row

bookCreation Operations

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.

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.

Task
test

Swipe to show code editor

  1. Write an SQL query to insert a new record into the articles table. The query should insert values into the title, content, and author columns. Store the query in the variable insert_query.

  2. Use the cursor method to execute the SQL query with the data stored in the article_data variable.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

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.

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.

Task
test

Swipe to show code editor

  1. Write an SQL query to insert a new record into the articles table. The query should insert values into the title, content, and author columns. Store the query in the variable insert_query.

  2. Use the cursor method to execute the SQL query with the data stored in the article_data variable.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Section 2. Chapter 2
Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
We're sorry to hear that something went wrong. What happened?
some-alt