Thursday, March 19, 2026
Wednesday, March 18, 2026
NETWORKING PRACTICAL FULL LAB
🧪 NETWORKING PRACTICAL LAB
🎯 Scenario
You are designing a small campus network with:
- 2
Routers
- 2
Switches
- 4 PCs
- VLANs
+ Routing + DHCP
🗺️ TOPOLOGY DIAGRAM
🌐 IP ADDRESSING PLAN
|
Device |
Interface |
IP Address |
|
R1 |
G0/0 |
192.168.10.1 |
|
R1 |
G0/1 |
10.0.0.1 |
|
R2 |
G0/0 |
192.168.20.1 |
|
R2 |
G0/1 |
10.0.0.2 |
🧩 VLAN CONFIGURATION
|
VLAN |
Name |
Network |
|
10 |
HR |
192.168.10.0/24 |
|
20 |
IT |
192.168.20.0/24 |
⚙️ STEP-BY-STEP CONFIGURATION
🔹 1. SWITCH CONFIGURATION
(SW1 & SW2)
Create VLANs
enable
configure terminal
vlan 10
name HR
vlan 20
name IT
Assign Ports
interface fa0/1
switchport mode access
switchport access vlan 10
interface fa0/2
switchport mode access
switchport access vlan 20
Configure Trunk
interface fa0/24
switchport mode trunk
switchport trunk allowed vlan 10,20
🔹 2. ROUTER R1
CONFIGURATION
enable
configure terminal
interface g0/0
ip address 192.168.10.1 255.255.255.0
no shutdown
interface g0/1
ip address 10.0.0.1 255.255.255.252
no shutdown
🔹 3. ROUTER R2
CONFIGURATION
enable
configure terminal
interface g0/0
ip address 192.168.20.1 255.255.255.0
no shutdown
interface g0/1
ip address 10.0.0.2 255.255.255.252
no shutdown
🔹 4. STATIC ROUTING
On R1
ip route 192.168.20.0 255.255.255.0 10.0.0.2
On R2
ip route 192.168.10.0 255.255.255.0 10.0.0.1
🔹 5. DHCP CONFIGURATION
(R1)
ip dhcp excluded-address 192.168.10.1
ip dhcp pool HR
network 192.168.10.0 255.255.255.0
default-router 192.168.10.1
🔹 6. PC CONFIGURATION
👉 Set PCs to DHCP mode
OR manually:
|
PC |
IP |
Gateway |
|
PC1 |
192.168.10.2 |
192.168.10.1 |
|
PC2 |
192.168.20.2 |
192.168.20.1 |
🔍 TESTING (VERY
IMPORTANT)
Run these commands:
ping 192.168.20.2
ping 192.168.10.2
✔ All PCs should communicate
successfully.
🛠️ TROUBLESHOOTING
COMMANDS
show ip interface brief
show vlan brief
show ip route
🎯 WHAT YOU LEARN HERE
- VLAN
configuration
- Inter-router
communication
- Static
routing
- DHCP
setup
- Trunking
- Real
exam troubleshooting
Tuesday, March 17, 2026
PROGRAMMING PRACTICAL INTERVIEW MGA&LGA TIPS
PROGRAMMING PRACTICAL INTERVIEW MGA&LGA TIPS
1. System Overview
Project
Title: Appointment
Management System
Purpose:
To manage patient–doctor appointments efficiently with role-based access (User,
Doctor, Admin).
2. User Roles & Permissions
🔹 1. User (Receptionist/Patient)
- Create appointment
- View appointments
- Update appointment
🔹 2. Doctor
- View assigned appointments
- See patient details
- Cancel appointment
🔹 3. Administrator
- Create appointment
- Cancel appointment
- Add appointment
- Remove appointment
- Manage users (optional advanced
feature)
3. Functional Requirements
Appointment Management
- Create appointment
- Edit appointment
- Delete appointment
- Cancel appointment
- View appointment schedule
Authentication System
- Login / Logout
- Role-based access control (RBAC)
- Password encryption (bcrypt)
Security
- Prevent SQL Injection (use
prepared statements / ORM)
- Input validation
- CSRF protection
- Authentication tokens (JWT
optional)
4. System
Architecture
Option 1:
Monolithic (Simple)
- Backend: Django / Laravel /
Spring Boot
- Frontend: React JS (optional)
- Database: MySQL
Option 2:
Modern (Recommended)
- Frontend: React JS
- Backend API: Django REST /
Spring Boot / Laravel API
- Database: MySQL
5. System
Workflow
User
Flow:
1.
Login
2.
Create
appointment
3.
Select
patient + doctor + date
4.
Save
appointment
Doctor
Flow:
1.
Login
2.
View
appointments
3.
Cancel
appointment (if needed)
Admin
Flow:
1.
Login
2.
Manage
all appointments
3.
Add/remove/update
appointments
6.
Security Implementation
Prevent SQL Injection
- Use ORM:
- Django ORM
- Laravel Eloquent
- Spring JPA
7.
Authentication Design
Option A:
Session-based (Simple)
- Django/Laravel default
authentication
Option B:
JWT (Advanced)
- Token-based authentication for
APIs
8.
Frontend Pages (React JS)
- Login Page
- Dashboard
- Appointment List
- Create Appointment Form
- Doctor Schedule View
- Admin Panel
9. Testing
- Unit Testing
- API Testing (Postman)
- Security Testing (SQL Injection
tests)
10.
Advanced Features (Optional)
- Email notifications
- SMS reminders
- Calendar integration
- Reporting dashboard
- Audit logs
11.
Recommended Tech Stack
🔹 Best Combo (Easy + Powerful)
- Backend: Django + Django REST
Framework
- Frontend: React JS
- Database: MySQL
12.
Deployment
- Backend: Render / Railway / AWS
- Frontend: Vercel / Netlify
- Database: MySQL (Cloud or Local)
Monday, March 16, 2026
NETWORKING PRACTICAL EXAM
NETWORKING PRACTICAL EXAM - MAT
Duration: 3 Hours
Total Marks: 100
NETWORK TOPOLOGY
Devices required:
- 2 Routers
- 2 Switches
- 4 PCs
- 1 Server
Topology layout example:
PC1 ----\
Switch1 ---- Router1 ---- Router2 ----
Switch2 ---- PC3
PC2 ----/ \ ------PC4
Server
PART 1 — BASIC DEVICE CONFIGURATION
(10 Marks)
Configure basic settings on all routers and switches.
Task 1
Set hostname.
Task 2
Disable DNS lookup.
Task 3
Secure privileged mode.
Task 4
Configure console password.
PART 2 — IP ADDRESSING (15 Marks)
Use the following networks.
|
Network |
Subnet |
|
LAN1 |
192.168.10.0/24 |
|
LAN2 |
192.168.20.0/24 |
|
WAN |
10.0.0.0/30 |
Task 5
Configure Router1.
Task 6
Configure Router2.
Task 7
Configure WAN link.
Router1:
Router2:
PART 3 — SWITCH CONFIGURATION (10
Marks)
Task 8
Set hostname.
Task 9
Configure management IP.
Task 10
Set default gateway.
PART 4 — STATIC ROUTING (10 Marks)
Configure routing between networks.
Router1:
Router2:
Verify:
PART 5 — VLAN CONFIGURATION (15
Marks)
|
VLAN |
Name |
|
10 |
IT |
|
20 |
HR |
Task 11
Create two VLANs on Switch1.
Task 12
Assign ports.
PART 6 — INTER-VLAN ROUTING (10
Marks)
Configure Router-on-a-Stick.
PART 7 — DHCP CONFIGURATION (10
Marks)
Configure DHCP on Router1.
Exclude gateway address.
PART 8 — ACCESS CONTROL LIST (ACL)
(10 Marks)
Block PC2 from accessing the server.
Apply ACL.
PART 9 — NETWORK TESTING (5 Marks)
Test connectivity:
- PC1 → PC3
- PC1 → Server
- PC2 → Server
(should fail)
Check routing.
Check interfaces.
PART 10 — TROUBLESHOOTING (5 Marks)
Identify and fix the following issues:
- Router
interface shutdown
- Incorrect VLAN
assignment
- Wrong default
gateway
- Incorrect
subnet mask
- ACL blocking
traffic
PART 11 (10 Marks)
Configure SSH remote access on Router1.
MARKING SCHEME SUMMARY
|
SECTION |
MARKS |
|
Basic Configuration |
10 |
|
IP Addressing |
15 |
|
Switch Configuration |
10 |
|
Static Routing |
10 |
|
VLANs |
15 |
|
Inter-VLAN Routing |
10 |
|
DHCP |
10 |
|
ACL |
10 |
|
Testing |
5 |
|
Troubleshooting |
5 |
|
Part 11 |
10 |
SKILLS TESTED
This CCNA practical exam evaluates:
- Router
configuration
- Switch
configuration
- VLAN
implementation
- Inter-VLAN
routing
- Static routing
- DHCP
configuration
- ACL security
- Network
troubleshooting
