MITS Academy IT Glossary

A simple LLM chat is reactive — you ask, it answers. An agentic system is autonomous — it can plan multiple steps, use tools (calculator, web search, code execution), observe results, and iterate until a goal is achieved.

Examples: an AI customer-support agent that looks up your order, processes a refund, and emails confirmation. An AI research assistant that browses 10 sources and synthesises a report. An AI code-fix bot that reads error logs, edits files, and runs tests.

MITS Academy's GenAI programme covers agentic AI with CrewAI, LangGraph, and production deployment patterns.

AWS launched in 2006 and now generates ~$100B annual revenue. The cloud model means renting computing resources from Amazon's data centres instead of running your own servers.

Key services for developers: EC2 (virtual machines), S3 (object storage), RDS (managed databases), Lambda (run code without managing servers), CloudFront (CDN), Route53 (DNS), IAM (access control), CloudWatch (monitoring).

MITS Academy's Python Full Stack, Java Full Stack, and MERN programmes deploy every project to AWS Free Tier — students graduate knowing how to ship production apps, not just localhost demos.

APIs are the connective tissue of modern software. When you check the weather on your phone, your app calls a weather API. When you pay online, a payment API (Razorpay, Stripe) handles the transaction. Every major platform (Google Maps, WhatsApp Business, Razorpay) exposes APIs.

REST APIs use HTTP verbs: GET (read), POST (create), PUT/PATCH (update), DELETE (remove). Responses return JSON. Authentication uses API keys or OAuth tokens. Tools like Postman let you test APIs.

MITS Academy students build and consume REST APIs in every full-stack programme. This is the core competency for backend and full-stack engineering jobs.

Bjarne Stroustrup created C++ in 1983 as "C with classes". The language sits at the intersection of efficiency (close to hardware) and abstraction (objects, templates, smart pointers).

