OCA Oracle Database 11g Administration I Exam Guide: (Exam 1Z0-052)

Product Description

Write powerful SQL statements and PL/SQL programs

Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, youAnd#39;ll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.

*
Explore SQL Plus and SQL Developer
*
Use SQL SELECT, INSERT, UPDATE, and DELETE statements
*
Write PL/SQL programs
*
Create tables, sequences, indexes, views, and triggers
*
Write advanced queries containing complex analytical functions
*
Create database objects and collections to handle abstract data
*
Use large objects to handle multimedia files containing music and movies
*
Write Java programs to access an Oracle Database using JDBC
*
Tune your SQL statements to make them execute faster
*
Explore the XML capabilities of the Oracle Database
*
Master the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more

Product Details

* Amazon Sales Rank: #272174 in Books
* Published on: 2007-11-05
* Original language: English
* Number of items: 1
* Binding: Paperback
* 656 pages

Editorial Reviews

About the Author

Jason Price is a freelance consultant and former product manager at Oracle Corporation. He has contributed to many of OracleAnd#39;s products and is an Oracle Certified Database Administrator and Application Developer.

Customer Reviews

Great reference book4
It's a great reference book. it has nice examples for a beginner. would highly recommend for beginner/intermediate users.

Great book on SQL and PL/SQL5
I'm an experienced Oracle developer and I use this book all the time. I have several books on SQL, and this book is by far the best. It has good examples. I highly recommend it.

More myths2
Top of page 119 - the tip about not using count(*) because it is slower than using count(something else)

You have proof of this? Where, what, when, and you, of course, have set Tom Kyte straight on this matter?

OCA: Oracle 10g Administration Study Guide (1Z0-042)

Product Description

Sybex, the leading publisher of Oracle Certification Study Guides, offers this new, comprehensive study tool for candidates preparing for the Oracle Workshop I exam. Loaded with the learning tools that earned Sybex the title of "Best Study Guides" in the CertCities.com 2003 and 2002 Readers' Choice Awards, this definitive resource prepares you for the exam required for Oracle 10g Certified Associate (OCA) and Oracle Certified Professional (OCP) designations. The CD includes advanced testing engine with hundreds of sample exam questions, electronic flashcards, along with the entire book in PDF.
Product Details

* Amazon Sales Rank: #239238 in Books
* Published on: 2004-12-24
* Original language: English
* Number of items: 1
* Binding: Paperback
* 672 pages

Editorial Reviews

From the Back Cover
Here's the book you need to prepare for the Oracle Database 10g Administration I exam, 1Z0-042. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years, this book provides:

Clear and concise information on database administration with Oracle 10g Practical examples and insights drawn from the authors' real-world experiences Leading-edge exam preparation software, including a test engine and electronic flashcards

You'll also find authoritative coverage of key exam topics, including:

Installing Oracle Database 10g Software

Creating and Controlling Oracle Databases

Administering Users

Managing Schema Objects and Data

Implementing Oracle Security Features

Monitoring Performance

Performing Database Backup and Recovery

Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace

Featured on the CD

SYBEX TEST ENGINE Test your knowledge with advanced testing software. Includes chapter review questions and two bonus exams!

ELECTRONIC FLASHCARDS Reinforce your understanding with flashcards that can run off your PC, Pocket PC, or Palm handheld.

Also on the CD, you’ll find the entire book in searchable and printable PDF.

About the Author
Chip Dawes, OCP, is a consultant with D&D Technologies and presents at various Oracle User Group conferences. Bob Bryla, OCP, currently works as an Oracle DBA and Analyst for Lands' End in Dodgeville, Wisconsin. Joseph C. Johnson is an OCP with over 10 years of experience managing mission-critical Oracle databases. Joe is a Senior Database Administrator with Lands' End. Matthew Weishan, OCP, is a senior specialist for EDS in Madison, Wisconsin.
Customer Reviews

