Oracle PL/SQL Best Practices

Download Oracle PL/SQL Best Practices PDF Online Free

Author :
Publisher : "O'Reilly Media, Inc."
ISBN 13 : 1449378765
Total Pages : 207 pages
Book Rating : 4.4/5 (493 download)

DOWNLOAD NOW!


Book Synopsis Oracle PL/SQL Best Practices by : Steven Feuerstein

Download or read book Oracle PL/SQL Best Practices written by Steven Feuerstein and published by "O'Reilly Media, Inc.". This book was released on 2001-04-09 with total page 207 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this book, Steven Feuerstein, widely recognized as one of the world's experts on the Oracle PL/SQL language, distills his many years of programming, writing, and teaching about PL/SQL into a set of PL/SQL language "best practices"--rules for writing code that is readable, maintainable, and efficient. Too often, developers focus on simply writing programs that run without errors--and ignore the impact of poorly written code upon both system performance and their ability (and their colleagues' ability) to maintain that code over time.Oracle PL/SQL Best Practices is a concise, easy-to-use reference to Feuerstein's recommendations for excellent PL/SQL coding. It answers the kinds of questions PL/SQL developers most frequently ask about their code: How should I format my code? What naming conventions, if any, should I use? How can I write my packages so they can be more easily maintained? What is the most efficient way to query information from the database? How can I get all the developers on my team to handle errors the same way? The book contains 120 best practices, divided by topic area. It's full of advice on the program development process, coding style, writing SQL in PL/SQL, data structures, control structures, exception handling, program and package construction, and built-in packages. It also contains a handy, pull-out quick reference card. As a helpful supplement to the text, code examples demonstrating each of the best practices are available on the O'Reilly web site.Oracle PL/SQL Best Practices is intended as a companion to O'Reilly's larger Oracle PL/SQL books. It's a compact, readable reference that you'll turn to again and again--a book that no serious developer can afford to be without.

The Java Tutorial

Download The Java Tutorial PDF Online Free

Author :
Publisher : Addison-Wesley
ISBN 13 : 0132761947
Total Pages : 1488 pages
Book Rating : 4.1/5 (327 download)

DOWNLOAD NOW!


Book Synopsis The Java Tutorial by : Sharon Biocca Zakhour

Download or read book The Java Tutorial written by Sharon Biocca Zakhour and published by Addison-Wesley. This book was released on 2013-02-27 with total page 1488 pages. Available in PDF, EPUB and Kindle. Book excerpt: The Java®Tutorial, Fifth Edition, is based on Release 7 of the Java Platform Standard Edition. This revised and updated edition introduces the new features added to the platform, including a section on NIO.2, the new file I/O API, and information on migrating legacy code to the new API. The deployment coverage has also been expanded, with new chapters such as “Doing More with Rich Internet Applications” and “Deployment in Depth,” and a section on the fork/join feature has been added to the chapter on concurrency. Information reflecting Project Coin developments, including the new try-with-resources statement, the ability to catch more than one type of exception with a single exception handler, support for binary literals, and diamond syntax, which results in cleaner generics code, has been added where appropriate. The chapters covering generics, Java Web Start, and applets have also been updated. In addition, if you plan to take one of the Java SE 7 certification exams, this guide can help. A special appendix, “Preparing for Java Programming Language Certification,” lists the three exams available, details the items covered on each exam, and provides cross-references to where more information about each topic appears in the text. All of the material has been thoroughly reviewed by members of Oracle Java engineering to ensure that the information is accurate and up to date.

Expert Oracle Database Architecture

Download Expert Oracle Database Architecture PDF Online Free

Author :
Publisher : Apress
ISBN 13 : 1430200677
Total Pages : 764 pages
Book Rating : 4.4/5 (32 download)

DOWNLOAD NOW!


Book Synopsis Expert Oracle Database Architecture by : Thomas Kyte

