Introduction to Databases in Python

Explore the fundamentals of working with databases in Python, including connecting to popular database systems and executing basic SQL commands for creating, reading, updating, and deleting data. Understand how to structure tables, insert data, and perform essential queries to manage your data effectively.

We'll cover the following...

Basic SQL syntax
Creating a table
Inserting data
Updating data
Reading data
Deleting data

This chapter is about how we connect to and work with databases in Python. It is a general purpose chapter. We will not learn the complete SQL language in one chapter. Instead, we will give you high level overview of some SQL commands and then we will look at how to connect to some of the most popular databases with Python. Most databases use the basic SQL commands in the same way, but they also have some commands that are specific for that database backend or that just work slightly differently. Be sure to read particular database documentation if we run into issues.

We will start the chapter by learning some very basic SQL syntax.

1.Introduction

2.An Intro to Argument Parsing Using argparse

3.The Collections Module

4.Context Managers

5.The Functools Module

6.All About Imports

7.The importlib Module

8.Iterators and Generators

9.The Itertools Module

10.Regular Expressions

Mini Project

11.The Typing Module

12.Python Built-ins

13.Unicode

14.Benchmarking

15.Encryption and Cryptography

16.Databases

Mini Project

17.The Super Built-in

18.Descriptors

19.Scope

20.Web Scraping

21.Web APIs

22.Working with FTP

23.The urllib Module

24.The doctest Module

25.The unittest Module

26.The mock Module

27.An Intro to coverage.py

28.The asyncio Module

29.The Threading Module

30.The Multiprocessing Module

31.The concurrent.futures Module

Mini Project

32.Wrapping Up

Introduction to Databases in Python

Basic SQL syntax