National Soft Test Database System Engineer Tutorial (2nd edition) directory

A database engineer is to be tested this May. Mainly in order to take the title, in order to the omnipotent Beijing work residence permit, in order to give the baby to do medical card, the real battle has begun, refueling!

No more say, start, First report the catalogue. Pure handmade! I hope that we will learn from each other more opinions.

Chapter One, computer system knowledge

1.1 Basic knowledge of computer systems

1.1.1 Computer system hardware Basic composition

1.1.2 CPU

1.1.3 Data representation

1.1.4 Check Code

1.2 Computer architecture

The development of 1.2.1 computer architecture

1.2.2 Storage System

1.2.3 Input and output technology

1.2.4 Bus Structure

1.3 Basics of security, reliability, and system performance evaluation

1.3.1 Computer Security Overview

1.3.2 encryption technology and authentication technology

1.3.3 Computer Reliability

Performance evaluation of 1.3.4 computer system

Chapter Two, data structure and algorithm

2.1 Linear structure

2.1.1 Linear table

2.1.2 Stacks and queues

2.1.3 String

2.2 Arrays and matrices

2.3 Trees and graphs

2.3.1 Tree

2.3.2 Chart

2.4 Common algorithms

2.4.1 Algorithm Overview

2.4.2 Sorting algorithm

2.4.3 Lookup algorithm

2.4.4 String processing algorithm

2.4.5 Recursive algorithm

Correlation algorithm of 2.4.6 graph

Chapter III, operating system knowledge

3.1 Operating System Basics

Definition and function of 3.1.1 operating system

Features and functions of 3.1.2 operating system

3.1.3 Types of operating systems

3.2 Processor Management

3.2.1 Basic Concepts

3.2.2 Process Control

3.2.3 Inter-process communication

3.2.4 Tube Process

3.2.5 Process Scheduling

3.2.6 Deadlock

3.2.7 Threads

3.3 Storage Management

3.3.1 Basic Concepts

3.3.2 Storage Management Solution

3.3.3 Paging Storage Management

3.3.4 Segmented Storage Management

3.3.5 section-page Storage Management

3.3.6 Virtual Storage Management

3.4 Device Management

3.4.1 Equipment Management Concepts

3.4.2 I/O software

Related buffering techniques used in 3.4.3 equipment management

3.4.4 Disk Scheduling

3.5 File Management

3.5.1 File and file systems

Structure and organization of 3.5.2 files

3.5.3 File Directory

3.5.4 access method and storage space management

Use of 3.5.5 files

3.5.6 sharing and protection of files

Safety and reliability of the 3.5.7 system

3.6 Job Management

3.6.1 Operation and Operation control

3.6.2 Job scheduling

3.6.3 User Interface

3.7 Basic knowledge of network and embedded operating system

3.7.1 Network operating system

3.7.2 Embedded Operating system

3.8 Unix Operating system instances

3.8.1 Unix Operating system

3.8.2 Unix File system

3.8.3 UNIX process and storage management

3.8.4 UNIX Device Management

3.8.5 Shell Program

The fourth chapter, the procedural language basic knowledge

4.1 Program Language Overview

Basic concepts of 4.1.1 programming language

Basic components of 4.1.2 programming language

4.2 Language Processor Basics

Fundamentals of 4.2.1 Assembler program

Fundamentals of 4.2.2 Compiler program

4.2.3 Rationale for interpreting programs

The fifth chapter, the network basic knowledge

5.1 Network Overview

5.1.1 Concept of computer network

Classification of 5.1.2 Computer network

5.1.3 Network topology

5.2 Iso/osi Network Architecture

5.3 Network interconnect hardware

Devices for 5.3.1 Networks

Transmission Media for 5.3.2 Networks

5.3.3 Build a network

5.4 Protocols and standards for networks

Standard for 5.4.1 Networks

5.4.2 LAN protocol

5.4.3 WAN Protocol

5.4.4 TCP/IP protocol cluster

5.5 Internet and its applications

5.5.1 Internet Overview

5.5.2 Internet Address

5.5.3 Internet Services

5.6 Network security

5.6.1 Network Security Overview

Information Security of 5.6.2 Network

5.6.3 Firewall Technology

The sixth chapter, the Multimedia basic knowledge

6.1 Basic concepts of multi-media

6.1.1 Basic concept of multimedia

6.1.2 Basic concept of virtual reality

6.2 Sound

6.2.1 Basic Concepts

6.2.2 Sound file format

6.3 Graphics and images

