Databases with Python (MySQL, SQLite, MongoDB)

This repository follows the Udemy course: Databases with Python: MySQL, SQLite, MongoDB

It contains well-organized, practical notebooks for each section of the course, along with sample databases used throughout.

---

📁 Folder Structure

Databases-with-the-Python/
├── MongoDB/
│   ├── MongoDB with Python.ipynb
│   └── Use MongoDB with Python.ipynb
├── MySQL/
│   └── MySQL with Python.ipynb
├── SQLite/
│   └── SQLite with Python.ipynb
├── data_testing.db                # SQLite test database
├── Databases-with-the-Python.code-workspace

---

🔍 Contents

✅ SQLite

• How to connect SQLite to Python
• Creating tables, inserting data, querying data

✅ MySQL

• Connecting Python to MySQL
• Executing basic SQL queries

✅ MongoDB

• Installing and using pymongo
• Working with documents and collections
• CRUD operations in MongoDB using Python

---

🚀 How to Use

1. Clone the repo:

   git clone https://github.com/YOUR_USERNAME/Databases-with-the-Python.git

2. Open in VS Code or Jupyter Lab.

3. Run each notebook to follow along with the course.

---

📚 Course Reference

Udemy Course Link: Databases with Python

---

🧠 Contributions

Each notebook and file was committed individually to reflect progress through the course. Feel free to fork and enhance it for your own learning path!

---

🛠 Requirements

• Python 3.7+
• Jupyter Notebook
• pymongo, mysql-connector-python, sqlite3

You can install all dependencies via:

pip install -r requirements.txt

Note: MongoDB and MySQL should be installed locally or accessible remotely for the relevant notebooks.