This book is written for readers who have little or no previous experience with databases, SQL, or Oracle, and provides a very systematic approach to learning SQL in Oracle. Each chapter is written in a step-by-step manner and has examples that can be run using Oracle. Using the sample tables and data provided, the reader of this book will be able to do all the examples to experience hands-on Oracle programming. The book also presents a series of exercises at the end of the chapters to help readers gain proficiency with SQL.

Explore connectivity options, then delve into optimization methods that can be implemented in the Crystal environment, including the use of SQL Expressions and SQL Commands. Coverage includes an execution plan, optimization of indexes, and reduction of parsing, and Oracle-specific features such as external tables, Heterogeneous Connectivity, and Oracle Flashback. Common difficulties when using Oracle are described, and solutions provided.

This book/CD-ROM set is a complete reference of Designer/2000, Oracle's suite of business modeling, system design, and software development tools by an author with a proven track record. The CD-ROM provides supporting software which allows readers to work actively with the book, including over four hours of ScreenCam movies that show how to use Designer/2000 for Windows 95 and Windows NT.

This authoritative guide takes the developer each step of Oracle's CASE approach. The authors show the practical methodological steps and phases of producing software and practical ways that the Designer/2000 tool can support them. The authors explore the goals, processes and deliverables for each step in the case process, as well as techniques for successfully managing a CASE team. Interspersed throughout the book are tips and techniques for productive work in the tool, as well as tactical "how-to" discussions based on first-hand experience.

Oracle's Designer/2000 gives you powerful tools for information systems development, but its sophistication makes it very challenging to learn. In Rapid Application Development with OracleA (R) Designer/2000, the authors' "fast-path" approach puts Designer/2000 essentials into your hands quickly and shows how to make the most of the toolset in designing and implementing information systems that effectively serve your clients' needs.

The Ultimate Reference & Learning Guide for Oracle JDE / EnterpriseOne Consultants, Administrators, and Developers Over 150 Certification Questions, Answers, and Explanations It's clear that Oracle/JDE EnterpriseOne is the future for cost effective information systems management. Appropriate for all levels of JDE EnterpriseOne proficiency, over 150 Questions, Answers, and Explanations guide you through your learning process.

Designed as a user's manual, because the product ships with no written documentation, this book will be in great demand by those using this state-of-the-art information systems design product. The disk include sample applications used in the labs.

A fully integrated study system for Oracle Certification exam 1Z0-047

This exclusive Oracle Press guide covers all of the objectives on the newly created Oracle SQL Expert exam in detail, including control privileges, creating indexes and constraints, altering existing schema objects, creating and querying external tables, and using the advanced SQL features to query and manipulate data within the database.

This is the only practical, hands-on guide available to database administrators to secure their Oracle databases. This book will help the DBA to assess their current level of risk as well as their existing security posture. It will then provide practical, applicable knowledge to appropriately secure the Oracle database. The book's companion Web site contains dozens of working scripts that DBA's can use to secure and automate their Oracle databases.