Course
Skills
Introduction to SQL Server
A introduction to relational databases and SQL Server
What you'll learn
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.
Table of contents
What is a Relational Database?
18mins
SQL Server Data Manipulation Language
10mins
Using Select
38mins
Using Insert, Update, and Delete
35mins
- 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
25mins
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.