Java interview, Java back-end interview, database requirements for junior and senior programmers

This content is excerpted from the Java Web Lightweight Development Interview tutorial

For qualified programmers, basic database operation skills are required, which are embodied in the following three areas.

L First, for a class of databases (such as MySQL, Oracle, SQL Server, etc.), will be basic additions and deletions to the operation, will use some basic functions, will write the stored procedure trigger index and other tools.

Second, know some basic concepts that are helpful to project development, such as paradigms, indexes, partitioning, and so on.

L Third, can write some relatively complex SQL statements, such as with connection, tape query, nested query and so on.

For advanced programmers, the type of database used is of course the more the better, in addition, the following three aspects of the ability to master.

L First, can design a variety of complex SQL statements to meet the various needs of the project.

L Second, according to the project situation, the design of the data table structure, and can reasonably configure the foreign key and the primary key.

L Third, and most importantly, to have a certain database tuning capabilities, such as the reasonable creation of the table structure, to correctly create the index, but also through the use of indexes to reasonably optimize database performance, through the execution plan to analyze and optimize SQL.

Because the tuning techniques for various data sheets are not necessarily consistent, advanced programmers are better able to master tuning techniques for multiple databases.

In the project development process, the role of qualified programmers is generally to write (add, delete, change, check storage structure) SQL statements, and senior Programmer's responsibilities also include design and tuning.

Java interview, Java back-end interview, database requirements for junior and senior programmers