It's not so hard to find sample data and data sources to use for interesting side-projects, or just for practicing writing SQL. In-product sample data Most DBMSes come with sample databases. You can write lots of interesting queries against them, and usually a tutorial accompanies the database in the documentation. Documentation for Microsoft SQL Server's samples ** Microsoft's sample database GitHub , which includes the Contoso database For MySQL: there's the Employees sample database and the Sakila sample database For PostgreSQL: there are several sample DBs in the PostgreSQL wiki a GitHub repository with a collection of PostgreSQL samples from the old pgfoundry site Oracle publishes a manual section about there sample databases Some websites are full of sample data sets. Why not download an interesting one, learn to load it up, and write your own interesting queries? Dataset Websites There are many websites which host data sets. Kaggle.com is full of sample data! FiveThirtyEight.com has lots of neat data sets The github awesomedata repository has a collection of interesting data sets Wikipedia has a list of datasets for machine learning research Third-party sample data Of course, some sample data is built for generic tutorials, by third parties: SqlSkills.com publishes sample databases for SQL Server, which include some corrupt databases so you can practice recovery operations SQLTutorial.com's Sample Database is available for sseveral vendors Practice Sites There are some sites that let you write queries interactively with canned data, rather than having you download data to play with on your own. I haven't used it, but I've seen people recommend SqlZOO.net LearnSQL.com has a blog post called " Learning SQL? 12 Ways to Practice SQL Online " with lots of resources. Sylvia Moestl Vasilik's website (which supports their book) has almost 60 practice problems. Regular dumps Some sites publish data by making their backups available, or dumping the data they use to make their own reports. Wikipedia publishes all of the content of Wikipeida as SQL scripts for MySQL, plus as XML files. You can get that data (or subsets of it) and play around. StackOverflow makes their developer survey data sets available each year. Some governments make data about the city and its residents available openly: London Open Data New York City Open Data Seattle Open Data Tokyo open data (in Japanese, obviously) Find open data at data.gov.uk Live data sources Some data sources produce data live, as it happens. These are itneresting sources becaue they usually represent slowly changing dimensions, and will need to be accumulated or logged before being stored or processed. Wikipedia Event Streams can show edits that are happening on Wikipedia, as they happen. The TWitter API provides a way to stream a subset of all tweets in realtime. GTFS data is provided by many metropolitain areas to describe movement of their transportation infrastructure; where are scheduled busses and trains right now? In the New York City area, the MTA provides GTFS data . You can find GTFS feeds for Seattle , and their live data through other APIs . Tokyo (and other municipalities in Japan) have hosted transit data challenges to encourage use of their data. Some games make gameplay data available in realtime. SuperCell's Clash Royale , for example, has a gameplay API . Finding more There's data everywhere! If you don't like these sources, you can try finding other data sets. Once you know the protocol or format, search for it! The OneBusAway API and GTFS protocols are about public transportation data, so earch for "GTFS Data {YourCity}". Search for APIs for your favortie game or game server. GitHub uses tags for search, so try #sample-databases , #opendata , or #datasets . What other tags can you find? Answer from mikeblas on reddit.com
๐ŸŒ
SQL Practice Online
sql-practice.online
SQL Practice Online โ€” Free SQL Compiler & Editor
Free SQL online ide & sql sandbox โ€” practice PostgreSQL, MySQL, SQL Server & Oracle. Free sql editor, sql query builder, 5 real databases, no signup.
๐ŸŒ
HackerRank
hackerrank.com โ€บ domains โ€บ sql
Solve SQL Code Challenges
SQL ยท Solve Challenge ยท Solve Challenge ยท Solve Challenge ยท Solve Challenge ยท Solve Challenge ยท Solve Challenge ยท Solve Challenge ยท Solve Challenge ยท Solve Challenge ยท Solve Challenge ยท Status ยท Solved ยท Unsolved ยท Skills ยท SQL (Basic) SQL (Intermediate) SQL (Advanced) Difficulty ยท
๐ŸŒ
Reddit
reddit.com โ€บ r/sql โ€บ what is the best sql practice platform?
r/SQL on Reddit: What is the best SQL practice platform?
March 12, 2024 -

Yesterday I posted a question about the value of subqueries in everyday life. Iโ€™d like to thank this wonderful community for your replies. Iโ€™ll definitely persevere until I understand subqueries.

Now I need advice on practice platforms. I use LeetCode, but it only has 50 exercises. Which platform is the best for practicing SQL? Thanks again for your kindness. Much respect

