Databases in Python

Databases in Python

0%

1. Introduction to SQLite

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.

What is SQLite3 Library?

Connecting to Database

Creating a Simple Table

Challenge: First Table

2. CRUD

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.

Creation Operations

Read Operations

Update Operations

Delete Operations

3. More About SQLite

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.

Challenge: Table Design

4. SQLAlchemy

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.

Object–Relational Mapping

Getting Started with SQLAlchemy

Creating Your First Model

Building SQLAlchemy Objects

Reading from DB

Deleting from DB

Course Content

Databases in Python

Databases in Python

Challenge: First Table

Task

Swipe to show code editor

Your task is to complete the code that creates an SQLite database and a table called articles. Here’s what you need to do:

Connect to the database my_database.db.
Create a cursor to execute SQL commands.
Use the cursor to create a table named articles with the following fields:
- id — type INTEGER.
- title — type TEXT.
- content — type TEXT.
- author — type TEXT.
Save the changes and close the database connection.

_{Once you've completed this task, click the button below the code to check your solution.}

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 5

toggle bottom row

Challenge: First Table

Task

Swipe to show code editor

Your task is to complete the code that creates an SQLite database and a table called articles. Here’s what you need to do:

Connect to the database my_database.db.
Create a cursor to execute SQL commands.
Use the cursor to create a table named articles with the following fields:
- id — type INTEGER.
- title — type TEXT.
- content — type TEXT.
- author — type TEXT.
Save the changes and close the database connection.

_{Once you've completed this task, click the button below the code to check your solution.}

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 5

Switch to desktop for real-world practiceContinue from where you are using one of the options below

some-alt