Does anyone know of a free to download piece of software that would enable me to practice writing SQL statements?
by 
anonymous
ANSWERS: 4
-
Get yourself MySQL (It's free) and install it on your machine. You can then open up the Client Dialog and access the database directly with SQL statements. OR Go to http://www.sqlzoo.net On here are a LOT of examples connected to a real database that give you problems and feedback!
-
Yeah, you need a database! That will let you practice all the SQL statements you like. Try MySQL, which is free and available on multiple operating systems. You can download the Community Edition here: http://dev.mysql.com/downloads/mysql/5.1.html
-
If you want a brilliant application development environment that includes SQL tutorials and a wonderful help facility, spring for Visual FoxPro when you get a few bucks. It's worth it, in my opinion, and is fairly backwards compatible across its various releases. You won't ever need to pick up a hardcopy manual to learn SQL and concepts of programming logic. One important point about programming with SQL: Different implementations of relational databases communicate exceptional conditions in different ways, so you might want to identify your real-world target environment, at some point, and focus on error handling and recovery procedures specific to that environment; for example, SQLCODE values and resolutions for DB2.
-
Download OpenOffice (free ). It comes with a database component and wizards etc. Create yourself a database using a wizard and then create a query (which you can then view in SQL View.
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC