Computer Networks and Databases Syllabus

## Computer Networks ### Week 1 - Computer Network Architecture, Network Structure - Circuit Switching, Packet Switching, Message Switching - Physical Layer ### Week 2 - Data Link Layer, Framing - Retransmission Algorithms, Multiple Access and ALOHA - CSMA/CD, Ethernet, High-Speed LANs and Topol...

## Computer Networks ### Week 1 - Computer Network Architecture, Network Structure - Circuit Switching, Packet Switching, Message Switching - Physical Layer ### Week 2 - Data Link Layer, Framing - Retransmission Algorithms, Multiple Access and ALOHA - CSMA/CD, Ethernet, High-Speed LANs and Topologies ### Week 3 - Broadcast Routing, Spanning Trees - TCP/IP Stack, IP Networks, and Internet - Transport Layer and TCP/IP ### Week 4 - DNS and Firewalls - Intrusion Detection and Prevention - Network Management and Interoperability ## Databases ### Week 1 - ER Diagram - Data Models - Relational and Object-Oriented Databases - Database Design - Conceptual Design, Normalization ### Week 2 - Primitive and Composite Data Types, Physical and Logical Databases - Data Abstraction and Data Independence, Data Aggregation - Relational Algebra ### Week 3 - Application Development Using SQL - Host Language Interface, Embedded SQL - Stored Procedures, Triggers, Views, Constraints, Assertions - Internal RDBMS - Physical Data Organization (Sequential, Indexed, Hashed Files) ### Week 4 - Advanced RDBMS - Query Optimization, Join Algorithms - Transaction Processing - Concurrency Control, Recovery Management - Server Environments - Multi-User Systems, Client Interfaces in Distributed Applications