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

This article mainly introduces the computer second-level mysql database test which knowledge points, has a certain reference value, friends in need can refer to. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Exam syllabus requirements:

1. Master the basic concepts and methods of database technology.

2. Proficient in the installation and configuration of MySQL.

3. Be proficient in using SQL language to realize the interactive operation of database under MySQL platform.

4. Proficient in MySQL database programming.

5. Familiar with PHP application development language, initially have the ability to use this language to develop simple application systems.

6. Master the management and maintenance technology of MySQL database.

I. basic concepts and methods

1. The basic concepts and characteristics of database.

2. The structure of database system

3. Data model

4. Database design method

Second, SQL interactive operation under MySQL platform

1. Related concepts of database, table, index and view

2. Creation and maintenance of databases, tables, indexes and views

3. The concept, definition and usage of data integrity constraints

4. Query and data update operations for tables and views

III. Database programming of MySQL

1. The concept and function of triggers, events, stored procedures and stored functions

2. Creation and use of triggers

3. Creation and use of events

4. Creation and use of stored procedures and stored functions

IV. Management and maintenance of MySQL

Installation and configuration of 1.MySQL

The function and method of 2.MySQL user account Management

The function and method of Authority Management of 3.MySQL account

The concept and method of backup and recovery of 4.MySQL Database

5. Use of binary log files

5. Application programming of MySQL

The basic usage of 1.PHP language

Programming simple Application Program of PHP under 2.MySQL platform

Thank you for reading this article carefully. I hope the editor will share which knowledge points of the computer second-level mysql database test are helpful to everyone. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.