Schaum's Outline of Fundamentals of Relational Databases

• More than 200 completely solved problems and an equal number of supplementary problems facilitate the understanding of database technology
• Complete scripts allow students to create and populate all databases used in the book
• Syntax and database technology employed by the most important database developers are featured, including Oracle, Microsoft Access, and DB2
• Lab and practice tests similar to the tests currently used in the database certification exams for database developers are included to help students master database problems

Download:
Link_1
Or
Link_2

Teach Yourself Ole Db and Ado in 21 Days

Teach Yourself Ole Db and Ado in 21 Days (Sams Teach Yourself) By John Fronckowiak
Publisher: Sams Publishing 1997-08 | 648 Pages | ISBN: 067231083X | PDF (OCR from html) | 6.7 MB

With Sams Teach Yourself OLE DB and ADO in 21 Days, you will learn how to build distributed Web-based database applications using today's latest technologies. Step-by-step tutorials and real-world examples show you how OLE DB enables programmers to access data in the most optimal manner possible. You will also learn how to implement ActiveX Data Objects (ADO), the object model for accessing data using the OLE DB interface. You'll then move on to build the server-side infrastructure necessary to support your applications using Advanced Data Connector (ADC) controls.

* Learn OLE DB and ActiveX Data Objects (ADO)
* Utilize ADO and OLE DB for deploying distributed database applications
* Discover how ADO and OLE DB work with new technologies such as ADC, Visual InterDev, Transaction Server and ActiveX Server Pages
* Includes author's source code and useful third-party products.

Download:
Link_1

Oracle 10g RAC Grid, Services & Clustering

Murali Vallath, Oracle 10g RAC Grid, Services & Clustering
Digital Press | ISBN: 1555583210 | 2006 | PDF | 704 pages | 15.44 MB

Oracle RAC and grid technology is transforming the economics of high-end database computing and is a technology that all Oracle professionals should become familiar with. Murali is one of the worlds foremost independent experts on Oracle RAC technology and his book contains everything you need to become proficient in both the theory and practice of Real Application Clusters. If you are planning a RAC implementation, looking to optimize an existing RAC implementation or simply want to become more familiar with this important technology, you should read this book. - Guy Harrison: Chief Architect Database Solutions, Quest Software.

Download:
Link_1

Oracle 10g Data Warehousing

Lilian Hobbs, Oracle 10g Data Warehousing
Digital Press | ISBN: 1555583229 | 2004 | PDF | 872 pages | 18.11 MB

Oracle 10g Data Warehousing is a guide to using the Data Warehouse features in the latest version of Oracle Oracle Database 10g. Written by people on the Oracle development team that designed and implemented the code and by people with industry experience implementing warehouses using Oracle technology, this thoroughly updated and extended edition provides an insiders view of how the Oracle Database 10g software is best used for your application.

Download:
Link_1

Oracle Performance Tuning for 10gR2, Second Edition

Gavin JT Powell, Oracle Performance Tuning for 10gR2, Second Edition
Digital Press | ISBN: 1555583458 | 2006 | PDF | 960 pages | 19.03 MB

Fully updated for version 10gR2 and provides all necessary transition material from version 9i. Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning. Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective.

Download:
Link_1

LINQ Quickly

LINQ Quickly
Packt Publishing | 2007-11-24 | ISBN: 1847192548 | 252 pages | PDF | 4 MB

This book gets you started with LINQ and shows how it will make your programming life easier by making use of new features from the .NET Framework 3.0. This book is split into seven chapters, each of which is dedicated to presenting a feature of LINQ and its usage in real-life scenarios. Language Integrated Query (LINQ) is a new feature in Visual Studio 2008 that extends its query capabilities, using C# and Visual Basic. Visual Studio 2008 comes with LINQ provider assemblies that enable the use of LINQ with data sources such as in-memory collections, SQL relational databases, ADO.NET Datasets, XML documents, etc. In Visual Studio 2008, Visual C# and Visual Basic are the languages that implement the LINQ language extensions. LINQ language extensions use the new standard query operators API, which is the query language for any collection that implements IEnumerable.

Download:
Link_1
Or
Link_2

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (2nd Edition)

John L. Viescas, Michael J. Hernandez "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (2nd Edition)"

Addison-Wesley Professional | 2007-10-04 | ISBN: 0321444434 | 672 pages | PDF | 2,3 MB

Download:
Link_1

Oracle Database 11g SQL

Jason Price "Oracle Database 11g SQL"
McGraw-Hill Osborne Media | 2007-11-05 | ISBN: 0071498508 | 656 pages | PDF | 3 MB

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:
Link_1

SQL: Practical Guide for Developers

Michael J. Donahoo, Gregory D. Speegle "SQL: Practical Guide for Developers"
Morgan Kaufmann | 2005-08-01 | ISBN: 0122205316 | 272 pages | PDF | 1,4 MB

Would the basics of SQL querying be useful to you, but you dont want to start at the very beginning? Do you wish you had an easy way to ramp up quickly to get a basic understanding of key features and capability? Then you need this book! Without a ton of conceptual information or general programming basics you already know, this book is a quick guide for computing professionals and programmers to learn the basics--and more--in an easily digestible way.

+ Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief but really good introduction to SQL.
+ The approach is vendor-neutralso very adaptable and flexiblebut the book's Web site includes information about DBMS-specific peculiarities.
+ The focus is on teaching concepts by walking through concrete examples and explanations, and self-review exercises are included at the end of each chapter.
+ Coverage is on the key features of the language that are required to understand SQL and begin using it effectively.
+ SQL 2003-compliant.

Download:
Link_1

Microsoft SQL Server Black Book

Patrick Dalton, Microsoft SQL Server Black Book
Coriolis Group Books | ISBN: 1576101495 | 1997 | PDF | 464 pages | 3.33 MB

Teaches, with step-by-step guides, the most important SQL Server tasks. Troubleshoots common database and client-server problems. Improves performance with sophisticated SQL Server tuning techniques. Develops powerful database features that can easily be integrated into your current database system. Uses ready-to-run database examples and SQL code.

Download:
Link_1
Or
Link_2

Introduction to SQL: Mastering the Relational Database Language ,4 Ed

Rick F. van der Lans, "Introduction to SQL: Mastering the Relational Database Language ,4 Ed"
Addison-Wesley Professional; 4 ed | 2006 | ISBN: 0321305965 | 1056 pages | CHM | 4,5 MB

The Classic SQL Tutorial: Fully Updated for Today’s Standards and Today’s Top Databases
For twenty years, van der Lans’ Introduction to SQL has been the definitive SQL tutorial for database professionals everywhere, regardless of experience or platform. Now van der Lans has systematically updated this classic guide to reflect the latest SQL standards and the newest versions of today’s leading RDBMSs: Oracle, Microsoft SQL Server, DB2, and MySQL.
Using case study examples and hands-on exercises, van der Lans illuminates every key SQL concept, technique, and statement. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why SQL works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you’re a programmer or DBA, a student or veteran, this book will take you from “apprentice” to true SQL master.
Writing queries and updating data: all you need to know about SELECT
Working with joins, functions, and subqueries
Creating database objects: tables, indexes, views, and more
Specifying keys and other integrity constraints
Using indexes to improve efficiency
Enforcing security via passwords and privileges
Building stored procedures and triggers
Developing with embedded SQL and ODBC
Working with transactions, including rollbacks, savepoints, isolation levels, and more
Optimizing performance by reformulating SQL statements
Using object-relational features: subtables, references, sets, and user-defined data types
Reference section: SQL statement definitions and SQL function lists..

Download:
Link_1
Or
Link_2

Oracle9i : The Complete Reference

Kevin Loney,George Koch, "Oracle9i : The Complete Reference"
Oracle Press | 2002 | ISBN: 0072225211 | 1256 pages | PDF | 23 Mb

The most reknowned Oracle Resourse- Fully Updated for Oracle 9i. Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Get comprehensive information on all the features of Oracle 9i. Written by best-selling authors and Oracle gurus Kevin Loney, George Koch, and the experts at TUSC, Oracle9I: The Complete Reference covers critical relational, object-relational, and Web database concepts, as well as SQL, SQL*PLUS, PL/SQL, Java, JDBC, SQLJ, and XML programming. You'll also get full details on database administration techniques- and much more. This authoritative volume is a must-have tool for all Oracle professionals.

Download:
Link_1
Or
Link_2

Nathan Wallace - Learn OLE DB Development With Visual C++ 6.0

Nathan Wallace - Learn OLE DB Development With Visual C++ 6.0
Wordware Publishing | 2003 | ISBN: 1556226349 | Pages: 600 | PDF | 4.31 MB

Learn OLE DB Development with Visual C++ 6.0 presents the basics of the Component Object Model and OLE DB, and assists Visual C++ programmers in creating OLE DB providers and consumers. OLE DB is the ODBC-compliant standard from Microsoft that lets non-record-based data interact with its users via recordset semantics and powerful data controls like ADO and RDO. This book gives you all the basics needed to create your own OLE DB consumers and providers in Visual C++, using the ActiveX Template Library and the Microsoft Foundation Classes. Putting OLE DB components on the Internet is also covered.

Download:
Link_1

Beginning ASP Databases

"Beginning ASP Databases" by John Kauffman, Kevin Spencer, Thearon Willis
Publisher: Wrox | September 1999 | ISBN: 1861002726 | PDF | 20.22 Mb | 825 Pages

Microsoft created Active Server Pages (ASP) to sew together a group of technologies for creating modern web sites, which can intelligently interact with the user at the front end and with servers and datastores at the back end. Among these technologies is ActiveX Data Objects (ADO), which allows easy, powerful and robust control of technologies that access datastores. This book explains the theory and practice of using ADO with ASP by presenting numerous examples, exercises, lists of common errors and quizzes. The emphasis is on the authors' proven teaching techniques and the presentation of the most commonly used features of ADO in ASP. If you read each chapter and do the exercises you will have a portfolio of several dozen data-intensive web pages of increasing complexity a fine return on your investment.

Download:
Link_1

Professional XML Databases (by Kevin Williams)

