Sams Teach Yourself SQL in 21 Days

Name: Sams Teach Yourself SQL in 21 Days
Price: 6.09 USD
Availability: InStock
ISBN: 9780672311109

ISBN-10: 0672311100

ISBN-13: 9780672311109

Edition: 2nd 1997

Authors: Jeff Perkins

List price: $39.99

30 day, 100% satisfaction guarantee!

Marketplace

2 new & used from $6.09

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Starting with a history lesson the book explains common database concepts, enabling the reader to retrieve data from a RDBMS in a week. The SQL functions are covered so that quickly, the reader can query the database without recourse to 'wizards'.

Book details

List price: $39.99
Edition: 2nd
Copyright year: 1997
Publisher: Sams
Binding: Paperback
Pages: 596
Size: 7.32" wide x 9.06" long x 1.50" tall
Weight: 2.266
Language: English

Perkins is a Senior Software Engineer for the TYBRIN Corporation, where he frequently works on contract with the NASA facilities in Huntsville, AL.



Introduction



Introduction to SQL



Introduction to the Query: The SELECT Statement



Expressions, Conditions, and Operators



Functions: Molding the Data You Retrieve



Clauses in SQL



Joining Tables



Subqueries: The Embedded SELECT Statement



Manipulating Data



Creating and Maintaining Tables



Creating Views and Indexes



Controlling Transactions



Database Security



Advanced SQL Topics



Dynamic Uses of SQL



Streamlining SQL Statements for Improved Performance



Using Views to Retrieve Useful Information from the Data Dictionary



Using SQL to Generate SQL Statements



PL/SQL: An Introduction



Transact-SQL: An Introduction



SQL*Plus



Common SQL Mistakes/Errors and Resolutions



Glossary of Common SQL Statements



Source Code Listings for the C++ Program Used on Day 14



Source Code Listings for the Delphi Program Used on Day 14



Resources



ASCII Table


F: Answers to Quizzes and Exercises


Index