thiru's free oracle ebooks

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (2nd Edition)

2007-12-01T14:38:00.000+05:30

John L. Viescas, Michael J. Hernandez "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (2nd Edition)"

Addison-Wesley Professional (September 24, 2007) ISBN 0321444434 672 Pages PDF 2.3 Mb

Over the last several decades, SQL has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using SQL now totals in the millions. If you are accessing corporate information from the Internet or from an internal network, you are probably using SQL. SQL Queries for Mere Mortals will help new users learn the foundations of SQL queries, and will prove to be an essential reference guide for intermediate and advanced users.

http://rapidshare.com/files/73473066/SQL.Queries.for.Mere.Mortals.2nd.Edition.Sep.2007.rar

http://www.megaupload.com/?d=O3M5NDND

Practical Oracle Security: Your Unauthorized Guide to Relational Database Security

2007-12-01T11:51:00.000+05:30

Josh Shaul, Aaron Ingram, "Practical Oracle Security: Your Unauthorized Guide to Relational Database Security"
Syngress (August 15, 2007) ISBN 1597491985 432 Pages PDF 3.4 Mb

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 books companion Web site contains dozens of working scripts that DBAs can use to secure andautomate their Oracle databases.* The only practical, hands-on guide for securing your Oracle databasepublished by independent experts.* Companion Web site contains dozens of scripts to help you automatesecurity tasks.* Your Oracle database does not exist in a vacuum, so this book showsyou how to securely integrate your database into your enterprise.

http://rapidshare.com/files/73470750/Syngress.Practical.Oracle.Security.Aug.2007.rar
http://www.megaupload.com/?d=AJ94UNNE

Oracle Applications 11i, R12 - Administration

2007-11-30T20:51:00.000+05:30

http://kthiru.port5.com/Oracle_Applications_11i_R12_Administration_v4.zip

Oracle 1z0-001 Exam Q and A

2007-11-28T23:21:00.000+05:30

http://www1.vista-server.com/uploadfile/6/6/29/1651197660.zip

http://www2.vista-server.com/uploadfile/6/6/29/1651197660.zip

http://www3.vista-server.com/uploadfile/6/6/29/1651197660.zip

Joe Celko's SQL Programming Style

2007-11-24T22:46:00.000+05:30

Joe Celko "Joe Celko's SQL Programming Style" Morgan Kaufmann ISBN 0120887975 2005 Year PDF ~2 Mb 272 Pages

Are you an SQL programmer that, like many, came to SQL after learning and writing procedural or object-oriented code? Or have switched jobs to where a different brand of SQL is being used, or maybe even been told to learn SQL yourself? If even one answer is yes, then you need this book. A "Manual of Style" for the SQL programmer, this book is a collection of heuristics and rules, tips, and tricks that will help you improve SQL programming style and proficiency, and for formatting and writing portable, readable, maintainable SQL code. Based on many years of experience consulting in SQL shops, and gathering questions and resolving his students’ SQL style issues, Joe Celko can help you become an even better SQL programmer.+ Help you write Standard SQL without an accent or a dialect that is used in another programming language or a specific flavor of SQL, code that can be maintained and used by other people. + Enable you to give your group a coding standard for internal use, to enable programmers to use a consistent style. + Give you the mental tools to approach a new problem with SQL as your tool, rather than another programming language—one that someone else might not know!

http://rapidshare.de/files/5583753/SQL_Programming_Style.pdf.html

Beginning PL/SQL: From Novice to Professional

2007-11-24T22:43:00.000+05:30

Donald Bales , "Beginning PL/SQL: From Novice to Professional "Apress (August 24, 2007) ISBN: 1590598822 476 pages PDF 5,5 Mb

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales' extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features. Author Don Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule -- cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.Discover the 20% of PL/SQL that gives you 80% of the bang--key topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.Learn how to write production-level, object-oriented PL/SQL--you'll explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQL's object-oriented features as well.Work through real examples of using of PL/SQL--you'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.What you'll learnHow important SQL is in PL/SQLHow to use PL/SQL in both a relational and object-relational settingHow to create maintainable, modular, and reusable PL/SQL program unitsThe importance of testing as you go, and of building a permanent test plan for each moduleThe importance of building debugging capabilities into your code and building a permanent debug facility for each moduleThe importance of documenting as you go, and in the process building a permanent documentation set for your reusable modulesHow to apply modular PL/SQL to solve real-world problemsWho is this book for?Anyone who wants to learn how to create stored procedures against an Oracle database using PL/SQL. Programmers developing applications to be deployed against an Oracle database will need PL/SQL to take full advantage of the power Oracle has to offer. Database administrators who wish to implement functionality exposed only via PL/SQL package interfaces will also find this book useful.

http://depositfiles.com/files/2175989

http://rapidshare.com/files/65486766/Beginning_PLSQL_From_Novice_to_Professional_with_SOURCE_CODE-1590598822.rar

Oracle9i PL/SQL A Developers Guide

2007-11-24T22:39:00.000+05:30

Oracle9i PL/SQL: A Developer's Guide is intended for both intermediate-level Oracle developers who are designing or coding applications in SQL and PL/SQL and for advanced PL/SQL programmers who need to learn new PL/SQL 9ifeatures. In addition to providing developers with detailed coverage of the PL/SQL 9i language itself, author Bulusu Lakshman covers the techniques of using PL/SQL 9i for server-side applications and provides the methodology for implementing robust applications. Lakshman also mentors developers in implementing effective techniques for real-world and code-centric Oracle applications that, in the long run, will save them time and energy. Oracle9i PL/SQL: A Developer's Guide is a solid source for the development of Oracle9i PL/SQL applications. Developers incorporating these technologies into new applications and those migrating from earlier versions will both find Lakshman's expert treatment of the topic beneficial.

http://rapidshare.de/files/17398029/ebook0023.rar

Pass: danci

SQL Tuning

2007-11-24T22:36:00.000+05:30

SQL TuningO'Reilly Media, Inc.; 1st Edition edition ISBN: 0596005733 336 pages December 1, 2003 CHM 1 Mb

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.

http://www.icefile.info/index.php?page=main&id=cb9612204&name=0596005733.rar

Introduction to SQL: Mastering the Relational Database Language, 4th Edition

2007-11-24T22:34:00.000+05:30

Introduction to SQL: Mastering the Relational Database Language, 4th EditionPublisher: Addison-Wesley Professional; 4 edition (September 26, 2006) ISBN: 0321305965 Author: Rick F. van der Lans CHM 4,49 Mb 1056 pages

SQL was, is and always will be the database language for relational database systems such as Oracle, DB2, Sybase, Informix and Microsoft SQL Server. Introduction to SQL describes in depth the full capacity of SQL as it is implemented by the commercial databases, without neglecting the most recent changes to the standard, bringing the book up to date and fully compliant with SQL3. Unique in the extent of its coverage, this book takes you from the beginning to the end of SQL, the concepts to the practice, the apprentice to the master.Learn how to: * Query data * Update data * Create tables and views * Specify primary and foreign keys * Use indexes * Secure your data * Develop stored procedures and triggers * Develop applications with embedded SQL and ODBC * Carry out transactions * Optimize statements * Deal with object-relational concepts such as subtables, references, sets and user-defined data types.NEW section devoted to stored procedures and triggers NEW coverage of object-oriented concepts NEW information on application development with pre-programmed SQL NEW chapter on using SQL in combination with ODBCThe best way to learn a language is to work with it and the accompanying CD-Rom contains an SQL product called SOLID, chosen because it employs every aspect of SQL covered in the text. Experiment using the exercises in the book. --This text refers to the Paperback edition.

http://rapidshare.de/files/37043176/Addison.Wesley.Introduction.to.SQL.rar

http://depositfiles.com/files/320227

http://mihd.net/9ta0nx

Online Oracle9i SQL 1Z0-007 Training

2007-11-24T22:31:00.000+05:30

Courses within the Online Oracle9i SQL 1Z0-007 Training Series:

