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

Source: Internet
Author: User
Tags java web

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.