IGNOU REFERRED BOOKS

1. Fundamentals of Database Systems, Elmasri, Ramez, Navathe Shamkant B, Fourth Edition, Pearson Education, India, 2004 [download]

2. Database System Concepts, Silberschatz A., Korth Henry F., S.Sudarshan, Fifth Edition, McGraw Hill, 2006. [download]

3. An Introduction to Database Systems, Date C.J., 7th / 8th edition, Addison Wesley, 2006. [download]

If you have broadband, download some great lecture videos and other materials on Advanced DBMS from here (requires Real Player)-

http://aduni.org/courses/databases/index.php?view=cw

OR

http://www.archive.org/details/arsdigita_10_databases

Also, a streaming video tutorial on DBMS is available at http://www.course.com/downloads/mis/robcor.../DBMS/DBMS.html

Database System Concepts



Publisher McGraw-Hill/Osborne
Author(s) Abraham Silberschatz
ISBN 007120489X
Release Date 29 June 2007

Download here

I got a software to work on oracle/ sql...size is 10 mb.... can anyone check how it is......I think it needs some connectivity with the host machine so may be its not useful for us.......http://rapidshare.com/files/42667421/orclfac_ru.rar

I downloaded and installed the software and it seems that this is a nice GUI tool to visually as well as manually build SQL queries in Oracle. However, I do not have Oracle installed. I plan to install Oracle 10g soon. I have tested similar tools in MySQL which I installed in my computer since I am doing my project using PHP/MySQL and these types of tools are quite handy in building queries visually without writing actual SQL.

So far as Oracle 10g is concerned (11g is also coming up), one can download it from the Oracle website for free. First, view a comparison of the editions in this page - http://www.oracle.com/database/product_editions.html .

Here are the download pages for the various editions under Windows:




1. Oracle Database 10g Release 2 (10.2.0.1)
Express Edition for Microsoft Windows (165 MB)
Download from here

2. Oracle Database 10g Release 2 (10.2.0.1.0)
Enterprise/Standard Edition for Microsoft Windows (32-bit) (1.2 GB)
Download from here

If you want the older version, i.e. Oracle 9i, you can download it from here

Some further links:

Documentation
Oracle by Example : Hands on Tutorial R.2
Oracle Instant Client
Oracle 10g for Linux
Oracle Application Server 10g
Oracle+PHP
Sample Codes

A book by Author(s) Abraham Silberschatz's link is expired can anyone upload the new link or if any one has then do upload at filexoom in pieces..........

I have updated the link for Silberschatz's book. However, don't try filexoom for some days. They are changing servers and so the files/accounts are unavailable for now.

Microsoft SQL Server 2005

You can download the Microsoft SQL Server 2005 Express Edition from this page - http://www.microsoft.com/downloads/details...&displaylang=en

System Requirements

Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows XP Service Pack 2
Computer with Intel or compatible Pentium III 600 MHz or faster processor (1 GHz or faster is recommended.)
Minimum of 192 MB of RAM (512 MB or more is recommended.)
525 MB of available hard disk space

Hi

Please refer following url. It's a good one for the new commer too,

"http://www.prongs.org/linux/oracle/"

Hi

Improve your database knowledge....

Enjoy...

Oracle Database 11g DBA Handbook





This essential resource for Oracle DBAs has been completely updated to cover the new features of Oracle Database 11g, the industry standard Web-enabled enterprise database system. Oracle Database 11g DBA Handbook details each topic with an emphasis on the big picture, enabling you to achieve effective and efficient database management.

You will learn to get up-and-running on Oracle Database 11g, develop and implement applications, manage storage space, and create reliable system backups. New and revised sections cover high availability, performance optimization, information management, and security procedures. Real-world examples and case studies illustrate each concept along the way.


Download

Pass: knowfree.net

Expert MySQL - Apress






Since the enormous number of new features made available with MySQL release 5.0, MySQL has been gaining steam as a viable alternative to database behemoths like Oracle and IBM DB2. MySQL users now have the ability to extend MySQL with new SQL commands, optimize query execution, and embed MySQL within low-resource environments like embedded devices and kiosks.

Expert MySQL, by Dr. Charles A. Bell, is the first book to examine these opportunities in detail, showing you how to wield maximum control over this powerful open source database. You'll learn how to create your own custom storage handlers, ensuring maximum flexibility and speed within your specialized applications. You'll also gain valuable insight into MySQL's architecture and learn how to tweak its behavior through custom changes to the source code.


Download


Password: knowfree.net

Practical Oracle Security




This is the only practical, hands-on guide available to database administrators to secure their Oracle databases. This book will help the DBA to assess their current level of risk as well as their existing security posture. It will then provide practical, applicable knowledge to appropriately secure the Oracle database. The books companion Web site contains dozens of working scripts that DBAs can use to secure and automate their Oracle databases.

* The only practical, hands-on guide for securing your Oracle database published by independent experts.

