Shulou(Shulou.com)06/01 Report--

This article will explain in detail what the syllabus of the second-level mysql exam is. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Question type and score

40 points for single multiple choice questions (including 10 points for public basic knowledge)

60 points for operation questions (including basic operation questions, simple application questions and comprehensive application questions)

Examination environment

Development environment: WAMP 5.0 or above

Database management system: MySQL 5.5

Programming language: PHP

The outline of the examination is as follows:

I. basic concepts and methods

1. Basic knowledge of database

(1) basic concepts related to database

(2) the characteristics and structure of database system.

(3) data model

2. Relational database and relational model

3. The basis of database design

(1) steps of database design

(2) the method of designing relational database

4. Overview of MySQL

(1) characteristics and working mode of MySQL system

(2) basic MySQL programming (structured query language SQL, MySQL language structure)

Second, SQL interactive operation under MySQL platform

1. Database

(1) the basic concepts and functions of MySQL database objects.

(2) the operation method and application of using SQL statement to create, select, modify, delete and view MySQL database objects.

2. Data sheet (or table)

(1) the basic concepts and functions of data table (or table), table structure and table data in MySQL database.

(2) the operation method and application of creating, updating, renaming, copying, deleting and viewing data tables by using SQL statements.

(3) the operation methods and application of inserting, deleting and updating table data are realized by using SQL statement.

(4) using SQL sentence to realize the operation method and application of simple query, aggregate query, join query, conditional query, nested query and joint query on one or more data tables.

(5) the basic concept, classification and function of data integrity constraints.

(6) the operation method and application of using SQL statement to define, name and update integrity constraints.

3. Index

(1) the basic concept, function, storage and classification of index

(2) the operation method, principle and application of using SQL statement to create, view and delete index.

4. View

(1) the basic concepts, characteristics and principles of use of views.

(2) the difference between view and data table

(3) the operation method and application of creating and deleting views by using SQL statements.

(4) the operation method and application of modifying and viewing view definition by SQL statement

(5) the operation method and application of updating and querying view data by SQL statement.

III. Database programming of MySQL

1. Trigger

(1) the basic concept and function of trigger.

(2) the operation method and application of using SQL statement to create and delete trigger.

(3) types and differences of triggers

(4) the use and principles of triggers

2. Events

(1) the basic concept and function of event and event scheduler

(2) the operation method and application of using SQL statement to create, modify and delete events.

3. Stored procedures and stored functions

(1) the basic concepts, characteristics and functions of stored procedures and stored functions.

(2) the difference between stored procedures and stored functions.

(3) the basic concept and construction method of stored procedure body.

(4) the operation method and application of using SQL statement to create, modify and delete stored procedure.

(5) the calling method of stored procedure

(6) the operation method and application of using SQL statement to create, modify and delete storage function.

(7) the calling method of storing function

IV. Management and maintenance of MySQL

1. The use and management of MySQL database server.

(1) the basic method of installing and configuring MySQL database server

(2) the basic method of starting and shutting down MySQL database server

(3) client management tools of MySQL database server

2. User account management

(1) the basic concept and function of user account management in MySQL database.

(2) the operation method and application of using SQL statement to create, modify and delete MySQL database user account.

3. Account authority management

(1) the basic concept and function of account authority management in MySQL database.

(2) the operation method and application of granting, transferring, restricting and revoking the authority of MySQL database account by using SQL statement.

4. Backup and recovery

(1) the basic concept and function of database backup and recovery.

(2) the usage of backup and recovery of MySQL database

(3) the basic concept and function of binary log file.

(4) the use of binary log files

5. Application programming of MySQL

1. The basic usage of PHP language

(1) the characteristics and programming basis of PHP language.

(2) the basic steps and methods of MySQL database application programming with PHP language.

2. Compiling PHP simple application program based on B / S structure under MySQL platform.

(1) understand the process of programming simple PHP applications based on B / S structure under MySQL platform.

(2) to master the related techniques and methods of database application programming under MySQL platform in the process of PHP simple application programming.

On the mysql level 2 exam outline is shared here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.