Build Database Driven Applications using Python and IBM DB2
Db2 is a family of data management products, including database servers, developed by IBM. They initially supported the relational model, but were extended to support object–relational features and non-relational structures like JSON and XML.
What you’ll learn
- Setup Python Development Environment.
- Setup IBM DB2 Database server.
- Connect to DB2 using IBM Data Studio.
- Create a database and table.
- Create Application interface with Python.
- Connect Python to DB2.
- Perform CRUD operations from python app on DB2 database.
Course Content
- Python Setup –> 7 lectures • 23min.
- IBM DB2 Setup –> 6 lectures • 40min.
- Building CRUD App: Part 1 : Building the user interface –> 11 lectures • 1hr 4min.
- Building CRUD App : Part 2: Python and DB2 Interaction –> 11 lectures • 1hr 15min.
Requirements
Db2 is a family of data management products, including database servers, developed by IBM. They initially supported the relational model, but were extended to support object–relational features and non-relational structures like JSON and XML.
Python is a high-level, general-purpose programming language. Its design philosophy emphasizes code readability with the use of significant indentation. Its language constructs and object-oriented approach aim to help programmers write clear, logical code for small- and large-scale projects.
Python has a lot of GUI frameworks, but Tkinter is the only framework that’s built into the Python standard library. Tkinter has several strengths. It’s cross-platform, so the same code works on Windows, macOS, and Linux. Visual elements are rendered using native operating system elements, so applications built with Tkinter look like they belong on the platform where they’re run.
For python application to interact with a DB2 database it requires a database connector adaptor called ibm_db
Before you can run SQL statements to create, update, delete, or retrieve data, you must connect to a database. You can use the ibm_db API to connect to a database through either a cataloged or uncataloged connection. To improve performance, you can also create a persistent connection.
In this course we will a build a CRUD application from scratch using Python and IBM DB2 database.