After setting the stage with a quick survey of database history and theory, Week 1 moved right into the heart of SQL with the SELECT statement. The following summary of the SELECT statement syntax includes cross-references to the days on which the particular aspect was covered:

• SELECT [DISTINCT | ALL] (Day 2)--Columns (Day 1), Functions (Day 4)

• FROM (Day 2)--Tables or Views (Day 1), Aggregate Functions (Day 4)

• WHERE (Day 5)--Condition (Day 3), Join (Day 6), Subquery (Day 7)

• GROUP BY (Day 5)--Columns (Day 3)

• HAVING (Day 5)--Aggregate Function (Day 4)

• UNION | INTERSECT (Day 3)--(Placed between two SELECT statements)

• ORDER BY (Day 5)--Columns (Day 1)

If you build a million queries in your programming career, more than 80 percent of them will begin with SELECT. The other 20 percent will fall into the categories covered in Week 2.

Preview

The new skills you learn in Week 2 cover database administration. During Week 2 you will learn how to

• Create and destroy tables

• Assign permissions to your friends and prevent your enemies from even looking at your data

• Update and delete data in tables

---

© Copyright, Macmillan Computer Publishing. All rights reserved.