SQL Server 2014 Tutorial
Table of Contents
This tutorial uses SQL Server 2014 and covers the following:
- About SQL Server 2014
- SQL Server 2014 - Editions
- SQL Server 2014 - Installation
- SQL Server 2014 - Management Studio
- SQL Server 2014 - Create a Database
- SQL Server 2014 - Create a Table
- SQL Server 2014 - Adding Data
- SQL Server 2014 - SQL Scripts
- SQL Server 2014 - Query Designer
- SQL Server 2014 - Views
- SQL Server 2014 - Stored Procedures
- SQL Server 2014 - User Logins
- SQL Server 2014 - Server Roles
- SQL Server 2014 - Database Schemas
- SQL Server 2014 - Linked Servers
- SQL Server 2014 - Summary
This tutorial is for anyone who wants to learn how to use SQL Server 2014. It assumes a basic understanding of databases and how they work, but it does not assume any prior experience with SQL Server 2014 or previous editions.
If you don't know how databases work, start with the basic database tutorial first.
The examples in this tutorial are all done using the free version of SQL Server - SQL Server 2014 Express with Tools. You can download SQL Server 2014 Express with Tools from the Microsoft website (we'll get to that in a minute).
If you don't currently have SQL Server yet, that's OK. The tutorial is straight forward and contains plenty of screenshots.
Other Versions of SQL Server
For other versions of SQL Server, see SQL Server Tutorial. Also check out the SQL tutorial.