Intro to SQL
Intro to SQL
What Is SQL?
Language Documentation
Creating a Table
Some SQL Types
Populating a Table
Querying a Table
A Fuller Table
Updating a Table
Keys
Primary Key Constraints
Identity Columns
Determining Identity Column Values
More Tables with Keys
Tables Containing Information from Other Tables
Foreign Keys
Foreign Key Constraints
Compound Keys
Compound Conditions Can Use AND, OR, NOT
Selecting From Multiple Tables—Table Joins
More on Table Joins
Much More