Other than SQL managers on websites, are there any independent applications where one could test what one learns here?

Answer 1

Try to setup SQL Server locally, download Microsoft's sample database AdventureWorks and use it for your learning experiments. For MySQL: dev.mysql.com/doc/index-other.html (other MySQL documentation). Also there is MySQL port of AdventureWorks database on sourceforge (AdventureWorks Datbase for MySQL). Postgre sample databases can be found at wiki.postgresql.org/wiki/Sample_Databases. There are many online interactive SQL courses. For example, sqlzoo.net.

Answer 2

depends on the OS you're using, for Linux you would go with mysql/postgres, for Windows you would use mssql. I would not recommend Oracle for beginners.

Answer 3

how about setting up a local sql server?

Answer 4

Very true. But how does one go about doing so?

Answer 5

oracle sqldeveloper is "offline" (you must download from the web with oracle database 11g but when its installed you can use without internet) or the microsoft sql.

Answer 6

You can also download and install wamp server, its free. Use the console to access the command line on windows platform.

Answer 7

download latest version of wamp, install it and let it run successfully, then type in "localhost" in your native browser app.

Answer 8

Thanks all, much obliged!

Answer 9

try oracle express edition its free