Your cart

Your cart is empty

Browse All departments
  • R100 - R250 (38)
  • R250 - R500 (106)
  • R500+ (1,179)
  • -
Author / Contributor

Books > Computing & IT > Computer software packages > Database software

Expert Oracle Exadata (Paperback, 1st ed.): Kerry Osborne, Randy Johnson, Tanel Poder Expert Oracle Exadata (Paperback, 1st ed.)
Kerry Osborne, Randy Johnson, Tanel Poder
R1,439 Discovery Miles 14 390 Ships in 7 - 11 working days

Throughout history, advances in technology have come in spurts. A single great idea can often spur rapid change as the idea takes hold and is propagated, often in totally unexpected directions. Exadata embodies such a change in how we think about and manage relational databases. The key change lies in the concept of offloading SQL processing to the storage layer. That concept is a huge win, and its implementation in the form of Exadata is truly a game changer. Expert Oracle Exadata will give you a look under the covers at how the combination of hardware and software that comprise Exadata actually work. Authors Kerry Osborne, Randy Johnson, and Tanel Poder share their real-world experience, gained through multiple Exadata implementations with the goal of opening up the internals of the Exadata platform. This book is intended for readers who want to understand what makes the platform tick and for whom"how" it does what it is does is as important as what it does. By being exposed to the features that are unique to Exadata, you will gain an understanding of the mechanics that will allow you to fully benefitfrom the advantages that the platform provides. Changes the wayyou think about managing SQL performance and processing Provides a roadmap to laying out the Exadata platform to best support your existing systems Dives deeply into the internals, removing the black box mystique and showing how Exadata actually works What you'll learn Configure Exadata from the ground up Optimize for mixed OLTP/DW workloads Migrate large data sets from existing systems Connect Exadata to external systems Support consolidation strategies using the Resource Manager Configure high-availability features of Exadata, including Real Application Clusters (RAC) and automatic storage management (ASM) Apply tuning strategies utilizing the unique features of Exadata Who this book is for

Expert Oracle Exadata is for database administrators and developers who want to understand what makes Exadata unique so that they can take advantage of all the platform has to offer. It is also for anyone who needs to plan and execute migrations of systems to the Exadata platform. Finally, the book will be invaluable to those who support and maintain such systems. Table of Contents What Is Exadata? Offloading / Smart Scan Hybrid Columnar Compression Storage Indexes Exadata Smart Flash Cache Exadata Parallel Operations Resource Management Configuring Exadata Recovering Exadata Exadata Wait Events Understanding Exadata Performance Metrics Monitoring Exadata Performance Migrating to Exadata Storage Layout Compute Node Layout Unlearning Some Things We Thought We Knew

Expert PL/SQL Practices - for Oracle Developers and DBAs (Paperback, 1st ed.): Michael Rosenblum, Dominic Delmolino, Lewis... Expert PL/SQL Practices - for Oracle Developers and DBAs (Paperback, 1st ed.)
Michael Rosenblum, Dominic Delmolino, Lewis Cunningham, Riyaj Shamsudeen, Connor McDonald, …
R1,327 Discovery Miles 13 270 Ships in 7 - 11 working days

Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you'll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive difference in the quality and scalability of code that you write. The path to mastery begins with syntax and the mechanics of writing statements to make things happen. If you've reached that point with PL/SQL, then let the authors of Expert PL/SQL Practices show you how to combine syntax and mechanics with features and techniques to really make the language sing. You'll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects. These authors are passionate about PL/SQL and the power it places at your disposal. They want you to succeed, to know all that PL/SQL can offer. Let Expert PL/SQL Practices open your eyes to the full power of Oracle's world-class language for the database engine. Goes beyond the manual to cover good techniques and best practices Delivers knowledge usually gained only by hard experience Covers the functionality that distinguishes PL/SQLas apowerful andscalable programming language for deploying logic inside the database engine What you'll learn Learn when PL/SQL is best used, and when to avoid it Move data efficiently using bulk SQL operations Write code that scalesthrough pipelining, parallelism, and profiling Choose the right PL/SQL cursor type for any given application Reduce coding errors through sound development practices such as unit-testing Create and execute SQL and PL/SQL dynamically at runtime Who this book is for

Expert PL/SQL Practices is for PL/SQL developers who want to develop deep expertise in key aspects of the language and its use in database programming. Any developer writing code against Oracle's class-leading database engine will find value from the collected wisdom in this book. Some knowledge of PL/SQL is assumed. Readers should at least be past the beginning stage with the language. Table of Contents Do Not Use Dynamic SQL: Handling the Unknown PL/SQL and Parallel Processing Warnings and Conditional Compilation PL/SQL Unit Testing Bulk SQL Operations Know Your Code Contract-Oriented Programming PL/SQL from SQL Choosing the Right Cursor PL/SQL Programming in the Large Evolutionary Data Modeling Profiling for Performance Coding Conventions and Error Handling Dependencies and Invalidations