C++ is the language of choice for game development (Unreal Engine), browsers (Chrome's V8, Firefox), high-frequency trading, embedded systems, and competitive programming. The Standard Template Library (STL) gives you containers, algorithms, and iterators out of the box.

For placement preparation at top product companies (Mohali, Bangalore), C++ is often preferred over Python or Java for DSA practice because of its speed.

Cyber security covers multiple specialisations: offensive (penetration testing, red team, bug bounty), defensive (SOC analyst, incident response, threat hunting), governance (compliance, ISO 27001, audits), and emerging (AI security, cloud security).

Key tools: Kali Linux, Burp Suite, Nmap, Metasploit, Wazuh, Splunk, Nessus. Key certifications: CEH, CompTIA Security+, OSCP, CISSP.

MITS Academy's 6-month programme covers offensive + defensive sides with HackTheBox + TryHackMe access, CEH v12 prep, and AI security (prompt injection, OWASP LLM Top 10). Many alumni work remote SOC analyst roles for Bangalore MSSPs at ₹4-6 LPA fresher.

DSA is universally tested in software interviews because it reveals whether a candidate can think through complexity (Big-O), edge cases, and trade-offs. Product companies (Mohali startups, Bangalore SaaS) test it heavily; service companies (TCS, Infosys) test simpler variations.

Core data structures: arrays, linked lists, stacks, queues, hash maps, trees, graphs, heaps. Core algorithms: binary search, sorting, recursion, dynamic programming, greedy, two-pointer, sliding window.

MITS Academy's placement track dedicates 4-6 weeks to DSA practice in C++/Java/Python, mapped to TCS NQT, Infosys IIT, Cognizant GenC, Mohali product startup interview patterns.

Django's philosophy is "the framework for perfectionists with deadlines". You get a working CRUD app in hours, not days, because the framework provides ORM (database models → SQL), admin panel (auto-generated CMS), forms, authentication, and security middleware.

Django uses the Model-View-Template pattern. The django-rest-framework extension adds REST APIs in minutes.

MITS Academy's Python Full Stack programme uses Django alongside FastAPI — Django for full-featured CMS / admin work, FastAPI for high-performance APIs. Target placement: Mohali product startups at ₹6-12 LPA fresher.

Deep learning took off around 2012 when convolutional neural networks (CNNs) drastically improved image recognition accuracy. Today, transformers (the architecture behind GPT, BERT, Claude) dominate language tasks, while diffusion models lead image and video generation.

The two main frameworks are PyTorch (research + production, by Meta) and TensorFlow (production-first, by Google). Most academic and startup work in 2026 uses PyTorch.

MITS Academy's AI/ML programme covers PyTorch with hands-on training of image classifiers, NLP models, and fine-tuned LLMs.

Data Science sits at the intersection of three things: statistics (what does this data mean), programming (how do I work with it), and business knowledge (what should we do about it).

A typical data science workflow: collect data → clean it → exploratory analysis → feature engineering → model building → evaluation → deployment → monitoring. Languages and tools: Python, R, SQL, pandas, scikit-learn, PyTorch, Tableau, Power BI.

MITS Academy's Data Science programme covers all of this plus modern data stack (dbt, Snowflake, BigQuery) and AI integration. Many alumni work remote from Punjab for Bangalore SaaS companies at ₹6-12 LPA fresher.

Data Analytics is the most remote-friendly IT role in 2026. The skills (SQL, Excel, Tableau, Python) are async-friendly. Mohali / Bangalore SaaS companies actively hire from Punjab.

Core skills: SQL (deep), Pandas, statistics fundamentals (means, percentiles, A/B testing), dashboarding (Tableau, Looker, Power BI), and storytelling with data. Modern stack: dbt + Snowflake + Looker.

MITS Academy's Data Analytics programme places alumni at Bangalore D2C unicorns at ₹6-12 LPA fresher, working remote from Punjab.

Before Docker, "works on my machine" was a real problem — apps would run differently on dev laptops vs servers due to OS / library mismatches. Docker solves this by bundling the app + its OS dependencies into an image that runs in an isolated container.

A Dockerfile defines the image build. Docker Compose orchestrates multi-container apps (e.g. web + database). Kubernetes orchestrates Docker containers across many servers.

MITS Academy's full-stack programmes cover Docker basics (writing Dockerfiles, running containers) and Docker Compose for local development.

Traditional IT separated developers (who write code) from operations (who deploy and maintain). DevOps merges them: developers care about deployment, operations cares about code quality, both use automation.

Core practices: CI/CD pipelines (GitHub Actions, GitLab CI, Jenkins), infrastructure as code (Terraform, CloudFormation), monitoring (Datadog, Prometheus + Grafana), and incident response (PagerDuty).

MITS Academy covers DevOps fundamentals in full-stack programmes (Git workflows, GitHub Actions, AWS deployment) but offers it as a separate specialisation track for students wanting dedicated DevOps roles.

Digital Marketing has multiple specialisations: SEO, paid search, paid social, email, content, influencer, affiliate, video / YouTube, and analytics. A full-stack digital marketer knows all of them at intermediate level.

Key skills: keyword research, ad copywriting, landing page optimisation, conversion tracking, A/B testing, dashboard reporting, and AI tool fluency (ChatGPT, Canva Magic, AdCreative.ai, Custom GPTs).

MITS Academy's 6-month Digital Marketing programme covers all channels with real campaigns, freelance launchpad, and AI tools integration. Outcomes: ₹3-7 LPA fresher + freelance income.

DSA interviews are used by Google, Amazon, Microsoft, Flipkart, and Paytm to screen engineers for problem-solving ability independent of any language or framework. You learn to analyse time/space complexity using Big-O notation.

Key data structures: arrays, linked lists, stacks, queues, hash maps, trees (BST, heap, trie), graphs. Key algorithm patterns: two pointers, sliding window, binary search, recursion, backtracking, dynamic programming, greedy, BFS/DFS.

For Punjab students targeting Mohali product companies or FAANG off-campus, 3-4 months of dedicated DSA practice on LeetCode is required. MITS Academy covers DSA fundamentals in all programming courses.

Released in 2010 by TJ Holowaychuk, Express became the default Node.js framework because it gets out of your way. You define routes (app.get, app.post), add middleware (auth, logging, error handling), and ship.

Express is the foundation for many other Node frameworks (NestJS uses Express under the hood). It powers backend APIs at countless startups, freelance projects, and enterprise products.

MITS Academy MERN students build production-grade Express APIs with JWT auth, rate limiting, validation, and AWS deployment.

Embeddings convert qualitative data (e.g. the sentence "MITS Academy teaches Python") into a numerical vector (e.g. 1536 floating-point numbers). Vectors close to each other in this high-dimensional space represent similar meaning.

Popular embedding models: OpenAI text-embedding-3, BGE, Voyage, Cohere. For images, CLIP. For code, OpenAI code-embedding.

Vector databases (Pinecone, Chroma, Weaviate, Qdrant) store and search billions of embeddings efficiently. This is the foundation of RAG systems.

Ethical hacking follows a methodology: reconnaissance (gathering info), scanning (finding open ports / services), enumeration (identifying users / shares), exploitation (gaining access), post-exploitation (maintaining access, privilege escalation), and reporting (documenting findings).

Legal frameworks matter — ethical hackers operate under explicit written authorisation. Bug bounty programmes (HackerOne, BugCrowd) let you legally find bugs in major company products and earn rewards.

MITS Academy's Cyber Security programme covers ethical hacking with hands-on HackTheBox + TryHackMe practice on safe targets.

For Indian students, 0% EMI on course fees removes the upfront affordability barrier. The institute pays a small "merchant fee" to the financing partner (typically Razorpay or Bajaj Finserv); the student pays the fee amount over months.

MITS Academy offers 0% EMI on all course fees above ₹20,000, supporting most students who want to learn but cannot pay lump sum.

Eligibility typically requires: age 21+, valid PAN card, basic income proof, and minimum credit score.

The distinction between ethical and unethical hacking is authorisation. Ethical hackers have a signed scope-of-work document allowing them to attack specific systems during a defined window. They follow a structured methodology (PTES, OWASP Testing Guide) and produce a detailed report.

Career paths: penetration tester, security analyst, bug bounty hunter, red team operator, security consultant. Entry-level roles in India start at ₹4-8 LPA; senior pen testers at top consulting firms earn ₹20-40 LPA.

MITS Academy's Cyber Security programme covers ethical hacking tools, web application security (OWASP Top 10), network attacks, and certificate exam preparation.

FastAPI delivers two big wins over Django REST Framework: it's async-native (handles thousands of concurrent connections efficiently) and it auto-generates Swagger/OpenAPI docs from your function signatures.

It uses Python type hints + Pydantic for request/response validation. The result: minimal boilerplate, excellent IDE support, and Node.js-comparable performance.

MITS Academy teaches FastAPI alongside Django so students can choose the right tool: Django for monolithic full-featured apps, FastAPI for microservices and high-performance APIs.

Figma's breakthrough was making design collaborative — multiple designers and stakeholders can edit a file simultaneously, like Google Docs for design. Auto-layout, components, and variants make design systems easy to build and maintain.

Key features: auto-layout (responsive components), variants (component states), prototyping (clickable flows), inspect mode (developer specs), Figma Slides (presentation mode), Figma Sites (web building).

MITS Academy's Graphic Design programme covers Figma alongside Adobe Creative Cloud, with a bridge module to UI/UX for students wanting product design careers.

Firewalls work at different layers: packet-filtering firewalls inspect IP/TCP headers; stateful inspection firewalls track connection state; next-generation firewalls (NGFW) include deep packet inspection, intrusion prevention (IPS), and application awareness.

Types: network firewalls (perimeter protection), host-based firewalls (on individual computers — e.g. Windows Defender Firewall), WAFs (Web Application Firewalls — filter HTTP traffic for SQLi, XSS, etc.).

For Cyber Security students, understanding firewall rule creation, zone-based security policies, and WAF configuration is foundational to both defensive security roles and pen testing (bypassing firewalls is a pen testing skill).

GenAI exploded into public awareness with ChatGPT in late 2022, but the underlying transformer architecture had been around since 2017. The leap was scaling: more data + more parameters + better training techniques = qualitatively new capabilities.

GenAI categories: text (GPT-4, Claude, Gemini), image (DALL-E, Midjourney, Stable Diffusion), audio (ElevenLabs, Suno), video (Runway, Sora), code (Copilot, Cursor).

For Punjab businesses (hosiery exporters, sports goods, restaurants), GenAI is the highest-ROI new tool — used for ad creative, content writing, customer service, and product photography. MITS Academy's AI Marketing programme teaches this end-to-end.

Google Ads (formerly AdWords) launched in 2000. It works on an auction model — advertisers bid on keywords, Google ranks them by bid × Quality Score. Higher Quality Score (relevance + landing page experience) wins lower costs.

Campaign types: Search, Display, Video, Shopping, Performance Max, Demand Gen, App. Each suits different goals.

MITS Academy's Digital Marketing programme runs real ad campaigns with real budgets (₹3,000-8,000/student) during the course. Many students freelance Google Ads management for Jalandhar SMBs at ₹10-50k/client/month.

Git lets every developer maintain a full copy of the codebase history locally. Commits create checkpoints; branches let work proceed in parallel; merges and rebases combine changes.

Core commands: git clone, git add, git commit, git push, git pull, git branch, git merge, git rebase, git stash. Understanding merge vs rebase, resolving conflicts, and writing good commit messages separates juniors from seniors.

No IT job in 2026 exists without Git. MITS Academy introduces Git in week 1 of all programming programmes — students use GitHub for their portfolio projects.

Traditional ML models are discriminative — they classify inputs (spam/not-spam, cat/dog). Generative models learn the underlying distribution of training data and can sample from it to produce new examples.

Key architectures: Transformers (GPT series), Diffusion Models (Stable Diffusion, DALL-E 3, Sora), GANs (older image generation), VAEs. Most modern generative AI uses Transformers.

For MITS Academy students, generative AI is a professional multiplier: developers use GitHub Copilot to write code faster; marketers use AI to create ad copy and images; designers use Midjourney for ideation. The skill gap between AI-fluent and non-fluent workers is widening rapidly.

ISO 9001:2015 certification is granted after an independent third-party audit verifies the organisation follows documented quality processes. Annual surveillance audits maintain certification.

For IT training institutes in Punjab, this matters because it differentiates serious operators from fly-by-night centres. Students and parents can verify the certificate before paying fees.

MITS Academy is one of fewer than 10 IT training institutes in Punjab with ISO 9001:2015 certification (plus MSME registration + Startup India recognition).

Under Punjab Technical University (PTU / IKG-PTU) and Punjab University (PU) norms, 6-week industrial training is compulsory for B.Tech students and counts toward degree credits. The training must be from an ISO-certified or NASSCOM-recognised institute to be accepted by the university.

For students, good industrial training means: learning an industry-relevant tech stack (React, Python, Java Full Stack), working on a live project for the portfolio, getting a certificate that can be shown to recruiters, and potentially converting to a job offer.

MITS Academy offers 3 tiers: 6-week (post-semester), 45-day (summer project focus), and 6-month (pre-final year deep-dive). All programmes are ISO-certified and accepted by PTU/IKG-PTU/PU.

Released by Sun Microsystems in 1995 (now Oracle), Java's "write once, run anywhere" promise made it the dominant enterprise language. Java code compiles to bytecode that runs on the Java Virtual Machine (JVM), which exists on essentially every server and Android phone.

The Spring Boot framework dominates modern Java backends. Microservices, REST APIs, batch processing — most India-listed companies' core systems are Java + Spring Boot.

Java Full Stack (Java + React + AWS) is the safest IT career path for fresh graduates because TCS, Infosys, Wipro, Cognizant, Capgemini all hire thousands of Java engineers per year at predictable salary bands.

Created in 10 days by Brendan Eich in 1995, JavaScript was originally a small browser scripting language. Today it is the dominant front-end language, and via Node.js, also a major server-side language.

Key concepts: it is dynamically typed, single-threaded with async I/O, uses prototype-based OOP, and runs in event loops. Modern JavaScript (ES6+) added classes, modules, arrow functions, destructuring, and async/await.

For Punjab developers, JavaScript via the MERN stack (React + Node) is the fastest path to Mohali product startup jobs at ₹6-12 LPA fresher.

LLMs use the transformer architecture (introduced in the 2017 "Attention Is All You Need" paper). They are trained on trillions of tokens of internet text, then fine-tuned with RLHF (Reinforcement Learning from Human Feedback) to follow instructions.

Key concepts: tokens (sub-word pieces), context window (how much text the model can attend to), embeddings (vector representations), and prompt engineering (writing inputs that get good outputs).

MITS Academy's GenAI / Prompt Engineering programme covers ChatGPT, Claude, Gemini, Custom GPTs, RAG pipelines, fine-tuning with LoRA, and agentic AI. Target placement: AI engineer at ₹6-15 LPA Mohali / Bangalore product companies.

LLMs are trained using self-supervised learning on billions of web pages, books, and code. They learn to predict the next token in a sequence, which produces emergent abilities like reasoning, translation, summarisation, and code generation.

In 2026, LLMs are integrated into: code editors (GitHub Copilot), search engines (Google AI Overview, Bing Copilot), office tools (Microsoft 365 Copilot, Google Gemini), customer support (chatbots), and content creation (Jasper, Copy.ai).

For IT students in Punjab, understanding how LLMs work and how to integrate OpenAI / Gemini APIs into applications is a skill that commands a 20-30% salary premium over peers who only know traditional programming.

Salary bands in Indian IT (2026 estimates):

Service companies (TCS, Infosys, Wipro, Cognizant — campus hiring): ₹3.5-7 LPA fresher. Product companies Mohali (Paytm, Nagarro, Tek Experts, fintech startups): ₹6-14 LPA fresher. Bangalore/Hyderabad SaaS (remote or relocation): ₹8-25 LPA for strong React/Python/Go developers. Freelance (Punjab-based): ₹20-60k/month for web dev, digital marketing, graphic design.

MITS Academy graduates have achieved up to ₹14 LPA at Mohali product companies. The highest earners typically specialise in MERN, Data Science, or DevOps and have strong GitHub portfolios.

MERN became popular around 2017 as an alternative to MEAN (which used Angular instead of React). The appeal: one language (JavaScript/TypeScript) across the stack, fast development, large community.

A typical MERN architecture: React frontend → Express REST API → MongoDB document store. Deployment is usually Vercel (frontend) + AWS/Render/Railway (backend) + MongoDB Atlas (database).

For Punjab developers, MERN is the fastest path to Mohali product startup jobs. MITS Academy's 6-month MERN programme covers React 18 + TypeScript + Node + Express + MongoDB + AWS deployment + GitHub Copilot.

Traditional SQL databases (MySQL, PostgreSQL) require you to design tables and columns upfront. MongoDB lets you store any document shape and change it over time without migrations.

Key concepts: collections (like tables), documents (like rows, but nested), embedded documents (no joins needed), and BSON (binary JSON). MongoDB Atlas is the managed cloud version most startups use.

For Punjab MERN developers, MongoDB is essential. MITS Academy teaches it with proper schema design patterns (because "schemaless" still benefits from intentional design).

ML breaks down into three main types: supervised learning (learning from labelled data — e.g. spam detection), unsupervised learning (finding patterns in unlabelled data — e.g. customer segmentation), and reinforcement learning (learning by trial and error — e.g. game-playing AI).

Core algorithms: linear regression, logistic regression, decision trees, random forests, gradient boosting (XGBoost), support vector machines, and neural networks (deep learning).

MITS Academy's AI/ML programme covers all of these with Python, scikit-learn, PyTorch, and real deployed projects. Target placement: ₹6-15 LPA at Mohali / Bangalore product companies.

Relational databases (MySQL, PostgreSQL) store data in rigid tables. MongoDB stores data as BSON documents (binary JSON) in collections — no fixed schema, easy to nest complex objects, easy to scale horizontally.

Key concepts: collections (like tables), documents (like rows), BSON fields, indexes, aggregation pipeline, replica sets, sharding. The Mongoose ODM adds schema validation on top of MongoDB for Node.js.

MongoDB is best for: user-generated content (reviews, comments), product catalogues with variable attributes, real-time analytics, and any use case where schema evolves frequently. MITS Academy covers MongoDB as the database layer in the MERN stack programme.

Before Node.js, JavaScript only ran in browsers. Node.js gave it server-side superpowers — file I/O, HTTP servers, database connections, all event-driven and asynchronous.

The most popular Node.js framework is Express — minimal, unopinionated, used in millions of projects. For larger apps, NestJS (TypeScript-first, Angular-inspired) is growing fast. The Node ecosystem (npm) has over 2 million packages.

Node.js is the "N" in the MERN stack (MongoDB + Express + React + Node). For Punjab students learning MERN at MITS Academy, Node.js mastery is essential for backend roles at ₹6-10 LPA fresher.

Plain React renders entirely in the browser, which is bad for SEO (Google sees blank HTML initially). Next.js solves this by rendering pages on the server first, then "hydrating" them on the client.

Key features: file-based routing (pages/about.tsx → /about), API routes (pages/api/foo.ts → backend endpoint), Image optimisation, ISR (incremental static regeneration), App Router (with React Server Components).

MITS Academy's MERN programme covers Next.js 14/15 because most Mohali product startup hiring now expects it.

Before Node.js (2009), JavaScript only ran in browsers. Ryan Dahl's insight was to take V8 (Google's fast JS engine) and pair it with asynchronous I/O — making Node ideal for handling thousands of simultaneous connections with minimal CPU overhead.

