Databases with Python: MySQL, SQLite & MongoDB with Python

Install MySQL locally using the installer and launcher, set up the server with MySQL Workbench and MySQL Shell, and install Python MySQL connector via pip to test import and connection.

Create and modify tables by defining a primary key with auto increment in column id, and alter existing tables to add a primary key for unique record identification.

Learn to insert many records into a students table using the execute mini statement, by passing a list of values and committing changes, then display the inserted records.

Connect to the new data database, create a cursor, and execute a select statement to retrieve data from the students table; fetch the first record with fetchone and print result.

Filter records from the students table by using a select statement with a where clause, execute it with a cursor, fetch results, and print matching records in Python.

Explore wildcard characters in MySQL to filter records with the like operator, using % and _ to match patterns in the name column.

Use the update statement to modify existing records in a table, then commit changes and print the result; protect against SQL injection by using placeholders with execute.

Explore sqlite3 in Python to connect to a sqlite database or create one with no installation. Import the library and execute SQL statements directly in a lightweight setup.

Use the daytime function from the skylight library in Python to obtain the current date and time via a select statement, then execute and fetch one to print the result.

learn to create and manage a sqlite3 database in python by connecting to a data testing database, creating a clients table, inserting records, committing, closing, and fetching results.

Drop the clients table in the data testing database using the drop table statement. Use if exists to avoid errors, then commit and close the connection.

Create a sqlite3 program in Python that drops and recreates a clients table, uses with statement, inserts multiple records, and selects and prints rows where number > 7.

Use the find method to limit and select documents in the new students collection, then apply advanced query modifiers and order results in ascending or descending order.

Apply a query to delete first matching document with delete_one, or delete_many with an empty query to delete all matches in new students collection, and print the deleted count.

Learn how to drop a MongoDB collection, and update documents with update_one and update_many using the set operator, illustrated on the new students collection.