+ 10

Where can I test my SQL commands?

Did anyone know somewhere I can practice some SQL commands?

4th Feb 2018, 2:19 PM
Mohammed Suhail KM
Mohammed Suhail KM - avatar
8 Antworten
+ 13
U can use MySQL
4th Feb 2018, 3:36 PM
Gaurav Agrawal
Gaurav Agrawal - avatar
+ 4
W3Schools has a nice ‘Try It Yourself ‘ built in to the tutorial and you can skip to a topic you need since it isn’t a class. https://www.w3schools.com/sql/
4th Feb 2018, 3:41 PM
SQrL
SQrL - avatar
+ 2
apt-get install mysql-server sometimes it might be installing 'mariadb',don't worry it will work. service mysql start mysql
4th Feb 2018, 2:59 PM
Krishna Narayan
Krishna Narayan - avatar
+ 2
no need to download anything, just go to sqlfiddle.com
4th Feb 2018, 3:20 PM
Yousaf
Yousaf - avatar
+ 2
1. You can install (1) Microsoft SQL Server 2017 Express edition and (2) Management Studio for free and practice with training databases like AdventureWorks2016, WideWorldImporters and Northwind. Search the Google. 2. Oracle provides free access to its 11g database, not 12c.
5th Feb 2018, 8:19 PM
Volodya Tikhomirov
Volodya Tikhomirov - avatar
+ 1
or sql-ex.ru with big stack of exercises)
6th Feb 2018, 11:04 PM
Serhii Ivaniuk
Serhii Ivaniuk - avatar
+ 1
I am happy with Razor SQL. It's not free, but you can test it for 30 days. It supports many SQL syntaxes such as Oracle, MS Access, MySQL, SQLite, HSQLDB, MariaDB, SQL Server etc. You can write the code yourself and view the results or you can use tools that help you with the codes and copy them to the editor to learn from it. If you want a free alternative I recommend MySQL workbench. Both support triggers, Create table, create database, create user etc.
12th Feb 2018, 10:55 AM
SQL Guy
0
you can use Visual studio 2019, there is a database workplace that includes SQL.
30th Nov 2020, 7:34 PM
Super Toast
Super Toast - avatar