This database design and database management site aims to provide book reviews and free ebook on oracle, pl sql, dba, sqlplus, mysql sql, php my sql, my sql tutorial, ms sql tutorial, db2 database, db2 tutorial, sybase sql,sysbase tutorial, Access tutorial, data mining, data modelling, data warehousing, and information retrieval, etc

Sams Teach Yourself SQL in 24 Hours

By Ron Plew and Ryan Stephens
Who Should Read This Book?
Welcome to the world of relational databases and SQL! This book is written for those self-motivated individuals out there who would like to get an edge on relational database technology by learning the Structured Query LanguageSQL. This book was written primarily for those with very little or no experience with relational database management systems using SQL. This book also applies to those who have some experience with relational databases but need to learn how to navigate within the database, issue queries against the database, build database structures, manipulate data in the database, and more. This book is not geared toward individuals with significant relational database experience who have been using SQL on a regular basis.
What This Book Intends to Accomplish
This book was written for individuals with little or no experience using SQL or those who have used a relational database, but their tasks have been very limited within the realm of SQL. Keeping this thought in mind, it should be noted up front that this book is strictly a learning mechanism, and one in which we present the material from ground zero and provide examples and exercises with which to begin to apply the material covered. This book is not a complete SQL reference and should not be relied on as a sole reference of SQL. However, this book combined with a complete SQL command reference could serve as a complete solution source to all of your SQL needs.
What We Added to This Edition
This edition contains the same content and format as the first and second editions. We have been through the entire book, searching for the little things that could be improved to produce a better edition. We have also added concepts and commands from the new SQL standard, SQL3, to bring this book up to date, making it more complete and applicable to today's SQL user. The most important addition was the use of MySQL for hands-on exercises. By using an open source database such as MySQL, all readers have equal opportunity for participation in hands-on exercises.
What You Need
You may be wondering, what do I need to make this book work for me? Theoretically, you should be able to pick up this book, study the material for the current hour, study the examples, and either write out the exercises or run them on a relational database server. However, it would be to your benefit to have access to a relational database system to which to apply the material in each lesson. The relational database to which you have access is not a major factor because SQL is the standard language for all relational databases. Some database systems that you can use include Oracle, Sybase, Informix, Microsoft SQL Server, Microsoft Access, MySQL, and dBASE.

Sams Teach Yourself Microsoft SQL Server 7 in 21 Days

By Richard Waymire and Rick Sawtell
Welcome to Sams Teach Yourself Microsoft SQL Server 7.0 in 21 Days. We hope this book will help not only teach you about SQL Server but also prove valuable for everyday work involving SQL Server. We have worked hard to see that the skills you learn from this book will easily translate into real-world methods and solutions.
There are certain skills you need to successfully install, administer, troubleshoot, and configure SQL Server. The kinds of skills you must know can be divided into two general categories:
  • SQL Server programmer
  • SQL Server administrator

Note
In a small company, the developer, programmer, and administrator might be the same person; large companies usually have the functions separate.

A SQL Server developer is generally responsible for designing, programming, and populating the database. Sams Teach Yourself Transact-SQL in 21 Days is a great place to start for beginning SQL programmers. After the database has been created, responsibility for the database is often turned over to an administrator, who takes care of the ongoing maintenance.

A SQL Server administrator is usually responsible for the day-to-day administration of the database. This book is designed more for administrators, although many lessons apply to programmers as well. Although some administrators might never have to do any SQL programming, we have these lessons in enough detail so that administrators can begin to pick up on SQL programming if they want to. Programming tasks covered here relate to skills administrators might be called on to perform—such as creating tables, creating indexes, and writing complex queries.

Click to Read More

Up and Running with DB2 UDB ESE: Partitioning for Performance in an e-Business Intelligence World

