💻 CUET UG 2026
Computer Science
Notes by Thunder
CS/IP – 308 · Complete Chapter-wise Notes · 15 Chapters · Detail + Short PDF
🗄️ Database & SQL
🌐 Networks
🐍 Python
📊 Data Structures
🔒 Security
15
Total Chapters
30
PDF Resources
2026
Exam Ready
Section A – Common for CS & IP
4 CHAPTERS
A
CH 1
CH 1
- Database vs File System
- Relational Data Model: Domain, Tuple, Relation
- Keys: Candidate, Primary, Alternate, Foreign
- Relational Algebra: Selection, Projection
- Union, Set Difference, Cartesian Product
A
CH 2
CH 2
- DDL, DQL, DML · MySQL Intro
- CREATE, DROP, ALTER TABLE
- SELECT, FROM, WHERE · INSERT, UPDATE, DELETE
- Math Functions: POWER(), ROUND(), MOD()
- Text Functions: UCASE, LCASE, MID, LENGTH, TRIM
A
CH 3
CH 3
- Date Functions: NOW(), DATE(), MONTH(), YEAR(), DAY()
- Aggregate: MAX, MIN, AVG, SUM, COUNT
- GROUP BY, HAVING, ORDER BY
- Union, Intersection, Minus, Cartesian Product
- JOIN Operations
A
CH 4
CH 4
- Evolution of Networking
- Network Types: LAN, WAN, MAN
- Devices: Modem, Hub, Switch, Router, Gateway
- Topologies: Mesh, Ring, Bus, Star, Tree
- MAC & IP Address · Internet vs Web
Section B1 – Computer Science
11 CHAPTERS
B1
CH 1
CH 1
- Syntax Errors vs Exceptions
- try-except-else · try-finally Clause
- User-defined & Built-in Exception Classes
- Text & Binary File Handling
- pickle Module · File Access Modes · Offsets
B1
CH 2
CH 2
- LIFO Principle · Stack using Python List
- PUSH and POP Operations
- Prefix, Infix & Postfix Expressions
- Evaluating Postfix using Stack
- Infix to Postfix Conversion
B1
CH 3
CH 3
- FIFO Principle · Queue using Python List
- INSERT (Enqueue) & DELETE (Dequeue)
- Introduction to Deque
- Deque Implementation in Python
B1
CH 4
CH 4
- Sequential (Linear) Search
- Binary Search Algorithm
- Best, Worst & Average Case Analysis
- Python Implementation
- Hashing: Hash Functions & Collision Resolution
B1
CH 5
CH 5
- Bubble Sort
- Selection Sort
- Insertion Sort
- Best, Worst & Average Case Dry Run
- Python Implementation
B1
CH 6
CH 6
- Data, Purpose, Collection & Organization
- Mean, Median, Mode (Central Tendency)
- Range, Standard Deviation, Variance
- Data Interpretation
B1
CH 7
CH 7
- Database vs File System (Revisited)
- Relational Data Model: Domain, Tuple, Relation
- Keys: Candidate, Primary, Alternate, Foreign
- Relational Algebra: Selection, Projection
- Union, Set Difference, Cartesian Product
B1
CH 8
CH 8
- DDL, DQL, DML · Data Types & Constraints
- CREATE, DROP, ALTER · INSERT, UPDATE, DELETE
- Math, Text & Date Functions
- Aggregate: MAX, MIN, AVG, SUM, COUNT
- GROUP BY, HAVING, ORDER BY · JOIN
B1
CH 9
CH 9
- LAN, WAN, MAN · Network Evolution
- Devices: Modem, Hub, Switch, Router, Gateway
- Topologies: Mesh, Ring, Bus, Star, Tree
- MAC & IP Address · Internet vs Web
- Domain Name System (DNS)
B1
CH 10
CH 10
- Types of Data Communication & Switching
- Wired: Twisted Pair, Coaxial, Optical Fibre
- Wireless: Bluetooth, WLAN, Infrared, Microwave
- Protocols: HTTP, FTP, IP, PPP · Email Protocol
- Bandwidth (Hz/KHz/MHz) & Data Rate (bps–Tbps)
B1
CH 11
CH 11
- Threats: Viruses, Worms, Trojan Horse, Spam
- Adware, Cookies, Hackers & Crackers
- Firewall · HTTP vs HTTPS · Antivirus
- Denial of Service · Intrusion Problems
- Snooping & Eavesdropping
.png)
