Skip to content
hands-on lab

Python: Database API Specification v2.0

Difficulty: Intermediate
Duration: Up to 2 hours
Students: 76
Rating: 5/5
Start lab
On average, students complete this lab in40m
Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.
Learn and validateUse validations to check your solutions every step of the way.
See resultsTrack your knowledge and monitor your progress.
About
Author

Description

The Python Database API Specification v2.0 -- documented in PEP 249 -- defines a common API for accessing databases with Python. Making database access with Python more consistent across different database engines.

This lab introduces some of the primary concepts of DB-API compliant database modules.

Expand your development skills by learning Python's database access standard.

Learning Objectives

Explore the DB-API standard through the built-in sqlite3 module.

At the end of this lab you'll be familiar with:

  • Connection objects
  • Cursor objects
  • Query parameters

Intended Audience

  • Python Developers

Prerequisites

  • Familiarity with the Python runtime
  • Familiarity with the Python language syntax
  • Familiarity with callables
  • Familiarity with classes
  • Familiarity with relational databases
  • (Optional)
    • Familiarity with SQL

Updates

April 19th, 2023 - Updated theia to include autosave

Covered topics

Development
Python
Hands-on Lab UUID

Lab steps

Web IDE Review
Introduction to Python Database API Specification v2.0
Getting Started
Rollback
Security Considerations
Summary

Lab Rules