Expert Oracle GoldenGate (Paperback, 1st ed.): Ben Prusinski, Steve Phillips, Shing Chung Expert Oracle GoldenGate (Paperback, 1st ed.)
Ben Prusinski, Steve Phillips, Shing Chung
R1,481 Discovery Miles 14 810 Ships in 7 - 11 working days

Expert Oracle GoldenGate is a hands-on guide to creating and managing complex data replication environments using the latest in database replication technology from Oracle. GoldenGate is the future in replication technology from Oracle, and aims to be best-of-breed. GoldenGate supports homogeneous replication between Oracle databases. It supports heterogeneous replication involving other brands such as Microsoft SQL Server and IBM DB2 Universal Server. GoldenGate is high-speed, bidirectional, highly-parallelized, and makes only a light impact on the performance of databases involved in replication. The authors share their experience in the form of tutorials on designing and implementing all types of Oracle GoldenGate environments. You'll learn methods for tuning Oracle GoldenGate performance. You'll discover GoldenGate's utility as a migration and extract, transform, load (ETL) tool. You'll learn to configure highly-available environments involving GoldenGate, Real Application Clusters, and Data Guard. From installation to design to implementation and troubleshooting, Expert Oracle GoldenGate helps you master all aspects of using and applying Oracle GoldenGate as the replication tool of choice in your environment. Explains all aspects of using GoldenGate for replication Covers homogeneous, heterogeneous, and bidirectional replication Shows the use of GoldenGate for data migration and extract, transform, load (ETL) What you'll learn Install Oracle GoldenGate quickly and painlessly Design single- and bi-directional replication solutions Apply GoldenGate to high-availability solutions Troubleshoot and tune GoldenGate for performance Verify data synchronization using GoldenGate Veridata Manage and monitor GoldenGate environments using GoldenGate Director Who this book is for

Expert Oracle GoldenGate is for database professionals who need to master the latest in replication technology from Oracle. It is for the Oracle Database administrator, technical manager, or Oracle developer requiring a solid base of expertise on to implement or manage replication environments with GoldenGate technology. Expert Oracle GoldenGate is an appropriate and timely reference for all users of the GoldenGate software. Table of Contents Introduction Installation Architecture Basic Replication Bi-Directional Replication Heterogeneous Replication Tuning Oracle GoldenGate Monitoring Oracle GoldenGate Oracle GoldenGate Veridata Oracle GoldenGate Director Troubleshooting High Availability & Disaster Recovery Zero Downtime Migrations and Upgrades Best Practices

Pro Oracle Application Express 4 (Paperback, 2nd ed.): Tim Fox, Scott Spendolini, John Scott Pro Oracle Application Express 4 (Paperback, 2nd ed.)
Tim Fox, Scott Spendolini, John Scott
R1,601 Discovery Miles 16 010 Ships in 7 - 11 working days

Pro Oracle Application Express 4 is your key to mastering one of the most innovative products to come out of Oracle in years. Application Express, termed "APEX" for short, is fast becoming one of the easiest and most widely-used of tools for creating enterprise-level applications that run against an Oracle database. APEX is easy enough for power users to create ad-hoc applications atop something more reliable than a spreadsheet. Yet APEX is powerful and extensible enough to enable fully-scalable, enterprise-level applications that are accessed by thousands of users. Authors Tim Fox, John Scott, and Scott Spendolini take you to the professional level in developing for Application Express. They show how to handle user authentication in enterprise environments and how to extend APEX by writing components based upon Oracle's new plug-in architecture. You'll learn to deal with localization issues such as time zones and translations, and to customize the look and feel of an APEX website to blend in with your corporate branding strategy. The authors also cover web service development, performance and scalability, and the production issues that you encounter in enterprise-level deployments. Many years of experience in solving the hard problems are coalesced in this book to help you, the reader, take advantage of all that APEX has to offer. Focuses on high-end, enterprise-level development Covers new features such as plug-ins and Websheets Introduces the new interface released with APEX 4.0 What you'll learn Design APEX solutions that conform to your corporate look and feel Create compelling reports, charts, navigation, and layout Create your own components based upon APEX's new plug-in architecture Authenticate users and manage their access to your applications Develop and deploy web services using APEX Scale APEX applications to thousands of users Secure your applications and data from intrusion Who this book is for