Online Oracle9i SQL 1Z0-007 Training: Advanced Queries and Views
Online Oracle9i SQL 1Z0-007 Training: Combining Tables
Online Oracle9i SQL 1Z0-007 Training: Creating Tables and Constraints
Online Oracle9i SQL 1Z0-007 Training: Database Objects and User Security
Online Oracle9i SQL 1Z0-007 Training: Grouping and Summarizing Data
Online Oracle9i SQL 1Z0-007 Training: Intermediate Queries
Online Oracle9i SQL 1Z0-007 Training: Introduction to SQL
Online Oracle9i SQL 1Z0-007 Training: Practice Exam Online
Oracle9i SQL 1Z0-007 Training: Queries with Single-Row Functions
Online Oracle9i SQL 1Z0-007 Training: SQL*Plus And iSQL*Plus Reporting and PL/SQL Online Oracle9i SQL 1Z0-007 Training: Working with Data

Links:
http://rapidshare.de/files/18382912/appz0009.part1.rar
http://rapidshare.de/files/18383338/appz0009.part2.rar
http://rapidshare.de/files/18383913/appz0009.part3.rar
http://rapidshare.de/files/18384052/appz0009.part4.rar
Pass: danci

Online Oracle9i SQL 1Z0-007 TrainingWITHOUT PASSWORD and in 1 FILE

http://rapidshare.de/files/18454728/Oracle.rar

OReilly - SQL Cookbook

2007-11-24T22:28:00.000+05:30

SQL Cookbook O'Reilly 2005 CHM in RAR 1Mb

http://rapidshare.de/files/13022440/sql_c.rar

Password: www.AvaxHome.ru

SQL: Practical Guide for Developers

2007-11-24T22:23:00.000+05:30

Michael J. Donahoo, Gregory D. Speegle, "SQL: Practical Guide for Developers"Morgan Kaufmann ISBN 0122205316 2005 Year PDF 1,42 Mb 272 Pages

This book is not just another SQL text. The author's use of simple yet clear examples to illustrate difficult concepts throughout the text makes this a perfect book for use in an introductory database systems class as a supplement or as an introductory reference for the novice practitioner."--Paul Fortier, University of Massachusetts, Dartmouth

"The book lives up to its title: it is a very practical guide. The authors clearly know their SQL and manage to write about the language in a step-by-step style that progresses smoothly from the simple to the more difficult aspects of the language. The profuse use of examples, each with an accompanying motivation and explanation of the results, lets the reader follow even complex topics without a constant struggle. The authors have even included examples that illustrate common errors programmers make, explaining the right way to perform the task. It doesn't hurt that the sample application is based on something everybody uses every day: food." --Jim Melton, Oracle Corporation

http://www.mytempdir.com/393722

http://rapidshare.de/files/11331676/MJDonahoo.rar.html

Password: www.AvaxHome.ru

Trees and Hierarchies in SQL for Smarties

2007-11-24T22:10:00.000+05:30

Written by an SQL master, this book includes tips and techniques and also conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. It features examples and update to SQL-99, includes sections of Query techniques, and a section on scheme design, with a war-story teaching style.

http://www.ebooksclub.org/?link=WHCZxt

Password=www.AvaxHome.ru

Beginning SQL

2007-11-24T21:36:00.000+05:30

Wrox Press Author(s): Paul Wilton, John Colby ISBN: 0764577328

* Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all times* Focuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendix* Paul Wilton is a successful Wrox “Beginning” book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particulardatabase product* SQL is an international standard for manipulating data in databases and is used by database programmers in all major database systems: Microsoft, IBM, Oracle, MySQL, and many others

password: books_for_all

http://rapidshare.com/files/23453286/BB103F41-9FCC-41FB-A6E5-197216D53B44.rar

Beginning Database Design (Wrox Beginning Guides) by Gavin Powell

2007-11-24T21:30:00.000+05:30

Beginning Database Design (Wrox Beginning Guides) by Gavin PowellPublisher: Wrox (December 5, 2005) ISBN-10: 0764574906 PDF 6,9 Mb 504 pages

http://rapidshare.de/files/9546706/GPowell.rar.html

Password: www.AvaxHome.ru

Oracle Interview Questions Free E-Book

2007-11-24T21:15:00.000+05:30

http://kthiru.port5.com/OracleV1.zip

High Performance Oracle (with source code)

2007-11-24T20:55:00.000+05:30

Author(s) : Geoff IngramPublisher : WileyYear : Sep 2002ISBN 10 : 0471224367ISBN 13 : 9780471224365Language : EnglishPages : 720File type : PDFSize : 2.6 MB (book + source code)

The purpose of this book is to help organizations deploy Oracle8i and Oracle9i (including Release 2) systems that meet the key end-user requirements of performance and availability at the same time. The ability to deliver on these twin requirements requires a holistic approach to the design and build of the end-to-end Oracle system, and this holistic approach is at the heart of this book. Too often, insufficient emphasis is given to components that are not related to the server. For example, consider a scenario where an Oracle end-user application uses a local configuration file (tnsnames.ora) to locate an Oracle database.If the database relocates to a new server one weekend, and the configuration file change is overlooked, end users won’t be able to connect on Monday morning. The database may as well be down. From the end-user perspective, it is. In the worst case, the outage could affect the organization’s bottom line. Appropriate network configuration, based on a centralized naming service, is a critical success factor for delivering availability. A similar emphasis is required on all aspects of the Oracle configuration, from initial installation to production support, in order to meet performance and availability requirements.This book is divided into six parts, which are intended to cover subjects in the order you might address them when setting up an Oracle configuration from scratch. In order to get the most out of the book, the best approach is to read it from cover to cover in sequential order. The detail is important, and a lack of attention to detail in all relevant areas of the technology is based on personal experience significant reason why Oracle systems don’t meet end-user performance and availability requirements.This book is intended for both DBAs and developers of all levels. In many ways, the term advanced in the Oracle world is something of a misnomer. The scope of what Oracle provides is very extensive: There’s a lot to know, but most of it is not especially complex. Anyone who understands Oracle fundamentals can understand and benefit from the contents of this book and Oracle’s own Concepts Guide is a great place to start. The challenge comes in deploying systems based on techniques that work from the many techniques available. This book sets out to provide a fast track to deploying systems with performance and availability built in.

http://rapidshare.com/files/62272665/hiperforac.rar

password:ganelon

SQL Functions Programmer's Reference

2007-11-24T20:53:00.000+05:30

Author(s) : Arie Jones, Ryan K. Stephens, Ronald R. Plew, Robert F. Garrett, Alex KriegelPublisher : WroxYear : Apr 2005ISBN 10 : 0764569015ISBN 13 : 9780764569012Language : EnglishPages : 790File type : PDFSize : 2.7 MB

This book is a complete SQL functions reference for all of the major RDBMS vendors in today’s market. The SQL implementations covered in this book include ANSI SQL, Oracle, Microsoft SQL Server, Sybase, IBM Universal Database (UDB) DB2, MySQL, and PostgreSQL. As a SQL programmer, you will find that there is a growing need to effectively use SQL functions, yet there are few resources to serve as an aid. You will also encounter the need to cross-reference different SQL implementations, at times having to integrate data between, say, Oracle and SQL Server.Migrations of data from one implementation to another is also very common in data warehousing environments, and as organizations make the commitment to go with another vendor’s relational database management system (RDBMS) to better support evolving business needs. This book is the necessary tool to facilitate expedient function referencing, cross-referencing between implementations, creating userdefined functions (UDFs), and providing tips and examples for applying the use of functions to real-world data-retrieval situations.This book is for the SQL programmer, and any software developer who has a need to effectively retrieve data from a relational database, or to integrate applications with RDBMS implementations. Database administrators and other database users will also discover great value. This book is for readers of all levels, and has been organized in an easy-to-understand format that allows quick search and reference. This book is packed with realistic examples, allowing the reader to immediately apply SQL functions concepts to the job at hand.Although the intent of this book is not to teach you SQL, the introductory chapters we have provided serve as an introduction to the world of SQL, explaining basic SQL concepts and describing how to use SQL to query a database, either with or without the use of functions. The trailing chapters of this book show numerous applications of SQL functions in the modern database world.

http://rapidshare.com/files/67119817/sqlfuncprogref.rar

password:ganelon

Oracle Dba Made Simple: Oracle Database Administration Techniques (Oracle In-Focus Series)

2007-11-24T20:49:00.000+05:30

