Open the door to a career as an Oracle database administrator as you learn to plan for and install the Oracle Database software. Then learn the rudiments of database administration from longtime Oracle expert Iggy Fernandez. Take advantage of the high demand for Oracle expertise and use Beginning Oracle Database 11g Administration to launch you on the right track to Oracle DBA career success.

Beginning Database Programming with Oracle Application Express shows novice database developers and power users how to master Application Express to build effective web-based Oracle database applications. The author will provide hands-on, step-by-step guideance on the complete development process, through creating, customizing, and extending the application. The book gets quickly off the ground by showing how to build a simple application; it then gets into the details for extending the applic ation; reporting and charting; themes and templates, and security. The author also shows how to use packaged applications, as well as work with multiple applications. He concludes the book by providing guidance on data migration and integration with the Oracle environment.

This fully revised beginner's guide covers the fundamental concepts of Oracle Database 11g. Through self-paced tutorials, you will learn about database essentials, the role of the administrator, high availability, and large database features. An in-depth introduction to SQL and PL/SQL is also included. Oracle Database 11g: A Beginner's Guide walks you, step-by-step, through database setup, administration, programming, and backup and recovery. A configurable sample database available online prov ides additional support for projects and examples.

An oracle on Oracle, Byron Pearce takes the complexity out of the Oracle 11g database and helps readers work effectively in the Oracle 11g environment Begins with a friendly introduction to the basics of the Oracle database and then progresses to implementing Oracle in real-world situations, creating and protecting an Oracle database, and troubleshooting Covers the new features of Oracle 11g, including automatic memory tuning, fully automatic SQL tuning, automatic storage load balancing, and aut omatic diagnostic repository Devotes entire chapters to the oft-forgotten but critical topic of common mistakes that occur when installing Oracle, designing a database, and writing SQL code.

If you're developing applications that access Oracle databases, you can save time and work by having SQL do more of the data handling for you: This new book shows you how. It teaches you how to create effective SQL queries to extract and update the data in an Oracle database. It teaches you how to design and implement a database, giving you insight into performance and security issues. It teaches you how to use PL/SQL to take advantage of powerful features like stored procedures, functions, and triggers. In short, it teaches you to create the kind of efficient database applications that make you a more effective and valuable developer.

PL/SQL is Oracles proprietary variant of the industry standard Structured Query Language (SQL.) In order to effectively develop or maintain - or even use - an Oracle database you need to have a good working knowledge of PL/SQL. Many of the current PL/SQL titles are overkill for those who need to use PL/SQL but have no intention of becoming professional DBAs. This book teaches you what you really need to know, without getting bogged down by what you don't. Sams Teach Yourself Oracle PL/SQL in 10 Minutes is a tutorial-based book, organized into a series of short, easy-to-follow lessons. Instead of dwelling on database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data. It uses the format of the author's bestselling Sams Teach Yourself SQL in 10 Minutes =, which has proven to be highly effective and popular.

Beginning PHP and Oracle: From Novice to Professional offers comprehensive information on using the PHP scripting language in conjunction with Oracles database platform. PHP is one of the most prominent open source technologies in the area of web development, while Oracle is one of the most widely deployed and used database products. You'll learn to reap the benefits of these core technologies by using them in unison to create dynamic, data-driven web applications. The book is packed with pract ical examples based on the many years of real-world experience of authors W Jason Gilmore and Bob Bryla. This book is an ideal read for web designers or programmers wanting to create applications with PHP in an Oracle environment.

Oracle 11i E-Business Suite from the Front Lines is the first book to compile the tips, techniques, and practical advice for administering Oracle E-Business Suite 11i. The author examines Active Directory Utilities, patching, cloning, and the new features that 11i brings to the market. The book benefits those with limited experience with Oracle Application but with more extensive background in Oracle Database Administration. This volume is valuable to systems administrators or DBAs who have expe rience with older versions of Oracle Financials and want to expand their knowledge to include the changes inherent in 11i.

These Starter Kits include the full distribution of Oracle Database 10g Express Edition on CD-ROM. Readers will learn to install the database on Linux and take full advantage of all of the powerful features. Tutorials and step-by-step guidelines throughout will equip you with the key concepts and hands-on experience necessary to get started using Oracle Database 10g Express Edition right away.

