+ 10
Where can I test my SQL commands?
Did anyone know somewhere I can practice some SQL commands?
8 Antworten
+ 13
U can use MySQL
+ 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/
+ 2
apt-get install mysql-server
sometimes it might be installing 'mariadb',don't worry it will work.
service mysql start
mysql
+ 2
no need to download anything, just go to sqlfiddle.com
+ 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.
+ 1
or sql-ex.ru with big stack of exercises)
+ 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.
0
you can use Visual studio 2019, there is a database workplace that includes SQL.