Microsoft SQL Database Fundamentals
Everything you need to add SQL to your CV.
Level: Beginner to Intermediate - Self Paced Training
Please note that the following preview videos are not full quality, the full quality videos can downloaded from the FREE Download link above
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.
Creating Stored Procedures
Tutorial includes: creating and executing insert, update, delete, select
stored procedures and more.
Insert Statements / Database Diagrams
Tutorial includes: sql queries with joins, modifying tables with the database diagram and more.
Scalar & Inline Table Functions
Tutorial includes: creating scaler & inline table functions, using functions
in sql queries and more.
Creating Your First Database
Tutorial includes: creating a new table, setting a primary key, setting an
identity column and more.
Foreign Key Relationships
Tutorial includes: creating relationships between tables, creating a database diagram and more.
Select Queries / Aggregate Functions
Tutorial includes: working with views, creating sql queries with aggregate
functions and more.