Which entry door suits you?
☐ I love SQL puzzles                        → ETL / SQL developer
☐ I like dashboards and business questions  → Analytics route
☐ I enjoy Linux and cloud consoles          → Cloud route
☐ I like building automated workflows       → Junior data engineer
You can target two doors at once; the core skills overlap.

Search these titles when applying
- Data Engineer (Fresher / Associate / Trainee)
- ETL Developer
- SQL Developer
- Analytics Engineer
- Data Analyst (with SQL / Python)
- Big Data Trainee
- Cloud Support Associate
Read each description; titles vary between companies.

-- Rank students by marks within each department (sample schema)
SELECT department, student_name, total_marks,
       RANK() OVER (PARTITION BY department ORDER BY total_marks DESC) AS dept_rank
FROM results
WHERE semester = 5;

import sqlite3, requests

posts = requests.get("https://jsonplaceholder.typicode.com/posts", timeout=10).json()
with sqlite3.connect("practice.db") as con:
    con.execute("CREATE TABLE IF NOT EXISTS posts (id INTEGER PRIMARY KEY, user_id INTEGER, title TEXT)")
    con.executemany("INSERT OR REPLACE INTO posts VALUES (?, ?, ?)",
                    [(p["id"], p["userId"], p["title"]) for p in posts])
    print(con.execute("SELECT user_id, COUNT(*) FROM posts GROUP BY user_id LIMIT 3").fetchall())

Student pipeline project: Air quality tracker
1. Download public air quality data on a schedule (Python)
2. Land raw files in a folder or cloud storage
3. Load into PostgreSQL incrementally
4. Model: fact_readings, dim_station, dim_date
5. Data checks: nulls, duplicates, ranges
6. Dashboard: city trends
7. README with architecture diagram

Short internship message
Hello, I am a [year/branch] student in Noida learning SQL and Python for data roles.
I built [project] that [one-line result] (link).
I would be glad to help with any data, SQL or reporting tasks as an intern.
Could we have a short call?
Thank you, [Name]

Semester plan (adjust to your year)
Semester A: SQL basics → joins, aggregates; Python basics
Semester B: advanced SQL; pandas; Git; first small project
Semester C: data modelling; Linux; one cloud basics; internship search
Semester D: full pipeline project; orchestration basics; interview prep
Every semester: 3-4 hours/week of practice

Skill Tracker (0-3)
SQL                 ___
Python              ___
pandas              ___
Data modelling      ___
Linux               ___
Cloud basics        ___
Git                 ___
Orchestration       ___
Update monthly; focus on the lowest two.

Application Tracker
Company   Role               Route        Applied   Status
_______   ________________   analytics    ____      ______
_______   ________________   ETL/SQL      ____      ______
_______   ________________   cloud        ____      ______