Writing Smart SQL

4/10/2002


Click here to start


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