Beginning Oracle SQL

1. Auflage 2009
ISBN: 978-1-4302-7197-0
Verlag: Apress

Buch, Englisch, 459 Seiten, Format (B × H): 191 mm x 235 mm, Gewicht: 831 g

is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classic by Lex de Haan, and has been updated to cover developments in Oracle's version of the SQL query language. Written in an easygoing and example-based style, is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle database.

• Takes an example-based approach, with clear and authoritative explanations
• Introduces both SQL and the query tools used to execute SQL statements
• Shows how to create tables, populate them with data, and then query that data to generate business results

Zielgruppe

Popular/general

Autoren/Hrsg.

deHaan, Lex

Morton, Karen

Morton, Andrew

Gorman, Tim

Jorgensen, Inger

Fink, Daniel

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung Oracle

Inhaltsverzeichnis

1: Relational Database Systems and Oracle. 2: Introduction to SQL and the Interactive Query Tools. 3: Data Definition, Part I. 4: Retrieval: The Basics. 5: Retrieval: Functions. 6: Data Manipulation. 7: Data Definition, Part II. 8: Retrieval: Multiple Tables and Aggregation. 9: Retrieval: Advanced Features. 10: Views. 11: Writing Automating SQL Scripts. 12: Object-Relational Features. Appendix A: The Seven Case-study Tables.

Über Autor(innen)

Lex de Haan studied applied mathematics at the University of Technology in Delft, the Netherlands. His experience with Oracle goes back to the mid-1980s, version 4. He worked for Oracle Corporation from 1990 to 2004 in various education-related roles, ending up in Server Technologies (product development) as senior curriculum manager for the advanced database administration curriculum. In that role, he was involved in the development of Oracle9i and Oracle Database 10g. In March 2004, he decided to go independent and founded Natural Join B.V. (http://www.naturaljoin.nl). From 1999 until his passing in 2006, he was involved in the ISO SQL language standardization process, as a member of the Dutch national body. He was also one of the founding members of the OakTable network (http://www.oaktable.net).