Learning SQL

Alan Beaulieu

ISBN 10: 0596007272 / ISBN 13: 9780596007270

Published by O'Reilly Media, 2005

About this Item

Discussing various platform differences that you're likely to encounter, this guide offers a series of helpful chapter exercises that teach you how to generate, manipulate, and retrieve the data stored in your organization's database. It is useful for those writing applications, performing administrative tasks, or generating reports.

Seller Inventory # CIN0596007272G

Bibliographic Details

• Title: Learning SQL
• Publisher: O'Reilly Media
• Publication Date: 2005
• Language: English
• ISBN 10: 0596007272
• ISBN 13: 9780596007270
• Binding: Paperback
• Condition: Good

About this title

Synopsis

SQL, the universal language of databases, looks simple and is often used by developers as if it is, but in fact its relatively few but very powerful commands and the necessity of it being invoked by general-purpose languages such as C++, Java, Python and Perl make it a sophisticated tool that can solve difficult problems with a single statement. This introductory text aims at a solid understanding of SQL language and standard syntax in a practical format, covering creating and populating a database, querying (including querying multiple tables), filtering, working with sets, generating data (and converting and manipulating it), grouping, making sub-queries, and working with joins, conditional logic, transactions, indexes and constraints. Annotation ©2005 Book News, Inc., Portland, OR (booknews.com)

About the Author

Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters and can be reached at albeau_mosql@yahoo.com.