Win a copy of Rust Web Development this week in the Other Languages forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

SQL and table

 
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi guys

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.

SCJP 1.5
 
author & internet detective
Posts: 40913
840
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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)
 
Lao Kinsuyi
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thank you guys.
 
Surfs up space ponies, I'm making gravy without this lumpy, tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic