I'm sorry if this is a stupid question or novice. Infact, i'm very new to SQL. Firstly, can someone tell me what topics in SQL are relevant to a java programmer and they should know.
Secondly, how can i draw the table (database)for select,insert, upgrade in SQL by using notepad. Or can i use word programm for drawing the table to be used. Because, i read in a book that someone can only use notepad to write SQL and the table.
Lao, There's no such thing as a stupid question and novice questions are welcome.
1) A Java programmer should know how to write basic select queries - joins, aggregates functions, group by, etc. A Java programmer should also know how to write insert/update/delete queries. For any application with large amounts of data, it is also important to know about indexes and performance. If you have to design tables, it is good to get a book on database design and normalization. The Head First SQL book covers all of these.
2) I'm not sure what you mean by "draw the table." Are you looking for something graphical. Some databases (such as oracle) provide a more tabular view and generate the DDL (SQL for creating a table.) You can use any text editor to create DDL by hand though.
To use SQL then you have to read about JDBC 2.0, you have to know how to: 1-get and register a JDBC driver. 2-open a connection to your DB. 3-create statements then exequete queries or updates. 4-read your result set.
what i understood from your second question that you think that there is somthing in java that output the result of your SQL DML commands into somthing graphical..actally the SELECT statement return somthing very similar to tables as object instance where you extract field data from but drawing tables is related to grapghical API's(eg..swing,awt)
SCJP 1.5 (94%), SCWCD 1.4 (91%), SCBCD 1.5 (95%)
Joined: Mar 22, 2007
Thank you guys.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com