Key tools: npm (package manager), Express.js (minimal HTTP framework), Fastify (high-performance framework), NestJS (enterprise-grade, TypeScript-first), Prisma/Drizzle (ORM). Most production systems pair Node with React on the front end and PostgreSQL/MongoDB on the database.

For Punjab students, Node.js is essential because it lets one language (JavaScript/TypeScript) cover both front-end and back-end — shorter learning curve and more versatile job profiles.

Plain React apps are single-page applications — the browser downloads JavaScript and renders everything client-side. This hurts SEO (Googlebot may not execute JS) and initial load performance. Next.js solves both by pre-rendering pages on the server.

Key features: App Router (React Server Components), Static Site Generation (pre-rendered at build time), Server-Side Rendering (rendered per request), API Routes (serverless functions), Image Optimization, Middleware.

In 2026, most new React projects start with Next.js rather than plain Create React App. MITS Academy's MERN programme covers Next.js fundamentals in the advanced module.

OOP emerged in the 1960s with Simula and became mainstream in the 1990s with Java and C++. The core idea: model real-world entities (a User, an Order, a Course) as objects with state (fields) and behaviour (methods).

The four classical pillars: encapsulation (hide internal state, expose interface), inheritance (child classes extend parents), polymorphism (same method, different implementations), abstraction (work with concepts, not details).

