www.learnsqlonline.org Open in urlscan Pro
2a06:98c1:58::60  Public Scan

Form analysis
0 forms found in the DOM

Text Content

learnsqlonline.org
 * Home (current)
 * About
 * Certify
 * More Languages
   Python Java HTML Go C C++ JavaScript TypeScript PHP Shell C# Perl Ruby Scala
   SQL

 * English
   Español
   
 * 

 * Python
 * Java
 * HTML
 * Go
 * C
 * C++
 * JavaScript
 * TypeScript
 * PHP
 * Shell
 * C#
 * Perl
 * Ruby
 * Scala
 * SQL

Get started learning SQL with DataCamp's free Introduction to SQL tutorial.
Learn Data Science by completing interactive coding challenges and watching
videos by expert instructors. Start Now!

This site is generously supported by DataCamp. DataCamp offers online
interactive SQL Tutorials for Data Science. Join 11+ million other learners and
get started learning SQL for data science today.

Good news! You can save 25% off your Datacamp annual subscription with the code
LEARNPYTHON23ALE25 - Click here to redeem your discount!


WELCOME

Welcome to the learnsqlonline.org free interactive SQL tutorial.

SQL (pronouned either as S-Q-L or Sequel) is a powerful language for querying
and analyzing any amount of data in the world. It is the most important tool for
developers, analysts and data scientists alike for being able to deal with data.

SQL is commonly used for Business Intelligence so companies can make operative
decisions on how to act based on data generated by the business. It is also used
for researching data to create new insights by aggregating vast amounts of data.
In the new big-data era, it is now possible to query petabytes of data using a
single query using novel data warehouse technologies (for example: Hadoop,
Spark, BigQuery, Presto/Amazon Athena, and more).

SQL can also be used to construct long-running data pipelines and process data
for business purposes - Spark is a great example of a technology that utilizes
SQL syntax to create data pipelines that can continuously process large amounts
of data and turn it into another form of useful data, either for insights or for
generating new data out of existing data.

To learn SQL on this website there is no need to download anything - Just click
on the chapter you wish to begin from, and follow the instructions. Good luck!

learnsqlonline.org is still under construction - If you wish to contribute
tutorials, please click on Contributing Tutorials down below.


LEARN THE BASICS

 * Hello, World!
 * Selecting data
 * Creating tables
 * Inserting rows
 * Updating rows
 * Deleting rows
 * Joining tables
 * Group by
 * Aggregate functions
 * The HAVING statement
 * Distinct queries
 * Order by


ADVANCED TUTORIALS

 * String operations
 * Inner and outer joins
 * The UNION statement
 * The CASE statement
 * Combining INSERT INTO and SELECT
 * Subqueries
 * Indexing
 * Altering tables
 * Views
 * Window functions


CONTRIBUTING TUTORIALS

Read more here: Contributing Tutorials

Start Exercise

--------------------------------------------------------------------------------




SPONSORS

--------------------------------------------------------------------------------






CHAPTERS

--------------------------------------------------------------------------------

Hello, World!
Selecting data
Creating tables
Inserting rows
Updating rows
Deleting rows
Joining tables
Group by
Aggregate functions
The HAVING statement
Distinct queries
Order by
Contributing Tutorials
Copyright © learnsqlonline.org. Read our Terms of Use and Privacy Policy

CODE

Run Reset Solution
-- Welcome to the Interactive SQL Tutorial. -- Start by choosing a chapter,
write your code in this window. CREATE TABLE helloworld (phrase TEXT); INSERT
INTO helloworld VALUES ("Hello, World!"); INSERT INTO helloworld VALUES
("Goodbye, World!"); SELECT * FROM helloworld WHERE phrase = "Hello, World!";

-- Welcome to the Interactive SQL Tutorial.



 
 
 


OUTPUT

Expected Output

 



 
 
 

Powered by Sphere Engine ™