Python Database Programming for Dummies

Put Python to work in databases--the fun way

An estimated 97% of enterprise-scale applications rely on some kind of database, so knowing how to work with them is a serious career boost. Python Database Programming For Dummies helps you design and create relational databases using both the MariaDB database tool and Python code. You'll learn to open a database and then create, read, update, and delete records with confidence.

This friendly guide covers non-relational databases, too, including key-value, document, wide-column, and graph databases. You'll discover when to use each type and why it matters for your projects. You'll also get the hang of essential maintenance tasks such as using indices, granting permissions, and performing backups to keep everything running smoothly.

Inside:

• Learn the fundamentals of relational database design and build your own databases from scratch using Python
• Discover how to use MariaDB alongside Python code to store, retrieve, and manage your data effectively
• Explore the world of non-relational databases, including key-value, document, wide-column, and graph database types
• Master essential database maintenance tasks such as creating indices, setting permissions, and running reliable backups
• Find out which database type fits your project and make smarter decisions for your applications

Whether you're a Python programmer ready to level up or a student diving into database programming for the first time, this Dummies guide gives you the accessible, step-by-step instruction you need.