Table of Contents
Writing Smart SQL
Presentation Outline
History of SQL
Relational Databases
SQL Language
Data Manipulation Language
SQL—NOT!
Views and Stored Procedures
Prime Directives
Engine Tuning
Index Selection
Don’t Over Index
Simple SELECT’s
Simple SELECT’s--continued
Simple SELECT’s—continued
Aggregate Functions
GROUP BY
JOINS
JOINS--continued
JOINS to get all info with single qry
JOINS to get all info with single qry --continued
Sub-SELECT’s
Other SELECT Topics
SQL makes your database work easier and faster
|
Author: Alan Shilepsky
|