hands-on lab
Python: Database API Specification v2.0
Difficulty: Intermediate
Duration: Up to 2 hours
Students: 57
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