According to the practice experience developed by my program, combine my own understanding of the database, I summed up as a Java developer, what extent should be grasped on the knowledge of the database. Of course, everyone's situation is different, these only represent my words.
1. Understand the basics of the database, including paradigms, SQL statements, such as creating (table, index), query, delete, update SQL statements, transactions, etc. 2. Understand the significance of JDBC's URL connection such as Oracle's JDBC URL connection string is: JDBC: Oracle: Thin: @ip: 1521: SID.
3, master the SQL statement. For example, flip pages, time comparison SQL statements we use the most. Give you a requirement you can immediately write a SQL statement.
4. Proficiency in using the JDBC class, know when to use the following functions. PreparedStatementexecutebatch
5. Master the necessary database optimization knowledge. The programmer is almost the same below the three points. (1) SQL statement needs to bind variables; (2) Establish the necessary index (when, what field recommendation index); (3) Optimization of SQL statements, the execution plan of the SQL statement will analyze the execution plan of the SQL statement.
PS: I am more interested in database performance optimization, and the database used in the project is mainly mysql and oracle, and it feels that the optimization of both databases is very different.