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


Next chapter


© Copyright, Macmillan Computer Publishing. All rights reserved.