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

Previous chapterNext chapterContents


Week 3 At A Glance

Applying Your Knowledge of SQL

Welcome to Week 3. So far you have learned the fundamentals of SQL and already know enough to apply what you have learned to some real-life situations. This week builds on the foundation established in Weeks 1 and 2. Day 15 shows you how to streamline SQL statements for improved performance. Day 16 talks about the data dictionary, or system catalog, of a relational database and shows you how to retrieve valuable information. Day 17 extends the concept of using the data dictionary to generate SQL as output from another SQL statement. You will learn the benefits of this technique and discover how generating SQL can improve your efficiency on the job. Day 18 covers Oracle's PL/SQL, or Oracle procedural language. PL/SQL is one of the many extensions to standard SQL. Another extension is Sybase's and Microsoft Server's Transact-SQL, which is covered on Day 19. Day 20 returns to Oracle to cover SQL*Plus, which allows you to use advanced commands to communicate with the database. SQL*Plus also enables you to format query-generated reports in an attractive manner. You can use SQL*Plus in collaboration with PL/SQL. Day 21 examines errors and logical mistakes that relational database users frequently encounter. We provide brief descriptions of the errors, solutions, and tips on avoiding errors.


Previous chapterNext chapterContents


Macmillan Computer Publishing USA

© 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.