Brought to you by EarthWeb
IT Library Logo

Click Here!
Click Here!


Search the site:
 
EXPERT SEARCH -----
Programming Languages
Databases
Security
Web Services
Network Services
Middleware
Components
Operating Systems
User Interfaces
Groupware & Collaboration
Content Management
Productivity Applications
Hardware
Fun & Games

EarthWeb Direct EarthWeb Direct Fatbrain Auctions Support Source Answers

EarthWeb sites
Crossnodes
Datamation
Developer.com
DICE
EarthWeb.com
EarthWeb Direct
ERP Hub
Gamelan
GoCertify.com
HTMLGoodies
Intranet Journal
IT Knowledge
IT Library
JavaGoodies
JARS
JavaScripts.com
open source IT
RoadCoders
Y2K Info

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.

footer nav
Use of this site is subject certain Terms & Conditions.
Copyright (c) 1996-1999 EarthWeb, Inc.. All rights reserved. Reproduction in whole or in part in any form or medium without express written permission of EarthWeb is prohibited. Please read our privacy policy for details.