| Introduction to Databases |
Relational Databases |
 |
Database |
|
Files or Tables |
|
Database - Further Properties |
|
Metadata |
|
|
Relational Database |
|
Example of a Relation |
|
Relational Operations |
|
| Introduction To SQL |
Table Creation |
|
History of SQL |
|
Data Definition Language |
|
Tables |
|
Schemas |
|
Views |
|
|
Data Manipulation Language |
|
Find Data |
|
Insert, Update and Delete Data |
|
Data Control Language |
|
Grant and Revoke
|
|
Commit and Rollback |
|
Non-Procedural Language |
|
SQL Datatypes |
|
| Finding Data In Tables - Part I |
Finding Data in Tables - Part II |
|
Select Statement |
|
Where Clause Predicates |
|
Boolean combinations |
|
SQL "Truth" Tables |
|
Boolean Precedence |
|
Two Value Rules Retained |
|
Between Predicate |
|
In Predicate |
|
Outer Reference |
|
Exists Predicate |
|
Quantified Predicate |
|
|
Joins |
|
Cross Product Joins |
|
Equ-Join |
|
Outer-Joins |
|
Left Outer Join |
|
Union, Intersection, and
Difference |
|
All Keyword |
|
Order By |
|
Multiple Column Order Bys |
|
NULL and ORDER BY |
|
Aggregate Functions |
|
Table for Aggregates |
|
Aggregate functions, examples |
|
Aggregate Function Rules |
|
Group By |
|
Having Cause |
|
Views |
|
Normalized Tables and Views |
|
Combined View |
|
Views and Security |
|
Drop View |
|
Update |
|
Assignments |
|
Delete |
|
Updateable Views |
|
| More Data Definition Language |
Data Control Language |
|
Drop Table |
|
Alter |
|
Create Index |
|
Index Speedup |
|
|
Data Control Language |
|
Grant |
|
Reference Privileges |
|
Revoke |
|
Abandoned Privileges |
|
Transaction |
|
Commit and Rollback |
|
Transactions and Microsoft (specific to Microsoft) |
|
SQL Server Locks |
|
Read Committed |
|
Read Uncommitted |
|
Repeatable Read |
|
HOLDLOCK |
|
Other Table Qualifiers |
|
Locking Granularity |
|
Shared, Exclusive and Update
Lock |
|
Intent, Extent and Demand Locks |
|
Demand locks |
|
sp_lock |
|
Deadlock |
|
ISQLW and Transactions |
|
ISQLW and set statements |
|
| Introduction to Relational Database Design |
|
|
One-To-One Relationships |
|
One-To-Many |
|
Many-To-Many |
|
Normal Forms |
|
First Normal Form |
|
Second Normal Form |
|
Third Normal Form |
|
|