Pro Oracle Application Express 4 is aimed at application developers looking for a rapid application development environment harnessing the full power of the Oracle Database, including SQL and PL/SQL. The book meets the needs of developers working at both the departmental and the enterprise level, with an emphasis on high-end, enterprise deployment. Table of Contents Development Best Practices Authentication and User Management Conditions and Authorization Schemes Data Security Navigation and Layout Reports and Charts Dynamic Actions: Ajax and JavaScript WebSheets Reporting and Printing Themes and Templates Localization Issues Plugins Web Service Development Performance and Scalability Production Issues APEX Dictionary

Expert Oracle Application Express (Paperback, 1st ed.): John Scott, Doug Gault, Raj Mattamal, Anton Nielsen, Martin... Expert Oracle Application Express (Paperback, 1st ed.)
John Scott, Doug Gault, Raj Mattamal, Anton Nielsen, Martin D'Souza, …
R1,562 Discovery Miles 15 620 Ships in 7 - 11 working days

Expert Oracle Application Express brings you groundbreaking insights into developing with Oracle's enterprise-level, rapid-development tool from some of the best practitioners in the field today. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. The framework rests upon Oracle's powerful PL/SQL language, enabling power users and developers to rapidly develop applications that easily scale to hundreds, even thousands of concurrent users. The 13 authors of Expert Oracle Application Express build their careers around APEX. They know what it takes to make the product singdeveloping secure applications that can be deployed globally to users inside and outside a large enterprise. The authors come together in this book to share some of their deepest and most powerful insights into solving the difficult problems surrounding scalability, globalization, configuration and lifecycle management, and more. You'll learn about debugging and performance, deep secrets to customizing your application user interface, how to secure applications from intrusion, and about deploying globally in multiple languages. Expert Oracle Application Express is truly a book that will move you and your skillset a big step towards the apex of Application Express development. Presents best-practices and development insights from leading experts in the field Addresses globalization, scalability, security, and other concerns of enterprise-level development Shows how to customize APEX for your own application needs What you'll learn Solve tough problems in scalability in order to serve thousands of users Design applications to sidestep performance problems and easily scale upwards Deploy applications globally while respecting linguistic and cultural differences Customize applications by exploiting APEX's roots in PL/SQL Reduce the stress of managing application lifecycle and configuration Secure outwardly-facing applications and their data from intrusion Who this book is for

Expert Oracle Application Express is aimed at APEX developers who seek the deepest possible knowledge of Oracle Application Express and how to develop with it. Readers should know and be proficient with APEX, and be prepared to expend some mental energy in absorbing the high-end material in this book. Table of Contents OHS, EPG, and APEX Listener Compared Oracle APEX 4.0 Charts Inside Out Tabular Forms Team Development Globalization Debugging Dynamic Actions Security Lifecycle Management Working with APEX Collections Plug-Ins Architecture Advanced Interactive Reporting

OCR Level 2 ITQ - Unit 19 - Database Software Using Microsoft Access 2010 (Spiral bound): CIA Training Ltd OCR Level 2 ITQ - Unit 19 - Database Software Using Microsoft Access 2010 (Spiral bound)
CIA Training Ltd
R396 Discovery Miles 3 960 Ships in 10 - 15 working days

This training guide has been written specifically for the OCR Level 2 ITQ unit Database Software, which requires you to iuse a software application to create and edit a single table database. Each exercise in this guide has been designed to gradually build up your knowledge of Microsoft Access using a simple, user friendly, step-by-step approach. This optional level 2 unit has a credit value of 4, and requires you to demonstrate the skills and knowledge needed to use a range of intermediate database software tools and techniques which may be non-routine or unfamiliar. This guide provides you with the knowledge and techniques necessary to meet these learning outcomes. Data files to accompany this title are available to download from our website, which allow you to practise the many different software features covered.

Oracle and PL/SQL Recipes - A Problem-Solution Approach (Paperback, 1st ed.): Josh Juneau, Matt Arena Oracle and PL/SQL Recipes - A Problem-Solution Approach (Paperback, 1st ed.)
Josh Juneau, Matt Arena
R1,188 R931 Discovery Miles 9 310 Save R257 (22%) Ships in 7 - 11 working days

Oracle PL/SQL Recipes is your go to book for PL/SQL programming solutions. It takes a task-oriented approach to PL/SQL programming that lets you quickly look up a specific task and see the pattern for a solution. Then it's as simple as modifying the pattern for your specific application and implementing it. And you're done and home for dinner.
Oracle PL/SQL Recipes is another in Apress' ongoing series of recipe books aimed at Oracle practitioners. The recipe format is ideal for the busy professional who just needs to get the job done. Covers the most common PL/SQL programming problems Presents solutions in ready-to-use format Stays short and to-the-point What you'll learn Move business logic into the database Implement robust exception-handling Optimize and debug, taking advantage of Oracle SQL Developer Integrate PL/SQL with web-based applications Interface with Java code and dynamic languages in the database, and running externally Run the UTPLSQL unit-testing framework Who this book is for

