SQL Fundamentals

John J. Patrick

768 pages, parution le 22/05/2002 (2^eme édition)

Ajouter à une liste

Indisponible

Résumé

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 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. From the simplest SELECT statements to the most sophisticated joins, Patrick shows you exactly how to write SQL queries that are easy to understand, verify, modify, and extend. SQL Fundamentals, Second Edition teaches you to :

Write simple statements to retrieve, store, or modify data
Build complex queries that draw information from multiple tables
Create your own tables
Summarize your data: basic and advanced techniques
Understand and ensure data integrity
Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins

Contents

Preface.
Acknowledgments.
1. Storing Information in Tables
2. Getting Information from a Table
3. Compound Conditions in the Where Clause
4. Saving Your Results
5. Modifying Data Through a View
6. Creating Your Own Tables
7. Formats, Sequences, and Indexes
8. Data Integrity
9. Row Functions
10. Using Row Functions
11. Summarizing Data
12. Controlling the Level of Summarization
13. Inner Joins
14. Outer Joins
15. Union and Union All
16. Cross Joins and Self Joins
17. Combining Tables in a Production Database
18. If-Then-Else and Subqueries
19. The Multiuser Environment
20. The Design of SQL
Appendix A. Obtaining and Installing Oracle
Appendix B. Tips on Using Oracle
Appendix C. Tips on Using Access
Appendix D. Diagram of the Lunches Database
Index

Caractéristiques techniques

	PAPIER
Éditeur(s)	Prentice Hall
Auteur(s)	John J. Patrick
Parution	22/05/2002
Édition	2^eme édition
Nb. de pages	768
Format	17,5 x 23,5
Couverture	Broché
Poids	1230g
Intérieur	Noir et Blanc
EAN13	9780130669476
ISBN13	978-0-13-066947-6