Where can I use SQL

Question

I finished the SQL course, how can I practice using it now? Is there a way on the code playground?

Answer 1

No, code playground is still unavailable for SQL. But you could still check out this link for some SQL challenges :

https://www.sololearn.com/discuss/517493/?ref=app

Also, You can practice SQL with this IDE :
https://www.jetbrains.com/datagrip/download/

Answer 2

@John -- I don't think it'd be good for beginners to use their local databases for usernames and passwords. Even on Linux hosts, it's common to see your databases looked through & copied. Before creating a database that serves as a grouping of your credentials (or any other sensitive information), first learn about how to implement security into the matter. Databases should not be unlocked and they should definitely not be unguarded.

Answer 3

you can practice SQL by installing xampp/wampp and open phpmyadmin, or mysql workbench. Online you can practice at www.sqlzoo.com and sqlbolt.com, www.sql-ex.com

Answer 4

Download oracel sql
Or
Microsoft sql express 2014

But installation is very complicated one

Answer 5

use sql server

Answer 6

on sql server

Answer 7

you can practice online on www.w3schools.com or get a LAMP stack like xampp or wamp and do it locally.

Answer 8

I didn't mean personal credentials, just made up credentials to learn the ins and outs of sql. Nothing you don't want people knowing. SQL injection is too easy nowadays. Learning how to gain unauthorized access to databases would be useful too, as you could learn how to implement security features to stop these kinds of attacks if you know exactly how they work. But you're right though. We've got 12 year olds port scanning random people to hack just for fun. Unencrypted and unsecured databases aren't a good idea if they contain confidential information.

Answer 9

sql programing is usefull for what?

Answer 10

If you work with programming depending on your function you will use SQL for data base mantaining and organization.

Answer 11

useful for operating the information gathered by the application. It is useful for processing, make calculations and return the result to the interface or have it accessed directly in the database.

Answer 12

you can practice SQL by installing a software called SQL management studio .... it has some versions .... but I am using 2012

Answer 13

Wow thanks

Answer 14

Build a small website on your local machine and try to implement some sql into it, maybe create a couple databases for usernames/passwords. Or build something useful. I'm making my inventory management system in c++, I'm sure you could build a web based one quite easily. Anything that's good practice, and if it looks good on a portfolio even better. Hopefully this is an educated answer, as I've only dabbled in sql years ago. Best of luck to you and congrats on your certification: )

Answer 15

Download MariaDB for database and HeidiSql for workbench
https://go.mariadb.com/download-mariadb-server-community.html?utm_source=google&utm_medium=ppc&utm_campaign=MKG-Search-Google-Branded-DL-NA-Server-DL&gclid=CjwKCAjwnef6BRAgEiwAgv8mQeHusa4YgMyolGvMLylwy1jxZlhYeng9OHuEM-z016M4zCVvl0gV7xoCiuoQAvD_BwE

HeidiSql:
heidisql.com