Oracle PL/SQL Recipes is database administrators and developers wanting to take advantage of Oracle Database's built-in support for procedural logic. Database administrators can use PL/SQL to automate administrative tasks, audit access to sensitive data, and more. Developers will be able to optimize processing, push business logic into the database layer, and interface with Java and web applications. Table of Contents PL/SQL Fundamentals Essential SQL Looping and Logic Functions, Packages, and Procedures Triggers Type Conversion Numbers, Strings, and Dates Dynamic SQL Exceptions PL/SQL Collections and Records Automating Routine Tasks Oracle SQL Developer Analyzing and Improving Performance Using PL/SQL on the Web Java in the Database Accessing PL/SQL from JDBC, HTTP, Groovy, and Jython Unit Testing With utPLSQL

The Definitive Guide to SQLite (Paperback, 2nd ed.): Grant Allen, Mike Owens The Definitive Guide to SQLite (Paperback, 2nd ed.)
Grant Allen, Mike Owens
R1,172 Discovery Miles 11 720 Ships in 7 - 11 working days

Outside of the world of enterprise computing, there is one database that enables a huge range of software and hardware to flex relational database capabilities, without the baggage and cost of traditional database management systems. That database is SQLite-an embeddable database with an amazingly small footprint, yet able to handle databases of enormous size. SQLite comes equipped with an array of powerful features available through a host of programming and development environments. It is supported by languages such as C, Java, Perl, PHP, Python, Ruby, TCL, and more. The Definitive Guide to SQLite, Second Edition is devoted to complete coverage of the latest version of this powerful database. It offers a thorough overview of SQLite's capabilities and APIs. The book also uses SQLite as the basis for helping newcomers make their first foray into database development. In only a short time you can be writing programs as diverse as a server-side browser plug-in or the next great iPhone or Android application! Learn about SQLite extensions for C, Java, Perl, PHP, Python, Ruby, and Tcl. Get solid coverage of SQLite internals. Explore developing iOS (iPhone) and Android applications with SQLite. SQLite is the solution chosen for thousands of products around the world, from mobile phones and GPS devices to set-top boxes and web browsers. You almost certainly use SQLite every day without even realizing it!

Interview Questions for DB2 9 (Paperback): Robert Wingate Interview Questions for DB2 9 (Paperback)
Robert Wingate
R205 Discovery Miles 2 050 Ships in 7 - 11 working days
Pro Oracle Database 11g RAC on Linux (Paperback, 2nd ed.): Julian Dyke, Steve Shaw, Martin Bach Pro Oracle Database 11g RAC on Linux (Paperback, 2nd ed.)
Julian Dyke, Steve Shaw, Martin Bach
R1,516 Discovery Miles 15 160 Ships in 7 - 11 working days

Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on 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.RAC is a complex and powerful technology. It demands expertise in its deployment. You can't just wing it in creating a RAC solution. Julian and Steve have earned the right to term themselves expert-in Pro Oracle Database 11g RAC on Linux, they offer a rigorous and technically-correct treatment of RAC that helps you build a solid foundation of expertise and achieve success. * Rigorous and technically accurate content* Complete coverage of RAC, from planning to implementation to rollout to ongoing maintenance and troubleshooting* Up-to-date with the very latest RAC featuresWhat you'll learn* Plan the architecture for a successful RAC installation* Implement failover and other fault-tolerant features* Scale RAC clusters up and down as needed to achieve performance targets* Consolidate RAC clusters using Oraclea s virtualization solution* Manage RAC proactively so as to sleep well at night* Troubleshoot and solve performance and availability problemsWho this book is for Pro Oracle Database 11g RAC on Linux is written for Oracle Database Administrators who want to step up their skills to be equal to the task of managing Real Application Clusters.

Oracle Solaris Cluster Essentials (Paperback, New): Read Oracle Solaris Cluster Essentials (Paperback, New)
R1,251 Discovery Miles 12 510 Ships in 7 - 11 working days

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""(R)""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 performanceEstablish requirements and design clustered systems that meet themMaster best practices for integrating clustering with virtualization technologiesImplement proven disaster recovery planning techniquesEfficiently maintain Oracle Solaris Cluster environments Part of the Oracle Solaris System Administration Series, "Oracle""(R)""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.

Easy Oracle PL/SQL Programming (Paperback, 2nd Revised edition): John Garmany Easy Oracle PL/SQL Programming (Paperback, 2nd Revised edition)
John Garmany
R573 Discovery Miles 5 730 Ships in 7 - 11 working days