These Starter Kits include the full distribution of Oracle Database 10g Express Edition on CD-ROM. Readers will learn to install the database on Windows and take full advantage of all of the powerful features. Tutorials and step-by-step guidelines throughout will equip you with the key concepts and hands-on experience necessary to get started using Oracle Database 10g Express Edition right away.

Written in the friendly, easy-to-understand style of the For Dummies series, this book shows novice PL/SQL programmers how to use PL/SQL, the procedural programming language embedded in Oracle, to develop Oracle applications. Experienced Oracle programmers and project managers will also benefit from the best practices and code and naming standards material in the book. Discusses getting started with PL/SQL (including language fundamentals, program control, exception handling, and packages); Ora cle-specific programming topics (Oracle constructs of interest to PL/SQL developers, code-placement option, and more); and advanced PL/SQL (manipulating strings, manipulating dates, and manipulating numbers, among others)

Targeting those new to Oracle data warehousing who need to get started right away, this book presents real-world problems and issues with managing large volumes of data in an Oracle database. All aspects of Oracle data warehouse management-including Oracle warehouse database administration, OLAP with Oracle Discoverer, Oracle Warehouse Builder, and Oracle data mining-are covered in detail. An overview of Oracle business intelligence tools and a downloadable code depot are also included.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

Even if you have limited programming experience, you can develop and deploy professional-quality applications using Oracle's new rapid web application development tool. Oracle HTML DB Handbook shows you how to quickly create secure and scalable web applications that can be instantly deployed. Learn how you can consolidate spreadsheets and desktop databases into an Oracle Database and share your applications over the web. You'll also get details on administration and security. Real-world sample p rojects get you started using Oracle HTML DB right away.

Students need a big-picture introduction to Oracle and they need specific examples and steps. This concise book covers all of the topics students need in a first class by using step-by-step techniques with a rich set of databases to provide students with practical experience - all in one book.

Flexible, reliable, and inexpensive, enterprise grid computing is the ideal solution to today's changing business needs. Perfect for business decision-makers, Grid Revolution provides an accessible overview of this technology. The book covers current grid standards activities and outlines the strategic steps required to phase grid computing into an existing infrastructure.

Explaining how to use the powerful Oracle10g automatic features for simple database administration, this book has complete coverage for 10g Automatic Storage Management (ASM), 10g Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Automatic SGA Management (ASM), and the SQL Tuning Advisor. Demonstrated is how a non-Oracle person can quickly install and configure Oracle database 10g for automatic database administration and how, in less than a day, a complete Oracl e10g database can be ready to use. Also explained is easy disk and file management with the 10g Automatic Storage Management and how the 10g Automatic Workload Repository collects important Oracle performance statistics.

The world of IT is always evolving, but in every area there are stable, core concepts that anyone just setting out needed to know last year, needs to know this year, and will still need to know next year. The purpose of the Foundations series is to identify these concepts and present them in a way that gives you the strongest possible starting point, no matter what your endeavor. Oracle Database Foundations provides essential knowledge about installing, configuring, maintaining, and querying Or acle 9i and 10g databases. What you learn here will benefit you in the short term, as you acquire and practice your skills, and in the long term, as you use them.

Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you'll get the fundamentals applicable to all Oracle database releases.

This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10g, and free code will be available for download.

This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for new Oracle8i release 8.1.6 features. SQL*Plus is available at every Oracle site--from the largest data warehouse to the smallest single-user system--and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQL*Plus can be. This book b oils down the most vital information from Gennick's best-selling book, Oracle SQL*Plus: The Definitive Guide, into an accessible summary. It concisely describes interacting with SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements.

Prepares students for the first exam in both the Oracle DBA and Internet Application Developer Certification Tracks, and offers a solid general understanding of Oracle9i SQL.

From the exclusive publishers of Oracle Press Books, here is the only book available offering complete coverage of RMAN (Recovery Manager), Oracle's free backup and recovery technology. An indispensable resource for new Oracle users, database administrators, and system administrators.

Your Oracle career starts here! Ideal for those new to Oracle technology, this introductory guide explains in easy-to-follow detail the day-to-day duties of a database administrator (DBA), as well as essential database installation, monitoring, and managing techniques.

Starts with very simple Oracle SQL concepts and slowly builds into more complex query development and PL/SQL. Covers SQL as it is invoked via SQL Plus, a command-line system to launch interactive queries. Provides an appendix for UNIX users of Oracle.

