COPA WEEK WISE NSQF SYLLABUS (SPILT UP)

WEEK. NO. 13 & 14

1. Reference Learning Outcome :-Create and manage database file by using MySQL. (NOS: SSC/N9401)
2. Duration :- Professional Skill 53 Hrs; Professional Knowledge 13  Hrs.  (for above learning out come)

TRADE THEORY (Professional Knowledge ) :- 

• •  Concept of DBMS, RDBMS.
  •  Data Models, Concept of DBA, Database Users.
  •  Database Schema.
  •  Designing Database using Normalization Rules.
  •  Various data types Data integrity, DDL DML and DCL statements.
  •  Enforcing Primary key and foreign key.
  •  Adding Indices.
  •  Concepts of Transactions
  •  ACID Property of Transaction Constraints.
  •  Joining of tables
  •  Sub Queries
  •  Functions used in query like sum, average, max, min, count etc.

TRADE PRACTICAL (Professional Skills  With Indicative Hours) :- Job no. & Name of the Practical

• 89. Installation of MySQL. (1 Hr)
• 90. Troubleshooting basic installation issues. (1 Hr)
• 91. Creation and use of database. (3 Hr)
• 92. Designing of tables. (3 Hr)
• 93. Applying data integrity rules. (2 Hr)
• 94. Using the DDL, DCL and DML statements. (2 Hrs)
• 95. Enforcing constraints, primary key and foreign key. (2 Hrs)
• 96. Adding indices to Tables. (1 Hr)
• 97. Simple select queries. (5 Hrs)
• 98. Insert and delete queries Update queries. (10 Hrs)
• 99. Using the Number, Date and Character functions. Joins and Functions (11.5 Hrs)
• 100. Joins, Group by, Having, Sub query. (11.5 Hrs)

WEEK. NO. 15

1. Reference Learning Outcome :-Install, setup/ configure, troubleshoot, and secure computer network including Internet. (Mapped NOS: SSC/N3022)
2. Duration :- Professional Skill 68 Hrs.; Professional Knowledge 16 Hrs.(for above learning out come)

TRADE THEORY (Professional Knowledge ) :- 

• • Local Networks,
  •  Communicating on a Local Network, Principles of Communications,
  •  How do Ethernet Networks Work?,
  •  How are Networks Built?,
  •  Routing Across Networks
  •  Explain how end-user devices and local networks interact with the global Internet.
  •  Communicating in a Connected World Explain the concept of network communication.

TRADE PRACTICAL (Professional Skills  With Indicative Hours) :- Job no. & Name of the Practical

• 101. View Network connections. (2 Hrs)
• 102. Connect a computer to a network and share Devices i.e. Printers, files, folders and drives. (4 Hrs)
• 103. Work with various Network devices, connectors and cables. Create straight and cross cable and punch a UTP cable in the patch socket and test the connectivity. (4 Hrs)
• 104. Practice IP Addressing and Subnet masking for IPV4/ IPV6 and pinging to test networks. (4 Hrs)
• 105. Configure Hub and Switch. (4 Hrs)
• 106. Set up and configure wired and wireless LAN in a Computer Lab within at least three computers. (6 Hrs)

 

WEEK. NO.  16

1. Reference Learning Outcome :-Install, setup/ configure, troubleshoot, and secure computer network including Internet. (Mapped NOS: SSC/N3022)
2. Duration :- Professional Skill 68 Hrs.; Professional Knowledge 16 Hrs.(for above learning out come)

TRADE THEORY (Professional Knowledge ) :- 

• •  Local Networks Explain the roles of devices in a network.
  •  What Does a Home Network Look Like?
  •  How Does Wi-Fi Work?
  •  Introduction to LAN Devices, Internetworking Devices,

TRADE PRACTICAL (Professional Skills  With Indicative Hours) :- Job no. & Name of the Practical

• 107. Use patch panel & I/O Box for wired LAN and installing & configuring Internet connection in a single PC and in a LAN. (6 Hrs)
• 108. Set up a proxy server/ DHCP Server with firewall. (8 Hrs)
• 109. Set up video conferencing using open-source software. (4 Hrs)
• 110. Use various tools (by open source /free) for network troubleshooting, maintenance and security for both Wired and Wireless (6 Hrs)