Details

Mastering Oracle SQL and SQL*Plus


Mastering Oracle SQL and SQL*Plus



von: Lex deHaan

52,99 €

Verlag: Apress
Format: PDF
Veröffentl.: 01.11.2006
ISBN/EAN: 9781430200000
Sprache: englisch
Anzahl Seiten: 488

Dieses eBook enthält ein Wasserzeichen.

Beschreibungen

*Ideal for anyone who wants to learn SQL programming for Oracle database.
<P>*Author has 25 years of teaching experience; 14 years of curriculum develoment experience; 14 years of experience with the Orcle database.
<P></P>
<P>*Book can be used as collateral/handouts for SQL training courses at universities/ high schools.
<P></P>
It is a true honor to be asked to write an introduction to a book by Lex de Haan. I just hope I can give Lex the credit he deserves for his friendship, knowledge, enthusiasm, carpentry . . . and sheer energy in the many years we’ve been doing things in the Oracle world. Lex spent 14 years in Oracle, starting as an instructor in Oracle Netherlands, becoming initiator and coordinator of Oracle’s excellent Technical Seminar business, and finally ending up in Oracle’s Curriculum Development division as a manager for a bunch of very excellent course developers. He is never afraid to start up something new, to enter new and untried waters… a personal trait he shares with about 0. 00001% of the global population. Then, finally, Lex started up for himself, and, of course, the company name had to reflect his twisted, funny way of thinking: Natural Join. Who else can get away with it, looking sto- faced and with just the slightest twinkle in his eyes, if you look really carefully? Since then Lex, as always, hasn’t looked back but has worked nonstop as instructor all over Europe and the Middle East, and as writer. The book in front of you is, in fact, an update of a book he wrote many moons ago, and which has served as a textbook in various Dutch schools.
<ol>
<li>Relational Database Systems and Oracle </li>
<li>Introduction to SQL, iSQL*Plus, and SQL*Plus </li>
<li>Data Definition, Part I </li>
<li>Retrieval: The Basics </li>
<li>Retrieval: Functions </li>
<li>Data Manipulation </li>
<li>Data Definition, Part II </li>
<li>Retrieval: Multiple Tables and Aggregation </li>
<li>Retrieval: Some Advanced Features </li>
<li>Views </li>
<li>SQL*Plus and iSQL*Plus </li>
</ol>
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).
<P>SQL is the ANSI-standard language for accessing and manipulating relational databases. Anyone (programmers, administrators, or designers) who work with a relational databases need to understand the SQL language. While most books on the market do not properly cover the basics, this book differs: it explains fundamentals in detail, supported by realistic examples.You will gain full competence to define, access, and manipulate data in an Oracle database. </P>

Diese Produkte könnten Sie auch interessieren:

Quantifiers in Action
Quantifiers in Action
von: Antonio Badia
Preis: 96,29 €
Managing and Mining Uncertain Data
Managing and Mining Uncertain Data
von: Charu C. Aggarwal
Preis: 96,29 €