The ideal audience for this book is the new Oracle DBA or UNIX system administrators who have either inherited DBA responsibilities or who want to gain cross-functional skills. Experienced DBAs will find much of this book too basic, and may complain that it doesn't cover the full range of database administration topics. In my opinion the relatively narrow scope of this book is one of its strengths. Instead of overwhelming the new DBA with hundreds of pages it sticks to the essentials. Another p oint in its favor is that the author doesn't attempt to go into gory details about how things work (information that you can get from other books as your comfort level and self-confidence improve), but remains focused on what you need to do in order to effectively manage and support an Oracle 9i instance.

Your Oracle career starts here! Ideal for those new to Oracle technology, this officially authorized guide explains in easy-to-follow detail how to administer an Oracle database using this state-of-the-art tool. Inside, you'll learn to eliminate, simplify, and automate administrative tasks and use Oracle Enterprise Manager (EM) as a management framework for your entire Oracle environment.

Like the earlier versions, this manual is intended for beginners and is not a reference book. This manual covers basics and advanced topics of SQL covering Oracle 8i version. This book is a training manual where anyone can learn SQL. This book has lot of exercises and solutions at the end of each chapter.

Oracle Backup and Recovery 101 explains, step-by-step, how to manage database backup and recovery via physical file operations and logical data operations. The book also teaches you how to perform server-managed backup and recovery using Oracle Recovery Manager (RMAN). Officially authorized by Oracle Corporation, this hands-on guide shows you everything you need to know to implement a basic backup and recovery plan for your Oracle database and includes full details on setting up a small sample d atabase so you can practice the tasks covered throughout the book.

Oracle development tools come and go, but one of the few constants in the Oracle database environment is the PL/SQL programming language, which has been around for more than a decade. As Oracle's premier tool for building store procedures, PL/SQL uniquely supplements the standard relational database language, SQL, with the features needed to build real-world applications. Among our best-selling books on PL/SQL, Learning Oracle PL/SQL is the first one a newcomer to the language will want to read . Beginning with a discussion of what PL/SQL is and what it's good for, this book then presents language features, one at a time, in an engaging and readable way. A consistent and understandable example application--the development of a library's electronic catalog system--runs through the chapters. Topics include: Why use PL/SQL at all? Fundamental components of the language Fast ways to read and write Oracle data Organizing code for reusability Using PL/SQL to generate web-based applications Making sure your PL/SQL application is secure against hackers Benefits of using third-party developer tools Interacting with the internet (e.g., sending email from the database) New PL/SQL features in Oracle9i Learning Oracle PL/SQL introduces PL/SQL in a way that's useful to a variety of audiences: beginning programmers, new Oracle database administrators, and developers familiar with other databases who now need to learn Oracle.

Tom Kyte is of a rare breed. To begin, he's technically expert in his subject (administration of and development of applications for Oracle database management systems). What's more (and what distinguishes him from the ranks of the super-competent), he is both able and willing to share his considerable store of wisdom with Oracle users via books like Expert One on One: Oracle. Perhaps the best book about Oracle products ever put out, this book is a model of all aspects of technical publishing: s cope, level of detail, clarity of explanations, and quality of examples. It's pretty much certain that you will learn a great deal about Oracle from Kyte's work, and that you'll become more capable in your work as a result of studying this book. Kyte - it's very tempting to call him an Oracle oracle - seems not to have had to struggle to fit his message into the Wrox Press form, which relies on a running commentary interspersed with code listings and conceptual diagrams. Kyte's commentary is em inently informed and packed with references to the differences between that which is ideal and that which often must be done to accommodate reality. He takes care to explain how little-known pieces of the Oracle environment - and alternative ways of looking at the more familiar ones - solve problems, an approach that leads to elegant, efficient solutions. Kyte boosts his readers across the chasm that separates people who can write applications for Oracle databases from people who understand Orac le databases.

PL/SQL is Oracle's version of SQL, the industry standard for enterprise-level database interaction. Explains how to write powerful, flexible programs, and to automate a multitude of database tasks. The only official Oracle entry-level book on the topic, it provides a complete introductory course to readers on SQL and PL/SQL. An invaluable tool for database administrators, developers and financial analysts, it teaches novice-through-experienced readers how to manipulate records to easily access a nd analyze database information. Popularity of SQL, combined with rich response to Oracle Press' other SQL titles, make this respected resource a guaranteed best-seller.