"Professional XML Databases" by Kevin Williams
Publisher: Wrox | Nov 2000 | ISBN: 1861003587 | PDF | 5.55 Mb | 1005 Pages

In this book, we look at how to integrate XML into your current relational data source strategies. With the increasing amount of data stored in relational databases, and the importance of XML as a format for marking up data - whether it be for storage, display, interchange, or processing - you need to have command of four key skills: understanding how to structure, process, access, and store your data.
By introducing guidelines for how to model your XML documents in relational databases and how to model relational database information as XML, we will establish structures that enable quick and efficient access, and make our data more flexible. We then look at the developer's XML toolbox, discussing associated technologies and strategies that will help us in describing, processing, and manipulating data. We also discuss common techniques for data access, data warehousing, transmission, and marshalling and presentation, giving working examples in every chapter.
Whether you are using XML for storage, as an interchange format, or for display, this book looks at some of the key issues you should be aware of when structuring, processing, accessing, and storing your documents.

Download:
Link_1

Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL (book + source code)

"Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL" by Wallace B. McClure, Gregory A. Beamer, John J. Croft, IV, J. Ambrose Little, Bill Ryan, Phil Winstanley, David Yack, Jeremy Zongker
Publisher: Wrox (2005) | ISBN: 0764584375 | PDF | 5.81 Mb | 648 Pages

ADO.NET revolutionized the way data was accessed through SQL Server, Oracle, and MySQL. With Microsoft's release of ADO.NET 2, ADO and the .NET Framework are integrated with SQL Server for the first time-enabling you to program .NET applications directly within the SQL Server database.
Packed with sample code and recommended best practices for using ADO.NET 2, this code-intensive book explores the new data types that are available in the 2.0 Framework and discusses the appropriate time and way to use them. You'll learn how to make repetitive, mundane tasks much simpler and you'll walk away with a solid foundation for developing database-driven applications.

What you will learn from this book
* The basics of creating a connection, executing a query, and returning a result
* Best uses for Oracle in the ADO.NET Framework
* The many new features that are available for XML
* How to use the full text search capabilities of Microsoft(r) SQL Server 2005
* Methods for retrieving data and presenting it in various ways
* Why MySQL is a viable option for data storage.

Download:
Link_1

Wrox Professional SQL Server 2000 Database Design

Wrox Professional SQL Server 2000 Database Design
ISBN: 1861004761 | Author: Louis Davidson | Publisher: Wrox Press | PDF

SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system.
Professional SQL Server 2000 Database Design provides an outline of the techniques that the designer can employ to make effective use of the full range of facilities that SQL Server 2000 offers. It attempts to move away from traditional texts on relational database design by considering design issues from a 'real world' point of view. To that end, it provides a full case study illustrating the scope of the designer's role - right from initial discussions regarding a client's needs, through development of a logical model, to full implementation of the system.

Download:
Link_1
Or
Link_2

Database Design Using Entity-Relationship Diagrams (Foundations of Database Design, 1)

Database Design Using Entity-Relationship Diagrams (Foundations of Database Design, 1)
TF-ARBCH | ISBN: 0849315484 | 264 pages | June 27, 2003 | PDF | 3 Mb

Entity-relationship (E-R) diagrams are time-tested models for database development well-known for their usefulness in mapping out clear database designs. Also commonly known is how difficult it is to master them. With this comprehensive guide, database designers and developers can quickly learn all the ins and outs of E-R diagramming to become expert database designers. Because E-R diagrams are so fundamental to database design, this book is also an indispensable text for teaching computer science students the basics of database development. Database Design Using Entity-Relationship Diagrams clarifies E-R diagramming by defining it in terms of requirements (end user requests) and specifications (designer feedback to those requests). The book explains how open communication between designers and end users is critical to developing usable, easy-to-understand E-R diagrams that model both requirements and specifications. The authors explain, in an intuitive, informal manner, how to develop an E-R diagram, how to map it to a database, and how the resulting database can be tested. This definitive guide is a basic component for any database course, and is also an invaluable reference that database professionals can use throughout their careers.

Download:
Link_1
Or
Link_2

JDBC 4.0 and Oracle JDeveloper for J2EE Development

JDBC 4.0 and Oracle JDeveloper for J2EE Development
Packt Publishing | ISBN: 1847194303 | 2008-04-30 | PDF | 444 pages | 1.8 Mb

Download:
Link_1

Sams Teach Yourself DB2 Universal Database in 21

Sams Teach Yourself DB2 Universal Database in 21 Days By Susan Visser
Publisher: Sams 1998-05-14 | 528 Pages | ISBN: 0672312786 | PDF (OCR from html) | 4.8 MB

This is a complete tutorial and hands-on guide to all the new features of DB2 Universal Database Version 5. This is a comprehensive guide to designing, administering and optimizing a DB2 Universal Server database. With this book, the reader will learn to build secure distributed databases and replication into a network environment, gain in-depth information on making your information web-accessible and gain valuable insight into parallel processing for data warehousing. There is an emphasis on how DB2 can improve the productivity and profitability of the reader's organization, while it covers installation and configuration, day-to-day database administration, commands, performance, tuning and troubleshooting.

Download:
Link_1