Oracle PL/SQL Programming

Ebook Free Download | Ebook Oracle PL/SQL Programming by Steven Feuerstein includes the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website.

This indispensable reference for both novices and experienced Oracle programmers will help you:

Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code
Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition
Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture
Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL
Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects
Build modular PL/SQL applications using procedures, functions, triggers, and packages

                                                                Download
Ebook Free Download

Secrets of the Oracle Database

Ebook Free Download | Ebook Secrets of the Oracle Database by Norbert Debes includes Secrets of the Oracle Database is the definitive guide to undocumented and partially documented features of the Oracle database server. Covering useful but little–known features from Oracle9i Database through Oracle Database 11g, this book will improve your efficiency as an Oracle database administrator or developer. Norbert Debes shines the light of day on features that help you master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible.

Finally, in one place, you have at your fingertips knowledge that previously had to be acquired through years of experience and word of mouth through knowing the right people. What Norbert writes is accurate, well–tested, well–illustrated by clear examples, and sure to improve your ability to make an impact in your day–to–day work with Oracle.

EJB 3.0 Database Persistence with Oracle Fusion Middleware 11g (repost)

 

Ebook Free Download | Ebook EJB 3.0 Database Persistence with Oracle Fusion Middleware 11g by Deepak Vohra includes  A complete guide to building EJB 3.0 database persistent applications with Oracle Fusion Middleware 11g tools
* Integrate EJB 3.0 database persistence with Oracle Fusion Middleware tools: WebLogic Server, JDeveloper, and Enterprise Pack for Eclipse
* Automatically create EJB 3.0 entity beans from database tables
* Learn to wrap entity beans with session beans and create EJB 3.0 relationships

* Apply JSF and ADF Faces user interfaces (UIs) to EJB 3.0 database persistence
* A practical guide illustrated with examples to integrate EJB 3.0 database persistence with Ajax and Web Services

In Detail
EJB (Enterprise JavaBeans) 3.0 is a commonly used database persistence technology in Java EE applications. EJB 3.0 has simplified the development of EJBs with an annotations-based API that eliminates the use of remote/local interfaces, home/local home interfaces, and deployment descriptors. A number of other books are available on EJB 3.0, but none covers

Sam R. Alapati - Expert Oracle Database 10g Administration

Ebook Free Download | Ebook Expert Oracle Database 10g Administration by Sam R. Alapati includes This is a unique, one-volume guide to the administration and management of the Oracle database. Fully revised and updated from its best-selling 9i predecessor, this edition covers all new features, with fully field-tested examples&emdash;not just "showcase" examples.

This book covers the new 10g management and performance tools and provides essential primers on Unix, Linux and Windows NT administration and on core SQL and PL/SQL programming techniques. And it provides everything the new and aspring Oracle DBA needs to build and admisiter complex Oracle 10g databases.
                                                                    Download
Ebook Free Download

Oracle Security (Repost)

Ebook Free Download | Ebook Oracle Security By William Heney by Marlene L. Theriault includes Security in a relational database management system is complex, and too few DBAs, system administrators, managers, and developers understand how Oracle implements system and database security. This book gives you the guidance you need to protect your databases. Oracle security has many facets:
Establishing an organization's security policy and planProtecting system files and passwordsControlling access to database objects (tables, views, rows, columns, etc.)Building appropriate user profiles, roles, and privilegesMonitoring system access via audit trails
Oracle Security describes how these basic database security features are implemented and provides many practical strategies for securing Oracle systems and databases. It explains how to use the Oracle Enterprise Manager and Oracle Security Server to enhance your site's security, and it touches on such advanced security features as encryption, Trusted Oracle, and various Internet and World Wide Web protection strategies.

                                                                 Download                                        
  Ebook Free Download

OCA Oracle Database SQL Expert Exam Guide: Exam 1Z0-047 (with Companion CD & Practice files)