Data warehouses in the 1990s were for the privileged few business analysts. Business Intelligence is now being democratized by being shared with the rank and file employee demanding higher levels of RDBMS scalability and ease of use, being delivered through Web portals.
To support this emerging e-Business Intelligence world, the challenges that face the enterprises for their centralized data warehouse RDBMS technology are scalability, performance, availability and smart manageability.
This IBM Redbook focuses on the innovative technical functionalities of DB2 UDB ESE V8.1 and discusses:
  • Guidelines on building the large database and determining the number of partitions
  • Bulk load using the new multipartition load
  • Performance enhancements using MultiDimensional Clustering and Materialized Query Tables.
  • Availability through the new online utilities
  • Self Managing And Resource Tuning features
  • Migration scenarios

This book positions the new functionalities, so you can understand and evaluate their applicability in your own enterprise data warehouse environment, and get started prioritizing and implementing them.

Click to Download

Data Modeling Techniques for Data Warehousing

This redbook gives detail coverage to the topic of data modeling techniques for data warehousing, within the context of the overall data warehouse development process.
The process of data warehouse modeling, including the steps required before and after the actual modeling step, is discussed. Detailed coverage of modeling techniques is presented in an evolutionary way through a gradual, but well-managed, expansion of the content of the actual data model.
Coverage is also given to other important aspects of data warehousing that affect, or are affected by, the modeling process. These include architecting the warehouse and populating the data warehouse.
Guidelines for selecting a data modeling tool that is appropriate for data warehousing are presented.

Information Retrieval

By C. J. van RIJSBERGEN
The material of this book is aimed at advanced undergraduate information (or computer) science students, postgraduate library science students, and research workers in the field of IR. Some of the chapters, particular chapter 6 (this became chapter 7 in the second edition), make simple use of a little advanced mathematics. However, the necessary mathematical tools can be easily mastered from numerous mathematical texts that now exist and, in any case, references have been given where the mathematics occur.
Information retrieval is a wide, often loosely-defined term but in these pages I shall be concerned only with automatic information retrieval systems. Automatic as opposed to manual and information as opposed to data or fact. Unfortunately the word information can be very misleading. In the context of information retrieval (IR), information, in the technical meaning given in Shannon's theory of communication, is not readily measured (Shannon and Weaver). In fact, in many cases one can adequately describe the kind of retrieval by simply substituting 'document' for 'information'. Nevertheless, 'information retrieval' has become accepted as a description of the kind of work published by Cleverdon, Salton, Sparck Jones, Lancaster and others. A perfectly straightforward definition along these lines is given by Lancaster: 'Information retrieval is the term conventionally, though somewhat inaccurately, applied to the type of activity discussed in this volume. An information retrieval system does not inform (i.e. change the knowledge of) the user on the subject of his inquiry. It merely informs on the existence (or non-existence) and whereabouts of documents relating to his request.' This specifically excludes Question-Answering systems as typified by Winograd and those described by Minsky. It also excludes data retrieval systems such as used by, say, the stock exchange for on-line quotations.

ORACLE Documentation (Absolute Unique Library)

This page contains links to the most current documentation for Oracle Database, Application Server, Developer Suite, Collaboration Suite and Applications/E-Business Suite.

Database

Oracle Database 10g Release 2
Oracle Gateways 10g Release 2
Oracle Database Lite 10g Release 2
Oracle Content Database 10g Release 1
Oracle Database 10g Release 1
Oracle Gateways 10g Release 1
Oracle9i Database Release 2
Oracle9i Database Release 1
Oracle Gateways for Oracle9i (Rel. 1&2)
Oracle interMedia
Oracle Spatial
Oracle Fail Safe
Oracle TimesTen In-Memory Database
Oracle Berkeley DB
Oracle Berkeley DB Java Edition
Oracle Berkeley DB XML
Oracle 10g R2 Lite
Oracle 9i Lite
Oracle Secure Backup
Oracle Application Express

Enterprise Management

Oracle Enterprise Manager 10g Release 3 (10.2)
Oracle Enterprise Manager 10g Release 1 (10.1)
Oracle Enterprise Manager Release 2.(9.2)
Oracle Enterprise Manager (Rel. 9.0.2 & 9.0.1)

Secure Enterprise Search