6.3.1 Basic Knowledge

6.3.2 graphics, image file formats

6.4 Animations and videos

6.4.1 Basic Knowledge

6.4.2 graphics, image file formats

6.5 Multi-Media network

6.5.1 Hypertext and Hypermedia

6.5.2 Streaming Media

6.6 Multi-media computer system

6.6.1 Multimedia Computer hardware system

6.6.2 Multimedia computer software system

The seventh chapter, the base of database technology

7.1 Basic Concepts

7.1.1 Database and database management system

The development of 7.1.2 database technology

Features and features of the 7.1.3 DBMS

Architecture of 7.1.4 Database system

Three-level schema structure of 7.1.5 database system

7.2 Data Model

Basic concepts of 7.2.1 Database model

Three elements of the 7.2.2 data model

7.2.3 E-r Model

7.2.4 Hierarchy Model

7.2.5 Mesh Model

7.2.6 Relationship Model

7.2.7 Object-oriented model

7.3 Control functions of the database

7.3.1 Transaction Management (ACID properties)

7.3.2 Failure Recovery

7.3.3 concurrency control

7.3.4 Security and authorization

7.4 Basic knowledge of data warehousing and data mining

7.4.1 Data Warehouse

7.4.2 Data Mining

Eighth chapter, relational database

8.1 Overview

Basic concepts of 8.1.1 relational database

8.1.2 Relational Database schema

8.1.3 Integrity constraints

8.2 Relational Operations

8.2.1 Relational algebra operations

8.2.25 Basic Relational Algebra operations

Relational operations for 8.2.3 extensions

8.3-Tuple calculus

8.3.1 Atomic formula

Definition of 8.3.2 formula

Conversion of v basic operation of 8.3.3 relational algebra to tuple calculus expression

8.4 Domain Calculus

8.4.1 Atomic formula

Definition of 8.4.2 formula

8.4.3 Example

8.5 Query optimization

8.5.1 Basic Concepts

Query optimization in algebraic expressions of 8.5.2 relationships

8.6 Basic theory of relational database design

8.6.1 Basic Knowledge

8.6.2 Normalization

The axiom system since 8.6.3 data

Characteristics of decomposition and decomposition of 8.6.4 model

Nineth chapter, SQL language

9.1 Database language

9.1.1 Database Language Overview C

9.1.2 Classification of database languages C

9.2 SQL Overview

9.2.1 Characteristics of SQL statements

9.2.2 Basic composition of SQL

9.3 Database Definitions

9.3.1 Basic Domain type

9.3.2 Creating tables (CREATE TABLE)

9.3.3 modifying tables and deleting tables

9.3.4 Creating and deleting indexes

9.3.5 View creation and deletion

9.4 Data manipulation

9.4.1 SELECT Basic Structure

9.4.2 Simple Query

9.4.3 Connection Query

9.4.4 sub-query and aggregation function

9.4.5 Group Query

9.4.6 Renaming operations

9.4.7 string manipulation

9.4.8 Set Operation C

9.4.9 View Query and update

9.5 Authorization in SQL

9.5.1 primary KEY (Primary key) constraint

9.5.2 foreign KEY (Foreign key) constraint

9.5.3 a constraint on a property value

9.5.4 Global Constraints Create assertions

9.5.5 Authorization (grant) and the right of elimination (revoke)

9.6 Creating and deleting triggers

9.6.1 Overview

9.6.2 Creating triggers

9.6.3 changing and deleting triggers

9.7 Embedded SQL

9.7.1 SQL and host language interfaces

9.7.2 Dynamic SQL

Object Relational model supported by 9.8 SQL-99

9.8.1 Nested relationships

9.8.2 Complex Types

9.8.3 inheritance

9.8.4 reference types

9.8.5 queries related to complex types

9.8.6 Functions and procedures

9.9 SQL Application Case

9.9.1 Application Case One

9.9.2 Application Case II

Tenth chapter, System development and Operation knowledge

10.1 Basic knowledge of software engineering

Basic principles of 10.1.1 Software engineering

10.1.2 Software life cycle model

10.1.3 Software Development Method

10.1.4 Software Development Project Management

10.1.5 software tools and software development environment

10.2 Basic knowledge of system analysis

10.2.1 System Analysis Concepts

10.2.2 Software Requirements Analysis

Method of structural analysis of 10.2.3

10.2.4 Object-Oriented analysis method

10.3 System Design Knowledge

Contents and steps of 10.3.1 system design

The basic principle of 10.3.2 system design

10.3.3 System Module Structure design

