Below you can find our SQL tutorial that is mostly suitable for beginners and those who want to learn something new. It covers SQL language only that usually can be applied to any software. We will use SQL Server 2008 R2 for our examples but most examples should work in different versions. Enjoy our SQL Server Tutorial
Each tutorial will have plenty of examples and screenshots that hopefully will help those who are new to SQL digest everything much quicker and gain understanding of the language in much shorter period of time. What we don’t necessarily show is proper and full syntax which we believe is usually too much for someone who just wants to learn something useful and use it in practise therefore we decided to provide always a few real life example in each tutorial page.
If you are new to database concepts. We recommend reading What is a database? To gain basic understanding of how databases are structured.
SQL Tutorial
-
SQL SELECT - Learn how to retrieve data from table(s) using SQL Select Statement.
-
SQL WHERE -Learn how to filter results/records with SQL WHERE Clause.
-
SQL GROUP BY -Learn how to Group By records with SQL GROUP By Clause.
-
SQL Union - Learn how to combine two or more queries using UNION operator
Data Manipulation Language tutorial (DML):
-
SQL UPDATE -In this tutorial you will learn how to update records with where and joins using SQL Update
-
SQL INSERT multiple rows -In this tutorial you will learn how you can using SQL insert multiple rows at once.
-
SQL INSERT DATE - In this tutorial you will learn how to insert date into a field using SQL INSERT
-
SQL INSERT if not exists - In this tutorial you will learn how to insert row if it does not already exist.
SQL Server Tutorial
Below are articles that are more specifc to SQL Server.
SQL Check if column exists
SQL Check if table exists
SQL Check if record exists
SQL Check if record exists before insert
SQL Check if record exists before update
SQL Convert date and time int into datetime
SQL Check if schema exists
SQL age bands
SQL Find table size
SQL add primary key to table with existing primary key
SQL Substring function
SQL Update progress status
SQL Server Soundex
The following link shows SQL Queries Examples from beginner to advanced