Oracle Secure Enterprise Search 10g

Tape Backup

Oracle Secure Backup

Technologies / Utilities

BLAF
Oracle Configuration Manager
Oracle Help Technologies
Oracle JSP Engine
Oracle Migration Tools
Oracle ODBC Drivers

Applications

E-Business Suite

Applications Releases 11i and 12

PeopleSoft Enterprise
PeopleSoft Enterprise
Archive PeopleSoft Enterprise

JD Edwards EnterpriseOne
JD Edwards EnterpriseOne
Archive JD Edwards EnterpriseOne

Oracle Retail
Oracle Retail

Siebel Applications
Siebel Applications
Siebel Integrations

Other Applications
Oracle Transportation Management (OTM) 5.5
Oracle Transportation Management (G-Log GC3) 5.0
Pharmeceutical
Oracle Demantra
Oracle Workforce Scheduling

Middleware

Application Server

Oracle Identity Management 10g (10.1.4)
Oracle Application Server 10g Release 3 (10.1.3.2)
Oracle Application Server 10g Release 3 (10.1.3.1)
Oracle Application Server 10g Release 3 (10.1.3)
Oracle Application Server 10g Release 2 (10.1.2.0.2)
Oracle Application Server 10g Release 2 (10.1.2)
Oracle Content Management SDK, 10g (9.0.4.2)
Oracle Application Server Release 10g (9.0.4)
Oracle Content Management SDK, 10g (9.0.4)
Oracle Forms 10g (10.1.2 and 9.0.4) and Oracle9i Forms (9.0.2)
Oracle9i Application Server Release 2
Oracle Content Management SDK
Oracle9i Application Server Release 1
Oracle Internet File System
Oracle Identity Manager
Internet Application Server 8i

Oracle Collaboration Suite

Oracle Collaboration Suite 10g Release 1
Oracle Collaboration Suite Release 2
Oracle Collaboration Suite Release 1

Development Tools

Oracle Developer Suite Release 10g Release 2
Oracle Developer Suite Release 10g
Oracle9i Developer Suite Release 2
Oracle9i JDeveloper
Oracle9i Developer Suite Release 1
Oracle9i Internet Developer Suite Release 1.0.2.4.1
Internet Developer Suite Release 1.0.1
Internet Developer Suite Release 1.0
Oracle Designer
Oracle SCM (Repository)
Oracle Reports
Oracle Forms

Data Warehousing and Business Intelligence

Oracle Business Intelligence
Oracle Business Intelligence Standard Edition
Oracle Business Intelligence Enterprise Edition
Oracle Business Intelligence Applications
Oracle BI Beans
Oracle Data Mining
Oracle OLAP
Oracle Warehouse Builder
Oracle Discoverer
Oracle Express Analyzer/Objects
Oracle Express Server
Oracle Express Web Agent
Oracle Data Mart Suite
Oracle Financial Analyzer
Oracle Reports

On Demand
Oracle E-Business Suite On Demand
Oracle Technology On Demand

Previously Released Oracle Documentation

Database

Oracle8i Database
Oracle8i Database Release 8.1.7
Oracle8i Database Release 8.1.6
Oracle8i Database Release 8.1.5
Oracle8 Database
Oracle8 Database Release 8.0.6
Oracle8 Database Release 8.0.5
Oracle8 Database Release 8.0.4
Oracle7 Release 7.3.4
Oracle Enterprise Manager and Management Packs
Release 2.x
Release 1.x
Oracle Gateways
Oracle Rdb

Data Warehousing and Business Intelligence

Oracle Reports
Oracle Darwin

Application Server

Oracle Application Server
Oracle Forms Services
Oracle Forms 6i
Oracle Forms Archive
Oracle Portal
Oracle9iAS Portal Center
Oracle9iAS Clickstream Intelligence
Oracle9iAS Personalization
Oracle Internet File System
Oracle Unified Messaging
Oracle Internet Directory
Oracle eMail Server
Oracle8i and 9iAS Appliance

