Welcome to Essential SQL Online SQL Tutorial. Use this page to get started learning SQL.

SQL Tutorial Overview

Use SQL (Structured Query Language) to query a relational database. You use SQL to “tell” the database what results that you would like to see.

Since the database stores its data in tables, which are made up of rows and columns, a typical SQL statement’s purpose is to describe what table to query and which columns to return.

SELECT FirstName, LastName FROM Person.Person
/* Answer */
SELECT FirstName, LastName
FROM   Person.Person

In this SQL Tutorial example we are querying the Person table and return each person’s first and last name.

You can try the query for yourself.  Just click Run Query

In fact, wherever, you see the box above, you can run the statement shown, or modify it to experiment and learn.

Now and then, we’ll ask you to write SQL! When you get stumped click on Show Answer to reveal what we wrote for the SQL Tutorial.

Tutorial Topics

Click on a topic to the right to view it. You can start from the top and do the topics in sequence, of if you wish, just skip ahead to a topic you want to learn.

The main topics covered are:

In either case, the SQL tutorial topics are just the right size for you to learn a concept within several minutes.

In addition to the topics there is also a SQL Server Reference.

Additional Resources

In addition to what we have here in our SQL tutorial, I would also recommend these popular articles from our blog:

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Are YOU READY TO START LEARNING SQL SERVER, BUT DON'T KNOW WHERE TO START?

Nothing is worse than, being excited to learn a new tool but not knowing where to start, wasting time learning the wrong features, and being overwhelmed .

But it doesn't have to be this way.

I'm Putting together a free email course to help you get started learning SQL Server.

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"b6728":{"name":"Main Accent","parent":-1},"03296":{"name":"Accent Low Opacity","parent":"b6728"}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"b6728":{"val":"var(--tcb-skin-color-0)"},"03296":{"val":"rgba(17, 72, 95, 0.5)","hsl_parent_dependency":{"h":198,"l":0.22,"s":0.7}}},"gradients":[]},"original":{"colors":{"b6728":{"val":"rgb(47, 138, 229)","hsl":{"h":210,"s":0.77,"l":0.54,"a":1}},"03296":{"val":"rgba(47, 138, 229, 0.5)","hsl_parent_dependency":{"h":210,"s":0.77,"l":0.54,"a":0.5}}},"gradients":[]}}]}__CONFIG_colors_palette__
Name*
Email*
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"dffbe":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"dffbe":{"val":"var(--tcb-color-4)"}},"gradients":[]},"original":{"colors":{"dffbe":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
Sign Up
>