Serge Abiteboul, Richard Hull, Victor Vianu, “Foundations of Databases”
Addison Wesley | 1994 | ISBN: 0201537710 | 685 pages | PDF | 2,8 MB
This database theory book provides a focused presentation of the core material on relational databases, and presents a number of advanced topics in a unified framework. Some of the advanced material has never before been presented in book form. The style is rigorous, with detailed proofs and many exercises. The text and numerous examples highlight the intuition underlying the development. As a textbook, the book is aimed at graduate students and seniors who would use it as the main text in a database theory course, or as complementary material in a database systems course. It can also serve as a reference for database researchers and for other computer scientists interested in databases.
Read the rest of this entry
Introduction to Databases: From Biological to Spatio-Temporal By Peter Revesz
Publisher: Springer 2009 | 754 Pages | ISBN: 1849960941 | PDF | 6 MB
This textbook reveals the workings of numerous database systems, enabling readers to develop complex database applications. Students will gain hands-on experience by following the exercises. The theory is complemented by detailed examination of specific applications from a broad range of areas. The text assumes only basic discrete mathematics, linear algebra, and programming knowledge. Features: Provides descriptions of 11 types of databases, and 2 database systems; Concludes each chapter with bibliographic notes and exercises; Examines database design, including issues of database interoperability, data integration, interpolation and approximation, and prediction and data mining; Presents course aids at a supporting website; Covers topics on indexing methods, data visualization, the safety of queries, general evaluation algorithms, the efficient implementation of evaluation algorithms, and the complexity of the evaluation of different types of queries; Structured to allow for flexible course design.
Read the rest of this entry
Portable DBA: SQL Server
Publisher: McGraw-Hill | ISBN: 0072230169 | edition 2004 | CHM | 352 pages | 10,1 mb
This book is the ultimate field guide for every SQL Server DBA’s laptop bag. Don’t go onsite without it! Covers the most commonly used SQL Server database versions. Handy, easy-to-find information includes security, database creation and management, restoration and recovery, automating SQL Server administration, monitoring performance, tuning, and much more.
MySQL: Essential Skills
Publisher: McGraw-Hill Osborne Media | ISBN: 0072255137 | edition 2004 | CHM | 496 pages | 14,4 mb
An introductory look into the most popular open source database. Get step-by-step instruction from installing MySQL, manipulating it, and basic reporting, to advanced reporting, interfacing programs, and backups. An accessible introduction to a powerful database, featuring progress checks, exercises, and Ask the Experts sections in each chapter.
Beginning SQL Server 2005 Administration
Publisher: Wrox | ISBN: 0470047046 | edition 2006 | PDF | 574 pages | 13,4 mb
For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly “administrative,” duties that have become much more complicated and difficult. With that in mind, a team of experienced Microsoft Certified Professionals provides you with the necessary information to be a more competent and successful database developer or administrator.
Beginning with a foundation that features detailed coverage of typical administrative duties, the authors proceed to explain how to build complex data transformations for data import, build distributed data solutions, and maintain the security and integrity of the database. You will be able to apply what you learn to real-world scenarios, and smoothly navigate the vastly changed landscape of SQL Server 2005 administration.
Read the rest of this entry