Oracle SQL Primer: Learning the Craft

0 avg rating
( 0 ratings by Goodreads )
 
9780964491250: Oracle SQL Primer: Learning the Craft
View all copies of this ISBN edition:
 
 

SQL is an elegant and powerful tool for querying Oracle databases. Oracle SQL Primer discusses the concepts, techniques, and mindset needed to produce accurate and fast SQL. These skills have never before been collected into a single book.

In Oracle SQL Primer, you'll experience SQL as a craft and learn how to: systematically approach any query and break it into easy, modular steps; ensure accurate SQL queries with good response time; define the query population and avoid common mistakes in definition; step through table joins and identify when errors occur; fix join errors that compromise the integrity of the query population; structure queries to make them easier to interpret, test, and debug; apply templates that will save time in report preparation; format and document reports for distribution to other people; use a set of SQL utility programs to explore any Oracle database; and write SQL that demonstrates true craftsmanship.

Oracle SQL Primer distinguishes itself from other SQL books with its: emphasis on SQL for reporting and ad hoc queries; templates to produce common reports; 200 figures that illustrate key points; exercises and answers to sharpen SQL skills (appropriate for training, classroom, or self-paced use); use of a simulated student registration system to provide reality to examples; extensive SQL and SQL*Plus documentation collected in one place; organization of topics based on what's most important to know to write effective SQL; informal, collegial writing style; and respect and admiration for SQL as a skilled craft.

"synopsis" may belong to another edition of this title.

About the Author:

Gary M. Lewis is the founder of Komenda, Inc, a consulting and publishing company that provides Oracle reporting solutions to colleges and universities. He is the author of two other books on SQL, including Oracle SQL: 101 Frequently Asked Questions. His background includes a doctorate in educational policy research and over 20 years experience in higher education, where he has held positions in management information systems and institutional research. He is presently senior database architect at Bentley College in Waltham, Massachusetts.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Gary M. Lewis
Published by Komenda Publishing Company
ISBN 10: 0964491257 ISBN 13: 9780964491250
Used Paperback Quantity Available: 1
Seller:
ThriftBooks - Atlanta Book Co.
(Atlanta, GA, U.S.A.)
Rating
[?]

Book Description Komenda Publishing Company. Paperback. Condition: Good. Book shows minor use. Cover and Binding have minimal wear and the pages have only minimal creases. Seller Inventory # G0964491257I3N00

More information about this seller | Contact this seller

Buy Used
US$ 22.56
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Lewis, Gary M.
Published by Komenda Pub Co (2001)
ISBN 10: 0964491257 ISBN 13: 9780964491250
Used Paperback Quantity Available: 1
Seller:
Elusive Books
(Thornton, CO, U.S.A.)
Rating
[?]

Book Description Komenda Pub Co, 2001. Paperback. Condition: Used: Very Good. Seller Inventory # 131217010

More information about this seller | Contact this seller

Buy Used
US$ 19.57
Convert Currency

Add to Basket

Shipping: US$ 3.00
Within U.S.A.
Destination, Rates & Speeds