Add Microsoft SQL database development to your CV
using the free version of Microsoft SQL Server 2008 or 2012

Buy a single user license now with Paypal (no account required)
to download the complete course immediately.

was $44.99
now only $14.99

Solution Graphics      
 
For multiple licences for education or business please contact us at:
Microsoft SQL database fundamentals

Level: Beginner to Intermediate - Self Paced Training

Learn the fundamentals of SQL as you build a database for a fictitious hardware store. See exactly how to build a database and the methods used to extract meaningful information via queries, stored procedures, scalar functions and views. 

The course was written by a senior SQL developer at a major global company and is based on skills and practices used on a daily basis, rather than classroom theory. This is the ideal training course if you need to learn SQL for a job interview in a short space of time, or need practical real world examples of a SQL database in use.

Purchase the course to benefit from 60+ pages of step by step PDF documentation and full 1024x768 resolution videos.

Lesson topics include:

0 - Installing SQL Server Express
1 - Creating Your First Database
2 - Creating Stored Procedures
3 - Foreign Key Relationships
4 - Insert Statements, Joins & Diagrams
5 - Queries With Aggregate Functions
6 - Scalar & Inline Table Functions
PDF user guide

FREE download of lessons 0, 1 & 2  
 


Getting Started
Installing SQL Server Express

You will need to first install Microsoft SQL Server Express 2008 or 2012 with Management Tools, download for free from the Microsoft Download Center.

Lesson 2
Creating Stored Procedures

Tutorial includes: creating and executing insert, update, delete, select
stored procedures and more.

Lesson 4
Insert Statements / Database Diagrams

Tutorial includes: sql queries with joins, modifying tables with the database diagram and more.

Lesson 6
Scalar & Inline Table Functions

Tutorial includes: creating scaler & inline table functions, using functions
in sql queries and more.
Lesson 1
Creating Your First Database

Tutorial includes: creating a new table, setting a primary key, setting an
identity column and more.

Lesson 3
Foreign Key Relationships

Tutorial includes: creating relationships between tables, creating a database diagram and more.

Lesson 5
Select Queries / Aggregate Functions

Tutorial includes: working with views, creating sql queries with aggregate
functions and more.


PDF user guidePDF user guide
Step by step PDF documentation allows you to refer back to the course without needing to watch the videos again!
Boolean Logical