SQL Server Tutorial

This SQL Server tutorial is for anyone who wishes to learn how to use SQL Server. It assumes a basic understanding of databases and how they work.

If you don't currently have an understanding of how databases work, start with the basic database tutorial first. That tutorial covers the basic concepts of databases, so the examples in this tutorial will make more sense once you return here.

To get the most out of this tutorial, you should have a copy of SQL Server installed on your computer, so that you can go through the examples yourself. If you don't have a copy, that's OK - you should still be able to gain an understanding of what SQL Server is and what's involved in using it.

You will find 3 tutorials here; a tutorial for SQL Server 2014, a tutorial for SQL Server 2008, and a tutorial for SQL Server 2000.

SQL Server 2014

This tutorial covers the 2014 edition of SQL Server (SQL Server 2014). Specifically, it uses (the free) SQL Server 2014 Express with Tools.

This tutorial consists of the following lessons:

  1. About SQL Server 2014
  2. SQL Server 2014 - Editions
  3. SQL Server 2014 - Installation
  4. SQL Server 2014 - Management Studio
  5. SQL Server 2014 - Create a Database
  6. SQL Server 2014 - Create a Table
  7. SQL Server 2014 - Adding Data
  8. SQL Server 2014 - SQL Scripts
  9. SQL Server 2014 - Query Designer
  10. SQL Server 2014 - Views
  11. SQL Server 2014 - Stored Procedures
  12. SQL Server 2014 - User Logins
  13. SQL Server 2014 - Server Roles
  14. SQL Server 2014 - Database Schemas
  15. SQL Server 2014 - Linked Servers
  16. SQL Server 2014 - Summary

SQL Server 2008

If you need to learn SQL Server 2008, use the SQL Server 2008 tutorial.

SQL Server 2000

And if for a blast from the past, check out my SQL Server 2000 tutorial!

SQL Programming Tutorial

If you already know about SQL Server and like to learn more about SQL programming, check out the SQL tutorial.

Enjoy this page?

  1. Link to this page (copy/paste into your own website or blog):
  2. Link to Quackit using one of these banner ads.

Thanks for supporting Quackit!

Sponsored Link: Design CODE-FREE Websites

Check a Domain:

ZappyHost Logo
Webydo Banner Ad