Python and DB2 App Development: Build a CRUD Application

Db2 是由 IBM 开发的数据管理产品系列，包括数据库服务器。它们最初支持关系模型，但经过扩展以支持对象关系特性和非关系结构，如 JSON 和 XML。

Python 是一种高级的通用编程语言。它的设计理念通过使用显着的缩进来强调代码的可读性。它的语言结构和面向对象的方法旨在帮助程序员为小型和大型项目编写清晰的逻辑代码。

Python 有很多 GUI 框架，但 Tkinter 是唯一内置到 Python 标准库中的框架。Tkinter 有几个优势。它是跨平台的，因此相同的代码适用于 Windows、macOS 和 Linux。视觉元素是使用本地操作系统元素呈现的，因此使用 Tkinter 构建的应用程序看起来像是属于它们运行的​​平台。

为了使 python 应用程序与 DB2 数据库交互，它需要一个名为 ibm_db 的数据库连接器适配器

在您可以运行 SQL 语句来创建、更新、删除或检索数据之前，您必须连接到数据库。您可以使用 ibm_db API 通过编目或未编目的连接来连接到数据库。为了提高性能，您还可以创建持久连接。

在本课程中，我们将使用 Python 和 IBM DB2 数据库从头开始构建一个 CRUD 应用程序。

Published 04/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 23 lectures (2h 5m) | Size: 609.6 MB

Build Database Driven Applications using Python and IBM DB2

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

Requirements
Basic knowledge of Python advised
Basic knowledge of database concepts advised

Description
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.

Who this course is for
Beginners to Python and DB2 Application Development