Download or read book Expert Oracle Database Architecture written by Thomas Kyte and published by Apress. This book was released on 2006-11-07 with total page 764 pages. Available in PDF, EPUB and Kindle. Book excerpt: * Based on a proven best-seller and written by the most recognized Oracle expert in the world and f * Fully revised book, covering bothfor the 9i and 10g versions of the database * Based on what is widely-recognized as the best Oracle book ever written. It defines what Oracle really is, and why it is so powerful * Inspired by the thousands of questions Tom has answered on his http://asktom.oracle.com site. It defines what Oracle really is, and why it is so powerful It and it tackles the problems that developers and DBAs struggle with every day

Expert One-on-One Oracle

Download Expert One-on-One Oracle PDF Online Free

Author :
Publisher : Apress
ISBN 13 : 9781430212799
Total Pages : 1328 pages
Book Rating : 4.2/5 (127 download)

DOWNLOAD NOW!


Book Synopsis Expert One-on-One Oracle by : Thomas Kyte

Download or read book Expert One-on-One Oracle written by Thomas Kyte and published by Apress. This book was released on 2010-11-16 with total page 1328 pages. Available in PDF, EPUB and Kindle. Book excerpt: * A proven best-seller by the most recognized Oracle expert in the world. * The best Oracle book ever written. It defines what Oracle really is, and why it is so powerful. * Inspired by the thousands of questions Tom has answered on his http://asktom.oracle.com site. It tackles the problems that developers and DBAs struggle with every day. * Provides everything you need to know to program correctly with the database and exploit its feature-set effectively.

Using Oracle 11i

Download Using Oracle 11i PDF Online Free

Author :
Publisher : Que Publishing
ISBN 13 : 9780789726704
Total Pages : 1206 pages
Book Rating : 4.7/5 (267 download)

DOWNLOAD NOW!


Book Synopsis Using Oracle 11i by : Jim Crum

Download or read book Using Oracle 11i written by Jim Crum and published by Que Publishing. This book was released on 2002 with total page 1206 pages. Available in PDF, EPUB and Kindle. Book excerpt: Annotation The must-have reference for users and implementers of Oracle Release 11i. This book provides the critical information required to configure and operate the Release11i applications in one book. Several readers have told us they saved tens of thousands of dollars after reading the previous edition of this book. Special Edition Using Oracle 11i has about 40% new content over the previous version including a new projects chapter, a new order management chapter, screen shots, tips, and, Release11i specific material. This book is the most complete reference available for the latest release of the Oracle financial, manufacturing, HRMS, and projects applications. Part 1 introduces the Oracle ERP applications and Release11i concepts. Part 2 educates the reader on proven techniques for implementing these complex and integrated systems. Part 3 discusses configuration and usage of each of the financial, distribution, manufacturing, HRMS, and project applications. Part 4 discusses working with Oracle Support, consulting firms, and compatible software vendors. The appendixes review the employment market, consulting opportunities, and provide the reader with an implementation checklist. All of Release11i's new features are covered in-depth and in practical terms. Not only will readers understand Oracle's new capabilities, they will be able to apply them right away. The authors are highly respected consultants from BOSS Corporation. They have worked with the Oracle Applications for over eight years since Release 9. Each chapter is written and edited by an expert consultant on that topic. The authors have published many white papers and newsletters about the Oracle Applications. BOSS Corporation is an active sponsor of the Oracle Applications User Group (OAUG). The authors have attended the last 14 national conferences, presented more than a dozen white papers at OAUG conferences, participated in the vendor exhibit hall, identified key words for white paper classification, and edited articles that are included in OAUG publications.

SQL Tuning

Download SQL Tuning PDF Online Free

Author :
Publisher : "O'Reilly Media, Inc."
ISBN 13 : 059655236X
Total Pages : 338 pages
Book Rating : 4.5/5 (965 download)

DOWNLOAD NOW!


Book Synopsis SQL Tuning by : Dan Tow

