This page has 0 threads | Add post

SQL tutorials

We've published 101 guides on how to use SQL, divided into the following categories:

Getting started in SSMS (3)

Before you get into writing SQL Queries you should take some time to familiarise yourself with the application in which you'll be spending most of your time.

Show these tutorials

Creating databases (2)

Designing and creating databases for use in SQL Server Management Studio.

Show these tutorials

Writing queries (7)

Write basic queries using the SELECT, FROM and ORDER BY keywords

Show these tutorials

WHERE criteria (version A) (6)

We've written two versions of our tutorial on using WHERE criteria in SQL - this is the Andrew Gould version.

Show these tutorials

WHERE criteria (version B) (4)

We've written two versions of our tutorial on using WHERE criteria in SQL - this is the Andy Brown version.

Show these tutorials

Calculations and Expressions (6)

You'll encounter calculations, or expressions, almost everywhere in SQL. The articles in this section explain everything from simple arithmetic to using complex sequences of nested functions.

Show these tutorials

Dates and times (7)

Dates can be one of the most frustrating things to work with in SQL Server, but these tutotirals should help explain things.

Show these tutorials

Joins (7)

Tutorials on how to create inner joins, left outer joins, right outer joins, full outer joins, cross joins and self-joins!

Show these tutorials

Use the GROUP BY clause in SQL for statistics Part one of a four-part series of blogs If you want to average, count, sum or perform any other statistic on values in SQL, you need to learn the GROUP BY and HAVING parts of a SQL statement.

Show these tutorials

Views (4)

Views are queries that you can save and reuse; but you can also use them as a basis for further queries.

Show these tutorials

Subqueries (4)

A subquery allows you to nest one query inside another allowing you to do all sorts of interesting things.

Show these tutorials

CTEs and derived tables (6)

Common Table Expressions are a cool successor to derived tables, which allow you to write SQL which is easier to understand

Show these tutorials

Programming in SQL (5)

Tutorials explaining some of the fundamental concepts you'll need to get the most out of programming in SQL.

Show these tutorials

Trapping errors and debugging (2)

Trap errors while your SQL code is running, including using TRY / CATCH and raising and throwing errors, and find the bugs in your code and stamp them out!

Show these tutorials

Stored procedures (7)

A stored procedure is a set of SQL instructions stored in a database.

Show these tutorials

User-defined functions (5)

Scalar User Defined Functions in SQL Server - UDFs Part one of a five-part series of blogs If you have a calculation that you frequently use in SQL queries you're probably bored of writing out the same code time after time. Why not try creating a user-defined function to save you the hassle?

Show these tutorials

If you want to learn any of the above in more detail, have a look at booking one of our classrooom and online SQL courses.

This page has 0 threads

Add a new post

Online tutorials

Tutorials on SQL

SQL tutorials

Getting started in SSMS (3)

Creating databases (2)

Writing queries (7)

WHERE criteria (version A) (6)

WHERE criteria (version B) (4)

Calculations and Expressions (6)

Dates and times (7)

Joins (7)

Grouping data (4)

Views (4)

Subqueries (4)

CTEs and derived tables (6)

Programming in SQL (5)

Trapping errors and debugging (2)

Stored procedures (7)

User-defined functions (5)

Entering and changing data (3)

Temporary tables and table variables (2)

Table-valued functions (1)

Pivoting data (3)

Triggers (4)

Dynamic SQL (4)

Transactions (4)

Cursors (1)

Head office

London

Manchester