LinkBack URL
About LinkBacksDoes anyone know if there's a software that will allow you to master your sql skills? I want to master my sql before I jump into installing unix, ingres, and database so that i can start practicing sql.
x10Hosting Member
Does anyone know if there's a software that will allow you to master your sql skills? I want to master my sql before I jump into installing unix, ingres, and database so that i can start practicing sql.
Grim Squeaker
Log into your control panel
Click on MySQL databases.
Create a database and a user.
Back to control panel
Under 'Databases' click on phpMyAdmin
Choose the db you just created
Click on SQL link/icon
Experiment.
Noticed you are going to use ingres. Why not postgres?
There are similar tools on the control panel for postgres.
Lastly, you can download Windows version of MySQL (and I assume postgres) for free if you want to experiment on your own computer. You do not need *nix.
Last edited by descalzo; 08-24-2009 at 01:15 PM.
Nothing is always absolutely so.
Community Advocate
Google is your best friend ;). There are tons of tutorials available on the Web. Please try the link below if you need help.
http://tinyurl.com/kma5yp
If I have helped you, please add to my reputation () on the bottom left corner of this post.
jtwhite.me - Visit my site :D
Grim Squeaker
He asked for a program/place/way to practice his SQL.
Do any of those tutorials that Google returns have an area to practice on an actual database?
Nothing is always absolutely so.
Community Public Relation
As always, one of the first resources a web developer or programmer should go check is w3schools. W3schools offers a quite good tutorial on SQL, perfect for the beginner and the expert.
█ Xavier L | Community Public Relations Manager (Free Hosting Support)
█ Yes, my position is too cool to even exist!
█ How am I helping? Rate this post by clicking the
█ Terms of Service | Acceptable Use Policy | x10Hosting Wiki
x10 Sophmore
w3 schools
http://www.w3schools.com/SQl/sql_tryit.asp
My Name is Larry Hyman from Montreal. I fix computers on site, see my web site for more details:
http://hyman.sytes.net
x10 Spammer
The following websites all have interactive tutorials (including the already mentioned W3Schools) that let you run queries. You can also try your own queries on their databases.
I believe they only let you play with the Data Manipulation Language (DML) portion of SQL. What is DML? It's basically the SELECT, INSERT, UPDATE and DELETE statements. It's the part of SQL that lets you manipulate table rows, as opposed to the Data Definition Language (DDL: the CREATE ALTER and DROP statements), which lets you define the models (tables, databases, views) themselves.
If you want full to play with DDL (and you do), you'll need to install an SQL DBMS (database management system), such as MySQL. While you're at it, install the MySQL GUI tools. You should probably skip MySQL Workbench as you're practicing SQL, though it may be useful to study the tables you create and (alternatively) to study the SQL statements corresponding to the tables it creates.
Be sure to read all pages linked in this post; they have further information that should prove useful. When asking for help, make sure you follow Eric Raymond's and Jon Skeet's guidelines for prompt, accurate responses. Please answer any questions I ask; they're not rhetorical (probably). Any posted code is intended as illustrative example, rather than a solution to your problem to be copied without alteration. Study it to learn how to write your own solution.Misson, not Mission.
x10Hosting Member
ooooo thank you guys....i've tried learning it from the sql on this control panel but i couldn't get any further...at work here we do use alot of sql to manage databases but i can't afford to mess around with them and screw up my paycheck..
W3schools is really helpful
Last edited by peacesam; 08-26-2009 at 11:43 AM.
Posting Permissions
Reply With Quote