* Companion Web site contains dozens of scripts to help you automate security tasks.

* Your Oracle database does not exist in a vacuum, so this book shows you how to securely integrate your database into your enterprise.



Download


Password: knowfree.net

Oracle Database 11g SQL





Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.

* Explore SQL Plus and SQL Developer
* Use SQL SELECT, INSERT, UPDATE, and DELETE statements
* Write PL/SQL programs
* Create tables, sequences, indexes, views, and triggers
* Write advanced queries containing complex analytical functions
* Create database objects and collections to handle abstract data
* Use large objects to handle multimedia files containing music and movies
* Write Java programs to access an Oracle Database using JDBC
* Tune your SQL statements to make them execute faster
* Explore the XML capabilities of the Oracle Database
* Master the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more


Download

Password: knowfree.net

Research And Trends In Data Mining Technologies And Applications







Activities in data warehousing and mining are constantly emerging. Data mining methods, algorithms, online analytical processes, data mart and practical issues consistently evolve, providing a challenge for professionals in the field. Research and Trends in Data Mining Technologies and Applications focuses on the integration between the fields of data warehousing and data mining, with emphasis on the applicability to real-world problems. This book provides an international perspective, highlighting solutions to some of researchers’ toughest challenges. Developments in the knowledge discovery process, data models, structures, and design serve as answers and solutions to these emerging challenges.


TABLE OF CONTENT:
Chapter 01 - Combining Data Warehousing and Data Mining Techniques for Web Log Analysis
Chapter 02 - Computing Dense Cubes Embedded in Sparse Data
Chapter 03 - Exploring Similarities Across High-Dimensional Datasets
Chapter 04 - Pattern Comparison in Data Mining: A Survey
Chapter 05 - Mining Frequent Patterns Using Self-Organizing Map
Chapter 06 - An Efficient Compression Technique for Vertical Mining Methods
Chapter 07 - A Tutorial on Hierachical Classification with Applications in Bioinformatics
Chapter 08 - Topological Analysis and Sub-Network Mining of Protein-Protein Interactions
Chapter 09 - Introduction to Data Mining Techniques via Multiple Criteria Optimization Approaches and Applications
Chapter 10 - Linguistic Rule Extraction from Support Vector Machine Classifiers
Chapter 11 - Graph-Based Data Mining
Chapter 12 - Facilitating and Improving the Use of Web Services with Data Mining


Download

Password:knowfree.net

Database Systems: Design, Implementation and Management, Sixth Edition

download

Check these first two ignou blocks

check these last two ignou blocks

SQL: A BEGINNER'S GUIDE 3/E

Product Description

Essential Skills–Made Easy!

Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A Beginner’s Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g.

Designed for Easy Learning:

*
Key Skills & Concepts–Lists of specific skills covered in the chapter
*
Ask the Experts–Q&A sections filled with bonus information and helpful tips
*
Try This–Hands-on exercises that show how to apply your skills
*
Notes–Extra information related to the topic being covered
*
Self-Tests–Chapter-ending quizzes to test your knowledge
*
Annotated Syntax–Example code with commentary that describes the programming techniques being illustrated

About the Author

Andrew J. (Andy) Oppel has designed and implemented hundreds of databases for a wide range of applications. He is the author of Databases Demystified and SQL Demystified.

Robert Sheldon is a consultant and technical writer. He has designed and implemented various Access and SQL Server databases

download

Joe Celko’s SQL Programming Style

“Joe Celko, maybe one of the most prominent representatives of the database community these days, has written some of the best books about SQL programming in general. This book, however, is different. “SQL Programming Style” doesn’t teach you how to become a better SQL developer with SQL puzzles and brainteasers. Rather, it shows you “how to work in logical and declarative terms”.”
- SQL-Server-Performance.com, August 17, 2006

download

Professional Microsoft SQL Server 2008 Administration

Product Description

Loaded with unique tips, tricks and workarounds for handling the most difficult SQL Server admin issues, Professional Microsoft SQL Server 2008 Administration is a how-to guide for experienced DBAs. Understand how to manage and monitor the SQL Server, automated administration, security, change management, performance tuning, scaling and replication, clustering, and backup and recovery. This updated edition includes new information about Change Data Capture, Performance Studio, Query Governor, and new techniques for monitoring and policy management so that you can have the latest and most comprehensive information at your fingertips.

download

hi

i have practised in sql server 2005

will it enough for me if i don't have oracle9i and mysql

what is the difference in all

pls help

thanks

@pneelam
This is not the right place to post your doubt.

Although there are no much differences between mysql,sqlserver and oracle
you first confirm with your seniors or from practical exam centre what type of DBMS they are going provide for practicals.

Accordingly try to practice. So that you can get better marks.

Data Mining & Data Warehousing
Jiawei Han and Micheline Kamber
Morgan Kaufmann Publishers

Few Chapters of this book may be helpful to our course

download from here