Structural design method of 10.3.4

10.3.5 Object-Oriented design method

10.3.6 system input and output design

10.3.7 Processing Process Design

10.3.8 User Interface Design

10.4 System Implementation Knowledge

10.4.1 System Implementation Concept

10.4.2 System Testing

10.4.3 test strategies and test methods

10.4.4 System Conversion

10.5 System operation and maintenance knowledge

10.5.1 System Maintenance Overview

10.5.2 System Evaluation

11th chapter, Database design

11.1 Database Design Overview

The life cycle of 11.1.1 database application system

General strategy of 11.1.2 database design

Steps for 11.1.3 Database design

11.2 System Requirements Analysis

11.2.1 tasks, methodologies, and objectives for demand analysis

11.2.2 documentation for the requirements analysis phase

11.2.3 Case Study

11.3 Conceptual Structure Design

Design strategy and method of 11.3.1 conceptual structure

11.3.2 Building a conceptual model with E-r method

11.4 Logical Structure Design

Transformation of 11.4.1 E-r graph to relational model

Specification of 11.4.2 Relationship model

11.4.3 Determining integrity constraints

11.4.4 User View OK

11.5 Physical design of the database

11.5.1 Database Physical design work process

11.5.2 Database Physical design work steps

11.6 Application Design

11.7 Realization of database system

11.8 Database implementation and maintenance

11.8.1 Database Implementation

11.8.2 Database Maintenance

11.9 Protection of the database

The concept of 11.9.1 things

Backup and recovery of 11.9.2 database

Security of the 11.9.3 database

11.9.4 integrity of the database

concurrency control of 11.9.5 database

11.10 Case Study

11.10.1 University Experiment Management System

11.10.2 Tourism Management System

11.10.3 Library Management System

12th chapter The operation and management of the database

12.1 Operation Plan of database system

12.1.1 validation of running policies

12.1.2 determining the Monitoring object and monitoring mode of database system

12.1.3 Database System Management plan

12.2 operation and maintenance of database system

12.2.1 monitoring data for mobile phones and analytics

12.2.2 Business continuity in a stable operation

12.2.3 Database Maintenance

Running statistics of 12.2.4 database system

Audit of 12.2.5 Database system

12.3 Management of database systems

Management of 12.3.1 Data dictionary

12.3.2 Data integrity maintenance and management

Storage Management of 12.3.3 database

12.3.4 Backup and Recovery

12.3.5 concurrency control and deadlock management

12.3.6 Data Security Management

12.4 Performance Tuning

Coding test of 12.4.1 SQL statements

Evaluation of 12.4.2 table design

12.4.3 Index Improvements

12.4.4 Device Enhancements

12.5 User Support

12.5.1 User Training

12.5.2 Service

13th chapter, database development and new technologies

13.1 Distributed Database

13.1.1 Concept of distributed database

13.1.2 Architecture of distributed database

13.1.3 distributed query processing and optimization

13.1.4 Distributed things Management

Application of 13.1.5 Distributed database system

13.2 Web and database

13.2.1 Web Overview

13.2.2 Web server footstep program and server interface

Application of 13.2.3 CGI

Application of 13.2.4 ASP

Application of 13.2.5 servlet and JSP

13.3 XML and Database

13.3.1 What is XML

13.3.2 problems with XML file storage

13.3.3 XML vs. database Data conversion

13.4 Object-oriented database

13.4.1 characteristics of Object-oriented database system

13.4.2 Object-oriented data model

13.4.3 Object-oriented database language

13.4.4 Object Relational database system

13.5 Decision support systems and databases

The concept of 13.5.1 decision support system

13.5.2 Data Warehouse Design

13.5.3 Database Transfer Technology

13.5.4 Online Analytical Processing (OLAP)

13.5.5 online transaction processing (OLTP)

13.6 Non-relational database NoSQL

13.6.1 NoSQL Concept

13.6.2 Related theoretical basis

13.6.3 Types of NoSQL databases

14th chapter, standardization and intellectual property basics

14.1 Basic knowledge of standardization

Basic concepts of 14.1.1 standardization

14.1.2 Information Technology Standardization

14.1.3 Standardization Organization

14.2 Basic knowledge of intellectual property

14.2.1 Basic concepts of intellectual property

14.2.2 Computer software Copyright

14.2.3 computer software trade secret right

14.2.4 Patent

14.2.5 Trademark

It's over, call it off and start the first chapter of notes.

National Soft Test Database System Engineer Tutorial (2nd edition) directory