Learn SQL statements...where?

[Hikarim]

Hello,
i had some basic SQL this year at school, but i feel like i didnt really learn that much, just basic stuff... like SELECT, UPDATE, DELETE, etc..

Does anyone know a site or something where i could learn to use more advanced SQL senteces?

[Terreox]

You can learn it on many websites. I learned it at .
Though it is not free it is a good website for learning several technologies especially Web stuff.
You also should be able to find a lot of resources on Google or YouTube.

[Mostey]

What do you mean by "more advanced SQL sentences"?

SQL is used to operate with your database and that's exactly what commands such as SELECT, INSERT, UPDATE and DELETE do.

There really isn't much more you will need when developing something that uses SQL. Although it's very basic stuff, you probably won't need anything other than that but if you do, you can always research your problem (or what you are trying to archive)

[IchVerabschiedeMich]

Originally Posted by Mostey

What do you mean by "more advanced SQL sentences"?

SQL is used to operate with your database and that's exactly what commands such as SELECT, INSERT, UPDATE and DELETE do.

There really isn't much more you will need when developing something that uses SQL. Although it's very basic stuff, you probably won't need anything other than that but if you do, you can always research your problem (or what you are trying to archive)

I think he probably mean thinks like LEFT JOIN // RIGHT JOIN // GROUP BY etc

[Mostey]

Originally Posted by Padrio

I think he probably mean thinks like LEFT JOIN // RIGHT JOIN // GROUP BY etc

I don't see the point in learning these constraints if you don't need them. However, the documentation will do the trick.

[Hikarim]

Yes, i meant GROUP BY, RIGHT JOIN, etc... but not just that i meant if there is a site where i could test some queries? Or is the only way for me to practice and learn if i make my own database? -If i could just test some queries on some premade database somewhere online that would be awesome.

[Mostey]

Hm. Many free hosters offer MySQL databases that you can use. The point is, that they are limiting the access to internal IPs or networks. So you won't be able to connect from your computer since the firewall will most likely drop your packets.

You should set up an own server and install MySQL (or any other database system) if you really want to train yourself. Shouldn't take long and you wouldn't actually need a real server, just get yourself a VM ready. There are plenty of tutorials and references available, I'd recommend you start with Ubuntu.

[Terreox]

Beside a VM you could also setup a MySQL server on you desktop without a VM.
Oracle offers a Windows installer for MySQL.

With this installer you can download the MySQL Server itself and some useful tools such as MySQL Workbench. With MySQL Workbench you get a nice tool to handle your MySQL server, run commands, setup databases, etc.

Download page for current version 5.6.20:

[Hikarim]

We worked with Oracle in school, so i actually have a database from there (the .sql files,...) which i can use, so i need to setup an oracle server?

[Mikesch01]

If you want to use a MySQL Server, so you have to install one.

The file extension ".sql" is very common for SQL Statement Files which can be imported in every application which use SQL for data storage.

I.e you can use xampp (phpmyadmin) for web applications or Microsoft Access for different kinds of usability.