Oracle Books
|
|
Please click on a book's thumbnail to read a bit about the book.
|
 |
The book has been written to provide genuine domain knowledge to programmers who wish to learn web based commercial application development using Oracle 9Ids as a front-end and Oracle 9i AS on Linux as the back-end.
Learning the Oracle Forms 9i toolbox is done through the construction of an Inventory system.This is something application developers would definitely appreciate. Finally, the concepts learnt are reinforced by building a Car Rental System.
|
|
The Topics Covered
- Installing Red Hat Linux
- Installing Oracle 9i AS On Linux
- An Introduction to Oracle Forms 9i DS
- Setting up the Forms 9i DS Environment
- Configuring NET Assistant
- Starting with Oracle Forms 9i
- Working with a Master/Detail Form
- PL/SQL Libraries
- Working with Menus.
- Working with Reports
- Working with Graphs
- Project Specification –Car Rental
- Car Rentals Projects
- Project Deployment
- Oracle 10G Grid Computing
|
|
 |
The book has been written to provide genuine domain knowledge to programmers who wish to learn web based commercial application development using Oracle 9Ids as a front-end and Oracle 9i AS on Linux as the back-end.
|
|
The Topics Covered
- Working With Forms
- Master Form
- Property Classes and Visual Attributes
- PL/SQL Libraries and Alerts
- Object Libraries
- The Master Detail Form
- Using Multiple Canvases
- Using Tab Canvas
- Interlinking Related Forms and Passing Parameters Between Forms
- User Defined Search Form
- Working With Menus
- Working With Reports
- Creating A Break Report
- Master/Detail Report
- Creating A Matrix Report
- Using PL/SQL With Report
- Working with Graphs
|
|
 |
Oracle Applications Development can beused as a reference book as well as a self-study guide to learn and masteradvanced Oracle9i technologies. It explains the development of complex applications using Pro Cprecompiler. It provides programs to explain the practical implementationof every important concept. The book contains tested program codes and providesyou in-depth discussionon developing servlet and JSP using SQL J Tool of Java.
It discusses various wizards and IDE tools of J Developer with practicalimplementations. It also discusses various Oracle XML technologies and the developmentof Java applications using XML.This book is accompanied by a CD thatcontains the source codes of programs in the chapters as well as in the exercises.
|
|
The Topics Covered
- Introduction
- Pro c precompiler
- Introduction to sqlj programming
- Enterprise applications in oracle sqlj
- Internet applications in oracle sqlj
- Introduction to oracle xml technologies
- Developing xml based java applications
- Developing applications using jdeveloper
- Developing applications using jpublisher
|
|
 |
Understanding Oracle teaches the Oracle in any easy and interactive way and can be used as a reference book as well as a self-study guide to learn and master SQL and PL/SQL concepts and their implementation. It clearly discusses the RDBMS concepts and their implementation in Oracle. It teaches Oracle from the beginner’s level that can be understood by novices. It requires no previous knowledge of any RDBMS. The book provides examples that help in understanding the concepts and information about integrity constraints in Oracle.
It also provides in-depth discussion in PL/SQL programming and its implementation. It discusses object-oriented design of Oracle and implements various database objects, such as table, views, packages, functions, procedures, triggers, synonyms and sequences. It explains the installation of Oracle 9i Server and Client. The book has interesting exercises to test the theoretical as well as practical knowledge. It is accompanied by a CD that contains the source codes of programs in the chapters as well as in the exercises.
|
|
The Topics Covered
- Introduction to Oracle and RDBMS
- Introduction to SQL
- DDL and DML Statements
- Views in Oracle
- Understanding DCL and TCL Statements
- PL/SQL Programming
- Exception Handling in Oracle
- Cursors in Oracle
- Procedures, Functions and Packages
- Triggers in Oracle
- Collections and LOB Types
- Object Oriented Programming in Oracle
|
|
|
Oracle is constantly evolving, and getting better with each evolutionary cycle. Today the corporate world wants to Internet enable their commercial applications, hence Oracle has responded by offering Oracle 10g DS. The book has been written to provide genuine domain knowledge to programmers who wish to learn web based commercial application development using Oracle 10g Developer Suite as a front-end and Oracle 10g Database as the back-end.
Learning the Oracle 10g DS – Forms toolbox is done through the construction of a Supplier module belonging to an Inventory system. This is something application developers would definitely appreciate. Finally, the concepts learnt are reinforced by building and later deploying the Manufacturing And Sales System on the Application Server. When the examples in each chapter are worked through they will build a strong, forms based, application development foundation using Oracle 10g DS, as the toolbox of choice.
|
|
The Topics Covered
- Setting Up the Framework
- Understanding The Framework
- Setting Up Oracle Database 10g
- Setting Up Oracle 10g Developer Suite
- Configuring Net Assistant
- Developing Forms In Oracle 10g DS
- An Introduction To Oracle 10g DS
- Built-In Wizards
- Handling Data
- Starting With Oracle 10g DS – Forms
- Working With A Master / Detail Form
- Working With PL/SQL Libraries
- Working With Menus
- Developing Reports In Oracle 10g DS
- Working With Reports
- Working With A Master / Detail Report
- Working With A Parameterized Report
- Working With Graphs
- Developing Projects In Oracle 10g DS
- Project Specifications – Purpose, Modules, Designs
- Project Planning – Specifications, Test Data, Validations, Micro Help
- Project Processing
- Project Deployment
|
|
 |
Oracle is constantly evolving, and getting better with each evolutionary cycle. Today the corporate world wants to Internet enable their commercial applications, hence Oracle has responded by offering Oracle 10g with HTML DB. This is a combination of an excellent RDBMS and a Forms based RAD tool that uses a Browser as the client side runtime environment. All this at the cheapest cost of ownership to company for the rapid deployment of production quality, Forms based, commercial applications on the Internet / Intranet.
This book explains the latest, additional SQL and PL/SQL attributes that Oracle 10g brings to the programmers world. Then goes on to explain the Forms based, application development using HTML DB, Oracle’s Forms based RAD tool. Each topic is very liberally sprinkled with examples that are mapped to applications, which fit in the real world.
|
|
The Topics Covered
- Understanding the framework
- Setting up oracle database 10g
- Setting up HTMLDB
- Overview of oracle databases 10g
- Interactive sql part-1
- Interactive sql part-2
- Interactive sql part-3
- Interactive Isql plus
- Introductions to pl/sql
- Using regular expressions
- Tablespaces DBA and user
- Overview and getting started
- Working with forms (The automatic way)
- Working With Forms (The Manual Way)
- Working with master details user interfaces
- Building Reports And Charts
|
|
|
The book has been written to provide genuine domain knowledgement to programmers who wish to learn professional project development using Oracle Forms 6i/9i DS ,as a front -end and Oracle 9i AS on RED HAT LINUX as the back-end .Learning the project Development (in Oracle Forms 6i) is done through the construction of two projects. A Retail Banking System and A Manufacturing And Sales System.
|
|
The Topics Covered
- Installing Red Hat Linux
- Installing Oracle 9i AS On Linux
- Setting up the Forms 6i Environment
- Setting up the Forms 9i DS Environment
- Configuring Net Assistant
- Business Model for Retail Banking
- Project Planning for Retail Banking
- Data Entry Forms Processing for Retail Banking
- Business Model for Manufacturing and Sales System
- Project Planning for Manufacturing and Sales System
- Data Entry Forms Processing for Manufacturing and Sales System
- Migrating Retail Banking to Forms 9i DS
- Migrating Manufacturing and Sales System
|
|
 |
The book has been written to provide an excellent grounding to those who wish to learn SQL and PL/SQL using Oracle. Like all his earlier books this book also has several illustrative examples, which have a logical link between them.
Each set of examples helps build skills that will take the reader to the next set of examples, which in turn leads upwards until a strong programming foundation using the natural language of Oracle has been established.
Learning of SQL & PL/SQL is done thought the construction of a Retail Banking System. The skills thus developed are implemented via hands on exercises based on the construction of a Sales Order System.
|
|
The Topics Covered
- Setting Up Oracle 9i
- Database Concepts
- Installation Of Oracle
- Post Installation Steps Setting Up The Interactive SQL*Plus Tool
- Setting Up The Business Model
- Business Model For Retail Banking
- Project Planning For Retail Banking
- Structural Querying Language
- Using Interactive SQL To Create Tables& Insert& View& Modify or Delete Table Records
- Using Interactive SQL To Set Data Constraints And Data Integrity
- Performing Arithmetic& Logical or Search Operations& Create Functions And Manipulating Dates
- Create Data Groups& Subqueries& Joins, Unions with the Intersect and Minus Clause
- Advance Structural Query Language
- SQL Performance Tuning Security Management Using SQL
- OOPS In Oracle Advance Features In SQL*Plus
- Procedure Language/ Structural Query Language
- Introduction to PL/SQL PL/SQL Transactions
- PL/SQL Security PL/SQL Database Objects
|
|
 |
The Administering Oracle book teaches the administering in an easy and interactive way.This book is written according to the syllabus of the BCA/MCA/DOEACC A level courses fo various recognised Indian Universities.This book can be used as a reference book as a self –study guide to learn and administer Oracle.
|
|
The Topics Covered
- Understanding Oracle Architectures
- Administering Databases and Tablespaces
- Managing Physical Files
- Managing Tables and Schema Objects
- Administering Users, Priviledges and Roles
- Indexes
- Optimitizing Database Performance
- Backing up and Recovering Data
- Replication
- Distributed Database in Oracle
- Introducing OEM
|
|
 |
The book has been written to provide an excellent grounding to those who wish to learn SQL, PL/SQLJ using Oracle 8i or 9i. Like all his earlier books this book also has several illustrative examples, which have a logical link between them.
Each set of examples helps build skills that will take the reader to the next set of examples, which in turn leads upwards until a strong programming foundation using the natural language of Oracle 8i or 9i has been establised.
Each topic is very liberally sprinkled with examples that are mappped to applications, which fit in the real world. If a grounding in Java is required a Study of Web Enabled Commercial Application Development Using 2.0 written by Ivan Bayross is recommended.
|
|
The Topics Covered
- Structural Querying Language
- Procedure Language / Structural Querying Language
- Structural Querying Language with Java - SQLJ
- Oracle 9i - New Features
- Installing and Configuring Oracle 8i Personal Edition on a Windows 9x machine
|
|
|
The book has been written to provide genuine domain knowledge to programmers who wish to learn web based commercial application development using Oracle 9Ids as a front-end and Oracle 9i AS on Linux as the back-end.
Learning the Oracle Forms 9i toolbox is done through the construction of an Inventory system.This is something application developers would definitely appreciate. Finally, the concepts learnt are reinforced by building a Car Rental System.
|
|
The Topics Covered
- Installing Red Hat Linux
- Installing Oracle 9i AS On Linux
- An Introduction to Oracle Forms 9i DS
- Setting up the Forms 9i DS Environment
- Configuring NET Assistant
- Starting with Oracle Forms 9i
- Working with a Master/Detail Form
- PL/SQL Libraries
- Working with Menus.
- Working with Reports
- Working with Graphs
- Project Specification –Car Rental
- Car Rentals Projects
- Project Deployment
- Oracle 10G Grid Computing
|
|
|