Week 1 at a Glance
Day 1 Introduction to SQL
Day 2 Introduction to the Query: The SELECT Statement
Day 3 Expressions, Conditions, and Operators
Day 4 Functions: Molding the Data You Retrieve
Day 5 Clauses in SQL
Day 6 Joining Tables
Day 7 Subqueries: The Embedded SELECT Statement
Week 1 in Review
Week 2 at a Glance
Day 8 Manipulating Data
Day 9 Creating and Maintaining Tables
Day 10 Creating Views and Indexes
Day 11 Controlling Transactions
Day 12 Database Security
Day 13 Advanced SQL Topics
Day 14 Dynamic Uses of SQL
Week 2 in Review
Week 3 at a Glance
Day 15 Streamlining SQL Statements for Improved Performance
Day 16 Using Views to Retrieve Useful Information from the Data Dictionary
Day 17 Using SQL to Generate SQL Statements
Day 18 PL/SQL: An Introduction
Day 19 Transact-SQL: An Introduction
Day 20 SQL*Plus
Day 21 Common SQL Mistakes/Errors and Resolutions
Week 3 in Review
Appendixes
A Glossary of Common SQL Statements
B Source Code Listings for the C++ Program Used on Day 14
C Source Code Listings for the Delphi Program Used on Day 14
D Resources
E ASCII Table
F Answers to Quizzes and Excercises
/ Copyright, Macmillan Computer Publishing. All rights reserved.
Join the National Guard
Car Computer
Serve in your own backyard Get Free Info Here. No
Obligation
www.military.com
Complete Diagnostic Software Tool DTC Codes,
Sensor Readings & More! www.digimoto.com Teach Yourself SQL in 21 Days, Second Edition
Acknowledgments
A special thanks to the following individuals: foremost to my loving wife, Tina, for her tolerance and endless support, to Dan Wilson for his contributions, and to Thomas McCarthy at IUPUI. Also, thank you Jordan for your encouragement over the past few years.
-- Ryan K. Stephens
Special thanks to