Oracle Dba Made Simple: Oracle Database Administration Techniques (Oracle In-Focus Series) Mike Ault ISBN: 097407165X Publisher: Rampant Tech Press - 2003-08

http://rapidshare.com/files/38089491/Oracle_DBA_Made_Simple_Oracle_Database_Administration_Techniques.rar

Password: www.blueportal.org

OCP Instructors Guide for Oracle DBA Certification

2007-11-24T20:46:00.000+05:30

http://rapidshare.com/files/35146070/Rampant_TechPress_OCP_Instructors_Guide_for_Oracle_DBA_Certification_2003.rar

Password: www.blueportal.org

Oracle 9iAS Portal Bible

2007-11-24T13:42:00.000+05:30

This is your complete reference to Oracle Portal — the next generation release of Oracle WebDB, which provides a secure and manageable framework for delivering access to distributed software services and information resources.

Oracle9iAS Portal Bible shows you how to use Oracle Portal to build and deploy enterprise portals. Tthis book is for experienced Oracle users, developers, and database administrators looking for a more efficient means for delivering data to employees and customers over a web-based network. The book includes a complete and in-depth exploration of the various components of Oracle Portal and also shows you how to use the SiteBuilder component of Oracle Portal to create and manage Web sites. You’l learn how to create and deploy portlets and understand how to use the portlet API to extend the functionality of their components. Other topics covered in the book are integrating Oracle Portal’s functions with those of legacy applications; administering completed web applications using built-in management and performance monitoring functions; and creating, integrating, and customizing portlets.

http://www.mytempdir.com/277171

Oracle 10g - PowerPoint Tutorial Slides Part 1

2007-11-24T13:41:00.000+05:30

Oracle 10g Forms
Oracle 10g Reports
Oracle 10g SQL Fundamentals I
Oracle 10g SQL Fundamentals II
http://rapidshare.com/files/26183852/Oracle_10g_Forms__PPT_.rar
http://rapidshare.com/files/26185647/Oracle_10g_Reports__PPT_.rar
http://rapidshare.com/files/26186990/Oracle_10g_SQL_Fundamentals_I.rar
http://rapidshare.com/files/26181717/Oracle_10g_SQL_Fundamentals_II.rar

Password: www.flibrary.org

Oracle 10g - PowerPoint Tutorial Slides Part 2

2007-11-24T13:36:00.000+05:30

Oracle 10g Build J2EE Applications
Oracle Forms Developer 10g Build Internet Application
Oracle 10g Java Programming
Oracle JDeveloper 10g Build Applications with ADF
OracleAS Portal 10g Build Portlets with PLSQL

http://rapidshare.com/files/26216219/Oracle_10g_Build_J2EE_Applications.rar
http://rapidshare.com/files/26379280/Oracle_Forms_Developer_10g_Build_Internet_Application.rar
http://rapidshare.com/files/26380561/Oracle_10g_Java_Programming.rar
http://rapidshare.com/files/26381588/Oracle_JDeveloper_10g_Build_Applications_with_ADF.rar
http://rapidshare.com/files/26381749/OracleAS_Portal_10g_Build_Portlets_with_PLSQL.rar
Password www.flibrary.org

Oracle 10g - Powerpoint tutorial slides

2007-11-24T13:34:00.000+05:30

Inlcudes:
Fundamentals I
Fundamentals II
SQLPL/SQL
Forms Developer

http://rapidshare.de/files/14385353/Oracle_10g_PPTs.rar

Oracle 9i PowerPoint Slides

2007-11-24T13:25:00.000+05:30

Develop Applications with BC4J
Oracle9i Access the DB with Java
Oracle9i AS Portal Build Corporate Portals
Oracle9i AS Portal Build Portlets with Java
Oracle9i Develop Applications with Enterprise JavaBeans

http://rapidshare.com/files/28187462/Develop_Applications_with_BC4J.rar
http://rapidshare.com/files/28187844/Oracle9i_Access_the_DB_with_Java.rar
http://rapidshare.com/files/28189353/Oracle9i_AS_Portal_Build_Corporate_Portals.rar
http://rapidshare.com/files/28191265/Oracle9i_AS_Portal_Build_Portlets_with_Java.rar
http://rapidshare.com/files/28193143/Oracle9i_Develop_Applications_with_Enterprise_JavaBeans.rar

Password: www.flibrary.org

Oracle 10g Release 3 Enterprise Manager Advanced Configuration

2007-11-24T13:22:00.002+05:30

ISBN B40002-02 Release date Feb 2007 Language English PDF 3.2Mb

http://rapidshare.com/files/64067819/Oracle10gAdvancedConfiguration.rar

Oracle 10g Advanced Replication

2007-11-24T13:22:00.001+05:30

ISBN B1422601 Release date Jun 2005 Language English PDF 2.2Mb

http://rapidshare.com/files/67257528/Oracle_10g_Advanced_Replication_by_fantoom121.rar

Oracle 10g Workflow Administrator's Guide

2007-11-24T13:21:00.000+05:30

ISBN B1585202 Release date Jun 2005 Language English PDF 1.9Mb

http://rapidshare.com/files/65037610/Oracle_10g_Workflow_Administrator_s_Guide.rar

http://rapidshare.com/files/65037610/Oracle_10g_Workflow_Administrator_s_Guide.rar

Oracle 10g Release 2 Data Mining Administrator's Guide

2007-11-24T13:20:00.000+05:30

Oracle 10g Release 2 Data Mining Administrator's Guide + Application Developer's Guide
ISBN B14338-02 Release date Nov 2005 Language English PDF 1.5Mb

http://rapidshare.com/files/64069029/Oracle10gDMGuide.rar

Learn Oracle Database 10g Database

2007-11-24T13:16:00.000+05:30

Overview/Description:
To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces
Target Audience:
Anyone wanting to learn about Oracle Database 10g database administrationPrerequisites:An understanding of database concepts and technologies
Objectives:
identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus. recognize how to use the DESCRIBE, PROMPT, and SELECT commands to work with data. recognize how to join tables and use DML and DDL statements to manipulate and define data. identify the functions of different SQL statements and recognize the function of data locking. identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus. use SQL*Plus and iSQL*Plus to manage data. identify the basic elements of PL/SQL and recognize the uses of PL/SQL. identify the characteristics of some common database interfaces. identify how Oracle works with common database interfaces.

http://rapidshare.com/files/56831055/SkillSoft.Oracle.Database.10g.Database.Interfaces.Release.2-LiB.rar

Oracle Database Foundations

2007-11-24T13:12:00.001+05:30

http://www2.fixdown.com/soft/22281.asp

Oracle Study Materials Collection

2007-11-24T13:10:00.000+05:30

http://www.4shared.com/dir/1158110/64bb0e7b/sharing.html

Practice Tests - Oracle DBA

2007-11-24T13:05:00.000+05:30

Oracle DBA Practice Tests v5.63
http://rapidshare.de/files/27819389/23443359629.zip
9.32 MB
Oracle DBA Practice Tests v5.63
http://rapidshare.de/files/27819375/2343041597.zip
6.50 MB
Oracle DBA Practice Tests v5.53
http://rapidshare.de/files/27819401/2340654273.zip
6.41 MB
Oracle DBA Practice Tests v5.35
http://rapidshare.de/files/27819461/23361074651.zip
8.33 MB
Oracle DBA Practice Tests v5.34
http://rapidshare.de/files/27819492/23351112229.zip
8.45 MB

OCP.Oracle.10g.Administration.II.Study.Guide

2007-11-24T13:03:00.000+05:30

Here's the book you need to prepare for the Oracle Database 10g Administration II exam, 1Z0-043. 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 advanced 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 flashcardsYou'll also find authoritative coverage of key exam topics, including:* Configuring Recovery Manager* Understanding the Flashback Database* Recovering from User Errors* Working with Globalization Support* Using the Scheduler to Automate Tasks* Monitoring and Managing Storage* Securing the Oracle ListenerLook to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace.

http://www1.vista-server.com/uploadfile/6/5/26/10233682417.zip
http://www2.vista-server.com/uploadfile/6/5/26/10233682417.zip
http://www3.vista-server.com/uploadfile/6/5/26/10233682417.zip

OCA: Oracle 10g Administration I Study Guide

2007-11-24T12:45:00.000+05:30

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 flashcardsYou'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