Oracle Database 10g Release 1 (10.1) Documentation Library

Welcome to the Oracle Database 10g Documentation Library. Here you can research new information, look up reference information, and search across the entire library.
Getting Started
These books provide background information for new users:
2 Day DBA HTML PDF
Concepts HTML PDF
Administrator's Guide HTML PDF
Master Glossary HTML
Most Popular
These books contain the most commonly used information for general database administration and application development:
2 Day DBA HTML PDF
Concepts HTML PDF
Administrator's Guide HTML PDF
Application Developer's Guide - Fundamentals HTML PDF
Reference HTML PDF
Performance Tuning Guide HTML PDF
PL/SQL User's Guide and Reference HTML PDF
SQL Reference HTML PDF
Upgrade Information
If you are familiar with earlier Oracle releases and are moving to Oracle Database 10g, these books describe the new features, and explain how to upgrade your database.
New Features Guide HTML PDF
Upgrade Guide HTML PDF
License Information
This book explains how certain database features are licensed:
Licensing Information HTML PDF
Companion CD Installation Guides
The Companion CD Installation Guides cover the software other than the main database server. This software works in conjunction with the database, and requires a separate, optional installation. Again, there is a set of Quick Installation Guides for typical scenarios, and a full Installation Guide for advanced scenarios.
Companion CD Installation Guide for 64-Bit WindowsHTML PDF
Companion CD Installation Guide for Linux x86-64 HTML PDF
Companion CD Installation Guide for UNIX Systems HTML PDF
Companion CD Installation Guide for Windows HTML PDF
Companion CD Quick Installation Guide for 64-Bit Windows HTML PDF
Companion CD Quick Installation Guide for AIX-Based Systems HTML PDF
Companion CD Quick Installation Guide for HP Tru64 UNIX HTML PDF
Companion CD Quick Installation Guide for HP-UX PA-RISC (64-Bit) HTML PDF
Companion CD Quick Installation Guide for Linux x86 HTML PDF
Companion CD Quick Installation Guide for Linux x86-64 HTML PDF
Companion CD Quick Installation Guide for Solaris Operating System (SPARC) HTML PDF
Companion CD Quick Installation Guide for Windows HTML PDF
Quick Installation Guides
The Quick Installation Guides cover the basics of installing on a clean machine, using a specific operating system.
Quick Installation Guide for 64-Bit Windows HTML PDF
Quick Installation Guide for AIX-Based Systems HTML PDF
Quick Installation Guide for HP Tru64 UNIX HTML PDF
Quick Installation Guide for HP-UX PA-RISC (64-Bit) HTML PDF
Quick Installation Guide for Linux x86 HTML PDF
Quick Installation Guide for Linux x86-64 HTML PDF
Quick Installation Guide for Solaris Operating System (SPARC) HTML PDF
Quick Installation Guide for Windows HTML PDF
Real Application Clusters Quick Installation Guide for Oracle Database Standard Edition for Windows HTML PDF
Installation Guides
The full Installation Guides cover a wide variety of installation scenarios. Use them if your situation is not covered in the Quick Installation Guides.
Enterprise Manager Grid Control Installation and Basic Configuration HTML PDF
Installation Guide for 64-Bit Windows HTML PDF
Installation Guide for Linux x86-64 HTML PDF
Installation Guide for UNIX Systems HTML PDF
Installation Guide for Windows HTML PDF
Procedural Gateway for APPC Installation and Configuration Guide for Microsoft Windows HTML PDF
Real Application Clusters Installation and Configuration for All Platforms HTML PDF
Real Application Clusters Installation and Configuration for Linux x86-64 HTML PDF
Transparent Gateway for DRDA Installation and User's Guide for Microsoft Windows HTML PDF
Universal Installer Concepts Guide HTML PDF
Client Installation Guides
The Client Installation Guides cover the simplified install for just the Oracle client software, which lets you connect to a database running on a different system, using a database application or the interactive SQL*Plus tool. Again, there is a set of Quick Installation Guides for typical scenarios, and a full Installation Guide for advanced scenarios.
Client Installation Guide for 64-Bit Windows HTML PDF
Client Installation Guide for Linux x86-64 HTML PDF
Client Installation Guide for UNIX Systems HTML PDF
Client Installation Guide for Windows HTML PDF
Client Quick Installation Guide for 64-Bit Windows HTML PDF
Client Quick Installation Guide for AIX-Based Systems HTML PDF
Client Quick Installation Guide for HP-UX PA-RISC (64-Bit) HTML PDF
Client Quick Installation Guide for Linux x86 HTML PDF
Client Quick Installation Guide for Linux x86-64 HTML PDF
Client Quick Installation Guide for Solaris Operating System (SPARC) HTML PDF
Client Quick Installation Guide for Windows HTML PDF
Client Quick Installation Guide HP Tru64 UNIX HTML PDF

