Subject 1. Programming Fundamentals (20 items)

Basic Syntax

• Data types
• Variables, operators

Language Types

• Procedural programming languages
• Object-oriented programming languages
• Scripting languages
• Declarative languages

Subject 2. Database Design and Operation (20 items)

Basic SQL Writing

• SQL syntax
• DDL/DML/DCL
• User-defined functions

Advanced SQL Writing

• Tables/views/indexes
• Subqueries/joins

Database Design

• Logical database design
• Physical database design
• Normalization/denormalization
• E-R diagrams

Subject 3. Network Fundamentals and Management (20 items)

Network Fundamentals

• Structure of the internet
• 7-layer network model
• IP
• TCP/UDP

Network Setup and Management

• LAN/routers/switches
• Server equipment operation (OS, NAS, DAS, SAN, etc.)
• Line control/OS communication control
• Analog/digital data transmission

Subject 4. Information Security Fundamentals (20 items)

SW Development Security

• Secure SDLC
• Authentication, access control, confidentiality, permission management
• Error handling/session control
• Cryptographic algorithms

System Security

• Types of service attacks
• Server authentication/access control
• Security architecture/frameworks
• Log analysis/vulnerability analysis

Subject 5. Information Technology Ethics (10 items)

• Internet ethics
• Netiquette