Ebook Free Download | Ebook OCA Oracle Database SQL Expert Exam Guide: Exam 1Z0-047 (with Companion CD & Practice files by Steve O'Hearn includes study system for Oracle Certification exam 1Z0-047. This exclusive Oracle Press guide covers all of the objectives on the newly created Oracle SQL Expert exam in detail, including control privileges, creating indexes and constraints, altering existing schema objects, creating and querying external tables, and using the advanced SQL features to query and manipulate data within the database.

Oracle Database SQL Expert Exam Guide features real-world examples, practice questions, and chapter summaries to help you learn the material. The CD-ROM contains two practice exams and an electronic copy of the book. 

                                                                Download

Ebook Free Download

Pro ODP.NET for Oracle Database 11g

Ebook Free Download | Ebook Pro ODP.NET for Oracle Database 11g by Edmund Zehoo, Yap Wai Hong includes easy-to-understand guide for using the Oracle Data Provider (ODP) version 11g on the .NET Framework. It also outlines the core GoF (Gang of Four) design patterns and coding techniques employed to build and deploy high-impact mission-critical applications using advanced Oracle database features through the ODP.NET provider.

The book details the features of the ODP.NET provider in two main sections: “Basic,” covering the basics and mechanisms for data access via ODP.NET; and “Advanced,’ covering advanced Oracle features such as globalization, savepoints, distributed transactions and how to call them via ODP.NET, advanced queueing (AQ), and promotable transactions. It takes you from the ground up through different implementation scenarios via a rich collection of both VB.NET and C# code samples.

It outlines database security and performance optimization tricks and techniques on ODP.NET that conform to best practices and adaptable design. Different GoF design patterns are highlighted for different types of ODP.NET usage scenarios with consideration of performance and security.

It provides a comprehensive guide to the synergistic integration of Oracle and Microsoft technologies such as the upcoming Oracle Developer Tools for Visual Studio (11.1.0.7.10). It also details how programmers can make use of ODT to streamline the creation of robust ODP.NET applications from within the Visual Studio environment.
What you’ll learn
How to use the full set of features available in ODP.NET 11g (with code samples and diagrams illustrating each feature/concept). New features such as using Oracle Streams AQ, promotable transactions, Oracle database event notifications, and Oracle database control are also covered.
The core performance and feature differences between ODP.NET, Microsoft.NET Provider for Oracle, OLEDB.NET, and ODBC.NET, together with the strengths and weaknesses of each method. This section also provides comprehensive coverage on the differences between ODP.NET 9i, 10g, and 11g.
How to take advantage of connection pooling, fetch size controls, ref cursors, bind variables, client result cache and statement caching via ODP.NET to squeeze every ounce of performance from your .NET application.
How to secure your ODP.NET applications via authentication and ODP.NET 11g’s new classes to enforce imperative and declarative Oracle security.
The common programming pitfalls and design patterns to use/avoid in different ODP.NET usage scenarios
How to use a significant set of features of Oracle Developer Tools for Visual Studio (11.1.0.7.10), including new features such as the AQ designers, user/role management, and performance-tuning tools.
                                                              Download
Ebook Free Download

Oracle Solaris Cluster Essentials

Ebook Free Download | Ebook Oracle Solaris Cluster Essentials By Tim Read includes Thousands of IT organizations have adopted clustering to improve the availability of mission-critical software services. Today, with the rapid growth of cloud computing environments, clustering is even more crucial.

Oracle® Solaris Cluster Essentials is a comprehensive, authoritative guide to the industry’s most stable, robust clustering platform: Oracle Solaris Cluster. This book covers both Oracle Solaris Cluster 3.2 and Oracle Solaris Cluster Geographic Edition in thorough detail, offering start-to-finish lifecycle guidance for planning, implementation, management, and troubleshooting.

Written by Oracle Solaris Cluster expert Tim Read, this book covers both high availability and disaster recovery features, and offers in-depth guidance for both Oracle and non-Oracle database environments. It also presents several example implementations that can be used to quickly construct effective proofs-of-concept.

Whether you’re new to clustering or upgrading from older solutions, this book brings together all the information you’ll need to maximize the value, reliability, and performance of any Oracle Solaris Cluster environment. You’ll learn how to

• Understand Oracle Solaris Cluster’s product features and architecture, and their implications for design and performance
  
• Establish requirements and design clustered systems that meet them
  
• Master best practices for integrating clustering with virtualization technologies
  
• Implement proven disaster recovery planning techniques
  
• Efficiently maintain Oracle Solaris Cluster environments
  

Part of the Oracle Solaris System Administration Series, Oracle® Solaris Cluster Essentials combines a complete technology introduction and hands-on guide for every architect, administrator, and IT manager responsible for high availability and business continuity.

Download

Ebook Free Download

Pro Oracle SQL

Ebook Free Download |  Ebook Pro Oracle SQL By Karen Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen, Jared Still includes the power of SQL in the Oracle Database—one of the most potent SQL implementations on the market today. To master it requires a three-pronged approach: learn the language features, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets.

Karen Morton and her team help you master powerful aspects of Oracle SQL not found in competing databases. You’ll learn analytic functions, the MODEL clause, and advanced grouping syntax—techniques that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL also helps you minimize parsing overhead, read execution plans, test for correct results, and exert control over SQL execution in your database. You’ll learn when to create indexes, how to verify that they make a difference, how to use SQL Profiles to optimize SQL in packaged applications, and much more. You’ll also understand how SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions.

What’s the bottom-line? Pro Oracle SQL helps you work at a truly professional level in Oracle dialect of SQL. You’ll master the language, the tools to work effectively with the language, and the right way to think about a problem in SQL. Pro Oracle SQL helps you rise above the crowd to provide stellar service in your chosen profession.
Endorsed by the OakTable Network, a group of Oracle technologists well-known for their rigorous and scientific approach to Oracle Database performance
Comprehensive – goes beyond the language with a focus on what you need to know to write successful queries and data manipulation statements.

What you'll learn

• Master powerful SQL features implemented only in Oracle Database
  
• Read and interpret SQL execution plans
  
• Quickly diagnose and fix badly performing SQL
  
• Control execution plans through hints, profiles, and plan baselines
  
• Optimize queries within packaged applications without touching the code
  
• Recognize when not to waste time on SQL that is performing optimally  

                                                             
                                                              Download
 Ebook Free Download

Oracle SQL Recipes: A Problem-Solution Approach

Ebook Free Download |Ebook Oracle SQL Recipes: A Problem-Solution Approach includes Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle’s manual set. This book frees you from that drudgery by providing tested and working examples of SQL used to solve common problems faced by developers and database administrators on a daily basis. When you’re under pressure to get results fast, Oracle SQL Recipes is there at your side.
Example-based, providing quality solutions to everyday problems
Respects your time by putting solutions first and keeping discussions short
Solves the most commonly encountered SQL problems
What you’ll learn
Recognize common query patterns and apply their corresponding solutions.
Solve common reporting problems such as sorting rows into buckets.
Troubleshoot SQL performance problems.
Create and manage database objects such as tables, indexes, and views.
Work with XML and tree-structured data.
Take advantage of analytic functions, regular expressions, hierarchical query support, and other powerful aspects of Oracle SQL.
Who is this book for?

Oracle SQL Recipes is written for developers and database administrators who write SQL to run against an Oracle database. It is further written for those whose time is precious, and who just wish for a good example to help them get on with their work. If you want to spend your time writing SQL rather than reading about it, then this is the right book for you.
                               
                                                         Download

Ebook Free Download

Advanced SQL Functions in Oracle 10g.

Ebook Free Download 

Ebook Free Download | Ebook Advanced SQL Functions in Oracle 10g includes Designed to exploit Oracle 10g's SQL, this book is a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, the book covers collection/object-oriented structures and introduces new Oracle 10g topics like SQL, XML, and statistical functions.

 
Download

Ebook Free Download

Expert Oracle Database Architecture: Oracle Database Programming 9i, 10g, and 11g Techniques and Solutions

Ebook Free Download

 Ebook Free Download | Ebook Expert Oracle Database Architecture includes how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly.
This fully revised second edition covers the latest developments in Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.
Don’t treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career.
Fully-revised to cover Oracle Database 11g
 

Download

Ebook Free Download

Pro Oracle Database 11g RAC on Linux

Ebook Free Download 

  Ebook Free Download | Ebook Pro Oracle Database 11g RAC on Linux includes implementing Oracle Real Application Clusters in a Linux environment. Real Application Clusters, commonly abbreviated as RAC, is Oracle's industry-leading architecture for scalable and fault-tolerant databases. RAC allows you to scale up and down by simply adding and subtracting inexpensive Linux servers. Redundancy provided by those multiple, inexpensive servers is the basis for the failover and other fault-tolerance features that RAC provides.

Written by authors well-known for their talent with RAC, Pro Oracle Database 11g RAC on Linux gives you a rock-solid and technically flawless foundation on which to build your RAC-management skills. Authors Julian Dyke and Steve Shaw share their hard-won experience in building RAC clusters, showing you how to build for success using the very latest Oracle technologies, such as Automatic Storage Management (ASM) and Oracle Clusterware. You'll learn to troubleshoot performance and other problems. You'll even learn how to correctly deploy RAC in a virtual-machine environment based upon Oracle VM, which is the only virtualization solution supported by Oracle Corporation. 
Download

Ebook Free Download

Oracle Database 11g The Complete Reference (Osborne ORACLE Press Series)

Ebook Free Download 

Ebook Free Download | Ebook Oracle Database 11g The Complete Reference|Ebook include  details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included. 

Download

Ebook Free Download

OCP: Oracle Database 11g Administrator Certified Professional Study Guide: (Exam 1Z0-053)

Ebook Free Download 

 Author, "OCP: Oracle Database 11g Administrator Certified Professional Study Guide: (Exam 1Z0-053)" 
his updated study guide for the latest release of the most popular database software in the world—Oracle Database 11g— reviews using the RMAN recovery catalog, handling Flashback technology, managing memory and resources, automating tasks, diagnosing the database, and much more. Plus, more than 100 pages of workbook exercises help prepare you to take the 1Z0-053 exam.

From the Back Cover

Prepare for OCP certification in Oracle Database 11g

Study, practice, and review for Oracle Certified Professional certification in Oracle 11g, Oracle's new release of its top-selling database software. Inside this in-depth guide, you'll find full coverage of essential topics for the very latest, updated Administration II exam (1Z0-053), including database architecture and ASM; configuring backups; using Flashback technology; managing database performance, memory, and resources; and more. Get extra exam practice using the exercise workbook in the Appendix. Start your preparation today with:  
DOWNLOAD

Ebook Free Download

oracle 11g dataguard handbook

Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard, 2 ed

Ebook Free Download

Scott Jesse, Bill Burton, Bryan Vongray, "Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard, 2 edition" 
MgH Osb..ne M.dia | 2011 | ISBN: 0071752080 | 557 pages | PDF | 5,4 MB

Leverage Oracle Database 11g Release 2 High Availability Features

Protect your critical business assets and achieve maximum database uptime using the detailed information in this Oracle Press guide. Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, Oracle Real Application Clusters, and Oracle Data Guard, Second Edition provides cost-effective solutions to current availability challenges. Discover how to grid-enable your IT framework, roll out Oracle Real Application Clusters, maintain standby databases, and deploy Oracle Flashback. Monitoring, tuning, and disaster recovery techniques are also covered in this comprehensive resource.

Install Oracle Clusterware (as part of Oracle's grid infrastructure) or upgrade from an earlier version
Build test clusters and hosts using Oracle VM
Work with Oracle Automatic Storage Management and Oracle Automatic Storage Management Cluster File System
Create synchronized standby databases using Oracle Data Guard
Reliably archive and restore data with Oracle Recovery Manager
Use Oracle Flashback to identify and undo user errors
Configure Oracle Enterprise Manager Grid Control for management of an Oracle maximum availability architecture environment

Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard, 2 ed Ebook Free Download

                                                                    DOWNLOAD