hands-on lab

Python: Database API Specification v2.0

Intermediate
2h
42
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.
Lab 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

About the author
Avatar
Ben Lambert
Software Engineer
Students
107,513
Labs
37
Courses
48
Learning paths
58

Ben Lambert is a software engineer and was previously the lead author for DevOps and Microsoft Azure training content at Cloud Academy. His courses and learning paths covered Cloud Ecosystem technologies such as DC/OS, configuration management tools, and containers. As a software engineer, Ben’s experience includes building highly available web and mobile apps. When he’s not building software, he’s hiking, camping, or creating video games.

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