SQL Compiler?

Oct 1, 2015 at 3:34am
Hey so I know this is probably the wrong place to ask this, but I've been learning SQL for a little bit and I was wondering if there was a program that I could practice in that is similar to Visual Studio. Something where I would be able to code in and get some sort of output from. Thanks!
Oct 1, 2015 at 6:29pm
You'll need a database to run it against. There might be play databases on the web, I'm not sure. IMO your best option is to just install a database system of your choice and start messing with it.

SQL doesn't get compiled, it's not even really a programming language. It's a query language.
Nov 6, 2015 at 2:44am
It does get compiled. But your advice is correct. Get a database installed and use it. Try to get hold of the query plans used in the queries. You will need large tables (millions of rows) to gain any useful insights.
Nov 6, 2015 at 4:05am
closed account (18hRX9L8)
@kbw An SQL query does not get compiled into a program, if that's what you are saying. However, it can be "prepared".
Last edited on Nov 6, 2015 at 4:05am
Nov 6, 2015 at 8:43am
You can use SQLite, which uses almost the same language that the large engines use, only the database is stored in a single file, so there's no need to run a complex database process, or to do any IPC. The implementation is distributed as a single amalgamated C source with its header.
Last edited on Nov 6, 2015 at 8:44am
Nov 6, 2015 at 10:43am
closed account (z05DSL3A)
Aideux, If you are using Windows, take a look at SQL Server Express for the RDBMS and SQL Server Management Studio Express to do your DBA. Microsoft also have sample schemas that you can load and play with, look for Northwind
Nov 6, 2015 at 7:34pm
> @kbw An SQL query does not get compiled into a program
compiled != program. compiling at its core is turning A -> B.
Dec 15, 2015 at 4:18am
This may not sound right or answer your question but for SQL I have been using Microsoft Office Access, you can setup databases and tables and send SQL queries.
Topic archived. No new replies allowed.