Teach Yourself Oracle 8 In 21 Days

By Edward Whalen
Contributing Author: Steve Adrien DeLuca
I have worked with Oracle for many years. Every time a new version is released or a new problem crops up, I am rejuvenated; I become excited about working with Oracle again. I want to share this enthusiasm with you, and I hope that after you become familiar with Oracle, more and more aspects of the Oracle RDBMS will interest you. The most important thing is that you enjoy what you are doing; I hope that you enjoy working with Oracle as much as I do.
The Oracle RDBMS is an enormous environment with unlimited potential. When you start working with Oracle, you might find it overwhelming. Don't give up; you will see how the different components work together as you learn about the Oracle RDBMS. Rarely do I undertake a project without learning something new about Oracle.
This book is designed for inexperienced Oracle users. Experienced Oracle DBAs will likely find this book too elementary. Most of the lessons are designed to step the reader through specific administrative and user tasks.
The best way to use this book is to read each lesson, then practice the techniques and tasks outlined in that lesson. Each lesson covers a single topic, so some lessons might be longer than others. If you complete one lesson per day, you can easily complete the full course in three weeks.
At the end of each lesson, you'll find a series of questions and answers. These questions are designed to point out some of the key concepts that were covered in the lesson. Following the Q&A section, you'll find a series of quiz questions that focus on techniques and tasks covered in the lesson. Each lesson also includes a series of exercises that are intended to familiarize you with some of the key tasks covered in that lesson.

Microsoft® Access 97 Quick Reference

By Rick Winter
The Microsoft Access 97 Quick Reference is the latest in a series of comprehensive, task-oriented references and details how to use the features and functionality of Access 97. Compiled for the intermediate-to-advanced user who wants a concise, comprehensive reference, the Microsoft Access 97 Quick Reference is loaded with detailed instructions outlining important tasks you need to complete.
The Microsoft Access 97 Quick Reference presents the tasks and functions most often sought by users of Access 97. The book also includes a comprehensive glossary with many terms and definitions that refer to the newest features in Access 97.
The Microsoft Access 97 Quick Reference is written for casual to advanced computer users who need a fast reference to Access 97 tasks, functions, and features. It is an ideal companion to Que's Special Edition Using Microsoft Access 97. The Quick Reference size makes it ideal for travel.
If you are upgrading from Access 95 or Access 2, you will find this reference useful for finding new features and looking up new ways of getting a job done. If you are converting from other field data types--for example, dBASE, Paradox, or Btrieve--this Quick Reference might be the right amount of instruction you need to transfer your know-how investment to new products.
As a reference, this book is not intended to tutor learners. If you are just starting to use Access software for the first time, or are a very casual user, you might want to consider Que's User-Friendly Using Microsoft Access 97 or The Complete Idiot's Guide to Microsoft Access 97 as a book to get you up to speed. For beginner or very casual task reference, check out Que's Easy Microsoft Access 97. If you want the most complete reference as well as tutorial and foundation information, then you need Que's Special Edition Using Microsoft Access 97. This Microsoft Access 97 Quick Reference makes an ideal companion to the comprehensive Special Edition.

Popular Posts

Followers

Search for unlisted Ebooks