Page 24 - COPA Vol I of II - TP - Telugu

primary key and foreign key. (2 Hrs) • Adding Indices.
96. Adding indices to Tables. (1 Hr) Queries (4 Hrs)
Demonstrate on (15 Hrs) • Concepts of Transactions
97. Simple select queries. (5 Hrs) • ACID Property of Transaction
98. Insert and delete queries Constraints.
Update queries. (10 Hrs) Joins and Functions (5 Hrs)
Demonstrate on (23 Hrs) • Joining of tables
99. Using the Number, Date and • Sub Queries “ Functions
Character functions. Joins used in query like sum, average,
and Functions (11.5 Hrs) max, min, count etc.
100. Joins, Group by, Having,
Sub query. (11.5 Hrs)

Professional Install, setup/ configure, Computer Network (68 Hrs.) Set-up Communicating in a Connected
Skill - 68 Hrs; troubleshoot, and secure & configure a Computer Network World (12 Hrs.)
Professional computer network (48 Hrs.) • Local Networks,
Knowledge - including Internet. 101. View Network connections. • Communicating on a Local
16 Hrs (Mapped NOS: SSC/ (2 Hrs) Network, Principles o f
N3022) 102. Connect a computer to a Communications,
network and share Devices • How do Ethernet Networks
i.e. Printers, files, folders and Work?,
drives. (4 Hrs)
103. Work with various Network • How are Networks Built?,
devices, connectors and • Routing Across Networks
cables. Create straight and • Explain how end- user devices
cross cable and punch a UTP and local networks interact
cable in the patch socket with the global Internet.
and test the connectivity. • Communicating in a Connected
(4 Hrs) World Explain the concept of
104. Practice IP Addressing and network communication.
Subnet masking for IPV4/ IPV6 • Local Networks Explain the roles
and pinging to test networks. (4 of devices in a network.
Hrs) • What Does a Home Network
105. Configure Hub and Switch. Look Like?
(4 Hrs) • How Does Wi-Fi Work?
106. Set up and configure • Introduction to LAN Devices,
wired and wireless LAN in a Internetworking Devices,
Computer Lab within at least Internet Concepts ( 4
three computers. (6 Hrs)
107. Use patch panel & I/O Box Hrs)
for wired LAN and installing • Introduction to www, Concept of
& configuring Internet Internet, Web Browsers,
connection in a single PC and internet servers and search
in a LAN. (6 Hrs) engines.
108. Set up a proxy server/ DHCP • Concepts of Domain
Server with firewall. (8 Hrs) naming Systems and E mail
109. Set up video conferencing communication.
using open-source software. (4 • Introduction to video chatting
Hrs) tools and Social Networking
110. Use various tools (by open concepts.
source /free) for network
troubleshooting, maintenance
and security for both Wired and
Wireless (6 Hrs)
111. Set up Internet access &
communication (10 Hrs)
• Set-up internet connectivity
• Set-up digital communication
112. Use the Internet (10 Hrs)
• Browse the Internet

(xxii)