Introduction to SQL Server

By Dan Sullivan
A introduction to relational databases and SQL Server
Course info
Level
Beginner
Updated
Jan 24, 2011
Duration
2h 10m
Table of contents
What is a Relational Database?
Overview 2m Entities 2m Primary Key 4m Text Based Language 1m Scalar Values 3m RDBMS 3m Summary 2m References 1m
SQL Server Data Manipulation Language
Overview 1m SSMS 1m Select 2m Insert 1m Missing and Default Values 1m Update 1m Delete 1m Join 1m Summary 1m References 0m
Using Select
Overview 2m SSMS 2m Database in use 3m Inspection 6m Select 4m Distinct 1m Null 3m Where 3m Count 1m Join 11m Summary 1m References 1m
Using Insert, Update, and Delete
Overview 1m Insert 1m Basic Insert 2m Specifying Columns 2m Null Values 2m DefaultValues 1m Multiple Inserts 1m Select Into 3m Insert from Select 5m Update 0m Basic Update 2m Search and Replace 3m Update Single Entity 2m Update Based on Select 4m Delete 0m Basic Delete 1m Delete by Attribute 2m Delete Single Entity 2m Summary 1m
Data Definition Language
Overview 2m Create Table 0m Simple Table 4m Table with Primary Key 6m Creating the People Table 6m Alter Table 1m Add Column 3m Drop Table 2m Summary 1m
Description
Course info
Level
Beginner
Updated
Jan 24, 2011
Duration
2h 10m
Description

This course starts with a high level introduction to relational databases. It follows up with the use of the Data Modification and Data Definition Languages that are part of SQL Server.

About the author
Dan Sullivan
About the author

Dan is an independent consultant, author, and speaker. He likes data; pointy data, rectangular data, even data just lying around on the floor. He is a co-author of the book "A Developers Guide to SQL Server 2005". His articles have been published in MSDN Magazine and SQL Server Magazine and he has spoken at WinDev, Microsoft events, as well as to various developer groups.

More from the author
Alan Turing's Wonderful Machine
Beginner
2h 20m
Dec 16, 2015
XML Fundamentals
Intermediate
4h 51m
May 11, 2012
.NET Regular Expressions
Intermediate
3h 29m
Oct 31, 2011
More courses by Dan Sullivan

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT