Topic 4: Databases

⏱️ Estimated time: 3-4 days

We will be using a database to store our application data. For this we need to first understand how databases work and how to interact with them.

---

📚 Learning Path

1. Study SQL basics: Intro to SQL

2. Choose your cloud database:

   Cloud	Database	Tutorial
   AWS	DynamoDB	DynamoDB Tutorial For Beginners
   Azure	Cosmos DB	Cosmos DB Essentials Playlist

3. Complete the Python quickstart for your chosen database:

   • AWS DynamoDB Python Quickstart
   • Azure Cosmos DB Python Quickstart

---

🧪 Test Your Knowledge

Test your knowledge with an AI assistant using these prompts:

1. Can you ask me to explain what a database is and how it works?
2. Can you quiz me on the difference between SQL and NoSQL databases?
3. Can you ask me to explain the concept of CRUD operations in databases?
4. Can you ask me to explain how to connect to a database from a Python application?
5. Can you quiz me on how to perform CRUD operations in a database using Python?
6. Can you ask me to explain how to use an ORM (Object-Relational Mapping) library in Python?
7. Can you ask me to explain how to use a NoSQL database like DynamoDB or Cosmos DB?
8. Can you quiz me on how to model data in a NoSQL database like DynamoDB or Cosmos DB?

---

✅ Topic Checklist

Before moving on, make sure you can answer "yes" to these:

• I understand SQL basics and CRUD operations
• I understand the difference between SQL and NoSQL databases
• I completed the Python quickstart for my chosen cloud database
• I can connect to a database from Python