Software to learn SQL?

R

rshri

Adept
Nov 14, 2006
513
8
32
I wish to polish my SQL and PL/SQL skills. Can I practice over MS Office Access? I want to refrain from install MS SQL Server. It will be too heavy for my PC. Is there any other software alternative?
 
R

rshri

Adept
Nov 14, 2006
513
8
32
Just checked the MySQL download. Should I download the Community Server? Does it has a GUI for SQL practicing?
 
asingh

asingh

Staff member
Super Mod
Jun 13, 2009
6,707
1,626
303
New Delhi
rshri said:
I wish to polish my SQL and PL/SQL skills. Can I practice over MS Office Access? I want to refrain from install MS SQL Server. It will be too heavy for my PC. Is there any other software alternative?
Click to expand...

Yes, you can practice SQL 'logic' on MS Access. You can create different types of queries using the GUI (keep them small initially), and then click on the SQL view icon. It will how you how the SQL syntax looks. Using this software you will not be able to try out SP,T-SQL, or SQL server functionality. Good tool to build SQL basics -- Select, delete, insert , update. Though remember after 2GB you will start to see latency.
 
D

dpacmittal

Disciple
May 10, 2009
59
1
0
33
Just install SQLite. Although it lacks some features, it is pretty good for practicing. If you want all the features, look into MySQL or PostgreSQL.
 
Top Bottom