Teach Yourself SQL in 21 Days, Second Edition
Imprint:
Author: Various
Publication Date: Jun-96
ISBN: 0-672-31110-0
Table of Contents
Introduction
Week 1 at a Glance
Day 1 Introduction to SQL
Week 1 in Review
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 2 at a Glance
Day 8 Manipulating Data
Week 2 in Review
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 3 at a Glance
Day 15 Streamlining SQL Statements for Improved Performance
Week 3 in Review
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
Appendixes
Appendix A Glossary of Common SQL Statements
Appendix B Source Code Listings for the C++ Program Used on Day
14
Appendix C Source Code Listings for the Delphi Program Used on Day
14
Appendix D Resources
Appendix E ASCII Table
Appendix F Answers to Quizzes and Excercises
© Copyright, Macmillan Computer Publishing. All rights reserved.