If I still take the database exam, I recommend a tutorial book, Database Technology, published by the Ministry of Education. The following is the database exam outline.
basic requirement
1, master the basic concept, application and working mode of information system.
2. Understand the information system project organization, development process, development methods and system operation and maintenance methods, and have basic information system project organization and management capabilities.
3. Grasp the basic concepts and principles of relational database and deeply understand the relational data model; Master the design method and principle of relational database, and have basic design ability of relational database.
4. Master and skillfully use structured query language SQL.
5, understand the use of relational database management system, with the ability to create and maintain the database.
6, master the realization technology of information system, with the ability to use programming languages and development tools to realize the application of information system.
7, with the comprehensive application ability of information system and database technology.
Examination content
First, the basic concept of information system
Basic concepts of information system.
Data and information
Information resources
information system
2. Application of information system
Transaction processing system
Management information system
decision support system
Expert system
Various functional information systems
3. Information system management
Technical management of information system
Organizational behavior management of information system
Security, Law and Morality of Information System
Second, the information system development method
1, information system development technology
Data management technology: file, database and data warehouse.
Data processing technology: online transaction processing, OLAP, data mining.
System development technology: software engineering method and software development technology.
Information system integration technology
2, information system development method
System life cycle method
Prototype research
Object-oriented development method
3. Information system development process and environment
Management modes of system development: resource outsourcing, resource self-outsourcing and resource outsourcing.
Software Process Management: Capability Maturity Model CMM
computer aided software engineering
System development file
4. Working mode of information system
Centralized host mode
Client/server mode
Browser/server
Third, the basic principle of relational database
1, relational data model
Basic concepts: relationship, table, tuple (record), attribute (field, domain), range, keyword, index.
The relationship between tables: main table and appearance, main keyword and foreign keyword.
Relationship types between tables: one-to-one relationship, one-to-many relationship and many-to-many relationship.
Relational patterns and relational submodels
Data integrity constraints of relational model: domain integrity, entity integrity, referential integrity.
Relational operations in relational algebra: union, difference, intersection, selection, projection and connection.
2. Database system
The composition of database system: database, database management system, database application program, database related personnel, software and hardware environment.
Characteristics of database system
Three-level schema structure of database
3. Design of relational database
Relational database methods: intuitive design, standard design and computer-aided design.
Design steps of relational database: requirement analysis, conceptual design, logical design, physical design, implementation, operation and maintenance.
Entity contact model (E-R model)
Normalization of relational schema and its application
4. New database technologies: distributed database, parallel database, multimedia database, object-oriented database, data warehouse and data mining, Web database.
Fourthly, structured query language SQL.
1, the functions and characteristics of SQL language
Data definition language DDL: creattable, Drop Table creates indexes; Descending index
DML: Select, Insert, Delete and Update
Data control language
2. About SQL variables, operators and common functions
3.SQL control statement flow: Begin…End, IF…Else, Case, While, Return.
Verb (abbreviation of verb) relational database management system
1, the basic function of relational database management system DBMS
2, the use of commonly used DBMS (desktop database or network database)
1) desktop database
Basic operations of database: tables and their relationships, queries (selection query, cross-table query, operation query).
Database management: optimization, backup, compression, repair and encryption.
2) Network database
Enterprise manager
Query analyzer
Basic operation of database: tables and their relationships
Views, stored procedures, and triggers
Database protection and management: transaction, concurrency control, backup/recovery, import/export, integrity control and security control.
Realization technology of intransitive verb information system
1, general information system development platform and tools
2. Using development tools to realize the application of information system.
Database access technology ADO or ADO.net
Basic application of database: data query and update (insertion, deletion and modification)
Stored procedure call
Use common window interface objects, menus, etc. Achieve a friendly user interaction application interface.
Data reports and charts
Common techniques for implementing application programs with related development tools.
Seven, computer operation
1, master basic computer operation.
2. Master the basic operation and management of database management system (desktop database or network database).
3, master the basic methods of information system and database design.
4. Master the basic technology, programming and debugging methods of developing information system applications with a programming language.
5. Grasp the practical application of knowledge related to the examination content.