Two Minute SQL Server StumpersVol. 5
Red gate books | 2009 | ISBN: n\a | 207 pages | PDF | 2 MB

Whether you’re practicing for an exam or interview or just wanting to see who’s got the biggest SQL Server brain in your office, this book is perfect.

Containing 100 SQL Server Central Questions of the Day, this book is a great way to test yourself or increase your knowledge.

If you spend enough time in SQL Server to answer the questions in this book then you’d benefit from the SQL Toolbelt.

The SQL Toolbelt allows developers and DBAs to gain access to all the SQL Sever tools we currently produce. This means that when you are working with SQL Server databases, you can have the most powerful set of tools immediately to hand.

Download Here

Password default : ebookhouse.org

Oracle PL/SQL Programming, 4th Edition
O’Reilly Media, Inc.; 4 edition | ISBN: 0596009771 | 1198 pages | August 22, 2005 | CHM | 3 Mb

For the past ten years, O’Reilly’s Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle’s powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone–from novices to experienced developers, and from Oracle Forms developers to database administrators–make the most of PL/SQL.

The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers.

The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization.

Co-authored by the world’s foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications–making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.

Download Here

Oracle Database 11g The Complete Reference

Product Description

The Definitive Guide to Oracle Database 11g

Get full 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.

• Install Oracle Database 11g or upgrade from an earlier version
• Create database tables, sequences, indexes, views, and user accounts
• Construct SQL statements, procedures, queries, and subqueries
• Optimize security using virtual private databases and transparent data encryption
• Import and export data using SQL*Loader and Oracle Data Pump
• Use SQL replay, change management, and result caching
• Avoid human errors using flashback and automatic undo management
• Build and tune PL/SQL triggers, functions, and packages
• Develop database applications using Java, JDBC, and XML
• Optimize availability and scalability with Oracle Real Application Clusters
  Download

Oracle 10g Data Warehousing

Book Description
New edition of successful book with Oracle employees and consultants as authors.

Download

Oracle 10g RAC Grid, Services & Clustering

Product Description
Grid architecture is Oracle’s 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.

Oracle 10g RAC focuses on RAC-specific topics including ASM, operating system configuration, installation and configuration of RAC and much more. Coverage includes network configuration for high availability, FAN, TAF, ONS, implementation of maximum availability architecture (MAA), EM Grid Control, AWR, ADDM and other performance-related tools. The author includes several scripts for performance tuning and implementation that the reader can use to configure a RAC environment either on a 2, 4, 8, 60 or 99 node configuration.

* Focuses on implementing, testing and tuning features of Real Application Clusters (RAC) database
version 10g Release 2
* Provides extensive coverage of usage, day-to-day functions and operations
* Includes tips and techniques such as script samples
to illustrate various features of RAC
* A jumpstart into all the key features of 10g R2 RAC

Download

Oracle PL/SQL: Expert Techniques For Developers and Database Administrators

Product Description
Welcome aboard the first book focusing exclusively on PL/SQL techniques, through Oracle 11g. These techniques are tried-tested-true, yet do not compromise performance. You’ll find coverage of all types of scenarios, starting from design to coding and testing to debugging and tuning. PL/SQL is more than just a 3GL sequel to SQL; instead it can be used as a methodology for application development using Oracle. The techniques covered here have a broader scope, in applications ranging from OLTP to OLAP and from data warehousing to business intelligence. The world of PL/SQL is exciting and this book provides a repository of techniques for PL/SQL developers and DBAs alike. This book takes you beyond the existing solutions found in other professional and reference texts or in online documentation. Starting from PL/SQL internals that include PL/SQL program structure, internal representation, compilation, and execution, users are taught PL/SQL concepts and techniques that go way beyond SQL, such as data structure management, error management, data management, application management, and transaction management. It covers the practical “how-to” techniques of applying these PL/SQL concepts in live projects and elaborates on various PL/SQL frameworks, the integration of PL/SQL with Java, and Web-enabling PL/SQL. The last two chapters on PL/SQL tuning and debugging and PL/SQL coding standards contain comprehensive coverage of performance-enhancing techniques and PL/SQL coding standards that can’t be found in anywhere else. All techniques include examples and hands-on code, as well as tips and coding standards. The companion CD-ROM includes all the source code for the examples in the book.

Download

Oracle VM Manager 2.1.2

Product Description

Manage a Flexible and Elastic Data Center with Oracle VM Manager

• Learn quickly to install Oracle VM Manager and Oracle VM Servers
• Learn to manage your Virtual Data Center using Oracle VM Manager

• Import VMs from the Web, template, repositories, and other VM formats such as VMware
• Learn powerful Xen Hypervisor utilities such as xm, xentop, and virsh
• A practical hands-on book with step-by-step instructions