http://rapidshare.com/files/6870931/N0782143679.rar

Practice Exams - ORACLE

2007-11-24T12:39:00.000+05:30

Oracle 10g DataPump

2007-11-24T12:34:00.000+05:30

http://rapidshare.de/files/8141761/DataPump.pdf.html

actualtests Oracle 1z0-023, 1z0-025, 1z0-101

2007-11-24T12:09:00.000+05:30

http://rapidshare.de/files/14624355/Actualtests.Oracle.1Z0-023.Exam.Q.and.A.03.01.06-DDU.rar.html

http://rapidshare.de/files/14624374/Actualtests.Oracle.1Z0-025.Exam.Q.and.A.03.02.06-DDU.rar.html

http://rapidshare.de/files/14624389/Actualtests.Oracle.1Z0-101.Exam.Q.and.A.03.02.06-DDU.rar.html

Oracle Wait Interface A Practical Guide to Performance Diagnostics and Tuning

2007-11-20T23:02:00.000+05:30

Oracle Wait Interface A Practical Guide to Performance Diagnostics and Tuning Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time. This book explains how to take full advantage of the revolutionary Oracle Wait Interface to quickly pinpoint--and solve--core problems and bottlenecks, and incr

http://www.oebook.com/%7BCC6E3B16-8EFE-485F-BCBF-8A2AF0192886%7D.htm

JDBC Metadata, MySQL, and Oracle Recipes: A Problem-Solution Approach

2007-11-20T23:01:00.000+05:30

JDBC Metadata, MySQL, and Oracle Recipes is the only book that focuses on metadata or annotation-based code recipes for JDBC API for use with Oracle and MySQL. It continues where the author’s other book, JDBC Recipes: A Problem-Solution Approach, leaves off.This new edition is also a Java EE 5-compliant book, perfect for lightweight Java database development. And it provides cut-and-paste code templates that can be immediately customized and applied in each developer’s application development.

http://rapidshare.de/files/28510896/Apress.JDBC.Metadata.MySQL.and.Oracle.Recipes.A.Problem.Solution.Approach.Mar.2006.eBook-BBL.rar.html

Password: ebooksatkoobe

R11i Extend Oracle Applications Forms Volume 1 Student Guide

2007-11-20T23:00:00.000+05:30

http://www.megaupload.com/?d=6Q8HS91A

Oracle Database 10g High Availability with RAC, Flashback, and Data Guard

2007-11-20T22:59:00.001+05:30

Oracle Database 10g High Availability with RAC, Flashback, and Data GuardMcGraw-Hill Osborne Media; 1 edition ISBN: 0072254289 496 pages April 21, 2004 CHM

Attain real solutions for current availability challenges. Based on a "DBA-centric" approach to High Availability, Oracle Database 10g High Availability concentrates on explaining Oracle Database 10g technologies and practices to database administrators, covering general availability, real application clusters (RAC), disaster planning and recovery, and distributed database solutions. Hardware and application needs are also taken into account. While Oracle Database 10g is the main focus, many of the options discussed are available in earlier database releases. Organized to provide conceptual understanding of High Availability, included are "HA Workshops," step-by-step instructions to get you through certain implementations, plus real-world inspired case studies.

http://ebook.icefile.org/index.php?page=main&id=85cbd742&name=0072254289.rar

http://rapidshare.com/files/21582517/0072254289.rar

Oracle Database 10g XML&SQL: Design,Build, & Manage XML Applications in Java, C,C ,& PL/SQL

2007-11-20T22:57:00.000+05:30

Written by members of the Oracle XML group, this is a must-have reference for all IT managers, DBAs, and developers who want to learn the best practices for using XML with Oracleâ€™s XML-enabled products.Â Includes real-world case studies based on the authorsâ€™ experience managing Oracleâ€™s XML Discussion Forum–a community of 20,000+ XML component users.

http://ebook.icefile.org/index.php?page=main&id=de15e926&name=0072229527.rar

http://rapidshare.com/files/12848168/Oracle_20-_20Oracle_20SQL_20Tuning_20Pocket.pdf

2007-11-20T22:56:00.000+05:30

http://www.mytempdir.com/277171

Oracle SQL Tuning Pocket Reference by Mark Gurry

2007-11-20T22:54:00.002+05:30

Oracle SQL Tuning Pocket Reference by Mark GurryPublisher: O'Reilly Media; Pocket edition (November 15, 2001) ISBN-10: 0596002688 PDF 1 Mb 112 pages

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time. SQL statements that perform poorly result in frustration for users, and can even prevent a company from serving its customers in a timely manner. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. Mark also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. In addition to the specific problem/solution scenarios for the optimizers, Mark provides a number of handy SQL tuning tips. He discusses the various optimizer hints, telling you when they can be used to good effect. Finally, Mark discusses the use of the DBMS_STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify.

http://depositfiles.com/files/549721

http://rapidshare.com/files/12848168/Oracle_20-_20Oracle_20SQL_20Tuning_20Pocket.pdf

OReilly - Perl for Oracle DBAs ISBN 0596002106

2007-11-20T22:54:00.001+05:30

http://rapidshare.de/files/3975676/OReilly_-_Perl_For_Oracle_DBAs.chm.html

Oracle Database 10g XML and SQL Design Build and Manage XML Applications

2007-11-20T22:53:00.000+05:30

http://rapidshare.de/files/15959925/Ora10gXMLSQL.rar.html

Oracle 10g Release 3 Enterprise Manager Advanced Configuration

2007-11-20T22:51:00.000+05:30

Oracle 10g Release 3 Enterprise Manager Advanced ConfigurationISBN B40002-02 Release date Feb 2007 Language English PDF 3.2Mb

http://rapidshare.com/files/64067819/Oracle10gAdvancedConfiguration.rar

Oracle Data Warehousing and Business Intelligence Solutions

2007-11-20T22:50:00.000+05:30

Publisher: WileyLanguage: EnglishISBN: 0471919217Paperback: 386 pagesData: January 10, 2007Format: PDF
Description: Up-to-date, comprehensive coverage of the Oracle database and business intelligence tools Written by a team of Oracle insiders, this authoritative book provides you with the most current coverage of the Oracle data warehousing platform as well as the full suite of business intelligence tools. You'll learn how to leverage Oracle features and how those features can be used to provide solutions to a variety of needs and demands. Plus, you'll get valuable tips and insight based on the authors' real-world experiences and their own implementations. Avoid many common pitfalls while learning best practices for:* Leveraging Oracle technologies to design, build, and manage data warehouses * Integrating specific database and business intelligence solutions from other vendors * Using the new suite of Oracle business intelligence tools to analyze data for marketing, sales, and more * Handling typical data warehouse performance challenges * Uncovering initiatives by your business community, security business sponsorship, project staffing, and managing risk

http://ebook.icefile.org/index.php?page=main&id=0d2bd952&name=0471919217.rar

Oracle Application Server 10g: J2EE Deployment and Administration

2007-11-20T22:47:00.000+05:30

Oracle Application Server 10g: J2EE Deployment and Administration focuses on the la version of Oracle’s fully J2EE-certified application server (previously called Oracle9iAS). Oracle Corp. is aggressively attacking this market with a new lost-cost version of the server, as well as a program to move BEA customers onto Oracle free of charge. Adoption interest is growing rapidly amidst favorable reports regarding performance and reliability.
Deploying and configuring J2EE applications are some of the trickiest processes in J2EE development, and they unfortunately receive scant attention in general J2EE texts. This book is a focused, no-frills guide to getting J2EE applications up and running on 10g. It covers Oracle’s J2EE container, OC4J (available free of charge for development purposes), in full detail. It moves on to explain how to best configure and use the various enterprise-level features that come with the commercial editions. This is the book for anyone wanting to stay ahead in the world of Oracleâ€™s application servers.

http://rapidshare.de/files/24140955/Apress.Oracle.Application.Server.10g.J2EE.ebook-Spy.rar.html

Password: ebooksatkoobe

Oracle Regular Expressions Pocket Reference

2007-11-20T22:45:00.000+05:30

Publisher: O'Reilly Media, Inc.; 1 editionLanguage: englishISBN: 0596006012Paperback: 64 pagesData: September 5, 2003Format: CHM

