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

Ready for the real environment experience?

DifficultyIntermediate
Time Limit2h
Students13
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
Students81688
Labs4
Courses26
Learning paths31

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