Download or read book SQL Tuning written by Dan Tow and published by "O'Reilly Media, Inc.". This book was released on 2003-11-19 with total page 338 pages. Available in PDF, EPUB and Kindle. Book excerpt: A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications.There are two basic issues to focus on when tuning SQL: how to find and interpret the execution plan of an SQL statement and how to change SQL to get a specific alternate execution plan. SQL Tuning provides answers to these questions and addresses a third issue that's even more important: how to find the optimal execution plan for the query to use.Author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book include exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable problems."Whether you are a programmer who develops SQL-based applications or a database administrator or other who troubleshoots poorly tuned applications, SQL Tuning will arm you with a reliable and deterministic method for tuning your SQL queries to gain optimal performance.

Practical Guide to Using SQL in Oracle

Download Practical Guide to Using SQL in Oracle PDF Online Free

Author :
Publisher : Jones & Bartlett Publishers
ISBN 13 : 1449613039
Total Pages : 506 pages
Book Rating : 4.4/5 (496 download)

DOWNLOAD NOW!


Book Synopsis Practical Guide to Using SQL in Oracle by : Dr. Richard Earp

Download or read book Practical Guide to Using SQL in Oracle written by Dr. Richard Earp and published by Jones & Bartlett Publishers. This book was released on 2008-08-22 with total page 506 pages. Available in PDF, EPUB and Kindle. Book excerpt: Structured Query Language has become the standard for generating, manipulating, and retrieving database information. The dramatic increase in the popularity of relational databases, coupled with Oracle’s having the largest market share, has created a demand for programmers who can write SQL code correctly and efficiently. This book provides a systematic approach to learning SQL in Oracle. Each chapter is written in a step-by-step manner and includes examples that can be run using Oracle. Using the sample tables and data provided, readers will be able to perform the examples to gain hands-on experience with Oracle programming. Gain an understanding of basic SQL principles. Learn to generate, store, and edit SQL queries in Oracle. Develop joins, subqueries, and correlated subqueries. Work with XML and Oracle databases. Test your SQL knowledge with the exercises at the end of each chapter!

Effective Oracle by Design

Download Effective Oracle by Design PDF Online Free

Author :
Publisher : McGraw Hill Professional
ISBN 13 : 0071776788
Total Pages : 688 pages
Book Rating : 4.0/5 (717 download)

DOWNLOAD NOW!


Book Synopsis Effective Oracle by Design by : Thomas Kyte

Download or read book Effective Oracle by Design written by Thomas Kyte and published by McGraw Hill Professional. This book was released on 2003-09-12 with total page 688 pages. Available in PDF, EPUB and Kindle. Book excerpt: Tom Kyte of Oracle Magazine’s “Ask Tom” column has written the definitive guide to designing and building high-performance, scalable Oracle applications. The book covers schema design, SQL and PL/SQL, tables and indexes, and much more. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs.

Oracle PL/SQL Programming

Download Oracle PL/SQL Programming PDF Online Free

Author :
Publisher : "O'Reilly Media, Inc."
ISBN 13 : 9780596003814
Total Pages : 1028 pages
Book Rating : 4.0/5 (38 download)

DOWNLOAD NOW!


Book Synopsis Oracle PL/SQL Programming by : Steven Feuerstein

Download or read book Oracle PL/SQL Programming written by Steven Feuerstein and published by "O'Reilly Media, Inc.". This book was released on 2002 with total page 1028 pages. Available in PDF, EPUB and Kindle. Book excerpt: The authors have revised and updated this bestseller to include both the Oracle8i and new Oracle9i Internet-savvy database products.

Mastering Regular Expressions

Download Mastering Regular Expressions PDF Online Free

Author :
Publisher : "O'Reilly Media, Inc."
ISBN 13 : 9780596002893
Total Pages : 492 pages
Book Rating : 4.0/5 (28 download)

DOWNLOAD NOW!


Book Synopsis Mastering Regular Expressions by : Jeffrey E. F. Friedl