Description: Support for regular expressions in SQL and PL/SQL is one of the most exciting features of Oracle Database 10G. Oracle has long supported the ANSI-standard LIKE predicate for rudimentary pattern matching, but regular expressions take pattern matching to a new level. They provide a powerful way to select data that matches a pattern, as well as to manipulate, rearrange, and change that data. This concise pocket guide is part tutorial and part quick-reference. It's suitable for those who have never used regular expressions before, as well as those who have experience with Perl and other languages supporting regular expressions. The book describes Oracle Database 10G's support for regular expressions, including globalization support and differences between Perl's syntax and the POSIX syntax supported by Oracle 10G. It also provides a comprehensive reference, including examples, to all supported regular expression operators, functions, and error messages. O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. Whether you're using regular expressions for the first time or applying your skills from other languages to the latest version of Oracle, the Oracle Regular Expressions Pocket Reference is the book to have close by.

http://www.icefile.info/index.php?page=main&id=1db60835&name=0596006012.rar

NETg Oracle Database 10g Administration Workshop 1 & 2

2007-11-20T22:43:00.000+05:30

Learn To:
Match goals of Oracle Database 10g manageability features with the methods of achieving them.
Identify features of the Oracle Database 10g manageability strategy.
Identify globalization support features provided by Oracle Database 10g.
Identify features of different encoding schemes supported by Oracle Database 10g.
Distinguish between features of the database and national character sets used in Oracle Database 10g.
Identify listener security features in Oracle Database 10g.
Sequence the steps to set the listener password by using Enterprise Manager (EM).
Identify steps to set the listener password by using Net Manager.
Identify features of the RMAN.
Match various RMAN components with their features.
Identify features of RMAN media management.

http://rapidshare.com/files/14591693/dngor10.part01.rar
http://rapidshare.com/files/14594064/dngor10.part02.rar
http://rapidshare.com/files/14596398/dngor10.part03.rar
http://rapidshare.com/files/14599671/dngor10.part04.rar
http://rapidshare.com/files/14601940/dngor10.part05.rar
http://rapidshare.com/files/14604236/dngor10.part06.rar
http://rapidshare.com/files/14627921/dngor10.part07.rar
http://rapidshare.com/files/14607720/dngor10.part08.rar
http://rapidshare.com/files/14630680/dngor10.part09.rar
http://rapidshare.com/files/14613161/dngor10.part10.rar
http://rapidshare.com/files/14614822/dngor10.part11.rar
Password: www.flibrary.org

Oracle technical reference manual - Purchase

2007-11-20T22:41:00.001+05:30

http://rapidshare.de/files/7743886/potrm.pdf.html

Effective Oracle Database 10g Security By Design

2007-11-20T22:38:00.000+05:30

Oracle expert David Knox has written the most practical, up-to-date book on Oracle Database 10g security available. With an emphasis on real-world problems and detailed solutions, Effective Oracle Database 10g Security By Design provides all the information you need to develop and deploy secure database applications. The entire security cycle is covered -- from identification and authentication to fine-grained access control and encryption to effective auditing techniques.

Book Info:Published in 2004Published by McGraw-HillAuthor David KnoxISBN 0072231300 Size 3.00MB

http://www.team509.com/download/docs/security/WEB/Oracle Press - 0072231300 - Effective Oracle Database 10g Security by Design - fly.chm

Tuning.Third-party.Vendor.Oracle.Systems

2007-11-20T22:37:00.000+05:30

http://www1.vista-server.com/uploadfile/6/4/29/1012446494.zip

http://www2.vista-server.com/uploadfile/6/4/29/1012446494.zip

http://www3.vista-server.com/uploadfile/6/4/29/1012446494.zip

Oracle PL/SQL Built-ins Pocket Reference

2007-11-20T22:34:00.000+05:30

This pocket reference provides quick-reference information that will help you use Oracle Corporation’s extensive set of built-in functions and packages, including those new to Oracle8.Oracle’s PL/SQL language is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of Oracle development tools. Among the most useful constructs in the PL/SQL language are the built-in functions and packages. Built-in functions are constructs

http://www.mytempdir.com/446058

Oracle 10g RAC Grid, Services & Clustering

2007-11-20T22:31:00.000+05:30

Publisher: Digital PressLanguage: EnglishISBN: 1555583210Paperback: 670 pagesData: May 2006Format: PDF

Description: Grid architecture is Oracles strategy for high-end computing and RAC is the stepping stone into this arena. This book focuses on current technology including all valid RAC features up through Oracle Database 10g Release 2, with a primary focus on deploying it in a high-end grid environment. The book discusses this technology at length which users will find beneficial when researching, implementing or monitoring a RAC environment. The author covers workshop implementation of services and the distribution of workload across instances, with threshold definitions and the new load balancing algorithms. In addition it includes detailed discussions on ASM that complements the implementation of RAC in Oracle Grid strategy. The book also includes discussions on new Oracle Clusterware, its components and its integration with RAC.

http://rapidshare.com/files/56831116/Oracle.10g.RAC.GSC.May.2006.eBook-Spy.rar

Oracle Application Server 10g Essentials

2007-11-20T22:29:00.002+05:30

The new Oracle Application Server offers a wide range of functionality, including Java runtime and development tools, portal development tools, business intelligence, single sign-on identify management, and much more. It's so powerful and complex, in fact

http://www.oebook.com/%7BF5A779A7-5A1D-4BFA-BB1C-C05F6AF0EE6C%7D.htm

Oracle Application Server 10g Web Development

2007-11-20T22:29:00.001+05:30

Develop flexible, cross-platform Web applications using Oracle Application Server 10g and this exclusive Oracle Press guide. Take advantage of the full support for all major Web development languages, APIs, and frameworks and learn to create and test applications quickly, interface with the Oracle database seamlessly, and deploy your applications to the Web securely.Inside you will find full details on J2EE integration, Oracle Forms 10g, Oracle Reports 10g, OracleAS Discoverer 10g, OracleAS Portal, and Oracle JDeveloper 10g.

http://rapidshare.com/files/44247181/Oracle_Application_Server_10G_Web_Development_-_Fly.rar

Password: www.bluelibrary.org

OCP: Oracle 10g Administration II Study Guide

2007-11-20T22:27:00.000+05:30

Published in 2005
Author Doug Stuns
ISBN 0782143687
Size 8.09MB

http://rapidshare.de/files/19340960/0782143687.zip

Oracle High Performance Tuning For 9i And 10g

2007-11-20T22:21:00.000+05:30

http://lab.lpicn.org/pub/books/Digital Press - Oracle High Performance Tuning for 9i and 10g.chm

Oracle to DB2 Udb Conversion Guide

2007-11-20T22:20:00.000+05:30

http://www.mytempdir.com/274794

Forecasting Oracle Performance

2007-11-20T22:19:00.000+05:30

Publisher: ApressLanguage: EnglishISBN: 1590598024Paperback: 269 pagesData: Apr 2007Format: PDF

Description:

What makes seasoned IT professionals run for cover? Answer: Forecasting Oracle performance! Craig Shallahamer is an Oracle performance expert with over 18 years of experience. His book is the first to focus, not on the problem of solving today’s problem, but squarely on the problem of forecasting the future performance of an Oracle database. Other Oracle performance books are good for putting out fires; Craig’s book helps you avoid all the heat in the first place.
Application over mathematical proofs��If you��re an IT practioner who appreciates application over mathematical proofs than you��ll be pleasantly surprised! Each chapter is filled with examples to transform the theory, mathematics, and methods into something you can practically apply. Craig’s goal is to teach you about real-word Oracle performance forecasting. Period. There is no hidden agenda.
A practical and hands-on training course in a book��This book is a kind of training course. After reading, studying, and practicing the material covered in this book, you to be able to confidently, responsibly, and professionally forecast performance and system capacity in a wide variety of real-life situations.

http://rapidshare.com/files/51619972/Apress.Forecasting.Oracle.Performance.Apr.2007.eBook-BBL.rar

http://rapidshare.com/files/51713118/1590598024.rar

Oracle migration workbench

2007-11-20T22:18:00.000+05:30

http://rapidshare.de/files/7717820/Oracle_Press_-_Oracle_Migration_Workbench__2002.rar.html

Oracle WebDB Bible

2007-11-20T22:17:00.000+05:30

Oracle’s new run-anywhere browser-based tool delivers everything you need to deploy powerful database applications over the Internet. And this authoritative reference delivers everything you need to master the complete capabilities of WebDB — database browsing, application development, component management, performance monitoring, even constructing entire Web sites with SiteBuilder. Written by two veteran database applications developers who were key contributors to the WebDB beta program, this encyclopedic guide will help you extend the rich functionality of WebDB — and realize the full potential of your Web site. (22450)
Download:
http://tinyurl.com/k4dsc

Oracle Dba Survival Guide

2007-11-20T22:16:00.000+05:30

http://tinyurl.com/ns4te

Enterprise Reports with Oracle

2007-11-20T22:14:00.000+05:30

http://rapidshare.de/files/7312179/Reports.pdf.html

CBT Nuggets Oracle 9i/10g OCA Series

2007-11-20T22:13:00.000+05:30

http://rapidshare.com/files/64117644/CB-T-N-Or9I-10G.part1.rar
http://rapidshare.com/files/64117688/CB-T-N-Or9I-10G.part2.rar
http://rapidshare.com/files/64117700/CB-T-N-Or9I-10G.part3.rar
http://rapidshare.com/files/64118027/CB-T-N-Or9I-10G.part4.rar
http://rapidshare.com/files/64117702/CB-T-N-Or9I-10G.part5.rar
http://rapidshare.com/files/64075417/CB-T-N-Or9I-10G.part6.rar

Oracle dba-the Complete Video Course

2007-11-20T22:10:00.000+05:30

ORACLE 1Z0301 EXAMCHEATSHEET.V5.06.04

2007-11-20T22:09:00.000+05:30

Oracle9iAS: Basic Administrations

http://www1.vista-server.com/uploadfile/6/6/25/2244073374.zip

http://www2.vista-server.com/uploadfile/6/6/25/2244073374.zip

http://www3.vista-server.com/uploadfile/6/6/25/2244073374.zip

Oracle DBA Made Simple: Oracle Database Administration Techniques

2007-11-20T22:05:00.000+05:30

Written by one the world's top Oracle script developers and author of 14 best-selling Oracle books, Mike Ault targets his substantial knowledge of Oracle tuning in this concise eBook. With decades of experience using Oracle, Mike Ault shares secrets for O

http://www.oebook.com/%7BB83954F2-641E-4081-A779-B83998095024%7D.htm

Oracle 10g Workflow Administrator's Guide

2007-11-20T22:04:00.000+05:30

Oracle 10g Workflow Administrator's GuideISBN B1585202 Release date Jun 2005 Language English PDF 1.9Mb

http://rapidshare.com/files/65037610/Oracle_10g_Workflow_Administrator_s_Guide.rar

Oracle PL SQL for DBAs

2007-11-20T22:02:00.000+05:30

PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take inc

http://www.oebook.com/%7B18F96781-933F-4DF2-B94C-D76A1066307B%7D.htm

Oreilly Oracle PL/SQL Best Practices

2007-11-20T22:00:00.001+05:30

http://www.ihelpers.co.kr/programming/reference/Oreilly-Oracle.PLSQL.Best.Practices.pdf

actualtests Oracle 1z0-023, 1z0-025, 1z0-101

2007-11-20T21:56:00.000+05:30

Actualtests.Oracle.1Z0-023.Exam.Q.and.A.03.01.06-DDU.rar
Actualtests.Oracle.1Z0-025.Exam.Q.and.A.03.02.06-DDU.rar
Actualtests.Oracle.1Z0-101.Exam.Q.and.A.03.02.06-DDU.rar

http://rapidshare.de/files/14624355/Actualtests.Oracle.1Z0-023.Exam.Q.and.A.03.01.06-DDU.rar.html

http://rapidshare.de/files/14624374/Actualtests.Oracle.1Z0-025.Exam.Q.and.A.03.02.06-DDU.rar.html

http://rapidshare.de/files/14624389/Actualtests.Oracle.1Z0-101.Exam.Q.and.A.03.02.06-DDU.rar.html

Using the Oracle oradebug Utility Debugging Oracle ApplicationsUsing the Oracle oradebug Utility Debugging Oracle Applications

2007-11-20T21:55:00.000+05:30

Using the Oracle oradebug Utility Debugging Oracle Applications Written by one the world's most widely-read Oracle script developers and author of 14 best-selling Oracle books, Mike Ault targets his substantial knowledge of Oracle tuning in this concise eBook. With decades of experience using Oracle, Mike Ault shares

http://www.oebook.com/%7BFA0006FB-181C-49E3-8226-552A5E238D57%7D.htm

Oracle University Oracle Database 10g Administration Workshop 1

2007-11-20T21:53:00.000+05:30

This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam.This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification and Knowledge Center courses DO NOT meet the Hands-on Requirement.Learn To:* Install the Database* Back up and Recover Data* Administer Users* Transport Data between Databases* Manage Data* Configure the Network.

http://rapidshare.com/files/39866769/10g.rar

R11i Extend Oracle Applications Forms Volume 2 Student Guide

2007-11-19T22:56:00.001+05:30

http://www.megaupload.com/?d=ZKFHHXKD

Netg Oracle Applications Release 11i

2007-11-19T22:49:00.000+05:30

Description and objective: The Complete Oracle Applications Release 11i Curriculum is a comprehensive series designed to teach Information System professionals how to use the features of Oracle Applications Release 11i. In this curriculum, students learn to navigate within any of the application modules in the Oracle Applications Release 11i forms. The student is introduced to the architecture and advanced notification components of Oracle Workflow 2.5 and to different types of FlexFields and their various uses, components, and benefits. The student is taught about the Oracle Internet Procurement Suite which enables internal corporate users to independently order items from both internal and external catalogs. This curriculum also provides users with an overview of the order management module of Oracle Applications 11i. It specifically familiarizes users with booking orders and managing customers and orders. In addition, the curriculum teaches students how to set up and use Oracle General Ledger (OGL), enter journal entries, develop budgets, manage transactions between multiple companies, and prepare financial reports.This curriculum consists of 13 Skillbuilder courses: 64101 Oracle Applications Release 11i: Navigation 64102 Oracle Applications Release 11i: Workflow - Part 1 64104 Oracle Applications Release 11i: System Administration 64105 Oracle Applications Release 11i: Workflow - Part 2 64106 Oracle Applications 11i Procure to Pay: Procurement Management 64107 Oracle Applications 11i Procure to Pay: Supplier Management and Payments 64109 Oracle Applications 11i Order to Cash: Pricing 64110 Oracle Applications 11i Order to Cash: Picking and Shipping 64111 Oracle Applications 11i General Ledger: Set Up 64112 Oracle Applications 11i General Ledger: Transactions 64113 Oracle Applications 11i General Ledger: Advanced Features 64114 Oracle Applications 11i General Ledger: Reporting and Analysis 64115 Oracle Applications 11i General Ledger: Currencies and Multicompany Accounting

http://rapidshare.com/files/16423057/NG_Oracle11i.part01.rar

http://rapidshare.com/files/16429062/NG_Oracle11i.part02.rar

http://rapidshare.com/files/16536374/NG_Oracle11i.part03.rar

http://rapidshare.com/files/16540644/NG_Oracle11i.part04.rar

http://rapidshare.com/files/16540644/NG_Oracle11i.part04.rar

http://rapidshare.com/files/16557244/NG_Oracle11i.part05.rar

http://rapidshare.com/files/16660776/NG_Oracle11i.part06.rar

http://rapidshare.com/files/16666051/NG_Oracle11i.part07.rar

http://rapidshare.com/files/16670421/NG_Oracle11i.part08.rar

http://rapidshare.com/files/16674240/NG_Oracle11i.part09.rar

http://rapidshare.com/files/16677733/NG_Oracle11i.part10.rar

http://rapidshare.com/files/16655078/NG_Oracle11i.part11.rar

http://rapidshare.com/files/16578662/NG_Oracle11i.part12.rar

http://rapidshare.com/files/16532544/NG_Oracle11i.part13.rar

Password: www.flibrary.org

Oracle DBA Scripting Quick Reference

2007-11-19T22:48:00.001+05:30

http://www.oebook.com/%7B3024DE95-2FB7-49BF-A80A-8A0856AB6FAB%7D.htm

