China Computer Software Professional Qualification and Level Examination Outline in 2004
Programmer level test outline 1. Exam instructions 1. Exam requirements: (1) Master the numerical system and its conversion, data representation, arithmetic and logical operation, and related application mathematical basic knowledge; (2) understand the composition of the computer and performance indicators of the major components; (3) Master the basic knowledge of the operating system, program design language; (4) Skilled the basic operation of computer common software; (5) Skilled basic data structure and common algorithm; (6) Skilled C-programming language, and C , Java, Visual Basic's programming language; (7) Familiar with database, network, and multimedia basic knowledge; (8) Master the basic knowledge of software engineering, understand the basic knowledge of software process, software development project management; (9) Understand common Information technology standards, safety, and basic knowledge of relevant laws, regulations; (10) understanding informationization, computer application basics; (11) Correct reading and understanding simple English materials in computer fields. 2. According to the software development project management and software engineering requirements, the qualified personnel of this exam will be prepared and debugged according to the program design specification, and the corresponding documentation of the program is generated, the design requirements are required, and the design requirements can be properly and reliable. The procedure, the actual work ability and business level of assistant engineers (or technicians). 3. The subjects set by this exam include: (1) Computer hard software basic knowledge, test time is 150 minutes, written test; (2) programming, test time is 150 minutes, written test. Second, the examination scope test subject 1: computer hard software basics
1. Computer Science Foundation 1.1 Digital System and Its Conversion Binary, Decimal and Hexadecimal and Its Conversion 1.2 Data Representation (Original Code, Bright Code, Completion Expression, Integer and Real Machine Internal representation, accuracy and overflow) Non-numerical representation (characters and Chinese characters indicated, sound and image in the machine) Calibration method and check code (parity code code, Hamming check code) 1.3 arithmetic operation The basic operation of the binary calculation method logic algebra of the logical arithmetic computer and the simplification of the logical expression of the logical expression (the approximate solution, interpolation) arrangement of the mathematical application, the application statistics (statistical analysis of data) 1.5 Common data structural arrays (statement, dynamic arrays), linear table, linked list (one-way linked list, two-way linked list, cyclic list), queue, stack, tree (binary tree, lookup tree), diagram definition, storage, and operation 1.6 Common algorithm Common sort algorithm, find algorithm, numerical calculation, string processing, data compression algorithm, recursive algorithm, diagram related algorithm, relationship, algorithm efficiency, algorithm design, algorithm description (flow chart, pseudo code, decision table )2. Computer System Basics 2.1 Hardware Basics 2.1.1 Computer System Composition, Hardware System, Software System and Hierarchy 2.1.2 Computer Types and Features Microcomputer, Workstation, Server, Large Computer, Giant Computer 2.1.3 Central Processor CPU Composition, commonly used registers, instruction systems, addressing methods, instruction execution control, processor performance 2.1.4 Main memory and auxiliary memory system storage medium (semiconductor, hard disk, disc, flash memory, floppy disk, tape, etc. ) The concept, performance, and basic principles of Cache, the concept of virtual storage concept, the type, characteristics, performance, and capacity calculation of the device 2.1.5 I / O interface, I / O device, and communication device I / O interface ( Types and features of bus, DMA, channel, SCSI, parallel port, RS232C, USB, IEEE1394) I / O device (keyboard, mouse, monitor, printer, scanner, camera, and various co-operators) I / O devices Control mode (interrupt control, DMA) communication device Type and characteristics (MODEM, hub, switch, repeater, router, bridge, gateway) and its connection method and connection medium (serial connection, parallel connection, transmission media Types and Features) 2.2 Software Basics 2.2.1 Operating System Basics Operating System Types and Function Operating System Core (Interrupt Control) and Process Concept Processor Management, Storage Management, Device Management, File Management, Job Management Chinese Characterization Graphics User interface and its operational method 2.2.2 Programming language and language processing program basic knowledge assembly, compile, interpretation system basic knowledge programming language (data, operation, control, and transmission) process (function) call 2.3 network foundation Knowledge network function, classification, composition, and topology network architecture and protocol (OSI / RM, TCP / IP) common network device and network communication device, network operating system basic knowledge and use of Client / Server Structure, Browser / Server Structure LAN Basics Internet Basics 2.4 Database Basics Database Management System Main Features and Feature Database Models (Conceptual Mode, Outside Mode, Invention) Data Model, ER Map Data Operation (Relationship Operation) Database Language (SQL) Database Main Control Function 2.5 Multimedia Basics Multimedia Fundamental Concept, Performance Characteristics of Common Multimedia Equipment,
Common multimedia file format type simple graphics draw, image file basic processing method Audio and video information Application simple multimedia application production method 2.6 system performance indicator response time, throughput, turnover time, etc. Concept reliability, maintenanceability, expandable Sex, portability, availability, reusability, safety, etc. 2.7 Computer application basics and common office software operating methods information management, data processing, assist design, automatic control, scientific calculation, artificial intelligence, etc. Concept text processing foundation Knowledge and common operation method spreadsheet processing basics and common operation methods Presentation Method Email Processing Operation Method Web Page Method 3. Software Development and Operation Maintenance Basics 3.1 Software Engineering and Project Management Basics Software Engineering Basic Concept Software Development Phase Target and Task Software Process Basic Knowledge Software Project Management Basic Knowledge Objects Development Method Basic Knowledge Software Development Tools and Environment Basics (CASE) Software Quality Management Basics 3.2 Software Demand Analysis, Demand Definition and Software Basics Analysis Concept (Data Flow Diagram (DFD), Entity Diagram (ER)) Object-Oriented Design, Structured Design Basic Knowledge Simulation Design, Code design, human-machine interface design points 3.3 Program design basic knowledge structure design program design, procedure flow chart, NS diagram, PAD diagram design style face-oriented object design basics, visualization program design basic knowledge 3.4 program test basic knowledge black box test, White box test, gray box test basic knowledge test workflow 3.5 Software development document Basics 3.6 Software operation and maintenance basic knowledge software operation Basic knowledge software maintenance basics 4. Safety Basic Knowledge Security Basic Concepts Computer Virus Prevention, Computer Crime Prevention Access Control Encryption and Decryption Basics 5. Standardization Basic Knowledge Standardization Basic Concepts International Standards, National Standards, Industry Standards, Enterprise Standard Basic Knowledge Code Standards, File Formats, Safety Standards, Software Development Norms and Document Standard Basics Standardization Agency 6. Informatization basic knowledge informationization basic concepts global information trend, national information strategy, corporate information strategy and strategic common sense of law, regular point process education, e-commerce, e-government, etc. Information resources management knowledge 7. Computer Professional English Master Computer Technology Basic Words Correctly Read and Understand Simple English Data
Test Subject 2: Program Design 1. Internal Design 1.1 Understanding External Design 1.2 Function Division and Determining Structure Data Flow Diagram, Structure Figure 1.3 Physical Data Design Determines Data Organization Mode, Storage Media, Design Record Format and Processing Method 1.4 Detailed Input Output Design Interface Design, Report Design 1.5 Internal Design Document For program interface, program function, man-machine interface, input output, test plan description 1.6 internal design document 2. Program Design 2.1 Simulation Division (Principle, Method, Standard) 2.2 Writing Program Design Document Module Specification (Description of Program Processing Logic, Description of Input Output Data Format) Test Description Manual (Test Type and Target, Test Sample, Test Method) 2.3 Program Design Review 3. Program Implementation 3.1 Programming Programming Method and Standard Program Design Language Using Artificial Trader Documentation 3.2 Program Test Preparation Test Environment and Test Tool Preparation Test Data Write Test Report 4. Programming Language (C language is required, other languages Optional) 4.1 C Programming Language (ANSI C Standard) Program Structure, Syntax, Data Type Description, Executable Statement, Function Call, Standard Library Function, Pointer 4.2 C Program Design Language (ANSI C Standard) C and Object-Oriented Program design, grammar and program structure, class, member, constructor, destructive function, template, inheritance, polymorphism 4.3 Java programming (Java 2) Java and object-oriented programming language mechanism (program structure and grammar, class, member , Constructor, destructuring function, inheritance, interface) 4.4 Visual Basic programming (Visual Basic 6.0) User Interface Design Structure and Syntax File System Object Access Database
Software Designer (Advanced Programmer) Exam Outline 1, Exam Notes 1. Exam requirements: (1) Master data, arithmetic and logic operations; (2) Master the basic knowledge of relevant application mathematics, discrete mathematics; (3) Master the computer architecture and the performance and basic working principle of major components; (4) Master the basic knowledge of the operating system, programming language, understand the basic knowledge of the compiler; (5) Proficiency in the common data structure and common algorithm; (6) Familiar with the basics of database, network, and multimedia; (7) Master the C procedure Design language, and a programming language in C , Java, Visual, Basic, Visual C ; (8) Familiar with software engineering, software process improvement and software development project management basics; (9) Familiar with software design And technology; (10) Master common information technology standards, safety, and basic knowledge of relevant laws, regulations; (11) Understand the basics of information, computer applications; (12) Read and understand English materials in the computer. 2. Through the qualified personnel of this exam, according to the requirements of software development project management and software engineering, according to the system's overall design specification, write, write program design specifications, etc., organize and guide programmer writing, debugging procedures, and Software is optimized and integrated, developing high quality software that meets the overall design requirements of the system; has the actual work ability and business level of the project. 3. The subjects of this exam include: (1) Computer and software engineering knowledge, test time is 150 minutes, written test; (2) software design, test time is 150 minutes, written test.
Second, the examination scope test subject 1: Computer and software engineering knowledge 1. Computer Science Foundation 1.1 Digital System and Its Conversion · Binary, Decimal and Hexadecimal Systems and Its Conversion 1.2 Data Representation (Original Code, Bright Code, Completion, Migration Code, Integer And real-in-the-high representation, accuracy and overflow) · Non-numerical representation (character and Chinese characters, sound representation, image representation), verification method and check code (parity code code, Heming check code, cyclic redundancy Cat code) 1.3 Arithmetic operation and logical operation · Basic operation of logical algebraic and logical expressions 1.4 mathematical basic knowledge · proposition logic, predicate logic, form logic basic knowledge · Common numerical calculation (error, matrix and) , Approximate solution, interpolation, numerical integral) · Arrangement, probability theory application, application statistics (data statistical analysis) · Basic method of operation (prediction and decision making, linear planning, network diagram, simulation) 1.5 Common data structure · array ( Static array, dynamic array), linear table, linked list (one-way linked list, two-way linked list, cyclic list), queue, stack, tree (two-fork, find tree, balance tree, clue tree, clue tree, heap), diagram, etc. , Storage and operation · HASH (storage address calculation, conflict processing) 1.6 common algorithm, sorting algorithm, find algorithm, numerical calculation method, string processing method, data compression algorithm, recursive algorithm, diagram, algorithm, data structure Relationship, algorithm efficiency, algorithm design, algorithm description (flow chart, pseudo code, decision table), complexity of algorithm 2. Computer System Knowledge 2.1 Hardware Knowledge 2.1.1 Component of Computer System O Interface function, type, and feature · I / O control mode (interrupt system, DMA, I / O processor mode) · CISC / RISC, pipeline operation, multiprocessor, parallel processing 2.1.2 storage system · main memory CACHE storage system Working principle · Virtual memory basic working principle, multi-level storage system performance price · RAID type and feature 2.1.The security, reliability and system performance evaluation basics · Diagnostics and fault tolerant · System reliability analysis Computer System Performance Evaluation Method 2.2 Software Knowledge 2.2.1 Operating System Knowledge · Operating System Core (Interrupt Control), Process, Thread Concept · Processor Management (Status Conversion, Sharing and Mutual Enhancement, Time Turn, Blocking, Dead Lock) · Storage Management (Main Storage Protection, Dynamic Connection, Segmentation, Page, Dynamic) · Device Management (I / O Control, Spi Shop) · File Management (File Directory, File Organization, Access Method, Access Control , Restore processing) · Work management (job scheduling, job control language (JCL), multi-channel programming) · Chinese character processing, multimedia processing, human-machine interface · network operating system and embedded operating system basic knowledge · Configuration of operating system 2.2 .2 Programming language and language processing programs knowledge · assembly, compile, interpretation system basic knowledge and basic working principle · Basic components of programming language: data, operation, control and transmission, process (function)
Calling · All kinds of programming language main features and applications 2.3 Computer network knowledge · Network architecture (network topology, OSI / RM, basic network protocol) · Transmission medium, transmission technology, transmission method, transmission control · Common network equipment and Various types of communication equipment · Client / Server structure, Browser / Server structure · LAN topology, access control, LAN network, LAN-WAN connection, Internet basics, network software · Network management, network performance Analysis 2.4 Database Knowledge · Database Management System Features and Features · Database Model (Conceptual Mode, Outer Mode, Inner Mode) · Data Model, ER Figure, First Paradigm, Second Paradigm, Third Paradigm, Data Operation (Collection Operations Relationship operation) · Database Language (SQL) · Database Control Function (Concurrent Control, Recovery, Security, Integrity) · Data Warehouse and Distributed Database Basics 2.5 Multimedia Knowledge · Multimedia System Basic Knowledge, Multimedia Equipment Performance, Common multimedia file format · Simple graphics drawing, image file processing method · Application of audio and video information · Multimedia application development process 2.6 system performance knowledge · Performance indicator (response time, throughput, turnastive time) and performance design · Performance test And performance evaluation, reliability indicators and calculations, reliability design, reliability testing, and reliability assessment 2.7 Computer application basics, information management, data processing, assist design, automatic control, scientific calculation, artificial intelligence, etc. · Remote communication Service Basics · Common Application System 3. System Development and Operation 3.1 Software Engineering, Software Process Improvement and Software Development Project Management Knowledge · Software Engineering Knowledge · Software Development Life Cycle Objectives and Tasks · Software Development Project Management Basic Knowledge (Time Management, Cost Management, Quality Management, Human resource management, risk management, etc.) and its common management tools · Main software development methods (life cycle, prototyping, object-oriented method, Case) · software development tools and environmental knowledge · Software process improvement knowledge · Software quality management knowledge · Software Development Process Assessment, Software Ability Mature Assessment Basics 3.2 System Analysis Basics · System Analysis Purpose and Tasks · Structured Analysis Method (Data Flow Drawings (DFD), Data Dictionary (DD), Entity Diagram (ERD), Description Processing Structured Language · Unified Modeling Language (UML) · System Specifications 3.3 System Design Knowledge · The purpose and task of system design, structure design methods and tools (system flow chart, HIPO diagram, control flow chart) · System overall structural design (overall layout, design principle, module structure design, data storage design, system configuration scheme) · System detailed design (code design, database design, user interface design, processing process design) · System design manual 3.4 system implementation The main task of knowledge and system implementation, structured programming, object-oriented programming, visualization programming, program design style, programming language, the purpose, type, system test method (black box test, white box test , Gray box test) · Test design and management (
Error curve, error exclusion, convergence, injection failure, test case design, system test report) · System conversion basic knowledge 3.5 system operation and maintenance knowledge · System operation management basics · System maintenance basic knowledge · System evaluation basics 3.6 Object-oriented development Method · Object-Oriented Development Concept (Class, Object, Attribute, Encapsulation, Inheritance, Polymorphism, Object) · Advantageous Development Method and Efficient Area · Object-Oriented Design Method (Architecture, Class Design, user interface design) · Object-oriented implementation method (select programming language, class implementation, method implementation, user interface implementation, preparation test data) · Object-oriented programming language (such as C , Java, Visual, BSASIC) , Visual C , basic mechanism, object-oriented database, concept of distributed objects 4. Safety knowledge · Safety basic concept · Prevention and control computer virus, prevent computer crime · Access control, anti-introspection, safety management measures · Encryption and decryption mechanism · Risk analysis, risk type, anti-risk measure and internal control 5. Standardized knowledge, standardized awareness, standardization development, standard development process Informatization Basic Knowledge · Information Consciousness · Global Informatization Trend, National Information Strategy, Enterprise Information Strategy and Strategy · Law, Regulations, Distance Education, E-Commerce, E-Government, etc. · Enterprise Information Resource Management Basic Knowledge 7. Computer Professional English · Mastering Computer Technology Basic Words · Correctly Reading and Understanding English Data Tests in Computer Sports 2: Software Design 1. External Design 1.1 Understanding System Demand Description 1.2 System Development Preparation · Select Development Method, Prepare Development Environment, Develop Development Plan 1.3 Design System Features · Select System Structure, Design Each Subsystem Function and Interface, Design Safety Policy, Demand and Implementation Method, develop a detailed workflow and data stream 1.4 design data model · Design ER model, data model 1.5 Write external design document · System configuration diagram, each subsystem relationship diagram, system flow chart, system function manual, input and output specification, Data Specifications, User Manual Framework · Design System Test Requirements 1.6 Design Review 2. Internal Design 2.1 Design Software Structure · According to Press System Decomposition, Determining Members Function Specifications and Interfaces between Components • Design Input and Output · Screen Interface Design, Design Input Output Check Method and Check Information 2.3 Design Physical Data · Analysis Data characteristics, determine logical data organization, storage media, design record format, and processing method • Replace the logical data structure to physical data structure, calculation capacity, optimize 2.4 components, create, create, reuse components, Library or class library 2.5 Write internal design documents · Component division map, interface between components, component processing instructions, screen design documents, report design documents, file design documents, database design document 2.6 design review 3. Program Design 3.1 Module Division (Principles, Methods, Standards) 3.2 Writing Program Design Documents · Module Specifications (Features and Interface Description, Description of Program Processing Logic, Description of Input Output Data Formats) · Test Description Manual (Test Type and Target, Test case, test method) 3.3 Program design review 4.
System Implementation 4.1 Configuring Computer Systems and Its Environment 4.2 Select Suitable Program Design Language 4.3 Master C Programming Language, and C , Java, Visual, Basic, Visual C , in order to guide programmers to program and Test, and carry out the necessary Optimization 4.4 System Test · Guide the programmer to test, and check the acceptance · Prepare system integration test environment and test tool · Prepare test data · Write test report 5. Software Engineering · Software Survival Model (Waterfall Model, Spiral Model, Fountain Model) and Software Cost Model · Defines Software Demand (Systematic Target, Configuration, Function, Performance, Constraint) · Method for Describe Software Demand (Function Hierarchy Model, Data flow model, control flow model, data-oriented model, object-oriented model, etc.) · Define software requirements (structural analysis methods, object-oriented analysis methods) · Software design (analysis and integration, gradual refinement, abstraction, etc. Information hidden) · Software design method (structured design method, Jackson method, Warnier method, object-oriented design method) · Program design (structured program design, object-oriented programming) · Software test principles and methods · Software quality (software Quality characteristics, software quality control) · Software process assessment basic method, software capability maturity assessment basic method · Software development environment and development tool (analysis tool, design tool, programming tool, test tool, maintenance tool, case) · software engineering development Trend (facing component, unified modeling language (UML)) · Software process improvement model and method
System analysts 1. Exam instructions 1. Exam requirements: (1) Basic knowledge with system engineering; (2) Master the comprehensive technical knowledge of development information systems (hardware, software, network, database); (3) Familiar with enterprises And government information construction, and have the knowledge of organizational information strategic planning; (4) Familiar with the information system development process and method; (5) Familiar with information system development standards; (6) Master information security related knowledge and technology; 7) Understand the means of software quality assurance; (8) related basic knowledge of economic and management science, familiar with relevant laws and regulations; (9) has a college undergraduate mathematics; (10) Proficiency in reading and correctly related fields . 2. Through the qualified personnel of this exam, familiarize yourself with the business in the application, can analyze the needs and constraints of users, write the information system requirements specifications, and formulate project development plans, coordinate the various people involved in information system development and operation. Guidance to formulate the strategic data planning, organize development information system, assess and select the appropriate development methods and tools, can write system analysis, design documentation, design documentation in accordance with standard regulations, can conduct quality control and progress control of the development process, can specifically guide the project Development, high-level engineers' practical work ability and business level. 3. This exam sets include: (1) comprehensive knowledge of information system, test time is 150 minutes, written test; (2) information system analysis and design case, test time is 90 minutes, written test; (3) Information system analysis and design The paper, the test time is 120 minutes, written test.
Second, III Test Subject 1: Information System Comprehensive Knowledge 1. Computer System Comprehensive Knowledge 1.1 Computer Components and Architecture · The function of various components of computers and their interrelationships · Characteristics and applications of various architectures (SMP, MPP ) · Development of computer architecture 1. Data communication and computer network 1.2.1 Basic knowledge of data communication 1.2.2 Network architecture and protocols · Open system Interconnect reference model · TCP / IP hierarchical model · Commonly used protocol standard 1.2. 3 Computer Network Classification · Classification · LAN Definition and Types · WAN Definitions and Types 1.2.4 Internet · Route Structure · Address and Domain Name · Web Applications · Scalable Markup Language (XML) 1.3 Software Knowledge 1.3.1 Operating System · Operating System Types and Structure · Parallel Mechanism of System · Network Operating System · Distributed Operating System · Embedded Operating System · Mainstream Operating System Product 1.3.2 Database System · Database Management System Type, Structure · Relationship Database and Its Mainstream Products · Data Warehouse and Online Analysis Processing · Data Mining 1.3.3 Middleware 1.4 System Configuration and Performance Evaluation · Client / Server and Brower / Server Structure, Three-layer or Multi-layer Structure, Distributed System, System Configuration Method (Double, Double, Heat Backup, fault tolerant, cluster) · Typical reference test program (Benchmark) · System performance computing, system performance metrics, system performance evaluation, system reliability indicators, economic benefits indicators 1.5 computer application knowledge · Information management, data processing, secondary design, automatic Control, scientific calculation, artificial intelligence · Remote communication service, Web settlement · Multimedia technology foundation 2. Informatization Basics 2. Information · Information and Informationization · Informatization "Significance for Organization · Organization for Information Technology 2.2 Government Informationization Service Objects and E-government Concepts, Contents, Contents, Contents and Technical Forms of E - government Construction, the Role and Status of China 's Government Informationization, Strategies and History · Process Model and Technology Mode of E-Government Construction · The role of the government leadership department, business unit and technical department in information construction, new situation (government affairs, public emergency) Warning alarms) The Impact on Government Information Technology 2.3 Enterprise Informationization and E-Commerce · Enterprise Informationization Concept, Purpose, Planning, Method, Enterprise Resource Planning (ERP) Structure and Function · Customer Relationship Management (CRM) in business Application · Enterprise Portal · Enterprise Application Integration · Supply Chain Management (SCM) Ideology · Business Intelligence (BI) · E-Commerce Type, Standard 2.4 Information Resource Management (Information System Management, Standards, Regulations, Information Resources Safety management, human resource management, etc.) 2.5 related laws and regulations (intellectual property, standard, quality, security, Internet management) 3. Information system knowledge 3.1 Information system · Information system concept · Information system Features · The type of information system · Development of information system 3.2 Information system construction · Information system construction complexity · Information system lifecycle, main work content of all phases · Principles of information system construction · Information system development method (structure Analysis design method, prototyping method, strategic data planning method, etc.)
3.3 Software Engineering · Software Demand Analysis and Definition · Software Design, Test and Maintenance · Software Reuse · Software Quality Assurance and Quality Evaluation · Software Configuration Management · Software Development Environment · Case Tools · Software Intellectual Property Protection 3.4 Project Management Knowledge · Information Project Plan · Project Program Control · Project Workload Estimation · Risk Management · Resource and Task Allocation · Project Lifecycle Management 3.5 Software Process · Software Process Definition and Scope · The Function of Software Process · Main Software Process and Its Characteristics · Software Process Ability Evaluation (CMM, CMMI) · Software Process Improvement · Software Process Standard 3.6 Quality Management · Quality Assurance Program · Quality Certification System · Quality Management and Quality Management Technology · Comprehensive Quality Management · Quality Management Theory 4. Information System Development and Operation Knowledge 4.1 Software Process Technology · Software Life Cycle · Software Development Model (Waterfall Model, Spiral Model, Fountain Model) · Cost Model · Software Multiplexing Technology (Components, Reverse Engineering) 4.2 Software Demand Analysis and Design Methods · Structured Analysis and Design · Analysis Design (DFD, ERD) · Object-Oriented Analysis and Design (Inheritance, Abstract, Agent, Package, Polymorphism) · Unified Modeling Language (UML) · Module Design (Cohesive, Coupled) · I / O Design (Report Design, Screen Design, Code Design) · Human Interface Design 4.3 Development Environment and Development Tools · Integrated Development Environment · Development Tools (Modeling Tools, Analysis Design Tools, Development Platforms, Test Tools, Project Management Tools, etc.) · Comparison of software development platform 4.4 Package · Development Tool · Management Tool · OA Tools · Group Parts 4.5 Program Design · Program Design Language (Type, Development and Features) · Program Design Method (Structured, Object-Oriented, Parallel, Network Program Design) 4.6 Test and Review · Common Test Method · Test Plan and Test Process · Test Report and Test Results · Software Test Automation · Software Test Planning Standards · Review Methods and Principles 4.7 Application System Construction, Integration · Application System Development (Analysis Design The choice of method, the development of the organization, the implementation of the analysis design) · The use of software packages According to the design (ER model, paradigm, SQL, data distribution) and implementation · Network engineering (network planning, design, implementation and testing) · System integration (control integration, data integration, integration, application integration, external resource) 4.8 System Run · System Operation Management (Computer System, Database, Network) · System Cost Management · System Run (Job Scheduling, Data I / O Management, Operation Manual) · User Management · Distributed System Management · Hardware Resource Management · Software Resource Management (Program Management, Version Management) · Data Resource Management, Network Resource Management · Equipment and Facilities Management (Power, Equipment Management, Facilities Security Management) · System Fault Management (Processing Procedures, Monitor, Recovery Process, Precautions) · Security Management · System Operation Tools (Operation Tools, Monitoring Tools, Diagnostic Tools) · System Transformation (Transfer Running Phase, Running, Version Control) · System Run Service Standard 4.9 System Maintenance · Maintenance Type (
Perfect maintenance, error correction maintenance, adaptive maintenance, preventive maintenance) · Maintenance implementation (daily inspection, time maintenance, preventive maintenance, post-maintenance, remote maintenance) · Hardware maintenance, software maintenance · Contract maintenance 4.10 system Evaluation · Performance Evaluation · Economic Benefits 5. Safety Knowledge · Data Security and Confidentiality, Encryption and Decryption Mechanism · Communication and Network Security · System Access Control Technology · Database Integrity · Computer Security Operation · Computer Fault Diagnosis and Prevention, Prevention and Treatment Virus, anti-computer crime, invasion monitoring, safety management measures, relevant laws, regulations, systems, risk management and analysis (risk type, anti-risk measures and internal control) 6. Concepts of standardization knowledge · Standardization (standardization, standardization Development, standard life cycle) · Standard level (international standard, industry standard, local standard, corporate standard, project norm) · standard object (code standard, file format standard, security standard, software development specification, document standard) · Standardization Institutions 7. Economics and other related knowledge · Accounting common sense · Financial Cost Management · Modern Enterprise Organization · IT audit related common sense (auditing standard, auditing implementation and auditing report) 8. Mathematics · Event and probability, random variables and distribution functions · Logic · Figure, Combination Analysis, Algorithm and Its Complex 9. Management Science · Operation Practice Model · System Model · Quantity Economic Model · System Engineering 10. Professional English · English Words with University Graduation · Can Skilled Reading and Accuracy Understanding the relevant field English scientific literature exam subject 2: Information system analysis and design case 1. System plan · Proposal and selection of information system projects, the determination of project priority · Business evaluation based on management level · According to the current situation Analysis, feature, architecture, capability, maintenance application method and difficult situation of information systems, analysis, feasibility study and efficiency analysis, system plan, evaluation, and improvement, analysis and comparison, legacy system evaluation and processing Strategy · Required Resource Estimation · Existing Software, Hardware and Data Resources Effective Utilization · Technical Research and Evaluation of Enterprise Information Strategy · Develop Information Systems · Program Change and Control 2. Demand Getting · Business Model Extraction And graphical and documentation · Object business flow Extraction and confirmation · From the viewpoint of the information system to confirm the content for confirmation · Analysis and Solution of business problems · Explore the existing software system for business functions · All object services and business function integration · Analysis of existing software systems · Confirmation test plan · Popular demand analysis method · Prerequisites (personnel, delivery and cost, etc.) are satisfaction and in termination of technology, economy, etc. 3. Systematic analysis, organizational structure and function analysis · Business process Analysis · Data Summary and Data Process Analysis · System Function Division and Data Resources Distribution · The Establishment of Topics Database · Cost / Benefits Analysis · Systematic Fault Model and Reliability Model · System Reliability Analysis and Reliability Calculation · Improve System Reliability Measures · System's fault countermeasures and systematic backup and recovery · System analysis practical technology · Popular system analysis method 4. System design 4.1 Modeling technology · Modeling and significance • Steps for demand modeling · Use case driven Development method · Conceptual model and design model · Structured modeling technology, data flow map · Object-oriented modeling technology · Reverse engineering · Define issues and concatenation models (target, function, performance, etc.)
· Database Modeling 4.2 System Design · System Architecture · Treatment Process Design · System Hand Interface Design · Database Management System Selection and Database Design · System Document Design · System Security Design · Computer Application in Network Environment · Distributed application system design · Multimedia application system design · System operation environment integration and design, system processing capacity assessment, system test planning implementation · System conversion plan 5. Documentation and communication skills · Information strategy documentation · Information System Contest Documentation · Feasibility Research Report · Project Development Plan · Demand Specifications · Data Demand Specifications · User Manual · Operation Manual · Test Plan, Test Analysis Report · Technical Report · Development Schedule · Project Development Summary Report 6 System Operation Maintenance · System Transformation Demand Basic Method (Database Conversion, Network Environment Conversion, Transformation and Change of Business Specifications) · Software Maintenance Implementation and Management · System Software and Hardware Configuration Management · Tracking · Basic Software and Software Package, Application, Management, and Secondary Development · System Integration and Exchangement · Operation Design and Operation Management · System Update and Maintenance · Short-term Program and Long-Term Plan · Conversion of New Old Systems · Daily Fault Countermeasures and Recovery · Systematic safety management · System service quality and application evaluation 7. Software process improvement · Software process improvement system design · Software process improvement skills · Software process improvement tools 8. System development project management · Progress Management · Cost Management · Quality Management · Purchasing Management · Risk Management · Resource Management 9. Enterprise Information Strategy and Implementation · Information Planning and Strategic Planning · Concept, Event and Role of Information Planning, Information System Planning Method · Enterprise Process Recombination · CIO Concept and Main Responsibilities · Management Consultation In Information Technology and Significance · The Type of Management Consultation · The Current Situation of China 's Management Consultation · "Informatus" Formation Sound, Prevention, and Credit Measures · Typical Information Implementation process · The meaning of knowledge management · Knowledge management to organize informationization Significance and means of knowledge management, tools and means test subjects 3. Information system analysis and design papers, based on four papers related to system analysis design, and choose one of the questions, and write papers according to the requirements. The content of the paper is as follows: 1. Information system project, system plan and analysis · Demand analysis and definition · System maintenance · Project management · Quality assurance · Object-oriented technology · Computer aid software project · Software process improvement · Real-time system Development · Application System Analysis Design (Embedded System, Data Warehouse, Internet Application, etc.) 2. Database Engineering · Database Analysis · Database Modeling · Database Management 3. System Security · Data Security · Network Security · Fault Tolerance 4. Application System Integration · Integrated Object · Integrated Method · Integrated Tools 5. Enterprise Informatization and Government Informationization · Strategies and Strategies · Organization and Implementation · Methods and Step 6. New Technology Application · Extreme Programming (XP) · Agile Development
Network Administrator-Level Exam Outline 1. Examination Description 1, Exam Notes 1. Exam requirements: (1) Familiar with the basic knowledge of computer system; (2) Familiar with data communication; (3) Familiar with the architecture of computer networks, understand the basic knowledge of TCP / IP protocol; (4) Familiar with common computer network interconnection The performance, characteristics of the equipment and communication transmission media; (5) Familiar with the basic knowledge and application of the Internet; (6) Master the local area network architecture and local area network technology foundation; (7) Master the performance, characteristics, networking methods, and simple management of Ethernet (8) Master the installation, setting, and management method of the mainstream operating system; (9) Familiar with the configuration and management of DNS, WWW, Mail, FTP and proxy servers; (10) Master the establishment, management and maintenance method of the web site, familiar Web Page Production Technology; (11) Familiar with Integrated Wiring Basics; (12) Be familiar with relevant issues and prevention techniques of computer network security; (13) Learn about the basic knowledge of law, regulations, and informationization related to computer networks; (14) understand New technology, new development of computer networks; (15) to read and understand simple English materials in the art. 2. The qualified personnel of this exam can carry out the design, construction, installation, and debugging of small network systems. The operating maintenance and daily management of small and medium-sized local area networks is based on the needs of the application department, build and maintain web websites. Web production, assistant engineers (or The actual work ability and business level of technicians). 3. The subjects of this exam include: (1) Basic knowledge of computer and network, the test time is 150 minutes, written test; (2) Management and maintenance of network systems, the test time is 150 minutes, written test. Second, the examination scope test subject 1: computer and network basics
1. Computer Science Foundation
1.1 Norm and its conversion binary, decimal and hexadecimal and other common numerics and mutual conversion
1.2 Representation of data (original code, reaction, complement indication, integer, and real number) Non-numerical representation (character and Chinese characters, sound representation, image represented) check method and check code (parity) check)
1.3 Differential arithmetic method in arithmetic computing computer
2. Computer system basics
2.1 Hardware Basics Computer System Structure and Working Principle CPU Structure, Features, Classification and Development of Memory Structure, Feature Classification and Development I / O Interface, I / O Equipment and Communication Equipment
2.2 Software Basics Operating System Type, Configuring the Functional Database System Basics Application Software for Functional Database System Basics Application and Configuring Network Management Software
3. Computer network basics
3.1 Data communication basic knowledge data signal, basic concept data communication model constitutes data transmission basic knowledge data encoding classification, basic principles and application domain data exchange technology classification, basic principle and Performance characteristics
3.2 Computer Network Basic Knowledge Computer Network Concept, Classification and Composition of Protocols, Open System Interconnect Reference Model Structure and Function TCP / IP Protocol Concept and IP Datebook Format, IP Address, Subnet Mask And domain name
3.3 LAN Technology Basic IEEE802 Reference Model Local Domain Net Trumpet Structure LAN Media Access Control Technology CSMA / CD Ethernet Development History Ethernet Classification and Various Ethernet Performance Features Ethernet Technology Foundation, IEEE802.3 Frame Structure, Ethernet Spacing The basic principles and characteristics of the exchange type Ethernet, the full duplex Ethernet 4. Computer network application basics
4.1 Internet Application Basic Knowledge Internet Concept, Original and Provided Basic Service, and my country's Internet Current Situation Through PSTN, ISDN, ADSL, and LAN Dollar Basic Principles and Features WWW, Home, Hyperlink, HTML concept and Application Electronics Mail, FTP, Telnet, BBS, ICQ, network news group, network fax, network video conference, e-commerce and e-government concept and application
4.2 Network Operating System Basic Knowledge Network Operating System Concept, Structure and Features Windows Operating System Installation, Configuration, and Basic Application Linux Operating System Installation, Configuration, and Basic Application, KDE Environment and Linux Operation Commands
4.3 Application Server Basic Knowledge DNS Service Basic Principles WWW Service Basic Principles FTP Services Basic Principles Email Service Basic Principles
5. Network management basics
5.1 Network Management Basic Concept Network Management Concept, Function, Network Management Standards, Network Management Model Simple Network Management Protocol SNMP Overview, Management Information Library, SNMP
5.2 Network Management System Basic Knowledge Network Management System Concepts Sniffer Features and Features
6. Network Security Basic Knowledge Trusted Computer System Evaluation Guidelines Network Security Vulnerability Network Security Control Technology Firewall Basic Principle Intrusion Detection System Features and Basic Principle Vulnerability Scanning System Features and Basic Principles Network Antivirus System Features and Basic Principles CA Center Construction Concept And basic principles of disaster recovery system emergency treatment common methods and techniques
7. Standardized basic knowledge standardization institutions commonly used domestic and foreign IT standards
8. Legal, regulations related to the concept of informationization basic knowledge informationization
9. New technologies related to network systems, concept wireless personal network, wireless local area network, wireless metropolitan network and wireless wide area network Topology, media access control method and spread spectrum technology, IEEE802.11 new generation network management New generation network technology (IPv6, 3G) network
10. Professional English Master Computer Technology Essential English Vocabulary Correct Reading and Understanding Simple English Data
Exam subject 2: Management and maintenance of network systems
1. Construction Network Design Network Technology Selection Network Device Selection and Deployment Device Configuration and Managing Division of Small Computer Local Area Network
2. Integrated wiring integrated wiring concept, composition, design and basis for standard integrated wiring basic environment preparation cable and related hardware to install the performance indicators and test flows of integrated wiring systems
3. Small computer local area network server configuration
IP address, subnet mask planning configuration DNS server planning, setting, and maintenance (Linux environment and Windows environment) Email server planning, setting, and maintenance (Linux Environment, Windows Environment) FTP Server Plan, Set, and Maintenance ( Linux Environment and Windows Environment) Agent Server Planning, Setting, and Maintenance (Linux Environment and Windows Environment) DHCP Server Installation & Setup
4. Establishment, management and maintenance of web websites, construction, management and maintenance of web networks to use HTML and related software for web design and production (such as Photoshop, Flash, Fireworks or Dreamweaver, etc.) JSP, ASP, XML and other dynamic web pages Basic concept of programming technology
5. The operation, maintenance and management of the network system uses network management software to monitor, safe, performance, fault, billing for network management software, monitoring, positioning, diagnosis, and excluding small network maintenance strategies, planning, and implementation data for simply network failures. Backup and data recovery system performance analysis, system potential problem analysis
6. Firewall Technology Network Virus Protection Strategy Firewall Configuration Policy Intrusion Processing Policy Vulnerability Processing Strategy Exam Test Subject 2: Management and Maintenance of Network Systems 1. Construction Network Design Network Design Networking Technology Selecting Network Device Selection and Deployment Device Configuration and Managing Division VLAN2. Integrated wiring integrated wiring concept, composition, design and basis for standard integrated wiring basic environment preparation cable and related hardware to install the performance indicators and test flow 3 of the integrated wiring system. Small Computer LAN Server Configuring IP Address, Subnet Mask Planning Configuring DNS Server Planning, Setting, and Maintenance (Linux Environment and Windows Environment) Email Server Planning, Setting, and Maintenance (Linux Environment and Windows Environment) FTP Server Plan , Set and maintain (Linux Environment and Windows Environment) Proxy Server Planning, Setting, and Maintenance (Linux Environment, Windows Environment) DHCP Server installation and setting 4. Establishment, management and maintenance of web websites, construction, management and maintenance of web networks to use HTML and related software for web design and production (such as Photoshop, Flash, Fireworks or Dreamweaver, etc.) JSP, ASP, XML and other dynamic web pages Basic concept of programming technology 5. The operation, maintenance and management of the network system uses network management software to monitor, safe, performance, fault, billing for network management software, monitoring, positioning, diagnosis, and excluding small network maintenance strategies, planning, and implementation data for simply network failures. Backup and Data Restore System Performance Analysis, System Potential Issues Analysis 6. Firewall Technology Network Virus Protection Policy Firewall Configuration Policy Intrusion Processing Policy Vulnerability Processing Policy
Network Engineer Level Examination Outline 1, Exam Notes 1. Exam requirements (1) Familiar with the basic knowledge of computer systems; (2) Familiar with the basics of network operating systems; (3) understand the design and development method of computer application system; (4) Familiar with data communication; (5) familiarity Basic knowledge of system security and data security; (6) Master the basic technology and main security protocols and security systems of network security; (7) Master the basic principles of computer network architecture and network protocols; (8) Master computer network Standardization knowledge; (9) Mastering LAN network technology, understanding the basic technology of urban area network and wide area network; (10) Master computer network interconnection technology; (11) Master the networking method and network application service technology of TCP / IP protocol network; (12) ) Understanding access network and access technology; (13) Master the basic principles and operation methods of network management; (14) Familiar with the basic performance testing and optimization technology of network systems, and reliability design technology; (15) understanding network applications Basic principles and technologies; (16) Understanding network new technologies and development trends; (17) Learn about legal and regulations related to intellectual property and Internet; (18) Read and understand English materials in the art correctly. 2. Through the qualified personnel of this level, the network system's planning, design, and software and hardware installation and commissioning work of network system can be used according to the requirements of the application department, and the operation, maintenance and management of network systems can be used to efficiently, reliable and safely manage the network. Resources; technical support and guidance for system development as network professionals; the actual work ability and business level of engineers can guide assistant engineers engage in the construction and management of network systems. 3. The subjects set by this level include: (1) Computer and network knowledge, test time is 150 minutes, written test; (2) network system design and management, the test time is 150 minutes, written test.
Second, the examination scope test subject 1: Computer and network knowledge 1. Computer System Knowledge 1.1 Hardware Knowledge 1.1.1 Computer Structure · Computer Composition (Computer, Controller, Memory, Memory, I / O Part) · Instruction System (Instruction, Addressing Mode, CISC, RISC) · Multiprocessor (Tight coupling system, loosely coupled system, array processor, dual-machine system, synchronization) · Processor performance 1.1.2 memory · storage medium (semiconductor memory, magnetic memory, optical memory) · Storage system · Main memory and co-storage Main memory type, main memory capacity, and performance · Main memory configuration (main memory parity, cross access, multi-stage main memory, main memory protection system) · Cache · Calculation of auxiliary device 1.1.3 input Output structure and equipment · I / O interface (interrupt, DMA, channel, SCSI, parallel interface, general interface bus, RS-232, USB, IEEE1394, infrared interface, input and output control system, channel) · Input output device type and characteristics 1.1.4 Embedded System Basics 1.2 Operating System Knowledge 1.2.1 Basic Concept · Operating System Definition, Features, Features, Functions and Classification (Batch, Time, Real Time, Network, Distributed) · Multi-Digital Program · Core and Interrupt control, process and thread 1.2.2 processor management, storage management, device management, file management, job management, process status and conversion · Scheduling algorithm (minute rotation, priority, preemptive) · Dead lock · Storage management Program (segmentation and paging, false memory, page replacement algorithm) · Relevant technology for equipment management (spooling, buffering, DMA, bus, plug-and-play technology) · File management, sharing and security (sharing method, reliability and security Sex, recovery processing, protection mechanism) · The status and conversion of the job · Job scheduling algorithm (first serve, short homework, high response ratio) 1.3 System configuration method 1.3.1 System configuration technology · System architecture mode ( 2 floors, 3 layers and multi-layers C / S and B / S systems) · System configuration method (duplex, duplex, thermal backup, fault tolerance, tight coupling multi-processor, loosely coupled multi-processor) · Treatment mode (concentrated , Distributed, batch, real-time system, web computing, mobile computing) 1.3.2 System performance · Performance design (system adjustment, response characteristics) · Performance indicator, performance evaluation (test benchmark, system monitor) 1.3.3 system can Reliability, reliability calculation (MTBF, MTTR, availability, failure rate) · Reliability design (distribution and estimation of failure, soft failure, component reliability and system reliability) · Reliability index and reliability assessment, RAS (Reliability, availability and maintenance) 2. System Development and Running Basics 2.1 System Development Basics 2.1.1 Demand Analysis and Design Method · Demand Analysis · Structured Analysis Design · Object - Oriented Design · Module Design, I / O Design, Man Up Design 2.1.2 Development Environment · Development Tool (Design Tool, Programming Tool, Test Tool, Case) · Centralized Development Environment 2.1.3 Test Review Method · Test Method · Review Method · Test Design and Management (Injection Fault, System Test)
2.1.4 Project Management Basic Knowledge · Develop Project Plan · Quality Program, Management and Evaluation · Process Management (PERT Figure, Gantti, Work Decomposition Structure, Progress Control, Key Path) · Configuration Management · Personnel Program and Management · Document Management (Document Specifications, Change Procedures) · Development Organization and Role (Development Group Member, Project Manager) · Cost Management and Risk Management 2.1.5 System Audit · Audit Method, Audit Tracking · Incorporation and Audit 2.2 System Run and Maintenance Knowledge 2.2.1 System Run · System Operation Management (Computer System, Network) · System Cost Management · System Run (Job Scheduling, Data I / O Management, Operation Manual) · User Management (ID Registration and Management) · And facility management (power, air conditioning equipment, equipment management, facility security and management) · System fault management (handling procedures, monitoring, recovery process, precautions) · Safety management · Performance management · System running tool (automated operating tools, monitoring tools , Diagnostic tools) · System conversion (transfer phase, running test, version control) · System run service standard 2.2.2 system maintenance · Maintenance type (perfect maintenance, error correction maintenance, adaptive maintenance, preventive maintenance ) · Maintenance implementation (daily inspection, regular maintenance, preventive maintenance, post-maintenance, remote maintenance) · hardware maintenance, software maintenance, maintenance contract 3. Network Technology 3.1 Network Architecture · Network Topology · OSI / RM · Application Layer Agreement (FTP, Telnet, SNMP, DHCP, POP, SMTP, HTTP) · Transport Layer Protocol (TCP, UDP) · Network Layer Protocol IP (IP Address , Subnet mask) · Data link layer protocol (ARP, RARP, PPP, SLIP) · Physical address (unicast, broadcast, multicast) 3.2 encoding and transmission 3.2.1 Modulation and encoding · AM, FM, PM, QAM · PCM, Sampling 3.2.2 Transmission Technology · Communication (Single Work / Half Duplex / Full Duplex, Serial / Parallel, 2 Line / 4) · Error Control (CRC, Haiming Code, parity, Bit Error Rate) · Synchronous Control (Synchronization, Syn Synchronization, Synchronization, Frame Synchronization) · Multiplexed (FDM, TDM, WDM) · Compression and Decompression Method (JPEG, MPEG, MH, MR, MMR, Length 3.2.3 Transmission Control · Competitive System · Polling / Selection System · Basic Regulations, Multi-Link Procedures, Transmission Control Characters, Line Control · HDLC 3.2.4 Switching Technology (Circuit Exchange, Storage Forwarding, Packet Exchange, ATM Exchange, Frame Relay) 3.2.5 Public Networks and Rental Lines 3.3 Networks 3.3.2 Network Classification · According to Regional Classification (LAN, MAN, WAN) · By Service Classification (Internet, Enterprise Internal Network) · Classified by Transport Media (Phone, Data , Video) · Classification (station, access, backbone) 3.3.2 lan · LAN topology (bus type, star, ring)
· Access control system (CSMA / CD, token ring, token bus) · Connection between LAN-WAN, peer-to-peer connection, point-to-peer connection · High-speed LAN technology (Gigabit Ethernet) · Unlimited LAN 3.3. 3 MAN Common Structure 3.3.4 WAN and Remote Transport Service · Rental Line Service, Line Exchange Service, Packet Exchange Service · ISDN, VPN, Frame Relay, ATM, IP Connection Service · Satellite Communication Service, Mobile Communication Service, International Communication Service 3.3.5 Internet · Internet Concept (Internet Interconnect, TCP / IP, IP Routing, DNS, Proxy Server) · Email (Protocol, Mail List) · Web (HTTP, Browser, URL, HTML, XML) · File Transfer (FTP) · Search Engine (full-text search, directory search, intelligent search) · QoS, CGI, VoIP 3.3.6 Access Network and Access Technology 3.3.7 Network Performance · Calculation of Line Performance (Transmission Speed, Line Utilization , Line capacity, traffic, traffic design, performance evaluation, queuing application 3.4 Network communication device 3.4.1 Transport medium and communication cable · Wired / wireless medium (twisted pair, coaxial cable, fiber; radio wave, light , Infrared) · Distribution Mount (IDF), Main Mount Floor (MDF) 3.4.2 Various communication equipment · Line Terminal Equipment, Multi-channel Equipment, Exchange Equipment, Transfer Equipment · Line Connection Equipment (Modem, DSU, NCU , TA, CCU, PBX) 3.5 Network Connection Equipment · Internet Connection Equipment (Gateway, Bridge, Generated Tree Bridge, Source Routing Bridge, Router, Repeater, Hub, Switch) 3.6 Network Software System 3.6.1 Network Operation System · Network Operating System Features, Classification, and Features · Network Equipment Drivers (ODL, NDIS) · Network Communication System Function Call (Socket API) · RPC · TP Monitor · Distributed File System · Network Device Function 3.6 .2 Network Management · Network Management Domain (Safety Management, Configuration Management, Fault Management, Performance Management, Billing Management) · Network Management Protocol (CMIS / CMIP, SNMP, RMON, MIB-II) · Network Management Tools (PING , Traceroute, Netxra Y, Analyzer, Sniffer · Network Management Platform (OpenView, NetView, Sunnet Manager) · Distributed Network Management 3.6.3 Network Application & Services · WWW · FTP File Transfer · Email · Telnet · Information Search · Video Oncast · Network Conference · Distance education, e-commerce, e-government, CSCW and group parts 4. Network Security 4.1 Safety Calculation 4.1.1 Profight and Integrity · Private Key and Public Key Encryption Standard (DES, Idea, RSA) · Certification (Digital Signature, Identification) · Integrity (SHA, MD5) · Access Control (Save " Relief, password)
4.1.2 illegal intrusion and virus protection · Firewall · Intrusion Testing · VPN, VLAN · Security Agreement (IPSEC, SSL, ETS, PGP, S-HTTP, TLS) · Hardware Security · Computer Virus Protection 4.1.3 Availability · File Backup and Recovery 4.1.4 Security Protection · Personal Information Control · Anonymous · Unsable 4.1.5 LAN Safety · Network Equipment Reliability · Coping Natural Disaster · Environmental Security · UPS 4.2 Risk Management 4.2.1 Risk Analysis and Evaluation 4.2 2.2 Countermeasures for the risk · Risk prevention (risk transfer, risk fund, computer insurance) · Accidental accident (accidental accident category, action plan to accident accident) 4.2.3 Internal control · Safety rules and regulations, security strategies and safety management 5. Standardization Knowledge 5.1 Standards and Obtain 5.1.1 Standards and Acquisition Processes 5.1.2 Environmental and Safety Assessment Standardization 5.2 Information System Infrastructure Standardization 5.2.1 Standards · International Standards (IEC) and US Standards (ANSI) · National Standard (GB) · Industry Standards and Enterprise Standards 5.2.2 Open System (X / Open, OSF, POSIX) 5.2.3 Data Exchange Standard (EDIFACT, STEP, XML) 5.2.4 Security Standard · Information System Security Measures Standard · Computer Anti-Virus Standard · Computer Anti - law Access Standards · CC Standards · BS7799 Standards 5.3 Standardization Organization · International Standardization (ISO, IEC, IETF, IEEE, IAB, W3C) · US Standardization Organization · European Industrial Standardization Organization · China Standardization Committee 6. Informatization Basic Knowledge · Information Consciousness · Global Informatization Trend, National Informatization Strategy, Enterprise Information Strategy and Strategy · Enterprise Information Resource Management Basic Knowledge · Law, Regulatory Knowledge · Personal Information Protection Rule 7. Computer Professional English · Basic Words of Computer Technology · Correctly Reading and Understanding English Data Sheets in Computer Sports 2: Network System Design and Management 1. Design and Construction of Internet Systems 1.1 Demand Definition of Network System 1.1.1 Application Demand Analysis · Research (Application System Performance, Information Generation and Receive Point, Data Quantity, Data Type and Data Streaming) · Network Application Analysis 1.1.2 Existing Network System Analysis · Existing Network Architecture Research (Number and location of the server, the number and location of the client, the number of users, the number of users per day, each time S, each time Data transmission data, network congestion time, adopted protocol, communication mode) · Existing network architecture analysis 1.1.3 Demand definition · Functional requirements (function to be implemented) · Communication requirements (desired communication mode) · Performance requirements (desired performance) · Reliability requirements (expected reliability) · Safety requirements (safety standards) · Maintenance and operational demand (cost and maintenance costs) · Management requirements (management strategy)
1.2 Design of Network System 1.2.1 Research and Evaluation of Technical and Products · Collection Information · Comparative Study of Technical and Products Adopted · Comparison of Technologies and Equipment 1.2.2 Design of Network System · Determination Protocol · Determine Topology · Determine the connection (communication performance) · Determine the node (node processing power) · Determine the performance (performance simulation) of the network · Determining reliability measures · Determining security measures (safety measures to achieve safety measures Assessment of technical and equipment) · The choice of network equipment, the development of selection standards (cost, performance, capacity, processing volume, delay), performance index consistency, high-level testing necessity, interconnect confirmation 1.2.3 new network Business Operation Plan · Business Process Confirmation · Installation Plan · Convert to New Network Schedule 1.2.4 Design Review 1.3 Network System Construction and Test 1.3.1 Installation Work · Pre-Preparation · Process Supervision 1.3.2 Test and Evaluation · Connection Test · Safety test · Performance test 1.3.3 Convert to new network work plan 2. Network system operation, maintenance management, evaluation 2.1 Network system operation and maintenance 2.1.1 User measures · User management, user training, users negotiation 2.1 .2 Develop maintenance and upgrade strategies and programs · Determine strategy · Device's addressing · Review time · Upgrade time 2.1. Implementation of maintenance and upgrade · External contractual points · Internal implementation points 2.1.4 Backup and data recovery · Data Storage and Disposal • Backup • Data Recovery 2.1.5 Configuration Management of Network Systems · Device Management · Software · Network Configuration Figure 2.2 Management 2.2.1 Network System Monitoring · Network Management Agreement (SNMP, MIB-2, RMON) · Using Tool Surveillance Network Performance (LAN Monitor) · Using Tool Surveillance Network Fault · Using Tool Surveillance Network Security (Intrusion Detection System) · Checkpoints for Performance Monitor · Line Failure Check Points · Safety Monitor Checkpoint 2.2.2 Fault Recovery Analysis · Fault Analysis Key Point (LAN Monitor) · Exclusion Failure Points · Fault Report Writing Point 2.2.3 System Performance Analysis · System Performance Analysis Point 2.2.4 Hazard Security Countermeasures · Hazard Safety Analysis (Investigation Loss Killing Virus Measures) 2.3 Evaluation of Network System 2.3.1 System Evaluation · Systematic Restrictions · Potential Issues Analysis · System Evaluation Point 2.3.2 Improved Systems · System Life Cycle · System Economic Benefits · Systematic Expandability · It is recommended to improve the key points of the system. 3. Network system implementation technology 3.1 Network protocol · Commercial Network Protocol (SNA / Appn, IPX / SPX, AppleTalk, TCP / IP) · Business Protocol (XML, CORBA, COM / DCOM, EJB) · Web Service (WSDL, SOAP, UDDI)
3.2 Reliability Design · Hardware High Reliability Technology · Software High Reliability Technology · System Maintenance High Reliability Technology · Fault Tolerance Technology · Communication Quality 3.3 Network Facilities 3.3.1 XDSL Modem 3.3.2 ISDN Router · Interface · Function (Non-Communication Control Function, NAT function) 3.3.3 FRAD (Frad / Disassembly), CLAD (Cell Assembly / Disassembly) · Interface · Function 3.3.4 Remote Access Server · Function and Mechanism 3.3.5 Office Personal Handheld System (PHS) · Functional characteristics of digital cordless phones 3.3.6 Relay Hub · Baxi Hub (Functions and Mechanisms) 3.3.7 L2, L3, L4 and Multi-layer Switches Functions and Mechanism 3.3.8 IP Router Functions and Control 3.3.9 Virtual Network (Function and Mechanism) 3.3.10 Coexistence with other protocols (multi-protocol router, IP tunnel) 3.4 Network Application Services 3.4.1 Address Service · Mechanism, DHCP, IPv6 (Mechanism and Transmission Technology) 3.4.2 DNS (Function, Mechanism ) Domain name, FQDN 3.4.3 Email (function, mechanism) · SMPT, POP, MIME, IMAP4, LDAP · Mail list · Web Mail 3.4.4 Electronic News (Functions and Mechanism, NNTP) 3.4.5 Web Services (Function And mechanism, http 3.4.6 load distribution (web exchange) 3.4.7 Electronic authentication (function, mechanism, certification authorization, electronic certificate) 3.4.8 Services, service providers, supplier roaming services, dial-up IP connections, CATV connection, IP phone, Internet broadcast, multicast, e-commerce, e-government, mobile communication, ezWeb, host service provider, EDI (rules, form, web EDI), B2B, B2C, ASP, Data Center 4. Network New Technology 4.1 Fiber Object Network · ATM-PDS, STM-PDS · Passive Optical Network PON (APON, EPON) 4.2 Wireless Network · Mobile Phone System (WLL, WCDMA, CDMA2000, TD-SCDMA) · High Speed Fixed Wireless Access (FWA) · 802.11a, 802.11b, 802.11g · Microwave access (MMDS LMDS) · Satellite Access · Basket access 4.3 Main network · iPoversonEt / SDH · iPoverOverOptical · iPoverDWDM 4.4 Communication service · All-weather IP connection service (rental line IP service) · Local IP network (NAPT) · IPv6 4.5 network management · TMN-based network management · Cormba's network management 4.6 grid settlement
Database System Engineer Level Test Outline 1. Examination Description 1. Examination Requirements (1) Master the computer architecture and the performance and basic working principle of the major components; (2) Master the basic knowledge of the operating system, programming language, understand the compiler Basic knowledge; (3) Proficiency in the common data structure and common algorithm; (4) Familiarity with software engineering and software development project management; (5) Be familiar with the principle and technology of computer network; (6) Master database principle and basic theory (7) Master the application technology of common large database management systems; (8) Master the design method and development process of database application system; (9) Familiar with database system management and maintenance methods to understand relevant security technology; (10) Understand database development trends and new technologies; (11) Master common information technology standards, safety, and basic knowledge about laws, regulations; (12) understanding the basics of informationization, computer applications; (13) Correct reading and understanding your computer Field English information. 2. Can participate in the application of information system planning, design, construction, operation and management, can design, establish, run, maintain high-quality database and data warehouse according to user needs, design, establish, run, maintain high-quality database and data warehouse; as data administrator management information The data resources in the system are established and maintained as a database administrator; serving the technical support related to the database system, with a certain network structure design and networking capabilities; the actual work ability and business level of the engineer can guide computer technology. Work with the software professional assistant engineer (or technician). 3. The subjects of this exam include (1) information system knowledge, test time is 150 minutes, written test; (2) database system design and management, test time is 150 minutes, written test.
Second, III Test Subject 1: Information System Knowledge 1. Computer System Knowledge 1.1 Hardware Knowledge 1.1.1 Computer Architecture and Major Working principle · CPU and memory composition, performance, basic working principle · Common I / O equipment , The performance of the communication device, and the basic working principle · I / O interface function, type and feature · CISC / RISC, pipeline operation, multi-process machine, parallel processing 1.1.2 storage system · Virtual memory basic working principle, multi-level storage System · RAID Type and Features 1.1.3 Security, Reliability and System Performance Evaluation Basics · Diagnostics and Fault Tolerance · System Reliability Analysis · Computer System Performance Evaluation Method 1.2 Data Structure and Algorithm 1.2.1 Common Data Structure · Arrse ( Static array, dynamic array) · Linear table, linked list (one-way linked list, two-way linked list, cyclic chain table) · Stack and queue · tree (binary tree, find tree, balance tree, traversal tree, heap), diagram, collection definition, storage And operation · Hash (storage location calculation, collision processing) 1.2.2 Common algorithm · Sort algorithm, find algorithm, numerical calculation, string processing, data compression algorithm, recursive algorithm, diagram related algorithm, algorithm and data structure, Algorithm efficiency, algorithm design, algorithm description (flow chart, pseudo code, decision table), algorithm complex 1.3 software knowledge 1.3.1 Operating system knowledge · Operating system type, feature, status, kernel (interrupt control), process, Thread concept · Processor management (status conversion, synchronization with mutual exclusion, signal light, minute rotation, preemptive, deadlock) · Storage management (main memory protection, dynamic connection assignment, segmentation, paging, false memory) · Equipment management ( I / O control, spool, disk scheduling) · File management (file directory, architecture and organization, access method, access control, recovery processing, sharing, and security) · Job management (job scheduling, job control language (JCL), multi-channel programming) · Chinese character processing, multimedia processing, human-machine interface · network operating system and embedded operating system basic knowledge · Operating system configuration 1.3.2 Programming language and language handler knowledge · Compilation, Compile, interpretation of the basic knowledge of the system and basic working principle · Programming language basic ingredients: data, operation, control and transmission, implementation mechanism for program calls · Main features and applicable cases of various programming languages 1.4 Computer Network Knowledge · Network Architecture (network topology , OSI / RM, Basic Network Protocol) · Transmission Media, Transmission Technology, Transmission Method, Transmission Control · Common Network Equipment and Various WITTS · Client / Server Structure, Browser / Web / Datebase Structure · LAN Topology, access control, LAN network, LAN-WAN connection, LAN-WAN connection · Internet basics and applications · Network software · Network management · Network performance analysis · Network-related laws and regulations 2. Database technology 2.1 database technology foundation 2.1.1 Database Model · Database Systems Level 3 Model (Conceptual Model, Outer Mode, Internal Mode), Two - level Image (Conceptual Mode / Outer Mode, Outer Mode) · Database Model: Composition Elements of Data Model, Concept Data model ER diagram (entity, attribute, relationship)
, Logical data model (relational model, hierarchy model, network model) 2.1.2 Database management system features and characteristics (database definition, database operation, database control, transaction management, user view) · Features (ensure data independence , Data inventory, simultaneous execution process, row it control, fault recovery, security, integrity) · RDB (relational database), OODB (object-oriented database), ORDB (object relational database), NDB (mesh database) · Several common web databases 2.1.3 Database System Architecture · Centralized Database System · Client / Server Database System · Parallel Database System · Distributed Database System · Object Relational Database System 2.2 Data Operation 2.2.1 Relationship Operation · Relationship Algebra Calculation (and, passion, Cartesi) Define (Table, View, Index, Constraint) · Data Operation (Data Retrieval, Data Insert / Removal / Update, Trigger Control) · Security and Authorization · API in Program, Embed SQL 2.3 Database Control, Database Transaction Management (ACID Property) · Database Backup and Recovery Technology (Undo, REDO) · Concurrent Control 2.4 Database Design Basics 2.4.1 Relationship Database Design · Function Dependence · Standardization (First Paradigm, Second Paradise, Third Paradigm, BC Paradigm, fourth paradigm, fifth paradigm · Mode decomposition and decomposition should follow the principle 2.4.2 Object Relational Database Design · Nested Relationship, Complex Type, Inheritance and Reference Type · Inquiry and SQL in SQL And Process · Object Relationship 2.5 Data Mining and Data Warehouse Basic Knowledge · Data Mining Application and Classification · Association Rules, Clustering • Data Warehouse Composition · Data Warehouse Model 2.6 Multimedia Basic Knowledge 2.6.1 Multimedia Technology Basic Concepts · Multimedia System Foundation Knowledge · Common Multimedia Format 2.6.2 Multimedia Compression Coding Technology · Multimedia Compression Coding Technology · Statistics Coding · Forecast Coding · Coding International Standard 2.6.3 Multimedia Technology Application · Simple graphical drawing, image file processing method · Application of audio and video information · Multimedia application development process 2.7 system performance knowledge · Performance calculation (response time, throughput, turnaround time) · Performance index and performance design, performance testing and performance Evaluation 2.8 Computer Application Basics · Information Management, Data Processing, Association, Scientific Calculation, Artificial Intelligence, etc. Software Development Project Management Knowledge · Software Engineering Knowledge · Software Development Life Cycle Stage Target and Task · Software Development Project Basics (Time Management, Cost Management, Quality Management, Human Resource Management, Risk Management, etc.) and its common management tools · Main Software development method (life cycle method, prototype method, object-oriented method, case)
· Software Development Tools and Environmental Knowledge · Software Quality Management Basic Knowledge · Software Process Improvement Basic Knowledge · Software Development Process Assessment, Software Ability Maturity Assessment Basics 3.2 System Analysis Basic Knowledge · System Analysis Purpose and Tasks · Structured Analysis Method (Data Flow Drawings (DFD) and Data Dictionary (DD), Entity Diagram (ERD), Description Processing Structured Language) · Unified Modeling Language (UML) · System Specifications 3.3 System Design Knowledge · System Design And tasks, structured design methods and tools (system flow chart, HIPO diagram, control flow chart) · System overall structural design (overall layout, design principle, module structure design, data access design, system configuration scheme) · System detailed design (Code Design, Database Design, User Interface Design, Process Design) · System Design Manual 3.4 System Implementation Knowledge · System Implementation Main Tasks · Structured Program Design, Object-Oriented Program Design, Visual Program Design · Program Design Language Selection, Program design style, system test, type, system test method (black box test, white box test, gray box test) · Test design and management (error curve, error exclusion, convergence, injection failure, test trial design, system Test Report) · System Conversion Basics 3.5 System Operation and Maintenance Knowledge · System Operation Management Knowledge · System Maintenance Knowledge · System Evaluation Knowledge 4. Security Knowledge · Safety Basic Concept (Network Security, Operating System Security, Database Security) · Computer Virus prevention, computer crime prevention, disaster recovery, access control, anti-intrusion, safety management measures · Encryption and decryption mechanism · Risk analysis, risk type, anti-risk measures and internal control 5. Standardization knowledge · Standardization awareness, standardization Development, standard introduction process · International standard, national standard, industry standard, enterprise standard basic knowledge · code standard, document format standard, safety standard software development norms and document standards · Standardization agencies 6. Informatization Basic knowledge · Information awareness · Global Informatization trends, national information strategy, corporate information strategy and strategy · related laws, regulations, remote education, e-commerce, e-government, etc. · Enterprise information resources management basics 7. Computer Professional English · Master Computer Technology Basic Words · Correctly reading and understanding the English Data Test Subject 2: Database System Design and Management 1. Database Design 1.1 Understanding System Demand Instructions · Understand User Demand, Determine System Range · Determine Various Relations of Application System Database · Relationship between Existing Environment and New System Environment · Data Items, Data Dictionary, Data Stream 1.2 System Preparation · Select the development method, prepare the development environment, develop plan 1.3 design system function · Select system agency, design the function and interface of each subsystem, design security strategy, demand and implementation method, develop detailed workflow and data stream 1.4 Database Design 1.4.1 Design Data Model · Concept Structure Design (Design ER Model) · Logic Structure Design (Converted into DBMS) Can receive data model)
· Review Design 1.4.2 Physical Structure Design · Design Method and Content · Access Method · Evaluation Design and Performance Prediction 1.4.3 Database Implementation and Maintenance · Data Loading and Application Debugging · Database Terminal · Database Run and Maintenance 1.4 .4 database protection · Database backup and recovery · Database security · Database integrity · Database's computing control 1.5 Write external design document · Writing system manual (system configuration diagram, various subsystem relationship diagram, system flow chart, System function description, input output specification, data specification, user manual framework) · Design system test requirements 1.6 design review 2. Database application system design 2. Design database application system structure · Information system architecture (such as Client / Server) and DBMS · Multi-user database environment (file server architecture, Client / Server architecture) · Large-scale database and parallel computer architecture (SMP, MPP) · Middleware role and related tools · According to the decomposition of components, determine component function specifications and components Interface 2.2 Design Input Output · Screen Interface Design, Design Input Output Check Method and Check Information • Database Interaction and Connection (Master C Progress Design Language, and Java, Visual Basic, Visual C , Powerbuilder, Delphi in any development tool Methods (How to Communicate with Database Server) 2.3 Design Physical Data • Analyze the frequency and performance requirements running on the database, determine logical data organization, storage media, design index structure, and processing method · Logic data The structure is transformed into a physical data structure, calculates capacity (space cost), determines access method (time efficiency), system configuration (maintenance cost) and optimizes 2.4 Design security system · Clear level · Database login method · Database Access · License (Object License, Command License, License Method 2.5 Application Development 2.5.1 Application Development · Select Application Development Platform • System Implementation Order · Frame Development · Basic Group Program Development · Source Code Control · Version Control 2.5. 2 module division (principles, methods, standard) 2.5.3 Writing programming document · Module Specification (function and interface description, program processing logic description, input Description of Output Data Formats) · Test Description Description (Test Type and Target, Testing Example, Test Method) 2.5.4 Program Design Review 2.6 Writing Application System Design Documents · System Configuration Description, Members Division Map, Intercommodation Intercommunication Interface, Member Treatment Description, screen design document, report design document, program design document, file design document, database design document 2.7 Design Review 3. Database application implementation 3.1 Configuration and Management of the entire system 3.2 Applications of common database management systems (SQL Server, Oracle, Sybase, DB2, Access, or Visual FoxPro) · Create a database · Create a table, create an index, create a view, create constraints, create UDDT (User Custom Types) · Create and Administration Triggers · Establish a Security System 3.3 Database Application System Installation · System installation plan (considering factors such as fees, customer relationship, employee relationship, logistics relationship and risk) · Develop a human resource usage plan (rationality of organizational institutional arrangements)
· Direct installation (install new system and make the system quickly enter the running status) · Parallel installation (new system parallel running for a period of time) · Stage installation (through a series of steps and stages to gradually put into operation of each part of the new system) 3.4 Database application system Testing · Test objectives, plans, methods, and steps, data loading, preparation test data · Guide application programming Module Test for acceptance · Prepare System Integration Test Environment Test Tool • Write Database Run Test Report 3.5 Training and User Support 4. Running and Management of Database Systems 4.1 Run Planning of Database Systems • OK • Determine Database System Alarm Objects and Alarm Methods · Database System Management Plan (Execution, Fault / Recovery, Security, Integrity, User Training and Maintenance) 4.2 Running and Maintenance of Database Systems · Conversion of New and Old Systems · Collection and Analysis Alarm Data (Executive Alarm, Fault Alarm, Security Alarm) · Continuous and Stable Operation · Database Maintenance (Database Reconstruction, Security View Evaluation and Verification, Document Maintenance • Run statistics (collection, analysis, proposing measures for database systems) · Recommendations for the operation standards and standard improvement consistency · Database system audit 4.3 database management · Data dictionary and data warehouse management · Data integrity maintenance and management (Entity Integrity, Reference Integrity) · Database Physical Structure Management (Guaranteed Data Not Delayed) · Database Space and Debris Management · Backup and Recovery (Order, Log (Audit), Checkpoints) · Deadlock Management (Concentrate , Distributed) · Concurrent control (serial, lock mechanism, timestamp, optimization) · Data security management (encryption, security, access control, view, validity confirmation rules) · Database Administrator (DBA) duties 4.4 Performance Adjustment · SQL Statement Coding Test · Evaluation of Table Design · Improvement of Index · Improvement of Physical Allocation · Database Performance Optimization 4.5 User Support · User Training · After-sales Service 5. SQL 5.1 Database Language · Database Language Elements · Database language usage (interactive and embedded) 5.2 SQL Overview · SQL statement Features · SQL statement Basic Components 5.3 Database Definition · Create Datebase, Create Table · Definition Data Integrity · Amount, Delete Table (DROP TABLE), Delete Index, Delete Index · Delete View (DROP View), Update View 5.4 Data Operation • SELECT statement Basic Organization · Simple Query · Selection in SQL, Projection · String Comparison, Comparison of Null Values, Date Time, Boolean, Output · Multi-Table Query · Avoiding Attribute Ambiguity · SQL And, packet variables, sub-query 5.5 integrity control and security mechanism, primary key (Primary Key)
