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