Win a copy of Spring Boot in Practice this week in the Spring 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:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Mikalai Zaikin
  • Himai Minh

How to start off with sql

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Marshal
Posts: 76110
362
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
author
Posts: 4323
39
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
kedar nather
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Marshal
Posts: 76110
362
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic