> ## Documentation Index
> Fetch the complete documentation index at: https://notes.kodekloud.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Course Prerequisites

> Prerequisites and setup guidance for a course covering Python, Google ADK, and basic SQL with recommended development environment, tools, and resource links.

Before we start building, make sure you have the following prerequisites installed and a basic development environment configured:

1. Python
2. Google ADK (Agent Development Kit)
3. A bit of SQL

<Callout icon="lightbulb" color="#1CB2FE">
  This lesson assumes you already have the prerequisites installed and a basic Python development setup (virtual environment, editor/IDE). If any of these topics are unfamiliar, pause and review the linked resources before continuing — it will save time later.
</Callout>

Quick checklist

| Resource | Purpose | Recommended / Example |
| -: | - | - |
| Python | Run course code, write functions and async helpers | Python 3.10+; use `pyenv` or system package manager |
| Google ADK | Build and run agentic applications, bind models and tools | Follow the [Google ADK course](https://learn.kodekloud.com/user/courses/google-adk) |
| SQL | Read and understand simple `SELECT` queries produced or consumed by agents | Basic `SELECT` knowledge; no advanced SQL required |

## 1) Python

All course examples and exercises are written in Python. You don't need to be an expert, but you should be comfortable reading and writing Python — including basic async/await patterns used in some agent tool integrations.

Recommended setup:

* Install Python 3.10 or newer.
* Use a virtual environment (`python -m venv .venv`) or `pyenv` to manage versions.
* A lightweight editor (VS Code, PyCharm, or similar) with linting will help.

Example: A simple synchronous function that returns a customer record from an in-memory dictionary.

```python theme={null}
def get_customer(cid):
    # Example dataset
    CUST = {
        1: {"name": "Alice", "logins": 5},
        2: {"name": "Bob", "logins": 1},
    }
    return CUST.get(cid)
```

Tip: Some integration points in the course may call async helpers. Familiarity with `async def` and `await` will be helpful but not strictly required to follow the basics.

## 2) Google ADK (Agent Development Kit)

This course builds on Google ADK concepts. You should already understand:

* What an "agent" is in ADK terms
* How to bind a model to an agent
* How to configure and provide tools to an agent
* How to run and interact with an agent (local or cloud)

If ADK is new to you, take the prerequisite [Google ADK course](https://learn.kodekloud.com/user/courses/google-adk) before continuing — it provides the foundational concepts used throughout this curriculum.

## 3) SQL

Basic SQL literacy is sufficient for this course. You should be able to read simple `SELECT` statements and understand filtering and projection.

Example query (saved as `query.sql`):

```sql theme={null}
SELECT customer_id, logins
FROM customers
WHERE logins < 2;
```

You will often rely on generated queries rather than writing complex SQL by hand, but understanding the basics will help you validate results and debug agent outputs.

## Links and References

* [Python Downloads](https://www.python.org/downloads/)
* [Google ADK course — prerequisite](https://learn.kodekloud.com/user/courses/google-adk)
* [SQL Tutorial — W3Schools](https://www.w3schools.com/sql/)

<CardGroup>
  <Card title="Watch Video" icon="video" cta="Learn more" href="https://learn.kodekloud.com/user/courses/ai-agents-for-data-analytics/module/4e6bc78e-00a8-405d-97ce-830c7892b1b1/lesson/018c5762-c7de-4634-a64b-48fbb43251d6" />
</CardGroup>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.