You will combine SQL with Java programming when you use JDBC. The following tips will help you while you are learning SQL commands.
Though SQL is not case sensitive, use all capital letters to easily locate the SQL commands in your code.
The space between words in a SQL statement is not important.
You can use quotation marks to define strings. A single quotation mark (') indicates a string constant. A double quotation mark (") may be used to delimit database entities (such as table columns) that contain spaces. However, check your database documentation because these two characters are sometimes treated differently.
If you hear the terms "JDBC SQL type," "SQL type," and "JDBC type," don't be confused. These are all terms that programmers use to refer to the generic SQL type identifiers.
When you begin working with JDBC, read the SQL manual published by your database vendor. The documentation should provide a reference for specific information you may need (Open Database Connectivity) in a solution.