Oracle Univeristy Ebooks

2007-11-19T22:44:00.000+05:30

Oracle Designer Systems Modeling.

Oracle Designer 6i Server Design and Generation

Oracle 9i Designer:First Class

http://rapidshare.com/files/44016315/Oracle_Designer_Systems_Modeling.rar
http://rapidshare.com/files/44017276/OracleDesigner6iServerDesignandGeneration1.rar
http://rapidshare.com/files/44018883/OracleDesigner6iServerDesignandGeneration2.rar
http://rapidshare.com/files/44020263/Oracle_iDS_Designer_First_Class.rar

Password for all files: www.bluelibrary.org

Oracle Security And Auditing

2007-11-19T22:38:00.002+05:30

http://www.megaupload.com/?d=4RLNX03N

Oracle Storage Management

2007-11-19T22:38:00.001+05:30

http://rapidshare.de/files/7476942/asmwp.pdf.html

Oracle 10g Webservices Ebook

2007-11-19T22:37:00.000+05:30

http://rapidshare.de/files/7341599/installOra10gWSA.pdf.html

Scott W. Ambler, Pramodkumar J. Sadalage, «Refactoring Databases: Evolutionary Database Design»

2007-11-19T22:35:00.000+05:30

Scott W. Ambler, Pramodkumar J. Sadalage, «Refactoring Databases: Evolutionary Database Design»Addison-Wesley Professional ISBN 0321293533 2006 Year CHM 3,36 Mb 384 Pages
“
Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems.Ambler and Sadalage demonstrate how small changes to table structures, data, stored procedures, and triggers can significantly enhance virtually any database design–without changing semantics. You’ll learn how to evolve database schemas in step with source code–and become far more effective in projects relying on iterative, agile methodologies.This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You’ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments. The second half of this book systematically covers five major categories of database refactorings. You’ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or VB.NET, and other databases, such as DB2, SQL Server, MySQL, and Sybase.Using this book’s techniques and examples, you can reduce waste, rework, risk, and cost–and build database systems capable of evolving smoothly, far into the future.

http://rapidshare.de/files/36488027/SWAmbler.rar.html

http://depositfiles.com/files/312550

Backup & Recovery by W. Curtis Preston

2007-11-19T22:28:00.000+05:30

Backup & Recovery by W. Curtis PrestonPublisher: O'Reilly Media (December 1, 2006) ISBN-10: 0596102461 CHM 3 Mb 760 pages

Packed with practical, freely-available backup and recovery solutions for Unix, Linux, Windows and Mac OS X systems -- as well as various databases -- this new guide is a complete overhaul of Unix Backup & Recovery by the same author, now revised and expanded with over 75% new material. Backup & Recovery starts with a complete overview of backup philosophy and design, including the basic backup utilities of tar, dump, cpio, ntbackup, ditto, and rsync. It then explains several open source backup products that automate backups using those utilities, including AMANDA, Bacula, BackupPC, rdiff-backup, and rsnapshot. Backup & Recovery then explains how to perform bare metal recovery of AIX, HP-UX, Linux, Mac OS, Solaris, VMWare, & Windows systems using freely-available utilities. The book also provides overviews of the current state of the commercial backup software and hardware market, including overviews of CDP, Data De-duplication, D2D2T, and VTL technology. Finally, it covers how to automate the backups of DB2, Exchange, MySQL, Oracle, PostgreSQL, SQL-Server, and Sybase databases - without purchasing a commercial backup product to do so. For environments of all sizes and budgets, this unique book shows you how to ensure data protection without resorting to expensive commercial solutions. You will soon learn to:— Automate the backup of popular databases without a commercial utility — Perform bare metal recovery of any popular open systems platform, including your PC or laptop — Utilize valuable but often unknown open source backup products — Understand the state of commercial backup software, including explanations of CDP and data de-duplication software — Access the current state of backup hardware, including Virtual Tape Libraries (VTLs)

http://depositfiles.com/files/518466

http://rapidshare.com/files/11240581/OReilly.BR.rar

Oracle 11i E-Business Suite From the Front Lines

2007-11-19T22:23:00.000+05:30

http://www.megaupload.com/?d=15DJCA0P
Password=http://blueportal.org

Gavin Powell, «Beginning XML Databases»

2007-11-19T22:12:00.000+05:30

Publisher: Wrox Press Nov 2006 ISBN: 0471791202 Pages: 490 Format: CHM Size: 22.1 MB

The union of XML and relational databases creates a powerful tool with the ability to transfer information between two completely unrelated databases. With this book, veteran author Gavin Powell shows you how this confluence of two technologies can simplify your database work and provide a more standardized way to exchange data between multiple databases and web sites.You'll get an in-depth look at specific XML datatypes that are considered the most critical alliances between XML and a relational database. Plus, an introduction to the basics of SQL and numerous XML standards prove to be essential so that you can grasp database structure and comprehend how XML is used with the Oracle and SQL Server relational databases. Throughout the book, valuable exercises and a surfeit of step-by-step examples will help you get an overall understanding of the topics at hand.What you will learn from this bookThe platform independence capability that comes from using XML— including independence from database vendorsThe basics of XML, XSL, the XML DOM, and SQLXML datatypes and features in Oracle Database and SQL ServerHow to move data anywhere using XML (B2B)Ways to read XML documents using XQuery and navigate documents using XPathXML, the object data model, native XML databases, and industry applications of XMLWho this book is forThis book is for anyone—from novice to expert—who is interested in learning the details of XML and database technology as applied to both XML and relational database technology, working together.
http://fileho.com/download/f659a1341515/Wrox.Beginning.XML.Databases.ebook-Spy.chm.html

http://depositfiles.com/files/508573

http://rapidshare.com/files/10737931/0471791202.rar

Beginning PL/SQL: From Novice to Professional

2007-11-19T22:10:00.000+05:30

Donald Bales , "Beginning PL/SQL: From Novice to Professional "Apress (August 24, 2007) ISBN: 1590598822 476 pages PDF 5,5 Mb

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales' extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features. Author Don Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule -- cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.Discover the 20% of PL/SQL that gives you 80% of the bang--key topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.Learn how to write production-level, object-oriented PL/SQL--you'll explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQL's object-oriented features as well.Work through real examples of using of PL/SQL--you'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.What you'll learnHow important SQL is in PL/SQLHow to use PL/SQL in both a relational and object-relational settingHow to create maintainable, modular, and reusable PL/SQL program unitsThe importance of testing as you go, and of building a permanent test plan for each moduleThe importance of building debugging capabilities into your code and building a permanent debug facility for each moduleThe importance of documenting as you go, and in the process building a permanent documentation set for your reusable modulesHow to apply modular PL/SQL to solve real-world problemsWho is this book for?Anyone who wants to learn how to create stored procedures against an Oracle database using PL/SQL. Programmers developing applications to be deployed against an Oracle database will need PL/SQL to take full advantage of the power Oracle has to offer. Database administrators who wish to implement functionality exposed only via PL/SQL package interfaces will also find this book useful.
http://depositfiles.com/files/2175989

http://rapidshare.com/files/65486766/Beginning_PLSQL_From_Novice_to_Professional_with_SOURCE_CODE-1590598822.rar

Oracle9iR2 Data Warehousing

2007-11-19T22:05:00.000+05:30

Oracle9iR2 Data WarehousingDigital Press ISBN: 1555582877 519 pages February 6, 2003 CHM 17 Mb"By using Oracle 9i, pre-summarizing data, and storing it in materialized views, reports that used to take 2 hours to run now complete in 2 minutes."

http://ebook.icefile.org/index.php?page=main&id=0c83a412&name=1555582877.rar

SQL Hacks [ILLUSTRATED]

2007-11-19T22:02:00.000+05:30

SQL Hacks386 pages O'Reilly Media (November 2006) English 0596527993 2.0 MB

