← Academy
IP · NCERT

Informatics Practices

Python, Pandas, SQL, networking and data handling for the modern commerce world.

Grade
0/9 done
01

Data Handling using Pandas — Series

Series creation · Attributes · Indexing & slicing · Vector operations

Roadmap Notes + PYQ E · M · H quizzes 3–5 day plan
02

Data Handling using Pandas — DataFrame

DataFrame creation · Indexing · Adding/deleting · Iteration

Roadmap Notes + PYQ E · M · H quizzes 3–5 day plan
03

Data Visualization using Matplotlib

Line chart · Bar chart · Histogram · Customisations

Roadmap Notes + PYQ E · M · H quizzes 3–5 day plan
04

Importing/Exporting Data with CSV

read_csv · to_csv · Handling missing data

Roadmap Notes + PYQ E · M · H quizzes 3–5 day plan
05

SQL — Math, Text, Date Functions

POWER, ROUND, MOD · UPPER, LOWER, SUBSTR · NOW, YEAR, MONTH

Roadmap Notes + PYQ E · M · H quizzes 3–5 day plan
06

SQL — Aggregate Functions & GROUP BY

COUNT, SUM, AVG · GROUP BY · HAVING · ORDER BY

Roadmap Notes + PYQ E · M · H quizzes 3–5 day plan
07

SQL — Joins

Cartesian product · Equi-join · Natural join · Inner join

Roadmap Notes + PYQ E · M · H quizzes 3–5 day plan
08

Computer Networks

Types of networks · Topologies · Devices · Protocols · Web concepts

Roadmap Notes + PYQ E · M · H quizzes 3–5 day plan
09

Societal Impacts

Digital footprint · Net etiquette · IPR · Cyber crime · IT Act 2000

Roadmap Notes + PYQ E · M · H quizzes 3–5 day plan