SQL Tutorials for IIT Gandhinagar — ML & AI Program Database Course

"AI is Good"

SQL tutorials and exercises for the IIT Gandhinagar ML & AI program — from basics to advanced queries.

---

About

This repository contains SQL tutorials, exercises, and reference material prepared by HERE AND NOW AI for the Machine Learning & AI program at IIT Gandhinagar. It covers foundational to advanced SQL concepts needed for data-driven AI workflows.

Topics include database design, SELECT queries, JOINs, aggregations, subqueries, window functions, and SQL patterns commonly used in data science and ML pipelines. All examples are designed to be database-agnostic and work with SQLite, PostgreSQL, and MySQL.

This material is intended as both a classroom reference and a self-study guide for students who need strong database skills alongside their ML/AI coursework.

Features

• Structured SQL curriculum aligned with the IIT Gandhinagar ML & AI program
• Covers: DDL, DML, JOINs, aggregations, subqueries, window functions
• Practical exercises with solutions
• Examples relevant to data science and AI use cases
• Works with SQLite (zero-install), PostgreSQL, and MySQL

Getting Started

Prerequisites

• Any SQL-capable database: SQLite (built into Python), PostgreSQL, or MySQL
• Python 3.8+ (optional, for running SQL via db.py)

Installation

git clone https://github.com/hereandnowai/sql-iit-gn.git
cd sql-iit-gn
pip install -r requirements.txt

Usage

Run the database helper script to set up sample databases:

python db.py

Then open any .sql file or follow the tutorial notebooks in order.

---

Connect with HERE AND NOW AI

🌐 Website	hereandnowai.com
📧 Email	info@hereandnowai.com
📞 Phone	+91 996 296 1000
💼 LinkedIn	linkedin.com/company/hereandnowai
🐦 X / Twitter	x.com/hereandnow_ai
📸 Instagram	instagram.com/hereandnow_ai
▶️ YouTube	youtube.com/@hereandnow_ai
🐙 GitHub	github.com/hereandnowai
📝 Blog	hereandnowai.com/blog

---

HERE AND NOW AI — AI is Good

© 2025 HERE AND NOW AI. All rights reserved.