Free E-Books

Teach Yourself SQL in 21 Days, Second Edition

Next chapter
Table of Contents:

Introduction

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

Macmillan Computer Publishing

http://rapidshare.com/files/65055542/Sql21days.zip