hands-on lab

Python: Database API Specification v2.0

Difficulty: Intermediate
Duration: Up to 2 hours
Students: 56
Rating: 5/5
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.

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

Lab steps

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