Top answer
1 of 15
30
It's not so hard to find sample data and data sources to use for interesting side-projects, or just for practicing writing SQL. In-product sample data Most DBMSes come with sample databases. You can write lots of interesting queries against them, and usually a tutorial accompanies the database in the documentation. Documentation for Microsoft SQL Server's samples ** Microsoft's sample database GitHub , which includes the Contoso database For MySQL: there's the Employees sample database and the Sakila sample database For PostgreSQL: there are several sample DBs in the PostgreSQL wiki a GitHub repository with a collection of PostgreSQL samples from the old pgfoundry site Oracle publishes a manual section about there sample databases Some websites are full of sample data sets. Why not download an interesting one, learn to load it up, and write your own interesting queries? Dataset Websites There are many websites which host data sets. Kaggle.com is full of sample data! FiveThirtyEight.com has lots of neat data sets The github awesomedata repository has a collection of interesting data sets Wikipedia has a list of datasets for machine learning research Third-party sample data Of course, some sample data is built for generic tutorials, by third parties: SqlSkills.com publishes sample databases for SQL Server, which include some corrupt databases so you can practice recovery operations SQLTutorial.com's Sample Database is available for sseveral vendors Practice Sites There are some sites that let you write queries interactively with canned data, rather than having you download data to play with on your own. I haven't used it, but I've seen people recommend SqlZOO.net LearnSQL.com has a blog post called " Learning SQL? 12 Ways to Practice SQL Online " with lots of resources. Sylvia Moestl Vasilik's website (which supports their book) has almost 60 practice problems. Regular dumps Some sites publish data by making their backups available, or dumping the data they use to make their own reports. Wikipedia publishes all of the content of Wikipeida as SQL scripts for MySQL, plus as XML files. You can get that data (or subsets of it) and play around. StackOverflow makes their developer survey data sets available each year. Some governments make data about the city and its residents available openly: London Open Data New York City Open Data Seattle Open Data Tokyo open data (in Japanese, obviously) Find open data at data.gov.uk Live data sources Some data sources produce data live, as it happens. These are itneresting sources becaue they usually represent slowly changing dimensions, and will need to be accumulated or logged before being stored or processed. Wikipedia Event Streams can show edits that are happening on Wikipedia, as they happen. The TWitter API provides a way to stream a subset of all tweets in realtime. GTFS data is provided by many metropolitain areas to describe movement of their transportation infrastructure; where are scheduled busses and trains right now? In the New York City area, the MTA provides GTFS data . You can find GTFS feeds for Seattle , and their live data through other APIs . Tokyo (and other municipalities in Japan) have hosted transit data challenges to encourage use of their data. Some games make gameplay data available in realtime. SuperCell's Clash Royale , for example, has a gameplay API . Finding more There's data everywhere! If you don't like these sources, you can try finding other data sets. Once you know the protocol or format, search for it! The OneBusAway API and GTFS protocols are about public transportation data, so earch for "GTFS Data {YourCity}". Search for APIs for your favortie game or game server. GitHub uses tags for search, so try #sample-databases , #opendata , or #datasets . What other tags can you find?
2 of 15
5
U can try this site. https://advancedsqlpuzzles.com
๐ŸŒ
Oracle
oracle.com โ€บ database โ€บ technologies โ€บ oracle-free-sql
FreeSQL
Oracle FreeSQL is a user-friendly, free online platform that offers a comprehensive environment for learning and practicing SQL. With no installation required, users can write and run Oracle SQL directly in their browser, making it an ideal tool for learners, educators, and developers seeking ...
๐ŸŒ
W3Schools
w3schools.com โ€บ sql โ€บ sql_exercises.asp
SQL Exercises
W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.
๐ŸŒ
SQL Practice
sql-practice.com
Learn SQL - Online SQL Terminal - Practice SQL Querys
We cannot provide a description for this page right now
Find elsewhere
๐ŸŒ
SQLZoo
sqlzoo.net
SQLZoo
Online copies of implementation specific user manuals. ... How to connect to the server and execute SQL statements.
๐ŸŒ
Programiz
sql-editor.programiz.com
Online SQL Editor
The best SQL Editor to Run SQL queries online for free.
๐ŸŒ
Oracle FreeSQL
freesql.com
Oracle FreeSQL: Learn and practice SQL with the worksheet
Oracle FreeSQL lets you learn, practice, run, and share Oracle SQL, PL/SQL, and Quick SQL in a browser-based worksheet
๐ŸŒ
CodeChef
codechef.com โ€บ learn โ€บ course โ€บ sql
Learn SQL Online: Interactive SQL Course for Data Beginners | CodeChef
Learn SQL with our beginner-friendly course. Learn to create, query, and manage databases through interactive lessons, exercises, and real projects. get hands-on coding experience, and earn a SQL certification on CodeChef.
๐ŸŒ
SQL Fiddle
sqlfiddle.com
SQL Fiddle - Online SQL Compiler for learning & practice
We created SQL Fiddle to provide an online SQL playground to let people learn and improve their SQL skills.
๐ŸŒ
Codecademy
codecademy.com โ€บ learn โ€บ learn-sql
Learn SQL | Codecademy
Learn what relational databases are, how SQL is used in RDBMS, and explore the key components like tables, keys, and relationships with examples. ... Practice with some common SQL interview questions.
Rating: 4.6 โ€‹ - โ€‹ 27.1K votes
๐ŸŒ
SQLBolt
sqlbolt.com
SQLBolt - Learn SQL - Introduction to SQL
SQLBolt Learn SQL with simple, interactive exercises.
๐ŸŒ
TestDome
testdome.com โ€บ tests โ€บ sql-online-test โ€บ 12
SQL Online Test | TestDome
Practice your skills and earn a ... ... The SQL online test assesses SQL skills using live coding tasks that require writing CRUD operations in order to extract, combine, and manipulate data....
๐ŸŒ
Wise Owl
wiseowl.co.uk โ€บ sql โ€บ exercises โ€บ standard
Free SQL exercises
You are welcome to try any of the 202 SQL exercises listed below, but please do not distribute them in any form without asking for our written permission first.
๐ŸŒ
LeetCode
leetcode.com โ€บ problemset โ€บ database
LeetCode - The World's Leading Online Programming Learning Platform
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
๐ŸŒ
Knight Lab
mystery.knightlab.com
Knight Lab's SQL Murder Mystery
There's been a Murder in SQL City! The SQL Murder Mystery is designed to be both a self-directed lesson to learn SQL concepts and commands and a fun game for experienced SQL users to solve an intriguing crime.