Download or read book Mastering Regular Expressions written by Jeffrey E. F. Friedl and published by "O'Reilly Media, Inc.". This book was released on 2002 with total page 492 pages. Available in PDF, EPUB and Kindle. Book excerpt: Introduces regular expressions and how they are used, discussing topics including metacharacters, nomenclature, matching and modifying text, expression processing, benchmarking, optimizations, and loops.

Practical Oracle SQL

Download Practical Oracle SQL PDF Online Free

Author :
Publisher : Apress
ISBN 13 : 1484256174
Total Pages : 467 pages
Book Rating : 4.4/5 (842 download)

DOWNLOAD NOW!


Book Synopsis Practical Oracle SQL by : Kim Berg Hansen

Download or read book Practical Oracle SQL written by Kim Berg Hansen and published by Apress. This book was released on 2020-02-19 with total page 467 pages. Available in PDF, EPUB and Kindle. Book excerpt: Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92. Both standard SQL and Oracle’s own extensions to the language have progressed far over the decades in terms of how much you can work with your data in a single, albeit sometimes complex, SQL statement. If you already know the basics of SQL, this book provides many examples of how to write even more advanced SQL to huge benefit in your applications, such as:Pivoting rows to columns and columns to rowsRecursion in SQL with MODEL and WITH clausesAnswering Top-N questionsForecasting with linear regressions Row pattern matching to group or distribute rowsUsing MATCH_RECOGNIZE as a row processing engineThe process of starting from simpler statements in SQL, and gradually working those statements stepwise into more complex statements that deliver powerful results, is covered in each example. By trying out the recipes and examples for yourself, you will put together the building blocks into powerful SQL statements that will make your application run circles around your competitors. What You Will LearnTake full advantage of advanced and modern features in Oracle SQL Recognize when modern SQL constructs can help create better applicationsImprove SQL query building skills through stepwise refinementApply set-based thinking to process more data in fewer queriesMake cross-row calculations with analytic functionsSearch for patterns across multiple rows using row pattern matchingBreak complex calculations into smaller steps with subquery factoring Who This Book Is For Oracle Database developers who already know some SQL, but rarely use features of the language beyond the SQL-92 standard. And it is for developers who would like to apply the more modern features of Oracle SQL, but don’t know where to start. The book also is for those who want to write increasingly complex queries in a stepwise and understandable manner. Experienced developers will use the book to develop more efficient queries using the advanced features of the Oracle SQL language.

Oracle Essentials

Download Oracle Essentials PDF Online Free

Author :
Publisher : "O'Reilly Media, Inc."
ISBN 13 : 0596555334
Total Pages : 409 pages
Book Rating : 4.5/5 (965 download)

DOWNLOAD NOW!


Book Synopsis Oracle Essentials by : Rick Greenwald

Download or read book Oracle Essentials written by Rick Greenwald and published by "O'Reilly Media, Inc.". This book was released on 2007-11-01 with total page 409 pages. Available in PDF, EPUB and Kindle. Book excerpt: Oracle is an enormous system, with myriad technologies, options, and releases. Most users--even experienced developers and database administrators--find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g. This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on: Oracle products, options, data structures, and overall architecture for Oracle Database 11g, as well as earlier releases (Oracle Database 10g, Oracle9i, and Oracle8i) Installing, running, managing, monitoring, networking, and tuning Oracle, including Enterprise Manager (EM) and Oracle's self-tuning and management capabilities; and using Oracle security, auditing, and compliance (a new chapter in this edition) Multiuser concurrency, data warehouses, distributed databases, online transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing) Features beyond the Oracle database: Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a Web services provider The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction command, transparent data encryption, the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types) For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference. "Oracle Essentials gives a clear explanation of the key database concepts and architecture underlying the Oracle database. It's a great reference for anyone doing development or management of Oracle databases." --Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle Corporation

Programming with Oracle Developer

Download Programming with Oracle Developer PDF Online Free

