Learning SQL - Softcover

Beaulieu, Alan

Softcover

ISBN 10: 0596007272 ISBN 13: 9780596007270

Publisher: O′Reilly, 2005

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 this title

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.

Edition details

• Publisher: O′Reilly
• Publication date: 2005
• Language: English
• ISBN 10: 0596007272
• ISBN 13: 9780596007270
• Binding: Paperback
• Number of pages: 306