Oracle Financials Handbook discusses the various products contained in Oracle Financials, with an emphasis on its accounting packages. It provides detailed implementation instructions and expert advice not published elsewhere and offers a blueprint for planning an implementation. Readers will find find essential accounting knowledge within the context of the Oracle products, coverage of key features in each product, and the key issues in successfully installing them. They will also gain a practi cal plan for organizing, budgeting, staffing, and managing an Oracle Applications implementation and will learn about the subtle ways in which package implementation differs from custom software development. This book also addresses when to modify the package to meet business requirements-and when to modify business practices to suit the package.

The Oracle DBA Interactive Workbook presents an introduction to Oracle database administration in a unique and highly effective format. It is organized more like a teaching aid than a reference manual in that to learn basic administration techniques, you are challenged to work through a set of guided tasks rather than to read through descriptions. There is a list of additional reading material in Appendix B that you can reference if you wish to delve deeper into any of the topics covered in this book. This book is intended for beginners in the world of Oracle database administration. It will take you through a set of tasks, starting with creating a database to using some of the Oracle database tuning, and backup and recovery utilities. Those experienced with Oracle databases will recognize that a workbook covering the topic of database administration will be an extremely useful introduction for the beginner, but it cannot be used as a deep study of the Oracle database environment. Aft er working through this book, you will have been launched into the exciting and interesting (sometimes nerve-racking) world of database administration, but it will take years of experience to become a senior database administrator. This book is intended for anyone who needs a quick and detailed introduction to Oracle database administration tasks. It is not the intention of this book to provide an in-depth study of the Oracle database server. The foundation for this book was developed to supplem ent the Introduction to Oracle Database Administration class in the Database Track at Columbia University's Computer Technology and Applications (CTA) program in New York City. The book's sidebars and answers often reflect questions that students have asked in class.

Teaches beginners the essentials of running Oracle8i on a network, and advises IT managers and security administrators on a full complement of industry-compliant features designed to protect against security hazards. The only title yet published explicitly on Oracle8i Networking. Integrates Oracle servers with network services and Internet services, including advanced networking and security options. Covers integration of Oracle into the Distributed Computing Environment (DCE). (Osborne) Explain s how interactions over a network take place. Describes the hardware and software required, and how all the components interface to produce successful communications between computers and databases. Contains step-by-step procedures illustrated by screen shots. Details on Internet protocols and network encryption are included.

From the official publisher of Oracle Press books comes this complete book/CD-ROM package for deploying and running Oracle8i on the Linux platform. You'll get step-by-step details on installation, customization, administration, and troubleshooting. Plus, the CD-ROM contains the official version of Oracle8i for Linux and Enterprise Manager. You'll get everything you need to get up and running on Oracle8i for Linux. (Osborne) Provides the user with everything needed to get started using Oracle8i o n the Linux platform. Provides a collection of tutorials and step-by-step guidelines that provides the user with key concepts and hands-on experience necessary to install and deploy Oracle8i on Linux.

Gives background in Oracle's implementation of the SQL language. Each chapter is divided into labs, with objectives, examples, and exercises on specific tasks and questions that are designed to help readers discover important aspects of the SQL language. Exercises build knowledge step by step by introducing relational database concepts, the SQL*Plus environment, and the SQL language. Labs also include explained answers, multiple-choice review questions, and critical thinking questions. Morrison works in Internet development. Rischert is co-chair of Columbia University's Database Application Development and Design track at the Computer Technology and Application Program.

The Oracle Forms Interactive Workbook presents Oracle Forms in a unique and highly effective format. It challenges you to learn Oracle Forms by using it rather than by simply reading about it. Just as a grammar workbook would teach you about nouns and verbs by first showing you examples and then asking you to write sentences, the Oracle Forms workbook teaches you about Forms, triggers, and items by first showing you examples and then asking you to create these objects yourself. This book is inte nded for anyone who needs a quick but detailed introduction to building applications with Oracle Forms. The ideal readers are those with some experience with relational databases, specifically Oracle, but little or no experience with Oracle Forms or application development.

