Introduction to SQL Server
By Dan Sullivan
A introduction to relational databases and SQL Server
Course info
Rating
Level
Beginner

Updated
Jan 24, 2011

Duration
2h 9m

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
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
Description
Course info
Rating
Level
Beginner

Updated
Jan 24, 2011

Duration
2h 9m

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