Designed for any Oracle professional who must quickly implement Oracle reporting, this indispensable guide offers new tips and tricks that make Oracle reporting simple. The basics of PL/SQL are introduced using multiple examples that include code snippets and sample code results. The example-driven methodology teaches PL/SQL language structures, anonymous blocks, and stored procedures so well that by the end of the first chapter users will be coding blocks confidently. Exercises are also provided intermittently to test knowledge comprehension. While gradually building on previous concepts and increasing in complexity, this handbook always focuses on manageability.

Oracle Forensics - Accessing Oracle Security Vulnerabilities (Paperback, New): Paul M. Wright Oracle Forensics - Accessing Oracle Security Vulnerabilities (Paperback, New)
Paul M. Wright
R1,422 R1,324 Discovery Miles 13 240 Save R98 (7%) Ships in 7 - 11 working days

Today's Oracle professionals are challenged to protect their mission-critical data from many types of threats. Electronic data is being stolen is record amounts, and criminals are constantly devising sophisticated tools to breech your Oracle firewall. With advanced Oracle Forensics we can now proactively ensure the safety and security of our Oracle data, and all Oracle Forensics techniques are part of the due diligence that is required for all production databases. A failure to apply Forensics techniques to identify unseen threats can lead to a disaster, and this book is required reading for every Oracle DBA. This indispensable book is authored by Paul Wright, the world's top Oracle forensics expert, and the father of the field of Oracle Forensics. Packed with insights and expert tips, this is the definitive reference for all Oracle professional who are charged with protecting their valuable corporate information.

