-- Sample Lesson Content for "What is Networking?"
INSERT INTO lesson_content (task_id, content, content_type, reading_time_minutes) VALUES
(1, '# What is Networking?

Networking is the practice of connecting computers and other devices together to share resources and information. In the modern digital world, networking forms the backbone of all internet communication, cloud services, and cybersecurity operations.

## Key Networking Concepts

### IP Addresses
Every device on a network has a unique identifier called an IP address. Think of it like a postal address for your computer. There are two main versions:
- **IPv4**: Uses format like 192.168.1.1 (most common)
- **IPv6**: Uses format like 2001:0db8:85a3::8a2e:0370:7334 (newer, more addresses)

### Protocols
Protocols are rules that govern how data is transmitted across networks. The most important ones include:
- **TCP/IP**: The foundation of internet communication
- **HTTP/HTTPS**: Used for web browsing
- **DNS**: Translates domain names to IP addresses
- **FTP**: File transfer protocol

### Ports
Ports are like doors on your computer that allow different services to communicate. Common ports include:
- Port 80: HTTP (web traffic)
- Port 443: HTTPS (secure web traffic)
- Port 22: SSH (secure remote access)
- Port 3389: RDP (Remote Desktop)

### Network Types
- **LAN (Local Area Network)**: Connects devices in a small area like a home or office
- **WAN (Wide Area Network)**: Connects devices across large geographic areas
- **VPN (Virtual Private Network)**: Creates secure connections over public networks

## Why Networking Matters for SOC Analysts

As a SOC analyst, understanding networking is crucial because:
1. Most attacks occur over networks
2. You need to analyze network traffic for threats
3. Understanding protocols helps identify malicious activity
4. Network logs are a primary source of security intelligence

## Common Network Security Concerns
- **Man-in-the-Middle Attacks**: Intercepting communication between two parties
- **DDoS Attacks**: Overwhelming a network with traffic
- **Port Scanning**: Attackers probing for open ports
- **DNS Poisoning**: Redirecting traffic to malicious sites', 'markdown', 10);

-- Questions for "What is Networking?"
INSERT INTO lesson_questions (task_id, question_text, question_order, correct_answer, case_sensitive, hint) VALUES
(1, 'What is the standard port number for HTTPS traffic?', 1, '443', FALSE, 'Think about secure web browsing'),
(1, 'What protocol is used to translate domain names into IP addresses?', 2, 'DNS', FALSE, 'It stands for Domain Name System'),
(1, 'What type of attack involves intercepting communication between two parties?', 3, 'Man-in-the-Middle', FALSE, 'Also known as MITM'),
(1, 'What does LAN stand for?', 4, 'Local Area Network', FALSE, 'It connects devices in a small geographic area');

-- Sample Lesson Content for "Understanding OSI Model"
INSERT INTO lesson_content (task_id, content, content_type, reading_time_minutes) VALUES
(2, '# The OSI Model: Understanding Network Layers

The OSI (Open Systems Interconnection) Model is a conceptual framework that standardizes the functions of a network into seven distinct layers. Each layer serves a specific purpose and communicates with the layers directly above and below it.

## The Seven Layers

### Layer 7: Application Layer
This is the layer closest to the end user. It provides network services directly to applications.
- Examples: HTTP, FTP, SMTP, DNS
- What it does: Handles high-level APIs, resource sharing, remote file access

### Layer 6: Presentation Layer
Translates data between the application layer and the network format.
- Examples: SSL/TLS, JPEG, MPEG
- What it does: Data encryption, compression, translation

### Layer 5: Session Layer
Manages sessions and controls connections between computers.
- Examples: NetBIOS, RPC
- What it does: Establishes, manages, and terminates connections

### Layer 4: Transport Layer
Ensures complete data transfer with error checking and flow control.
- Examples: TCP, UDP
- What it does: Segments data, ensures reliable delivery

### Layer 3: Network Layer
Handles routing of data packets between different networks.
- Examples: IP, ICMP, routers
- What it does: Logical addressing, routing, packet forwarding

### Layer 2: Data Link Layer
Provides node-to-node data transfer and handles error correction from the physical layer.
- Examples: Ethernet, switches, MAC addresses
- What it does: Framing, physical addressing, error detection

### Layer 1: Physical Layer
The actual hardware that transmits raw bits over a physical medium.
- Examples: Cables, hubs, network cards
- What it does: Transmits raw bit streams over physical medium

## Why SOC Analysts Need to Know the OSI Model

Understanding the OSI model helps you:
1. **Troubleshoot network issues** systematically
2. **Identify where attacks occur** in the network stack
3. **Understand security controls** at each layer
4. **Analyze network traffic** more effectively
5. **Communicate with network teams** using standard terminology

## Security at Each Layer

Different types of attacks target different OSI layers:
- **Layer 7 (Application)**: SQL injection, XSS, DDoS
- **Layer 4 (Transport)**: SYN floods, port scanning
- **Layer 3 (Network)**: IP spoofing, routing attacks
- **Layer 2 (Data Link)**: MAC flooding, ARP spoofing
- **Layer 1 (Physical)**: Cable tapping, jamming', 'markdown', 12);

-- Questions for "Understanding OSI Model"
INSERT INTO lesson_questions (task_id, question_text, question_order, correct_answer, case_sensitive, hint) VALUES
(2, 'Which OSI layer is responsible for routing data packets between networks?', 1, 'Network Layer', FALSE, 'This is Layer 3'),
(2, 'What protocol operates at the Transport Layer (Layer 4)?', 2, 'TCP', FALSE, 'It ensures reliable data delivery'),
(2, 'Which layer handles encryption and data translation?', 3, 'Presentation Layer', FALSE, 'This is Layer 6'),
(2, 'What type of address is used at the Data Link Layer?', 4, 'MAC', FALSE, 'Physical address of network interfaces'),
(2, 'Which layer is closest to the end user and provides network services to applications?', 5, 'Application Layer', FALSE, 'This is Layer 7');
