SQL Fundamentals - Couverture souple

Patrick, John J.

Couverture souple

ISBN 10 : 0130960160 ISBN 13 : 9780130960160

Editeur : Prentice Hall, 1999

Synopsis

The book covers: the fundamental concepts and ideas of SQL used for creating ad-hoc reports. It covers the way these concepts are implemented in SQL products. Oracle and Access are the two examples used. Access for small data bases and Oracle for large data bases.

A propos du livre

À propos de l'auteur

John Patrickis a computer consultant and software developer specializing in relational database technology. He teaches SQL Fundamentals and other database courses at the University of California, Berkeley Extension, and has over 20 years experience in software development at Bank of America, Chevron, Kaiser Permanente and other leading firms.

À propos de la quatrième de couverture

9601F-1

Don't just learn "generic" SQL! Learn SQL to get results with the world's top database platforms: Oracle for the enterprise and Microsoft Access for the desktop! Based on John Patrick's hands-on SQL course for IT pros at the University of California, Berkeley, this book shows exactly how to retrieve the data you want, when you need it, in any application - from ad hoc reports to the data warehouse. SQL Fundamentals covers all this and more:

• Simple queries that retrieve information from a single table
• Creating tables and views to divide a complex process into a series of single steps
• Summarizing your data
• Inner joins, outer joins, unions, self joins, cross joins, and subqueries
• Writing SQL queries that are easily understood, verified, modified, and extended

Want better access to business data? Want to make your data more accessible to others? SQL Fundamentals delivers the practical techniques and examples you need - on the database platforms you already use! If you want to fully use the information in your database, then read this book!

CD-ROM INCLUDED

The accompanying CD-ROM contains a library of Access databases and the code for building Oracle databases. All the tables used in the book are furnished in both Oracle and Access format. A website provides additional technical support to assure that all the code is completely correct and works with the latest versions of both Oracle and Access.

Détails de l'édition

• Éditeur: Prentice Hall
• Date d'édition: 1999
• Langue: anglais
• ISBN 10: 0130960160
• ISBN 13: 9780130960160
• Reliure: Broché
• Numéro d'édition: 1
• Nombre de pages: 544
• Coordonnées du fabricant: non disponible
• Personne responsable: non disponible