Book Description
Beginning Oracle SQL 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 Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to cover the very latest developments in Oracle's version of the SQL query language. Written in an easygoing and example-based style, Beginning Oracle SQL 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
What you'll learn
- Create database tables and define their relationships
- Add data to your tables; change and delete that data
- Write database queries that generate accurate results
- Avoid common traps and pitfalls in writing SQL queries
- Take advantage of advanced Oracle SQL features such as support for hierarchical queries, analytic and window functions, flashback to a given point in time, and more
- Get a handle on Oracle Database's support for object types in the database
Who is this book for?
This book is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed.
About the Author
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 DBA 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).
Tim Gorman began his IT career in 1984 as a C programmer on UNIX and VMS systems, working on medical and financial systems as an application developer, systems programmer, and systems administrator. He joined Oracle Corporation in 1990 as a consultant, then became an independent consultant in 1998, and has worked for SageLogix since 2000. Gorman is the coauthor of Essential Oracle8i Data Warehousing and Oracle8 Data Warehousing. He specializes in performance tuning applications, databases, and systems, as well as data warehouse design and implementation, backup and recovery, architecture and infrastructure, and database administration. Gorman still considers himself a pretty good coder, although the market for C programs has dried up somewhat lately.
Karen Morton is a consultant and educator specializing in application optimization in both shoulder-to-shoulder consulting engagements and classroom settings. She is a Senior Principal Database Engineer for Agilex Technologies, a Chantilly, Virginia company founded by Bob LaRose and Jay Nussbaum. Agilex offers customers innovative thinking on leveraging advanced technologies within the healthcare, Federal, intelligence, commercial and public sectors to fully realize the value of information.
For over 20 years, Karen has worked in information technology starting out as a mainframe programmer, developer, DBA, data architect and now as a researcher, educator and consultant. Having used Oracle since the early 90′s, she began teaching others how to use Oracle over a decade ago.
She is a frequent speaker at conferences and user groups, an Oracle ACE, and a member of the OakTable network (an informal association of “Oracle scientists” that are well known throughout the Oracle community). She blogs at karenmorton.blogspot.com.
Book Details
- Paperback: 459 pages
- Publisher: Apress; 1 edition (December 22, 2009)
- Language: English
- ISBN-10: 1430271973
- ISBN-13: 978-1430271970
- File Size: 3.3 MiB
- Hits: 2,145 times
