Python: Database API Specification v2.0

Lab Steps

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

The hands-on lab is part of this learning path

Ready for the real environment experience?

DifficultyIntermediate
Time Limit2h
Students23
Ratings
5/5
starstarstarstarstar

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
About the Author
Students94776
Labs26
Courses44
Learning paths57

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