The Oracle PL/SQL Interactive Workbook presents the Oracle PL/SQL programming language in a unique and highly effective format. It challenges you to learn Oracle PL/SQL by using it rather than by simply reading about it. Just as a grammar workbook would teach you about nouns and verbs by first showing you examples and then asking you to write sentences, the Oracle PL/SQL workbook teaches you about cursors, procedures, and triggers by first showing you examples, and then asking you to create thes e objects yourself. Is For This book is intended for anyone who needs a quick but detailed introduction to programming with Oracle's PL/SQL language. The ideal readers are those with some experience with relational databases, with some Oracle experience, specifically with SQL and SQL*Plus, but with little or no experience with PL/SQL, or with most other programming languages.

Welcome to the Java 2 Programmer's Interactive Workbook. This book will help guide you as you learn the Java programming language, which is regarded as the future of computer programming. Never before has a computer language so successfully combined a powerful object-oriented language with all of the graphical tools needed to create a fully functional program that can run on any system and in any Web browser. With the advance of the Internet, Java has become the language of choice for developers who need to create and distribute their applications quickly. Java was developed by Sun Microsystems in the early 1990s and has been gaining popularity every since. Prior to Java, the two main languages used by the computer industry were C, and C++. C is simple, powerful, and sometimes elegant, but it is also a procedural language. C++ is object-oriented, but also hugely complex and requires a great deal of overhead to maintain a program. Both languages are also machine-dependent, meaning that their programs only run on one type of computer (PC, Mac, Unix). The program must be recompiled, and sometimes rewritten, to work on a different computer. This can lead to long development times for projects. Likewise, neither C nor C++ have built-in graphical utilities. Both must use special libraries that allow the program to use the windowing features of the computer. These libraries can be vastly different on various computer platforms, requiring more rewriting of the programs.

Oracle Developer is one of the most powerful database application tools available today, with excellent Internet and middle-tier capabilities. Oracle Developer Starter Kit provides a solid working introduction to using this tool effectively. Stressing a hands-on tutorial of the major features of this product, plus plenty of tips for successful programming, this book is all you need to be productive. The hands-on focus is a real strength of this text, which does a good job of explaining how Orac le Developer works, and offers plenty of advice about following Oracle-recommended conventions. (Readers are reminded that effective Developer programming means cooperating with the excellent built-in functionality of the product. By following a few principles in Developer, you can write database applications that will scale to hundreds or thousands of users effortlessly--this includes the ability to deploy to the Internet.) Early chapters introduce the basics of using Oracle Forms, the form-des ign tool, to create screens for data entry and reports (by using Oracle Reports), along with graphics and charts.

This compact guide provides the jump-start Oracle developers need to make the transition from traditional programming to the development of useful Web applications for Oracle8i. Even readers who start out knowing nothing about HTML, PL/SQL, or Oracle's other tools will learn how to create simple Web applications in a matter of days. The book focuses on Oracle8i, but also covers Web development for earlier Oracle versions (Oracle8 and Oracle7).

SAMS Teach Yourself PeopleSoft in 10 Minutes focuses on the end-user by covering general tasks including basic navigation skills, working with master data and running reports. This book covers the general PeopleSoft functions that every end-user of PeopleSoft-based applications must know. You will learn all the essential tasks for running PeopleSoft-based applications smoothly and easily. Using concise 10-minute lessons, you will learn how to log on to PeopleSoft, access the PeopleSoft modules, use basic navigation skills, work with master data, generate reports, read and interpret common error messages, and access extensive online help features.

This book provides a powerful set of tools for Oracle database administrators and developers. During their many years of administering, tuning, and troubleshooting Oracle databases, the authors have developed hundreds of useful scripts. Now you can instantly take advantage of their experience by putting these scripts to work at your own site. DBAs and developers are constantly reinventing the wheel. Most Oracle sites have similar requirements, problems, and crises, and at most of these sites DBA s and developers find themselves reinventing the wheel by writing the same kinds of scripts -- and too often they're writing them under pressure, in hit-or-miss and error-prone fashion. The scripts in this book are tried-and-true. They've been thoroughly tested in many different environments. You can use them right now to simplify the tasks you perform each day -- monitoring databases for reliability, protecting your database against data loss, improving performance, increasing security, and bui lding reports that provide insight into the inner workings of Oracle databases. You can also turn to these scripts in emergencies to diagnose system problems and repair databases when the pressure is on.

2001-2011 Oracle-Books.com