aspose file tools
The moose likes JDBC and Relational Databases and the fly likes How to start off with sql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How to start off with sql" Watch "How to start off with sql" New topic
Author

How to start off with sql

kedar nather
Greenhorn

Joined: Sep 27, 2009
Posts: 2
HI,
I am new to the database stuff...
I am trying to learn SQL. I want to know which book is good book.
I also want o learn Mysql , i was trying to download mysql server but i am confused which one to download??? So may thing from which i should choose
I am using windows.

Thanks.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 41851
    
  31
Welcome to JavaRanch.

Download MySQL5.1 "community". Follow the installation instructions to the letter. Set it up as a "Windows service" and give yourself a root password. Call it from the command-line before you try using a Java connector.
There are tutorials on the MySQL website, and a handbook; I quoted some links here.
There are lots of tutorials to SQL on the web; the Java™ Tutorials section is a good one.
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3740
    
  10

Do you have an existing database you can work with? I find the process of setting up a database server can turn many people off since they sometimes break and require manual recovery. In short, using a database is very different from administering it, so don't get discouraged if installation doesn't go well.


[OCA 8 Book] [Blog]
kedar nather
Greenhorn

Joined: Sep 27, 2009
Posts: 2
No i don't have a database now, i am yet to install the server because its very confusing . still not sure which to download.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 41851
    
  31
Go to the post I quoted yesterday, where there are other links; one gives you the installation instructions. You probably want the most recent available "stable" "essentials" version. Follow the instructions carefully, and yes, you probably want to run MySQL as a Windows Service.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to start off with sql