Learn SQL statements...where?

08/09/2014 04:00 Hikarim#1
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?
08/09/2014 09:34 Terreox#2
You can learn it on many websites. I learned it at [Only registered and activated users can see links. Click Here To Register...].
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.
08/09/2014 10:55 Mostey#3
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)
08/09/2014 11:40 IchVerabschiedeMich#4
Quote:
Originally Posted by Mostey View Post
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
08/09/2014 12:44 Mostey#5
Quote:
Originally Posted by Padrio View Post
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.
08/09/2014 22:46 Hikarim#6
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.
08/09/2014 23:29 Mostey#7
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.
08/10/2014 00:23 Terreox#8
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:
[Only registered and activated users can see links. Click Here To Register...]
08/14/2014 13:54 Hikarim#9
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?
08/14/2014 20:09 Mikesch01#10
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.