Expert Oracle Database Architecture - Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions (Paperback, 2nd... Expert Oracle Database Architecture - Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions (Paperback, 2nd ed.)
Thomas Kyte
R1,342 R1,058 Discovery Miles 10 580 Save R284 (21%) Ships in 7 - 11 working days

Now in its second edition, this best-selling book by Tom Kyte of Ask Tom fame continues to bring you some of the best thinking on 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* Proof-by-example approach: Let the evidence be your guide* Dives deeply into Oracle Databases's most powerful featuresWhat you'll learn* Develop an evidence-based approach to problem solving* Manage transactions in highly concurrent environments* Speed access to data through table and index design* Manage files and memory structures for performance and reliability* Scale up through partitioning and parallel processing* Load and unload data to interface with external systems* Think for yourself; don't take Tom's word for it Who this book is for This book is aimed at Oracle Database administrators, at PL/SQL and Java developers writing code to be deployed inside the database, and at developers of external applications who use Oracle Database as a data store. It is the go to book for those wishing to create efficient and scalable applications.

Linus for the Oracle Dba*** No Longer Ipg (Paperback): Jon Emmons Linus for the Oracle Dba*** No Longer Ipg (Paperback)
Jon Emmons
R1,082 R1,023 Discovery Miles 10 230 Save R59 (5%) Ships in 7 - 11 working days

Covering all major aspects of Linux system management critical to running Oracle on Linux, this guide focuses on those tasks most important to Oracle administrators, such as file management, moving and managing files between servers, startup and shutdown tasks, and shell scripting. This reference breaks down the complex subject of Linux administration into easy to digest chapters that are organized by task, providing clear, concise direction for learning to administer Oracle databases on the Linux operating system.

Oracle Performance Troubleshooting*** No Longer Ipg (Paperback, 2nd Revised edition): D. Burleson, R. Schumacher Oracle Performance Troubleshooting*** No Longer Ipg (Paperback, 2nd Revised edition)
D. Burleson, R. Schumacher
R697 Discovery Miles 6 970 Ships in 7 - 11 working days

This second edition is authored by two of the world's most widely read DBAs and Oracle internals experts, Donald Burleson and Robin Schumacher. It is an indispensable guide for any Oracle professional who is looking for real world tuning techniques. If you're a DBA who's looking for Oracle scripts and advice on how to get to the heart of critical Oracle performance problems, then you've come to the right place. Our second edition authors focus their incredible knowledge of the Oracle data dictionary into a superb book that shows how to quickly troubleshoot and correct Oracle performance problems.

Caching and Materialization for Web Databases (Paperback): Alexandros Labrinidis, Qiong Leo, Jie Xu, Wenwei Xue Caching and Materialization for Web Databases (Paperback)
Alexandros Labrinidis, Qiong Leo, Jie Xu, Wenwei Xue
R1,772 Discovery Miles 17 720 Ships in 7 - 11 working days

Database systems have been driving dynamic web sites since the early 90s; nowadays, even seemingly static web sites employ a database back-end for personalization and advertising purposes. In order to keep up with the high demand fuelled by the rapid growth of the Internet, a number of caching and materialization techniques have been proposed for web databases over the years. The main goal of these techniques is to improve performance, scalability, and manageability of database-driven dynamic web sites, in a way that the quality of data is not compromised. Although caching and materialization are well understood concepts in the traditional database and networking/operating systems literature, the Web and web databases bring forth unique characteristics that warrant new techniques and approaches. In this survey, the authors adopt a data management point of view to describe the system architectures of web databases, and analyze the research issues related to caching and materialization in such architectures. They also present the state of the art in caching and materialization for web databases and organize current approaches according to the fundamental questions, namely how to store, how to use, and how to maintain cached/materialized web data. Finally, they associate work in caching and materialization for web databases to similar techniques in other related areas, such as data warehousing, distributed systems, and distributed databases.

Inside the Museum Archive Software Project - The database design and code snippets that make this free software application... Inside the Museum Archive Software Project - The database design and code snippets that make this free software application work (Paperback)
Jim Halpin
R508 Discovery Miles 5 080 Ships in 7 - 11 working days

A guide to the design of the Museum Archive software package (available at www.musarch.com), complete with the full database schema and the source code snippets used by the developer. Owners of this book are entitled to a free upgrade to the premium version of the software.

Beginning Oracle SQL (Paperback, 1st ed.): Lex DeHaan, Karen Morton, Tim Gorman, Inger Jorgensen, Daniel Fink, Andrew Morton Beginning Oracle SQL (Paperback, 1st ed.)
Lex DeHaan, Karen Morton, Tim Gorman, Inger Jorgensen, Daniel Fink, …
R1,066 Discovery Miles 10 660 Ships in 7 - 11 working days

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classic Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to coverdevelopments in Oracle's version of the SQL query language. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle database.Takes an example-based approach, with clear and authoritative explanations Introduces both SQL and the query tools used to execute SQL statements Shows how to create tables, populate them with data, and then query that data to generate business results What you'll learn How to create database tables and define their relationships How to add data to your tables, thenchange and delete that data How to write database queries that generate accurate results How to avoid common traps and pitfalls in writing SQL queries How to take advantage of advanced Oracle SQL features such as support for hierarchical queries, analytic and window functions, flashback to a given point in time, and more How to get a handle on Oracle database's support for object types in the database Who this book is for

This book is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed. Table of Contents Relational Database Systems and Oracle Introduction to SQL, AQL*Plus, and SQL Developer Data Definition, Part I Retrieval: The Basics Retrieval: Functions Data Manipulation Data Definition, Part II Retrieval: Multiple Tables and Aggregation Retrieval: Some Advanced Features Views Writing and Automating SQL*Plus Scripts Object-Relational Features

Essential SQL on SQL Server 2008 (Paperback, New edition): Dr Sikha Bagui, Dr Richard Earp Essential SQL on SQL Server 2008 (Paperback, New edition)
Dr Sikha Bagui, Dr Richard Earp
R1,125 Discovery Miles 11 250 Ships in 7 - 11 working days

This Book, Written For Readers Who Have Little Or No Previous Experience With Databases, SQL, Or SQL Server, Provides A Very Systematic Approach To Learning SQL Using SQL Server. Each Chapter Is Written In A Step-By-Step Manner And Has Examples That Can Be Run Using SQL Server. Using The Sample Tables And Data Provided, The Reader Of This Book Will Be Able To Do All The Examples To Experience Hands-On SQL Programming In SQL Server. The Book Also Presents A Series Of Exercises At The End Of The Chapters To Help Readers Gain Proficiency With SQL. With This Book You Will Learn Beginning SQL Commands - How To Retrieve And Manipulate Data Using The Simple SELECT Statement; How To Customize SQL Server 2008'S Settings And About SQL Server 2008'S Functions; How To Create, Alter, Populate And Delete Tables; About Joins, A Common Database Mechanism For Combining Tables; Query Development, The Use Of Views And Other Derived Structures; Simple Set Operations; About Aggregate Functions; How To Write Subqueries And Correlated Subqueries; How To Create And Use Indexes And Constraints; Transaction Processing.

Oracle Performance Survival Guide - A Systematic Approach to Database Optimization (Paperback): Guy Harrison Oracle Performance Survival Guide - A Systematic Approach to Database Optimization (Paperback)
Guy Harrison
R1,428 Discovery Miles 14 280 Ships in 7 - 11 working days

Oracle Performance Survival Guide A Systematic Approach to Database Optimization The fast, complete, start-to-finish guide to optimizing Oracle performance "Oracle Performance Survival Guide" offers a structured, systematic, start-to-finish methodology for optimizing Oracle performance as efficiently as possible. Leading Oracle expert Guy Harrison shows how to maximize your tuning investment by focusing on causes rather than symptoms, and by quickly identifying the areas that deliver the greatest "bang for the buck." Writing for DBAs and developers with all levels of experience, Harrison covers every area of Oracle performance management, from application design through SQL tuning, contention management through memory and physical IO management. He also presents up-to-the-minute guidance for optimizing the performance of the Oracle 11g Release 2. You'll start by mastering Oracle structured performance tuning principles and tools, including techniques for tracing and monitoring Oracle execution. Harrison illuminates the interaction between applications and databases, guides you through choosing tuning tools, and introduces upfront design techniques that lead to higher-performance applications. He also presents a collection of downloadable scripts for reporting on all aspects of database performance. Coverage includes - "Tuning by layers," the most effective, highest-value approach to Oracle performance optimization - Making the most of Oracle's core tools for tracing, monitoring, and diagnosing performance - Highly efficient database logical and physical design, indexing, transaction design, and API use - SQL and PL/SQL tuning, including the use of parallel SQL techniques - Minimizing contention for locks, latches, shared memory, and other database resources - Optimizing memory and physical disk IO - Tuning Real Application Cluster (RAC) databases guyharrison.netinformit.com/ph

Expert SQL Server 2008 Encryption (Paperback, 1st ed.): Michael Coles, Rodney Landrum Expert SQL Server 2008 Encryption (Paperback, 1st ed.)
Michael Coles, Rodney Landrum
R1,058 R827 Discovery Miles 8 270 Save R231 (22%) Ships in 7 - 11 working days

Every day, organizations large and small fall victim to attacks on their data. Encryption provides a shield to help defend against intruders. Because of increasing pressure from government regulators, consumers, and the business community at large, the job descriptions of SQL DBAs and developers are expanding to include encryption. Expert SQL Server 2008 Encryption will show you how to efficiently implement SQL Server 2008 encryption functionality and features to secure your organizational data.Introduces encryption, guiding readers through its implementation in SQL Server Demonstrates advanced techniques such as the use of hardware security modules Covers all that a SQL Server database administrator needs to know about encryption What you'll learn Take advantage of hardware security modules via extensible key management Implement targeted encryption of individual columns Secure an entire database at once with Transparent Data Encryption Encrypt disk volumes using BitLocker encryption Effectively design and manage encryption as part of your total security solution Digitally sign documents stored in your database Who this book is for

The audience for this book includes SQL Server DBAs, SQL developers, and .NET developers who want to take advantage of the powerful encryption functionality available in SQL Server 2008. The features of SQL Server 2008 provide a powerful set of tools to secure your most sensitive data, helping protect it from theft. Table of Contents Introduction to Encryption Encryption Key Management Symmetric Encryption Asymmetric Encryption Extensible Key Management Transparent Data Encryption Hashing SQL CLR Cryptography Indexing Encrypted Data Encrypting Connections to SQL Server 2008 Regulatory Requirements

Beginning SQL Server 2008 Administration (Paperback, 1st ed.): Robert Walters, Grant Fritchey, Carmen Taglienti Beginning SQL Server 2008 Administration (Paperback, 1st ed.)
Robert Walters, Grant Fritchey, Carmen Taglienti
R994 R790 Discovery Miles 7 900 Save R204 (21%) Ships in 7 - 11 working days

Beginning SQL Server 2008 Administration is essential for anyone wishing to learn about implementing and managing SQL Server 2008 database. From college students, to experienced database administrators from other platforms, to those already familiar with SQL Server and wanting to fill in some gaps of knowledge, this book will bring all readers up to speed on the enterprise platform Microsoft SQL Server 2008.Clearly describes relational database concepts Explains the SQL Server database engine and supporting tools Shows various database maintenance scenarios What you'll learn To understand core concepts of relational databases How to install SQL Server in your environment How to use the tools that come with SQL Server to perform daily administrative tasks How to design and implement a database maintenance plan in SQL Server Configuring database security and protect your sensitive data from intruders How to meet regulatory and government compliance requirements like Sarbanes-Oxley and the Payment Card Industry (PCI) regulations Who this book is for

This book is primarily for those who are aspiring to become SQL Server 2008 database administrators. Reading this book gives you a great foundation of knowledge upon which to build a future career in database administration. You might be new to SQL Server 2008, or you might have experience with competing products such as Oracle. Either way, this book gets you up to speed quickly in managing SQL Server 2008, helping you transfer your existing knowledge into the SQL Server 2008 environment. Table of Contents The Database Administration Profession Planning and Installing SQL Server 2008 What's in the Toolbox? Creating Tables and Other Objects Transact-SQL SQL Server Internals Storage Management Strategies Database Backup Strategies Database Restore Strategies Common Database Maintenance Tasks Automation Through SQLCMD and PowerShell Database Maintenance Plans Performance Tuning and Optimization SQL Server Security Auditing, Encryption, and Compliance SQL Server in the Enterprise Where to Go Next?

Pro SQL Server 2008 Mirroring (Paperback, 1st ed.): Robert Davis, Ken Simmons Pro SQL Server 2008 Mirroring (Paperback, 1st ed.)
Robert Davis, Ken Simmons
R1,246 Discovery Miles 12 460 Ships in 7 - 11 working days

Pro SQL Server 2008 Mirroring is your complete guide to planning, using, deploying, and maintaining database mirroring as a high-availability option. Mirroring protects you by maintaining one or more duplicate copies of your database for use in the event the primary copy is damaged. It is a key component of any production-level, high-availability solution. This book covers the full spectrum of database mirroring, taking you from the planning phase through the implementation to the maintenance phase and beyond.Easy to follow, step-by-step instructions for beginner and intermediate users In-depth, detailed information for advanced and expert users Covers all phases of database mirroring from planning to sustained maintenance What you'll learn Plan effectively for database mirroring. Learn what questions to ask and what problems to anticipate Get step-by-step instructions on how to set up database mirroring Automate the initial setup and the ongoing maintenance of mirrored databases Monitor database mirroring, detect failures, and generate automated alerts Build a system that automatically responds to and fixes common problems Build in support for the missing facets of database mirroring, such as support for cross-database dependencies Define groups of databases that all fail over together to their mirrors when just one of those databases fails Create operational processes so that even nontechnical staff can manage mirrored databases Who this book is for

General audience: Pro SQL Server 2008 Database Mirroring is aimed at SQL Server 2008 database administrators, and especially those who desire to mirror their databases in support of high availability. System administrators and operational engineers who manage Windows Server systems that support mirrored database environments will also find much in the book of interest. Table of Contents High Availability Options Database Mirroring Overview Planning and Best Practices Database Mirroring Setup Automating Setup Maintenance Simplified Monitoring and Alerting Upgrading to SQL Server 2008 Reporting Considerations Planning for Failure

Beginning T-SQL 2008 (Paperback, 1st ed.): Kathi Kellenberger Beginning T-SQL 2008 (Paperback, 1st ed.)
Kathi Kellenberger
R874 R696 Discovery Miles 6 960 Save R178 (20%) Ships in 7 - 11 working days

Even if you have little or no knowledge of T-SQL, Beginning T-SQL 2008 will bring you up to intermediate level and teach you best practices along the way. You'll learn how to write code that will help you to achieve the best-performing applications possible.

You'll find an introduction to databases, normalization, and SQL Server Management Studio. You'll understand how data is stored in a database and learn how to use at least one of the available tools to get to that data.

Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises are included in each chapter because the only way to learn T-SQL is to write some code.

This book will do more than just give the syntax and examples. It will teach you techniques to help you avoid common errors and create robust and well-performing code.Imparts best practices for writing T-SQL Helps readers avoid common errors Shows how to write scalable code that yields good performance What you'll learn Understand the fundamentals of relational theory, upon which Transact-SQL is based Write accurate queries that are scalable and perform well Combine set-based and procedural processing, obtaining the best from both worlds Embed business logic in your database through stored procedures and functions Simplify your work through new and advanced features such as common-table expressions and virtual tables Enhance performance by knowing when to apply features such table value parameters Who this book is for

This book is for developers who will be writing database applications against SQL Server databases. Table of Contents Getting Started Writing Simple SELECT Queries Using Functions and Expressions Querying Multiple Tables Grouping and Summarizing Data Manipulating Data Understanding T-SQL Programming Logic Moving Logic to the Database Working with New Data Types Writing Advanced Queries Where to Go Next?

Free Delivery
Pinterest Twitter Facebook Google+
You may like...
Professional Microsoft SQL Server 2016…
Paul Turley Paperback R1,146 R814 Discovery Miles 8 140
Oracle Business Process Management Suite…
Manoj Das, Manas Deb, … Paperback R1,343 R1,059 Discovery Miles 10 590
Microsoft Access 2010 - Comprehensive…
Gary Shelly, Philip Pratt, … Paperback R1,013 R870 Discovery Miles 8 700
Shelly Cashman Series Microsoft Office…
Philip Pratt, Mary Last Paperback R972 R838 Discovery Miles 8 380
Database Systems: Pearson New…
Hector Garcia-Molina, Jeffrey Ullman, … Paperback R1,722 Discovery Miles 17 220
Oracle Database 10g RMAN Backup…
Matthew Hart, Robert Freeman Paperback R1,443 R1,133 Discovery Miles 11 330
New Perspectives Microsoft Office 365…
Mark Shellman, Sasha Vodnik Paperback R970 R836 Discovery Miles 8 360
Oracle Database Administration for…
Michelle Malcher Paperback R1,048 R818 Discovery Miles 8 180
Access 2019 Bible
Michael Alexander, Richard Kusleika Paperback  (1)
R1,325 R843 Discovery Miles 8 430
Oracle Database 10g Real Application…
K. Gopalakrishnan Paperback R1,323 R1,024 Discovery Miles 10 240