This tutorial illustrates the core concepts of the SQL language in a logical and coherent manner. This SQL tutorial covers a broad range of topics, starting from basic queries and filtering data, to sorting a result set, querying multiple tables, using various functions and creating new database structures.
In order to help you better understand different concepts, most of these tutorials are accompanied by exercises (including solutions), allowing you to practice the SQL Language. You may perform these exercises online or by downloading a sample database.
Please note – this SQL tutorial focuses on SQL Server environment. If you want to learn SQL on a different platform, please use this link.
This tutorial explains how to write basic SELECT statements, how to use arithmetic operators on different values, how to change column headings using column aliases, and how to concatenate two or more string values. In this tutorial you will also learn how to return only distinct (different) values using the DISTINCT statement.
Scalar Functions are used to carry out operations such as: mathematical tasks on numerical data, different manipulations on string and dates values, NULL-related operations, and datatypes conversions. This guide provides you a summary of some of the most common SQL Server Built-in Scalar Functions.
This tutorial explains how to insert new rows into a table using the INSERT statement, how to update existing fields using the UPDATE statement and how to remove existing rows using the DELETE statement.
This tutorial explains how to create new tables using the CREATE TABLE statement, how to modify the table structure using the ALTER TABLE statement and how to delete existing tables using the DROP TABLE statement.