This tutorial illustrates the core concepts of the SQL language in a logical and sorted manner. This SQL tutorial covers a broad range of topics, starting from basic queries and filtering data, 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. To download the databases used in these exercises, use one of the following links: [ACDB] [HR].
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.