Most MITS Academy courses cover OOP in the first 4 weeks because TCS NQT, Infosys IIT, Cognizant GenC interviews all include OOP questions.

Created by Guido van Rossum in 1991, Python emphasises readability — code looks close to plain English, which makes it the most beginner-friendly mainstream language. The language is interpreted (no compilation step) and dynamically typed.

Python powers ChatGPT, Instagram, Spotify, YouTube, Dropbox, and most Indian fintech backends. The standard library is enormous, and the third-party ecosystem (PyPI) has over 500,000 packages including PyTorch, TensorFlow, Django, FastAPI, Pandas, NumPy, Requests.

For Punjab students starting an IT career, Python is the cleanest first step — the same skill transfers to data science, AI engineering, backend web development, or DevOps automation.

A prompt is the text you send to an LLM. A good prompt makes the difference between a generic, vague answer and a precise, useful one.

Core techniques: zero-shot (just ask), few-shot (provide examples), chain-of-thought (ask the model to reason step by step), role assignment ("You are an expert..."), structured output (force JSON), ReAct (reasoning + acting with tools).

MITS Academy's GenAI / Prompt Engineering programme has a dedicated track for non-CS backgrounds (BBA, English Lit, BA) that targets AI Content Strategist and Prompt Engineer roles at ₹3-8 LPA fresher.

PyTorch became popular for its Pythonic API and dynamic computation graphs — you can debug it like regular Python code. Meta open-sourced it in 2016, and by 2020 it overtook TensorFlow in academic publications.

Key concepts: tensors (multi-dimensional arrays with GPU support), autograd (automatic differentiation), nn.Module (model class), DataLoader (batched data pipeline), and Hugging Face Transformers integration.

MITS Academy's AI/ML programme uses PyTorch for image classification, NLP, and LLM fine-tuning projects.

PostgreSQL has all standard SQL features plus advanced ones: JSON columns, full-text search, geospatial extensions (PostGIS), and the pgvector extension for AI/embedding workloads.

It is ACID-compliant (Atomicity, Consistency, Isolation, Durability), making it reliable for financial systems. Managed versions (AWS RDS, Google Cloud SQL, Supabase, Neon) make it easy to deploy.

MITS Academy uses PostgreSQL in Python Full Stack, Java Full Stack, and MERN courses (where MongoDB is the primary but Postgres is taught as the alternative).

Pandas was created in 2008 by Wes McKinney. Its DataFrame structure (inspired by R's data.frame) makes Excel-like operations easy in Python: filtering rows, grouping by columns, merging tables, computing statistics.

Core operations: read_csv / read_parquet (input), describe (stats), value_counts (counts), groupby + agg (aggregation), merge (joins), pivot_table, plot (visualisation).

MITS Academy's Python and Data Analytics courses cover Pandas from basics to advanced operations like multi-indexed dataframes and time-series resampling.

A pen test engagement has clear phases: scoping (what to test), reconnaissance, vulnerability identification, exploitation, post-exploitation, and reporting. Common test types: external (internet-facing), internal (corporate network), web application, mobile, wireless, social engineering.

Pen testers use tools like Nmap, Burp Suite, Metasploit, BloodHound, Mimikatz, plus custom scripts. Reports include CVSS scores (severity ratings) and remediation guidance.

MITS Academy's programme covers web application pen testing (OWASP Top 10) and network pen testing with real CTF practice.

Genuine placement support includes: resume / LinkedIn coaching, mock interviews, employer relationships (50+ partner companies in MITS's case), salary negotiation, and onboarding help.

For Punjab students, the strongest placement outcomes go to MITS alumni working remotely from Punjab for Bangalore SaaS companies (₹6-15 LPA), Mohali product startups (₹6-12 LPA), and large service companies (₹3-7 LPA).

MITS Academy has placed 800+ students since 2015 across 28+ courses. Specific names + LinkedIn profiles are available on request.

As AI tools become workplace staples, the ability to direct them precisely has become a valued skill. Poor prompts produce generic, hallucination-prone outputs. Well-engineered prompts produce accurate, structured, task-specific results.

Core techniques: zero-shot (direct instruction), few-shot (include examples), chain-of-thought (ask the model to reason step-by-step), role assignment ("You are a senior SQL developer…"), output formatting (ask for JSON, bullet lists, tables).

In 2026, prompt engineering is taught as a practical module in MITS Academy's AI tools, Digital Marketing, and Data Science programmes — because every professional role now interacts with AI tools daily.

Power BI Desktop is free; Power BI Service (cloud sharing) needs a Microsoft 365 license. The tool's strength is its deep integration with Excel, Azure SQL, Dynamics 365, and SharePoint — making it the default BI tool at most Indian MNCs and government-sector companies.

Key concepts: data model (star schema), relationships, DAX measures (calculated columns and measures), Power Query (M language for data transformation), report vs dashboard, and row-level security (RLS).

For Punjab students targeting analyst roles at MNCs (Infosys BPM, WNS, EXL, Genpact, Concentrix), Power BI is more important than Tableau. MITS Academy covers Power BI in the Data Science and Business Analytics programmes.

Created by Wes McKinney in 2008 at AQR Capital, Pandas is the workhorse of Python data analysis. A DataFrame holds rows and columns with labelled axes; a Series is a single column.

Key operations: reading data (CSV, Excel, SQL, JSON), filtering, sorting, groupby/aggregation, merge/join, pivot tables, handling missing values, datetime operations, and apply/map for custom transformations.

Pandas is used in every stage of data science work: exploratory data analysis (EDA), feature engineering, result formatting. MITS Academy covers Pandas in the first 3 weeks of the Data Science programme.

Pen testing phases: reconnaissance (passive & active info gathering), scanning (port/service enumeration), exploitation (attempting to exploit vulnerabilities), post-exploitation (privilege escalation, lateral movement), and reporting (findings + remediation recommendations).

Key tools: Kali Linux (pen test OS), Metasploit (exploitation framework), Nmap (network scanning), Burp Suite (web app testing), Wireshark (traffic analysis), and OWASP ZAP (automated web scanning).

For Punjab students, CEH (Certified Ethical Hacker) and OSCP are the most valuable certifications. MITS Academy's Cyber Security programme covers pen testing fundamentals, web app security, and network security.

React introduced two ideas that changed front-end development: components (reusable UI pieces with their own state) and the virtual DOM (an in-memory representation of the UI that React diffs to compute the minimum DOM changes).

Modern React (2024+) uses functional components with hooks (useState, useEffect, useContext, useMemo) instead of class components. Most React apps today are built with TypeScript and a meta-framework like Next.js.

For Punjab developers, React is the gateway to Mohali product startup roles at ₹6-12 LPA fresher. MITS Academy teaches React 18 + TypeScript across all front-end programmes.

Plain LLMs have two limitations: they hallucinate (make up facts) and their knowledge cuts off at training time. RAG solves both — you index your private documents in a vector database (Pinecone, Chroma, Weaviate), search by semantic similarity at query time, and pass the top results to the LLM.

A typical RAG pipeline: chunk documents → generate embeddings → store in vector DB → user query → retrieve top-K chunks → construct prompt → LLM generates grounded answer.

MITS Academy's GenAI programme covers production RAG with LangChain, LlamaIndex, and AWS deployment. RAG engineering is one of the highest-demand AI skills in 2026.

React introduced the component model — UI as a function of state. You write components (small, reusable UI pieces) that React efficiently re-renders when data changes, via a virtual DOM diffing algorithm.

Key concepts: JSX (HTML-in-JavaScript syntax), props (inputs to components), state (internal data), hooks (useState, useEffect, useContext), context API, and the React Router for SPA navigation. In 2026 React Server Components and Next.js dominate production React.

React + Node.js (the MERN stack) is the most in-demand web development skill set for Mohali product startup hiring in 2026. MITS Academy's MERN programme is the most popular course across both centres.

Post-COVID, Indian product companies — especially in Mohali, Bangalore, Hyderabad — normalised remote-first or hybrid work. A developer in Amritsar can earn a Bangalore-equivalent salary while spending significantly less on rent and lifestyle.

Key skills for remote work success: strong async communication (written English), self-management, video call etiquette, time-tracking tools (Toggl, Jira), and Git-based collaboration workflows.

MITS Academy specifically coaches remote work readiness — LinkedIn optimisation for inbound job opportunities, async communication templates, and portfolio websites that let students showcase work to out-of-city employers.

SQL has 4 main commands: SELECT (read), INSERT (create), UPDATE (modify), DELETE (remove). Real-world SQL adds JOINs (combining tables), aggregations (GROUP BY, COUNT, SUM), subqueries, window functions (ROW_NUMBER, LAG, LEAD), and CTEs (Common Table Expressions).

Dialects: PostgreSQL, MySQL, SQL Server, Oracle, SQLite, BigQuery, Snowflake. They share 80% of syntax with dialect-specific extensions.

MITS Academy's Data Analytics programme covers SQL deeply, including query optimisation, indexing, and modern warehouses (Snowflake, BigQuery).

SEO has three pillars: on-page (content quality, keywords, meta tags, internal linking), technical (site speed, mobile-friendly, structured data, sitemaps), and off-page (backlinks, brand mentions, reviews).

In 2026, AI Overview (Google's AI-summary search results) has changed SEO — you optimise for being cited in AI answers, not just blue-link rankings.

MITS Academy's Digital Marketing programme covers all three SEO pillars plus AI Overview optimisation. Many alumni run SEO freelance practices for Jalandhar / Amritsar businesses at ₹20-50k/month retainers.

SQL was developed at IBM in the 1970s and became ANSI/ISO standard. The language has four categories: DDL (CREATE, ALTER, DROP tables), DML (SELECT, INSERT, UPDATE, DELETE rows), DCL (GRANT, REVOKE permissions), TCL (COMMIT, ROLLBACK transactions).

Key concepts: joins (INNER, LEFT, RIGHT, FULL), subqueries, aggregations (GROUP BY, HAVING), indexes for performance, normalisation (1NF/2NF/3NF) for data integrity, and transactions for consistency.

SQL is tested in virtually every IT interview and is non-negotiable for backend engineers, data analysts, and database administrators. MITS Academy covers SQL in all programming and data science programmes.

TypeScript was released by Microsoft in 2012 to solve JavaScript's "everything is any type" problem. You write code with explicit types (string, number, custom interfaces), and the TypeScript compiler catches type errors before runtime.

TypeScript compiles down to plain JavaScript, so it runs anywhere JS runs — browsers, Node.js, React Native. The IDE experience is dramatically better than plain JS because autocompletion and refactoring work reliably.

MITS Academy teaches TypeScript-first React in all front-end programmes because that's what Mohali / Bangalore product startups expect.

Before transformers, sequential AI used RNNs and LSTMs which processed words one at a time. The 2017 paper "Attention Is All You Need" introduced transformers that look at all words simultaneously through self-attention.

This parallel processing made it feasible to scale models to billions of parameters, which unlocked emergent capabilities (reasoning, instruction following, code generation) that smaller models couldn't do.

For advanced students, MITS Academy's AI/ML programme covers transformer fundamentals, fine-tuning techniques (LoRA, QLoRA), and production deployment.

Founded in 2003 (acquired by Salesforce in 2019), Tableau popularised "self-service BI" — letting business users build their own dashboards. It connects to databases, spreadsheets, and APIs, then offers a powerful visual editor.

Key features: drag-drop dashboard builder, calculated fields, parameters, level-of-detail expressions, and Tableau Server / Cloud for sharing.

MITS Academy's Data Analytics programme covers Tableau alongside Looker and Power BI so students can pick the right tool for their hiring market.

Tableau's drag-and-drop interface makes it accessible without SQL or programming knowledge — though SQL knowledge dramatically improves Tableau outputs. Tableau Desktop creates visualisations; Tableau Server/Cloud shares them.

Key features: calculated fields, LOD (Level of Detail) expressions, parameters, sets, dual-axis charts, mapping, and story points. Tableau Prep handles ETL (extract, transform, load) pipelines.

For Punjab students, Tableau is more common at product companies and startups while Power BI dominates MNCs. Both tools are taught in MITS Academy's Data Science programme.

UX Design includes research (interviews, usability testing), information architecture, wireframing, and prototyping. UI Design includes visual hierarchy, typography, colour theory, component systems, and high-fidelity mockups.

Key tools in 2026: Figma (dominant), Sketch (declining), Adobe XD (declining), Adobe Illustrator (vector graphics), and increasingly AI tools (Adobe Firefly, Midjourney for ideation).

MITS Academy's Graphic Design programme covers UI/UX as a bridge module — students can pivot from graphic design to product design at Mohali product startups.

Traditional databases (PostgreSQL, MongoDB) are designed for exact-match queries. Vector databases use specialised indexes (HNSW, IVF, ScaNN) for approximate nearest neighbour search across millions of high-dimensional vectors in milliseconds.

In 2026, hybrid databases (Postgres with pgvector, Elasticsearch with vector search) are popular for combining keyword + semantic search.

MITS Academy's GenAI programme covers Pinecone, Chroma, and pgvector with hands-on RAG pipelines.