mysql database level 2 exam

How to take the mysql level 2 exam

The mysql computer level 2 exam is an on-camera exam that covers the basics of MySQL. Find out more about it below.

The type of questions and scores

Single choice questions 40 points (including 10 points in the public basic knowledge section)

Operational questions 60 points (including basic operational questions, simple application questions and comprehensive application questions)

Examination environment

Development environment: WAMP5.0 and above

Database management system: MySQL5.5

Programming Language: PHP

The syllabus of the exam is as follows:

I. Basic Concepts and Methods

1. Database Basics

(1) Basic concepts related to databases

(2) Characteristics and structure of database systems

(3) Data models

2. Relational Databases, Relational Models

3. Fundamentals of Database Design

(1) Steps in Database Design

(2) Approaches to Relational Database Design

4. Overview of MySQL

(1) Characteristics of the MySQL System and the Way It Works

(2) Fundamentals of Programming with MySQL (structural) Query Language SQL, MySQL Language Structures)

2. SQL Interactions on MySQL Platform

1. Database

(1) Basic Concepts and Roles of MySQL Database Objects

(2) Operations of creating, selecting, modifying, deleting, and viewing MySQL database objects using SQL statements and Applications

2. Data Tables (or Tables)

(1) Basic concepts and roles of data tables (or tables), table structures, and table data in a MySQL database

(2) Operation methods and applications of creating, updating, renaming, copying, deleting, and viewing data tables using SQL statements

(3) Operation methods and applications of using SQL statements to insertion, deletion, update and other operations and applications

(4) use SQL statements to achieve one or more data tables for simple query, aggregate query, join query, conditional query, nested query, joint query operations and applications

(5) the basic concepts of data integrity constraints, classification and role

(6) using SQL statements to define

3, index

(1) the basic concepts of indexes, the role of storage and classification

(2) the use of SQL statements to create, view, delete indexes of the operation methods, principles and applications

4, view

(1) the basic concepts of the view, features and principles of use

(2) the use of SQL statements to create, view, delete indexes

4, view

(1) the basic concepts, features and use of view principles

(2) Difference between view and data table

(3) Operation methods and applications of creating and deleting views using SQL statements

(4) Operation methods and applications of modifying and viewing view definitions using SQL statements

(5) Operation methods and applications of updating and querying data of views using SQL statements

III, Database Programming in MySQL

1. Trigger

(1) Basic concepts and roles of triggers

(2) How to create and delete triggers using SQL statements and their applications

(3) Types of triggers and their differences

(4) Trigger usage and principles

2. Events

(1) the basic concepts and role of events, event scheduler

(2) the use of SQL statements to create, modify, delete the operation of the event and its application

3, stored procedures and stored functions

(1) the basic concepts, characteristics and role of the stored procedure, stored function

(2) the difference between stored procedures and stored functions

(3) The basic concepts and construction methods of stored procedure bodies

(4) the use of SQL statements to create, modify, and delete stored procedures and their applications

(5) the invocation methods of stored procedures

(6) the use of SQL statements to create, modify, and delete stored functions and their applications

(7) the stored function Invocation Methods

4. MySQL Administration and Maintenance

1. MySQL Database Server

(1) Basic Methods of Installing and Configuring MySQL Database Server

(2) Basic Methods of Starting Up and Shutting Down MySQL Database Server

(3) MySQL Database Server Client Management Tools

2. User Account Management

(1) Basic Concepts and Roles of MySQL Database User Account Management

(2) Operation Methods and Applications of Creating, Modifying, and Deleting MySQL Database User Accounts Using SQL Statements

3. Account Privilege Management

(1) Basic Concepts and Roles of MySQL Database Account Privilege Management

(2) How to Grant, Transfer, Restrict, and Revoke MySQL Database Account Privileges Using SQL Statements and Applications

4. Backup and Recovery

(1) Basic Concepts and Roles of Database Backup and Recovery

(2) How to Backup MySQL Database and Recovery

(3) Basic Concepts and Role of Binary Log Files

(4) How to Use Binary Log Files

V. MySQL Application Programming

1. Basic Steps and Methods of Programming MySQL Database Applications in PHP Language

2. Developing PHP Simple Applications Based on B/S Structure under MySQL Platform

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

(2) To understand the process of developing PHP simple applications under MySQL platform

(3) To master the process of developing simple applications based on B/S structure under MySQL platform

(4) To understand the process of developing simple applications based on PHP. (2) To understand the techniques and methods related to the programming of database applications under the MySQL platform.

What is the computer level 2 test (computer level 2 registration time in December?)

There are nine subjects in the Computer Class II exam, which are C language, JAVA, ACCESS, C++, MySQL, Web, Python, MSOffice and WPSOffice, and the candidates can choose one in the exam, and the contents of the exams of the different subjects chosen are different. The following is a specific introduction:

1, C language exam includes the structure of the C language program, data types and their operations, basic statements, file operations, etc.;

2, Java language exam includes the characteristics of the Java language and the implementation mechanism, Java architecture, Java programming basic technology, etc.;

3, Access Exam content includes database basics, VBA programming basics, VBA database programming, etc.;

4, C++ language exam content includes C++ language overview, data types, expressions and basic operations, C++ basic statements, etc..

5. MySQL exam includes SQL interactive operation, database programming, application programming under MySQL platform, etc.;

6. Web exam includes the basics of Web technology, the basics of HTTP protocols, and the basics of HTML, etc.;

7. MSOffice exam includes the MicrosoftOffice Application fundamentals, Word functions and use, Excel functions and use, etc.;

8, Python exam content includes basic syntax elements, basic data types, control structure of the program, etc.;

9, WPSOffice exam content includes WPS integrated application fundamentals, WPS processing text documents, WPS processing spreadsheets, etc..

Summary

There are nine subjects in the Computer Class II exam, which are C language, JAVA, ACCESS, C++, MySQL, Web, Python, MSOffice and WPSOffice, and the content of the exam varies from subject to subject.