Good4
I have purchase this book after deep search for good oracle administration study guide. I think this book can provide a serious effort of preparing for the Oracle 10g OCA certification exam.

Mostly worthless2
This book does not cover topics well enough to pass the exam. It might be useful as an addition to other materials or as a review for experienced DBAs, but it does NOT have the information you need to pass by itself.

After failing the OCA exam (after acing the books' 2 exams, thanks guys!) I smashed this book against a brick wall until it was nothing but torn pages fluttering in the breeze. The binding held up well through the first several smashings, and stomping the separated pieces produced an enjoyable tearing sound.

A pretty decent study guide4
Getting Oracle certifications is not easy. The material is difficult and extensive not matter how you approach it. The Sybex study guide does a good job of presenting the material in an organized manner.

DirectX 9 Graphics: The Definitive Guide to Direct 3D

Product Description
DirectX 9 Graphics: The Definitive Guide to Direct3D provides a detailed and comprehensive guide to getting started with DirectX, with a specific focus on Direct3D, a technology designed to create interactive multimedia products. This book demystifies DirectX, starting with the basics of setting up a DirectX application and finishing with the intricacies of real-time 3D animation.

Learn how to: * Create and render 3D worlds. * Use index and vertex buffers to represent 3D primitives. * Apply 3D mathematical theory to graphic design. * Export 3D models from 3D rendering applications and import them into DirectX as meshes. * Save and load data using X files. * Create snow, rain, fog, and more using point sprites and particle systems. * Animate pixel data on textures. * Enhance your game world with real-time lighting and texture mapping. * Employ skeletal animation to animate meshes. About the Author
Alan Thorn is an experienced and well-traveled freelance programmer and games developer living in London. He frequently fulfills the roles of programmer, graphic artist, writer, and special effects expert as he delivers creative solutions to some of the largest corporations in the entertainment and leisure industry. He is also the author of DirectX 9 User Interfaces: Design and Implementation.

Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL by Wallace B. McClure

Product Description

ADO.NET revolutionized the way data was accessed through SQL Server, Oracle, and MySQL. With Microsoft's release of ADO.NET 2, ADO and the .NET Framework are integrated with SQL Server for the first time-enabling you to program .NET applications directly within the SQL Server database.

Packed with sample code and recommended best practices for using ADO.NET 2, this code-intensive book explores the new data types that are available in the 2.0 Framework and discusses the appropriate time and way to use them. You'll learn how to make repetitive, mundane tasks much simpler and you'll walk away with a solid foundation for developing database-driven applications.

What you will learn from this book
The basics of creating a connection, executing a query, and returning a result
Best uses for Oracle in the ADO.NET Framework
The many new features that are available for XML
How to use the full text search capabilities of Microsoft(r) SQL Server 2005
Methods for retrieving data and presenting it in various ways
Why MySQL is a viable option for data storage

Who this book is for

This book is for experienced database developers who want to learn the latest release of ADO.NET 2.0. Knowledge of ADO.NET 1.0, general .NET development, and Microsoft SQL Server is necessary.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
Product Details
Amazon Sales Rank: #529523 in Books
Published on: 2005-12-05
Number of items: 1
Binding: Paperback
648 pages
Editorial Reviews

Download Description
ADO.NET revolutionized the way data was accessed through SQL Server, Oracle, and MySQL. With Microsoft's release of ADO.NET 2, ADO and the .NET Framework are integrated with SQL Server for the first time-enabling you to program .NET applications directly within the SQL Server database. Packed with sample code and recommended best practices for using ADO.NET 2, this code-intensive book explores the new data types that are available in the 2.0 Framework and discusses the appropriate time and way to use them. You'll learn how to make repetitive, mundane tasks much simpler and you'll walk away with a solid foundation for developing database-driven applications. What you will learn from this book The basics of creating a connection, executing a query, and returning a result Best uses for Oracle in the ADO.NET Framework The many new features that are available for XML How to use the full text search capabilities of Microsoft(r) SQL Server 2005 Methods for retrieving data and presenting it in various ways Why MySQL is a viable option for data storage Who this book is for This book is for experienced database developers who want to learn the latest release of ADO.NET 2.0. Knowledge of ADO.NET 1.0, general .NET development, and Microsoft SQL Server is necessary. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

From the Back Cover
ADO.NET revolutionized the way data was accessed through SQL Server, Oracle, and MySQL. With Microsoft's release of ADO.NET 2, ADO and the .NET Framework are integrated with SQL Server for the first time—enabling you to program .NET applications directly within the SQL Server database.

Packed with sample code and recommended best practices for using ADO.NET 2, this code-intensive book explores the new data types that are available in the 2.0 Framework and discusses the appropriate time and way to use them. You'll learn how to make repetitive, mundane tasks much simpler and you'll walk away with a solid foundation for developing database-driven applications.

What you will learn from this book
The basics of creating a connection, executing a query, and returning a result
Best uses for Oracle in the ADO.NET Framework
The many new features that are available for XML
How to use the full text search capabilities of Microsoft® SQL Server 2005
Methods for retrieving data and presenting it in various ways
Why MySQL is a viable option for data storage

Who this book is for

This book is for experienced database developers who want to learn the latest release of ADO.NET 2.0. Knowledge of ADO.NET 1.0, general .NET development, and Microsoft SQL Server is necessary.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

About the Author
Wallace B. McClure graduated from the Georgia Institute of Technology in 1990 with a bachelor of science degree in electrical engineering. He continued his education there, receiving a master’s degree in the same field in 1991. Since that time, he has done consulting and development for such companies as Coca-Cola, Bechtel National, Magnatron, and Lucent Technologies, among others. Products and services have included work with ASP, ADO, XML, and SQL Server, as well as numerous applications in the Microsoft .NET Framework. Wally McClure specializes in building applications that have large numbers of users and large amounts of data. He is a Microsoft MVP and an ASPInsider, and a partner in Scalable Development, Inc. You can read Wally’s blog at http://weblogs.asp.net/wallym/.

Gregory A. Beamer is a solutions architect specializing in Microsoft Internet technologies. Greg got involved in programming in the early 1990s with Visual Basic 3 and has stayed on the leading edge of Microsoft Internet technologies since the Denali beta (ASP 1.0). Greg first worked with .NET with the PDC 2000 beta and has been on both the SQL Server 2005 and .NET 2.0 betas since spring 2003. When Greg is not working, he spends his time with his wife, Tiffany, and their four daughters, Rebecca, Emily, Annabelle, and Miranda.

John J. Croft IV graduated from the Georgia Institute of Technology in 1991, receiving a bachelor’s degree in mechanical engineering. He then spent five years consulting for large companies, including Coca-Cola, BellSouth, and MCI. Work at these companies primarily involved C and C++ programming and object-oriented systems analysis. His various clients have included both Fortune 100s and small startup companies. Their problems have ranged drastically, from large databases and executive information systems to lithotripter control and satellite telemetry. Croft has completed projects with Java, XML, and, recently, C# and .NET applications. He is a partner in Scalable Development, Inc.

J. Ambrose Little is the editor-in-chief of the ASPAlliance, an ASPInsider, and a Microsoft ASP.NET MVP who currently works as a Web architect for a large credit union in Tampa, Florida. Previously, he worked as a consultant at Verizon, creating XMLWeb Services and middle-tier components, and for BOK Financial’s Web Services department creating ASP.NET applications for their intranet. His pre-.NET programming experience consists mostly of developing Web applications using ASP and VB COM/DCOM for several years. He has a bachelor’s degree in medieval European history, which remains an interest. Apart from developing software, he enjoys movies, reading, writing, foosball, chess, tennis, badminton, and spending time with his wonderful family.

Bill Ryan currently works as a senior software developer for TiBA Solutions in Greenville, SC. He is also a Windows Embedded MVP, has served on Macromedia’s Flash Advisory Board, and helps run two popular .NET Focused Web sites (www.devbuzz.com and www.knowdotnet.com) and his blog www.msmvps.com/WilliamRyan. After earning his master’s degree in business administration, Bill began work as a statistical analyst, but quickly realized that his true love was programming. He has worked in multiple industries, including financial services/securities, manufacturing, health care, pharmaceuticals, and, currently, consulting. Bill is a frequent speaker at user’s group meetings, has spoken at multiple Microsoft Code Camps, and has hosted multiple MSDN Webcasts. Although technologically related things consume most of his time, Bill’s other interests include cult films, economics, Freemasonry, cuckoo clocks, and, most important, his girlfriend, Kim, and her daughter, Sarah.

Phil Winstanley is a Web applications developer working for Portfolio Europe, located in Manchester, England. He has been involved with ASP.NET since its inception, and has developed a deep understanding of the platform. As a Microsoft MVP (Most Valuable Professional), member of the ASPInsiders, co-owner of Microsoft Web Developers UK, and the North West England Regional Director for the .NET Exchange, Phil is deeply embedded in the development community and works closely with the Web Platforms team at Microsoft, regularly visiting the developers in Redmond, Washington.

David Yack is the president of Colorado Technology Consultants, Inc. He is a hands-on technology consultant with solid management experience in privately held and Fortune 500 companies and has over 15 years of experience in the IT industry. David is currently responsible for leading Colorado Technology Consultants’ focus on Microsoft .NET technologies. David is an active participant in the Microsoft development community, ranging from the Denver .NET user group to Microsoft’s Public Communities, such as www.asp.net and http://aspalliance.com. David is the leader of the South Colorado .NET user group. David is recognized by Microsoft as a .NET MVP (Most Valuable Professional).

Jeremy Zongker is a software development manager who works primarily on data-driven ASP.NET applications with Microsoft SQL Server databases. He is a Microsoft Certified Solutions Developer for .NET and a 2004 MVP for ASP.NET. Jeremy is the founder and senior developer for Trilitech, LLC, a Broken Arrow, Oklahoma, software development company.
Customer Reviews

A good ADO.Net reference
This book has a lot of good information. I found myself skimming forward just a little but there was still lots of good info to make me want to keep reading. I wish there was sometimes more explanation of why the author feels a certain way but all and all this is book worth owning.

What a letdown
I have 16 years experience as an adjunct instructor at a community college. I have a BS in Engineering and I'm 3 credits away from my Master's in Comp Sci.
I'm taking time from my class prep to write this review...
I have been assigned to teach a Visual Basic programming class with this book. Had I been given the opportunity to read the text beforehand, I would have fought hard to use some other book. The example code is formatted so poorly that I am embarassed to use it in class. Some of the example code in the book doesn't even match what's available for download on the WROX web site. The QC staff at WROX should be reassigned. I've QC'd many programming textbooks myself and I can see that this stinker was rushed to print without enough editing.
Don't be fooled by the title. The majority of the examples are SQL Server-specific. OK, Visual Studio has a SQL Server bent, given that both are Microsoft Products. That's no secret. However, if the title of the book references Oracle and MySQL, then all the examples should also. If a particular paradigm can only be implemented in SQL Server, then the authors have a responsibility to provide work-arounds for the other DBMS's that are listed on the cover of the book. Arrrgh.

Chapter 1 covers the History of Data Access. That doesn't fit with the remainder of the book. Part of chapter 2 covers normalization, also not a good fit with the remainder of the book. The authors even admit that the book is aimed at software developers who have prior knowledge of ADO .Net and SQL Server. That implies prior knowledge of normalization and database design.

Recently I was at the bookstore with my 11 year-old. I was agonizing over which ASP .Net book (both WROX titles) to purchase, so I held up two possibilities and asked her to help. She noted that one cover had 3 author's faces on it and the other had two. She concluded that the book with 3 faces must be better. I couldn't argue with that logic. This book has seven faces on it, but it just doesn't deliver.

Could not get download code to work. Wiley no help!
I had hoped that working through this book would bring extra insight and new techniques. After all, I have been a database consultant for 15 years and designed, programed and implemented many large solutions.

I found that the book left much unsaid and detailed instructions non existant. I had problems with the download code. It appears to be tied up with VS team system, so if you are a home or small business who is unfamiliar with tem system then you may have problems.

I contacted Wiley Customer Support, but they just told me the code works and provided nothing helpful.

I will not be buying any more Wrox / Wiley books.

Oracle PL/SQL Programming, 4th Edition by Steven Feuerstein

Product Description

For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL.

The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers.

The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization.

Co-authored by the world's foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.
Product Details
Amazon Sales Rank: #55936 in Books
Published on: 2005-08-22
Format: Illustrated
Number of items: 1
Binding: Paperback
1198 pages
Editorial Reviews

Amazon.com
If you're doing database application development in the Oracle environment, you're going to have to know PL/SQL, the company's extended query and update language. If you want your programs to exploit the special capabilities of Oracle software, you'll need to know the language well. That's where the third edition of Oracle PL/SQL Programming comes into play. It's an absolutely comprehensive reference (as well as a rather extensive tutorial) on PL/SQL, ideally suited to answering your questions about how to perform some programming tasks and reminding you of the characteristics of functions, triggers, and other elements of the database programmer's toolkit. The new edition covers calls to Java methods from within PL/SQL programs, autonomous transactions, object type inheritance, and the new Timestamp and XMLType data types. There's also more information about server internals--the way PL/SQL programs are run--than before, better enabling readers to optimize their code for fast and safe execution.

Steven Feuerstein takes care to explain, with prose and example code, the characteristics of PL/SQL elements. In explaining number conversions, for example, he explores Oracle's different ways of formatting numbers, then details the behavior of the to_number function under different conditions (with and without a specified format model, and with National Language Support information attached). It's a helpful approach that will have readers using the index to locate places in which Feuerstein mentions language elements of interest. --David Wall

Topics covered: How to use Oracle PL/SQL in all its manifestations through Oracle9i. Fundamentals of program structure (loops, cases, exceptions, etc.) and execution get attention, as do data types, transaction management, triggers, and the object-oriented aspects of the language. There's also coverage of calls to external Java and C programs.

Book Info
Introduces the main features of the PL/SQL language. Describes the basic PL/SQL programming components such as variables, cursors, and loops. Covers built-in functions, modular code, new PL/ SQL8 features and more. Paper. 3 1/2 inch disk included.

The publisher, O'Reilly and Associates
Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a relatively new programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of Oracle development tools, including SQL*Plus, Oracle Forms, Oracle Graphics, Oracle Reports, and Oracle Developer 2000 (formerly the Cooperative Development Environment (CDE)). It offers a myriad of data types, and such features as cursors, loops, conditional and sequential control statements, exception handlers, records, tables, and constructs for developing modular code (functions, procedures, and packages). Originally a rather limited tool, PL/SQL is now a mature and effective language for developers. As more and more Oracle customers move from the mainframe to client- server configurations, PL/SQL is becoming ever more crucial. It provides the foundation for the code used to distribute processing and transactions across the network. PL/SQL allows the developer to: Design powerful and easy-to-use GUI interfaces in products like Oracle Forms and Oracle Graphics Build complex reports and long-running batch processes Implement critical business rules in database triggers and stored procedures Link a World Wide Web page to an Oracle database Although PL/SQL is very important to Oracle customers, it has not received the attention -- by Oracle Corporation and outside vendors and authors -- that it deserves. The only book previously available on PL/SQL is the overly concise Oracle reference manual. Training courses tend to focus on the flashy side of the new GUI tools and ignore the more complicated PL/SQL programming that is so vital to production applications. Oracle PL/SQL Programming fills a huge gap in the Oracle market. The book provides developers with a single, comprehensive guide to building applications with PL/SQL -- and building them the right way. It's packed with strategies, code architectures, tips, techniques, and fully realized code. The book comes with a disk containing many examples of PL/SQL programs that readers can use immediately or as starting points for further development. Oracle PL/SQL Programming is divided into six parts: Part I introduces PL/SQL, its many versions, the environments in which it operates, PL/SQL language fundamentals, and effective coding style. Part II describes basic PL/SQL statements for variables, cursors, conditional and sequential control, loops, exception handling, records, and tables. Part III describes all of the built-in (predefined) PL/SQL functions and procedures -- string, date, number, and miscellaneous as well as the built-in packages that come with PL/SQL. Part IV describes how to modularize your PL/SQL programs using blocks, procedures, functions, and packages. Part V describes how to debug PL/SQL programs and manage code in the database. It also contains a summary of tips for using PL/SQL most effectively. Part VI contains appendices summarizing the contents of the disk and the calling of stored procedures from Version 1.1.
Customer Reviews

The PL/SQL Standard
As with the three previous editions, all of which I own, this book sets the standard for PL/SQL texts. Crammed with information, it provides a thorough and insightful reference and always has a place on my desk.

If you program in PL/SQL, then you need this book.
It is clear, concise, and as far as I can tell, correct. The writing is friendly, and the examples useful. I learned far more about PL/SQL from this book than from the Oracle documentation. I recently heard the author speak at a conference, and his good personality is reflected in the book.

The most famous PL/SQL author
No doubt you must own this book if you start learning PL/SQL or if you want to improve your coding. Steven reveals many traps that may be in your code. It explains how to take advantage of multiple techniques like BULK COLLECT.

It may serve as a reference book too

Advanced SQL Functions in Oracle 10g (Wordware Applications Library) by Richard Earp

Product Description

Designed to exploit Oracle 10g's SQL, this book is a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, the book covers collection/object-oriented structures and introduces new Oracle 10g topics like SQL, XML, and statistical functions.
Product Details
Amazon Sales Rank: #253148 in Books
Published on: 2006-01-25
Number of items: 1
Binding: Paperback
350 pages
Editorial Reviews

About the Author
Dr. Richard Walsh Earp is a former chair of and former associate professor in the Department of Computer Science and a former dean of the College of Science and Technology at the University of West Florida in Pensacola. He has taught a variety of computer science courses including database systems and advanced database systems. Dr. Earp was also an instructor with Learning Tree International and worked for Computer Sciences Corporation at the Naval Air Station in Pensacola as a database consultant after his retirement from academia. He has co-authored several books with Dr. Bagui.

Dr. Sikha Saha Bagui is an assistant professor in the Department of Computer Science at the University of West Florida. She teaches a variety of computer science courses and conducts research on database design, data mining, pattern recognition, and statistical computing. Dr. Bagui has published many journal articles and co-authored several books with Dr. Earp: Learning SQL: A Step-by-Step Guide Using Oracle, Database Design Using ER Diagrams, and Learning SQL: A Step-by-Step Guide Using Access.
Customer Reviews

Not that advanced and has some errors
I found a few errors and most chapters lack details.

In the 'model clause chapter' for example, more is needed for :
REFERENCE MODELs,
ITERATIVE MODELs (ITERATION_NUMBER (0-4294967295), PREVIOUS(), etc),
FOR LOOPs,
IS PRESENT,
ETC.

Also, more can be discussed for GROUPING_ID and GROUP_ID() and many other additions to advanced features such as hierarchical queries, analytical functions and others.