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

Editor to share with you about the computer level 2 mysql test what things, I believe that most people do not know much, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

What is the content of the computer second-level mysql test?

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.

These are all the contents of this article entitled "what are the second-level mysql exams in computers?" Thank you for your reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.