Foundation Db2 and Python
Apress (Verlag)
978-1-4842-6941-1 (ISBN)
Begin by getting your free version of Db2 for Linux and Windows. While the book concentrates more on the Linux version of Db2, it also covers enough of the Windows version so that you're comfortable with obtaining and installing Db2 on your version of Windows. Next, you'll see how to install the sample database that comes with Db2, and take some data from the web to design a database around it, including tables and indexes.
For Db2 to be really useful you need to use strong SQL expressions. This book provides specific examples of how to avoid using poor ones that can cause extra processing time for the query. Lastly, you'll look at each API in the ibm_db and ibm_db_dbi module. This module is not sponsored by IBM and must be installed separately from the Db2 database.
After reading Foundation Db2 and Python you'll be able to install Db2 on Windows or Linux, and perform backups and restore data.
What You'll Learn
Obtain and install Db2 properly on Linux and Windows
Create databases and load them on Db2
Work with ibm_db and ibm_db_dbi API modules for Python
Write SQL for Db2
Review the future of the ibm_db Python module
Who This Book Is For
Python programmers and DB2 administrators interested in building application with Python and DB2
W. David Ashley is a technical writer for SkillSoft where he specializes in open source, particularly Linux. As a member of the Linux Fedora documentation team he recently led the Libvert project documentation, and wrote the Python programs included with it. He has developed in 20 different programming languages during his 30 years as a software developer and IT consultant, including more than 18 years at IBM and 12 years with American Airlines.
Chapter 1: Introduction to Db2 for Linux and Windows.- Chapter 2: Installing Db2 Db2 on Linux and Windows.- Chapter 3: Db2 Management.- Chapter 4: Database Physical Design.- Chapter 5: Db2 Utilities.- Chapter 6: Business Rules and Constraints.- Chapter 7: Writing Good SQL for Db2.- Chapter 8: Python and Db2 - The ibm_db Module.- Chapter 9: ibm_db Module Documentation.- Chapter 10: Where Is The ibm_db Module Going?
| Erscheinungsdatum | 16.08.2021 |
|---|---|
| Zusatzinfo | 11 Illustrations, black and white; XV, 214 p. 11 illus. |
| Verlagsort | Berkley |
| Sprache | englisch |
| Maße | 178 x 254 mm |
| Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
| Mathematik / Informatik ► Informatik ► Netzwerke | |
| Informatik ► Programmiersprachen / -werkzeuge ► Python | |
| Mathematik / Informatik ► Mathematik ► Finanz- / Wirtschaftsmathematik | |
| Schlagworte | Blob • DB2 • IBM_DB • Linux • Python • SQL • Utility Modules • WINDOWS |
| ISBN-10 | 1-4842-6941-1 / 1484269411 |
| ISBN-13 | 978-1-4842-6941-1 / 9781484269411 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
