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.