Book Description

Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. The book offers 100 hacks -- unique tips and tools -- that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems. Learn how to:* Wrangle data in the most efficient way possible* Aggregate and organize your data for meaningful and accurate reporting* Make the most of subqueries, joins, and unions* Stay on top of the performance of your queries and the server that runs them* Avoid common SQL security pitfalls, including the dreaded SQL injection attackLet SQL Hacks serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and SQL Hacks is the must-have book for you.Why SQL Hacks?The term hacking has a bad reputation in the press. They use it to refer to people who break into systems or wreak havoc with computers as their weapon. Among people who write code, though, the term hack refers to a "quick-and-dirty" solution to a problem, or a clever way to get something done. And the term hacker is taken very much as a compliment, referring to someone as being creative, having the technical chops to get things done. The Hacks series is an attempt to reclaim the word, document the good ways people are hacking, and pass the hacker ethic of creative participation on to the uninitiated. Seeing how others approach systems and problems is often the quickest way to learn about a new technology. This book is a collection of 100 different hacks. Each hack involves a specific problem that you may have already seen before, but perhaps tackled in a way you wouldn't have considered. The hacks range from solving simple, everyday problems, all the way to tackling complex data processing scenarios. Each hack may concentrate on a particular scenario, but you should be able to adapt them to a wide range of problems specific to your own challenges. Some of these hacks will leave you thinking, "I guess that's one way to do it; thanks, but no thanks." However, we hope that most will make you say, "Wow...I didn't know SQL could do that." You should also be questioning the balance between SQL and your programming language. With a bit more understanding of SQL you can do more processing at the database, and as a result have less traffic between the database and your application. Nine times out of ten this approach is going to be faster and better. It's all about letting your program do the things it's good at, and letting the database do the things it's good at.

http://rapidshare.com/files/10771137/OReilly.SQL.Hacks.Nov.2006.rar

http://depositfiles.com/files/509858

http://ebook.icefile.org/index.php?page=main&id=0cd092155&name=0596527993.rar

The Database Hacker's Handbook : Defending Database Servers

2007-11-19T21:55:00.000+05:30

The Database Hacker's Handbook : Defending Database Servers Authors : David Litchfield, Chris Anley, John Heasman, Bill Grindlay Publisher: Wiley (July 14, 2005) ISBN: 0764578014 500 pages CHM Rar size : 1.11 MB

Book Description :

Databases are the nerve center of our economy. Every piece of your personal information is stored there—medical records, bank accounts, employment history, pensions, car registrations, even your children's grades and what groceries you buy. Database attacks are potentially crippling—and relentless. In this essential follow-up to The Shellcoder's Handbook, four of the world's top security experts teach you to break into and defend the seven most popular database servers. You'll learn how to identify vulnerabilities, how attacks are carried out, and how to stop the carnage. The bad guys already know all this. You need to know it too.
Identify and plug the new holes in Oracle and Microsoft® SQL Server
Learn the best defenses for IBM's DB2®, PostgreSQL, Sybase ASE, and MySQL® servers
Discover how buffer overflow exploitation, privilege escalation through SQL, stored procedure or trigger abuse, and SQL injection enable hacker access
Recognize vulnerabilities peculiar to each database
Find out what the attackers already know

http://rapidshare.de/files/31505300/0764578014.rar

http://mihd.net/5.1186/0764578014.rar.html

Java Programming with Oracle JDBC

2007-11-19T21:49:00.001+05:30

Donald Bales"Java Programming with Oracle JDBC"Publisher: O'Reilly ISBN: 059600088 388 pages PDF 1.36 mb

http://rapidshare.com/files/54005740/Java_Programming_with_Oracle_JDBC.rar

ODP.NET Developer's Guide

2007-11-19T21:48:00.000+05:30

ODP.NET Developer's GuidePackt Publishing ISBN: 1847191967 326 pages June, 2007 PDF 4 Mb

The Oracle Data Provider for .NET (ODP.NET) features optimized data access to the Oracle database from a .NET environment and allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security. It can be used from any .NET language, including C# and VB.NET. This guide will give you the information you need to work with the Oracle 10g v10.2 database from Visual Studio .NET 2005, using the Oracle Developer Tools and ODP.NET. After introducing ODP.NET, the authors move on to dealing with SQL, PL/SQL, and XML DB using ODP.NET. Next they look at application development with ODP.NET: Web Applications, Web Services, and Mobile Applications. The last chapter covers Oracle Developer Tools for Visual Studio .NET. All the code examples are in Visual Basic.NET 2005. What you will learn from this book:- Different ways of Connecting to Oracle databases using ODP.NET (including single Sign-on); Executing SQL queries and commands using ODP.NET; Working with PL/SQL blocks, stored procedures, stored functions, packages, and REF CURSORs; Working with Large Objects like BFILE, BLOB, and CLOB using ODP.NET; Working with XML and XMLDB; Application development using ODP.NET; - Database change notifications and Asynchronous programming; Developing Web Applications using ASP.NET & ODP.NET; Reporting (including charts) using ASP.NET and ODP.NET; Developing XML Web Services using ODP.NET; Developing applications for Smart Client devices (like Pocket PC); - Using Oracle Developer Tools for Visual Studio 2005; Creating & debugging PL/SQL stored procedures from Visual Studio 2005; Creating & Deploying .NET CLR stored procedures in Oracle database using Visual Studio 2005.

http://ebook.icefile.com/index.php?page=main&id=f97de1038&name=1847191967.rar

http://rapidshare.com/files/56680671/Packt.Publishing.ODP.NET.Developers.Guide.Jun.2007.pdf

http://xuploading.com/xus/index.php?page=main&id=0ddf2201&name=1847191967.pdf

Oracle Database 10g: A Beginner's Guide

2007-11-19T21:47:00.000+05:30

Oracle Database 10g: A Beginner's GuideMcGraw-Hill Osborne Media; 1 edition ISBN: 0072230789 448 pages March 17, 2004 CHM

distill... essential features of... newest version... straightforward... step-by-step projects... mastery checks... progress checks... \"Ask the Expert\" sidebars... notes... highly recommended

http://depositfiles.com/files/644577

http://ebook.icefile.org/index.php?page=main&id=6e7b4948&name=0072230789.rar

Oracle Database 10g New Features

2007-11-19T21:46:00.000+05:30

Oracle Database 10g New FeaturesMcGraw-Hill Osborne Media; 1st edition ISBN: 0072229470 272 pages March 24, 2004 CHM

indispensible...to personal and professional reference collections...expert commentary...ideal...for decision-makers and IT staff preparing for upgrades or migration

http://depositfiles.com/files/644567

http://ebook.icefile.org/index.php?page=main&id=3e109927&name=0072229470.rar

Oracle9i: The Complete Reference

2007-11-19T21:45:00.000+05:30

Kevin Loney and George Koch, «Oracle9i : The Complete Reference»ISBN 0072225211 Oracle Press August 2002 1256 pages pdf 23 MB

The most reknowned Oracle Resourse- Fully Updated for Oracle 9i. Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Get comprehensive information on all the features of Oracle 9i. Written by best-selling authors and Oracle gurus Kevin Loney, George Koch, and the experts at TUSC, Oracle9I: The Complete Reference covers critical relational, object-relational, and Web database concepts, as well as SQL, SQL*PLUS, PL/SQL, Java, JDBC, SQLJ, and XML programming. You'll also get full details on database administration techniques- and much more. This authoritative volume is a must-have tool for all Oracle professionals.

http://snipurl.com/vs22

Oracle Database 10g: High Availablity with RAC Flashback and Data Guard

2007-11-19T21:44:00.001+05:30

This text concentrates on explaining 10g technologies and practices to database administrators, covering general availability, real application clusters (RAC), disaster planning and recovery, and distributed database solutions.

http://rapidshare.de/files/16845639/10G_HighAvail.part1.rar
http://rapidshare.de/files/16845692/10G_HighAvail.part2.rar

Password: global

Using Oracle SQL Stored Outlines and Optimizer Plan Stability

2007-11-19T21:43:00.001+05:30

Using Oracle SQL Stored Outlines and Optimizer Plan Stability Author: Mike Ault ISBN: 0974071684 Publisher: Rampant TechPress - January 2003

http://www.megaupload.com/?d=DSGKD6PD

password : www.blueportal.org

Oracle Space Management Handbook

2007-11-19T21:42:00.002+05:30

Oracle Space Management Handbook Author: Don Burleson (Editor) ISBN: 0974435503 Publisher: Rampant TechPress - August 2003

http://www.megaupload.com/?d=25CJY4PW

password : www.blueportal.org