Author : Joan Casteel
Publisher : Course Technology
Page : 608 pages
File Size : 32,52 MB
Release : 2014-06-25
Category : Computers
ISBN : 9781305268029
ORACLE 11G: SQL is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle.
Author : Mark Scardina
Publisher : McGraw Hill Professional
Page : 601 pages
File Size : 29,79 MB
Release : 2004-07-19
Category : Computers
ISBN : 0071705341
Written by members of the Oracle XML group, this is a must-have reference for all IT managers, DBAs, and developers who want to learn the best practices for using XML with Oracle’s XML-enabled products. Includes real-world case studies based on the authors’ experience managing Oracle’s XML Discussion Forum--a community of 20,000+ XML component users.
Author : Ian Abramson
Publisher : McGraw-Hill Companies
Page : 430 pages
File Size : 49,51 MB
Release : 2004
Category : Computers
ISBN :
Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.
Author : K Gopalakrishnan
Publisher : McGraw Hill Professional
Page : 546 pages
File Size : 22,40 MB
Release : 2011-08-10
Category : Computers
ISBN : 0071752625
Master Oracle Real Application Clusters Maintain a dynamic enterprise computing infrastructure with expert instruction from an Oracle ACE. Oracle Database 11g Oracle Real Application Clusters Handbook, Second Edition has been fully revised and updated to cover the latest tools and features. Find out how to prepare your hardware, deploy Oracle Real Application Clusters, optimize data integrity, and integrate seamless failover protection. Troubleshooting, performance tuning, and application development are also discussed in this comprehensive Oracle Press guide. Install and configure Oracle Real Application Clusters Configure and manage diskgroups using Oracle Automatic Storage Management Work with services, voting disks, and Oracle Clusterware Repository Look under the hood of the Cache Fusion and Global Resource Directory operations in Oracle Real Applications Clusters Explore the internal workings of backup and recovery in Oracle Real Application Clusters Employ workload balancing and the Transparent Application Failover feature of an Oracle database Get complete coverage of Stretch Clusters, also known as Metro Clusters Troubleshoot Oracle Clusterware using the most advanced diagnostics available Develop custom Oracle Real Application Clusters applications
Author : Gavin JT Powell
Publisher : Elsevier
Page : 683 pages
File Size : 25,76 MB
Release : 2004-10-15
Category : Computers
ISBN : 0080479839
Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL.* Each of the hundreds of SQL code examples was tested on a working Oracle 10g database* Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code* Authors have four decades of commercial experience between them as developers and database administrators
Author : Richard Earp
Publisher : Wordware
Page : 397 pages
File Size : 47,80 MB
Release : 2006
Category : Computers
ISBN : 1598220217
Designed To Exploit Oracle 10G's SQL, This Book Takes A Comprehensive Look At Oracle 10G's Analytical Functions, MODEL Statements, And Regular Expressions. In Addition, The Book Covers Collection Objects And Object-Oriented Structures And Introduces New Oracle 10G Topics Such As XML And Statistical Functions. The Authors' Logical And Developmental Approach To Query Building Includes A Review Of Older Oracle Tools To Help In The Transition To Newer Material. This Text Will Teach The Reader How To Format Result Sets With SQL*Plus Reporting Tools; Use Aggregate Functions For Partitioning, Ordering, And Reporting; Perform Calculations With The MODEL Statement; Search Within Strings Using Regular Expressions; Work With Collection Objects; Handle XML Within SQL.
Author : Kevin Loney
Publisher : McGraw Hill Professional
Page : 737 pages
File Size : 35,81 MB
Release : 2005-04-14
Category : Computers
ISBN : 0071770437
Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it’s been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author.
Author : Gavin JT Powell
Publisher : Elsevier
Page : 499 pages
File Size : 33,47 MB
Release : 2011-04-08
Category : Computers
ISBN : 008045917X
"This book should satisfy those who want a different perspective than the official Oracle documentation. It will cover all important aspects of a data warehouse while giving the necessary examples to make the reading a lively experience. - Tim Donar, Author and Systems Architect for Enterprise Data WarehousesTuning a data warehouse database focuses on large transactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network and Internet environment, backwards and forwards, constantly! The ultimate objective of a data warehouse is the production of meaningful and useful reporting, from historical and archived data. The trick is to make the reports print within an acceptable time frame.A data model contains tables and relationships between tables. Tuning a data model involves Normalization and Denormalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.* Takes users beyond basics to critical issues in running most efficient data warehouse applications* Illustrates how to keep data going in and out in the most productive way possible* Focus is placed on Data Warehouse performance tuning
Author : Sam Alapati
Publisher : Apress
Page : 1285 pages
File Size : 49,43 MB
Release : 2006-11-22
Category : Computers
ISBN : 1430200669
*One-stop reference for administration and management of Oracle 10g Database *9i predecessor was a best seller; this edition covers all new features, with fully field-tested examples—not just "showcase" examples *Contains essential primers on Unix, Linux and Windows NT management and on SQL and PL/SQL programming; ideal for new/aspiring DBAs
Author : Joan Casteel
Publisher : Course Technology Ptr
Page : 508 pages
File Size : 31,38 MB
Release : 2007
Category : Computers
ISBN : 9781423901365
Learn how to use the PL/SQL programming language effectively, using one of the most popular and widely-used software programs in large companies today. Oracle 10g Developer: PL/SQL Programming uses Oracle 10g to provide an overview of the PL/SQL programming language, beginning with fundamental PL/SQL concepts and progressing to the writing and testing of PL/SQL code. The book then progresses to more advanced topics, such as Dynamic SQL and code tuning. Updated to the latest release, Oracle 10g, it uses the developer's perspective to focus on the PL/SQL component of the software. With real-world examples and a straightforward writing style, this is a valuable resource for anyone preparing for the new Oracle Certification exam, or simply looking to master the PL/SQL programming language with Oracle.
