CBSE Class 12 Informatics Practices Syllabus

Class XII

Unit-wise Syllabus

Informatics Practices

Term-2

Unit-wise Syllabus

Unit 2:

Database Query using SQL

Math functions: POWER (), ROUND (), MOD ().

Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM ().

Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME (). Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*).

● Querying and manipulating data using Group by, Having, Order by.

Unit 3:

Introduction to Computer Networks

Introduction to networks, Types of network: LAN, MAN, WAN.

Network Devices: modem, hub, switch, repeater, router, gateway.

Network Topologies: Star, Bus, Tree, Mesh.

Introduction to Internet, URL, WWW and its applications- Web, email, Chat, VoIP.

Website: Introduction, difference between a website and webpage, static vs dynamic web page, web server and hosting of a website.

Web Browsers: Introduction, commonly used browsers, browser settings, add-ons and plug-ins, cookies.

<