Introduction to SQL Server
A introduction to relational databases and SQL Server
You are currently not signed in. Please sign in to access subscriber-only content.
Currently using: {{getCurrentPlayerName()}} [Change]
| expand all | collapse all | Progress | Duration | |
|---|---|---|---|
What is a Relational Database? |
|
00:17:39 | |
|
Overview
|
|
02:09 | |
|
Entities
|
|
02:11 | |
|
Primary Key
|
|
04:00 | |
|
Text Based Language
|
|
01:27 | |
|
Scalar Values
|
|
02:41 | |
|
RDBMS
|
|
02:49 | |
|
Summary
|
|
01:51 | |
|
References
|
|
00:31 | |
SQL Server Data Manipulation Language |
|
00:10:01 | |
|
Overview
|
|
01:22 | |
|
SSMS
|
|
00:45 | |
|
Select
|
|
02:29 | |
|
Insert
|
|
00:36 | |
|
Missing and Default Values
|
|
00:37 | |
|
Update
|
|
01:13 | |
|
Delete
|
|
00:46 | |
|
Join
|
|
01:23 | |
|
Summary
|
|
00:39 | |
|
References
|
|
00:11 | |
Using Select |
|
00:39:10 | |
|
Overview
|
|
01:39 | |
|
SSMS
|
|
02:07 | |
|
Database in use
|
|
03:14 | |
|
Inspection
|
|
06:26 | |
|
Select
|
|
03:58 | |
|
Distinct
|
|
01:02 | |
|
Null
|
|
03:09 | |
|
Where
|
|
03:16 | |
|
Count
|
|
01:19 | |
|
Join
|
|
11:22 | |
|
Summary
|
|
01:05 | |
|
References
|
|
00:33 | |
Using Insert, Update, and Delete |
|
00:37:25 | |
|
Overview
|
|
00:42 | |
|
Insert
|
|
00:59 | |
|
Basic Insert
|
|
02:11 | |
|
Specifying Columns
|
|
01:43 | |
|
Null Values
|
|
02:18 | |
|
DefaultValues
|
|
01:29 | |
|
Multiple Inserts
|
|
01:19 | |
|
Select Into
|
|
03:22 | |
|
Insert from Select
|
|
04:50 | |
|
Update
|
|
00:12 | |
|
Basic Update
|
|
02:13 | |
|
Search and Replace
|
|
03:26 | |
|
Update Single Entity
|
|
02:15 | |
|
Update Based on Select
|
|
03:56 | |
|
Delete
|
|
00:17 | |
|
Basic Delete
|
|
01:24 | |
|
Delete by Attribute
|
|
01:42 | |
|
Delete Single Entity
|
|
01:47 | |
|
Summary
|
|
01:20 | |
Data Definition Language |
|
00:25:39 | |
|
Overview
|
|
01:45 | |
|
Create Table
|
|
00:25 | |
|
Simple Table
|
|
04:17 | |
|
Table with Primary Key
|
|
06:25 | |
|
Creating the People Table
|
|
06:09 | |
|
Alter Table
|
|
00:37 | |
|
Add Column
|
|
03:10 | |
|
Drop Table
|
|
01:40 | |
|
Summary
|
|
01:11 |
What is a Relational Database?