Author :
Publisher : Sams Publishing
ISBN 13 : 9780672321108
Total Pages : 364 pages
Book Rating : 4.3/5 (211 download)

DOWNLOAD NOW!


Book Synopsis Programming with Oracle Developer by : Matthew Bennett

Download or read book Programming with Oracle Developer written by Matthew Bennett and published by Sams Publishing. This book was released on 2002 with total page 364 pages. Available in PDF, EPUB and Kindle. Book excerpt: Programming with Oracle Developer is packed with expert advice, detailed explanations, and complete solutions that show you how to produce robust, precise, Internet-ready applications for developers. You'll get step-by-step guidance from prototyping through delivering a high-powered Internet application. After reading this book, the reader will Understand the nuts and bolts of building applications, including how to choose an appropriate application development life cycle Master design and prototyping issues including the new wizards and GUI design features of Developer forms, reports, and graphics Extend the reusability and optimize the security of your applications Deploy Internet applications and integrate them with other tools Create robust, Web-enabled Oracle applications

Java Programming with Oracle JDBC

Download Java Programming with Oracle JDBC PDF Online Free

Author :
Publisher : "O'Reilly Media, Inc."
ISBN 13 : 9780596000882
Total Pages : 500 pages
Book Rating : 4.0/5 (8 download)

DOWNLOAD NOW!


Book Synopsis Java Programming with Oracle JDBC by : Donald Bales

Download or read book Java Programming with Oracle JDBC written by Donald Bales and published by "O'Reilly Media, Inc.". This book was released on 2002 with total page 500 pages. Available in PDF, EPUB and Kindle. Book excerpt: JDBC is the key Java technology for relational database access. Oracle is arguably the most widely used relational database platform in the world. In this book, Donald Bales brings these two technologies together, and shows you how to leverage the full power of Oracle's implementation of JDBC. You begin by learning the all-important mysteries of establishing database connections. This can be one of the most frustrating areas for programmers new to JDBC, and Donald covers it well with detailed information and examples showing how to make database connections from applications, applets, Servlets, and even from Java programs running within the database itself. Next comes thorough coverage of JDBC's relational SQL features. You'll learn how to issue SQL statements and get results back from the database, how to read and write data from large, streaming data types such as BLOBs, CLOBs, and BFILEs, and you'll learn how to interface with Oracle's other built-in programming language, PL/SQL. If you're taking advantage of the Oracle's relatively new ability to create object tables and column objects based on user-defined datatypes, you'll be pleased with Don's thorough treatment of this subject. Don shows you how to use JPublisher and JDBC to work seamlessly with Oracle database objects from within Java programs. You'll also learn how to access nested tables and arrays using JDBC. Donald concludes the book with a discussion of transaction management, locking, concurrency, and performance--topics that every professional JDBC programmer must be familiar with. If you write Java programs to run against an Oracle database, this book is a must-have.

High-Performance Oracle

Download High-Performance Oracle PDF Online Free

Author :
Publisher : John Wiley & Sons
ISBN 13 : 047143034X
Total Pages : 720 pages
Book Rating : 4.4/5 (714 download)

DOWNLOAD NOW!


Book Synopsis High-Performance Oracle by : Geoff Ingram

Download or read book High-Performance Oracle written by Geoff Ingram and published by John Wiley & Sons. This book was released on 2002-10-15 with total page 720 pages. Available in PDF, EPUB and Kindle. Book excerpt: "Geoff Ingram has met the challenge of presenting the complex process of managing Oracle performance. This book can support every technical person looking to resolve Oracle8i and Oracle9i performance issues." -Aki Ratner, President, Precise Software Solutions Ensuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of "performance tuning"-- that is, how to fine-tune the Oracle database for its greatest processing efficiency. Geoff Ingram argues that this approach simply isn't enough. He believes that performance needs to be addressed right from the design stage, and it needs to cover the entire system--not just the database. High-Performance Oracle is a hands-on book, loaded with tips and techniques for ensuring that the entire Oracle database system runs efficiently and doesn't break down. Written for Oracle developers and DBAs, and covering both Oracle8i and Oracle9i, the book goes beyond traditional performance-tuning books and covers the key techniques for ensuring 24/7 performance and availability of the complete Oracle system. The book provides practical solutions for: * Choosing physical layout for ease of administration and efficient use of space * Managing indexes, including detecting unused indexes and automating rebuilds * SQL and system tuning using the powerful new features in Oracle9i Release 2 * Improving SQL performance without modifying code * Running Oracle Real Application Clusters (RAC) for performance and availability * Protecting data using Recover Manager (RMAN), and physical and logical standby databases The companion Web site provides the complete source code for examples in the book, updates on techniques, and additional documentation for optimizing your Oracle system.

Oracle Database Programming using Java and Web Services

Download Oracle Database Programming using Java and Web Services PDF Online Free

Author :
Publisher : Digital Press
ISBN 13 : 0080525113
Total Pages : 1121 pages
Book Rating : 4.0/5 (85 download)

DOWNLOAD NOW!


Book Synopsis Oracle Database Programming using Java and Web Services by : Kuassi Mensah

Download or read book Oracle Database Programming using Java and Web Services written by Kuassi Mensah and published by Digital Press. This book was released on 2011-04-08 with total page 1121 pages. Available in PDF, EPUB and Kindle. Book excerpt: The traditional division of labor between the database (which only stores and manages SQL and XML data for fast, easy data search and retrieval) and the application server (which runs application or business logic, and presentation logic) is obsolete. Although the books primary focus is on programming the Oracle Database, the concepts and techniques provided apply to most RDBMS that support Java including Oracle, DB2, Sybase, MySQL, and PostgreSQL. This is the first book to cover new Java, JDBC, SQLJ, JPublisher and Web Services features in Oracle Database 10g Release 2 (the coverage starts with Oracle 9i Release 2). This book is a must-read for database developers audience (DBAs, database applications developers, data architects), Java developers (JDBC, SQLJ, J2EE, and OR Mapping frameworks), and to the emerging Web Services assemblers. - Describes pragmatic solutions, advanced database applications, as well as provision of a wealth of code samples. - Addresses programming models which run within the database as well as programming models which run in middle-tier or client-tier against the database. - Discusses languages for stored procedures: when to use proprietary languages such as PL/SQL and when to use standard languages such as Java; also running non-Java scripting languages in the database. - Describes the Java runtime in the Oracle database 10g (i.e., OracleJVM), its architecture, memory management, security management, threading, Java execution, the Native Compiler (i.e., NCOMP), how to make Java known to SQL and PL/SQL, data types mapping, how to call-out to external Web components, EJB components, ERP frameworks, and external databases. - Describes JDBC programming and the new Oracle JDBC 10g features, its advanced connection services (pooling, failover, load-balancing, and the fast database event notification mechanism) for clustered databases (RAC) in Grid environments. - Describes SQLJ programming and the latest Oracle SQLJ 10g features , contrasting it with JDBC. - Describes the latest Database Web services features, Web services concepts and Services Oriented Architecture (SOA) for DBA, the database as Web services provider and the database as Web services consumer. - Abridged coverage of JPublisher 10g, a versatile complement to JDBC, SQLJ and Database Web Services.

OCA: Oracle 10g Administration I Study Guide

Download OCA: Oracle 10g Administration I Study Guide PDF Online Free

Author :
Publisher : John Wiley & Sons
ISBN 13 : 0782150756
Total Pages : 670 pages
Book Rating : 4.7/5 (821 download)

DOWNLOAD NOW!


Book Synopsis OCA: Oracle 10g Administration I Study Guide by : Chip Dawes

Download or read book OCA: Oracle 10g Administration I Study Guide written by Chip Dawes and published by John Wiley & Sons. This book was released on 2006-02-20 with total page 670 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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