Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

Wednesday, February 29, 2012

Database fundamentals

Free eBook “Database fundamentals” from IBM. Get the fundamentals to learn about databases.
Description
Read this free ebook to: Learn relational database theory, Understand different information models, Learn logical and physical database design, Get the basics of the SQL language and XML, Practice using hands-on exercises.
This book is tailored for new database enthusiasts, application developers, database administrators, and anyone with an interest in the subject and looking to get exposure such as university students and new graduates.
Contents
  • Databases and information models
  • The relational data model
  • The conceptual data model
  • Relational Database Design
  • Introduction to SQL
  • Stored procedures and functions
  • Using SQL in an application
  • Query languages for XML
  • Database Security
  • Technology trends and databases
Download:  Database Fundamentals

Troubleshooting SQL Server: A Guide for the Accidental DBA

Red Gate Software is offering another free eBook. This time “Troubleshooting SQL Server: A Guide for the Accidental DBA”, written by Jonathan Kehayias and Ted Krueger can be downloaded in pdf format along with a free trial version of SQL Monitor software.
Description
This book will help you understand how to approach troubleshooting and the essential tools you need. And explore the areas where problems regularly arise and the tools you can use to diagnose them. Also you can get practical solutions to remove the root causes of issues.
The primary audience for this book is anyone who has found themselves in charge of SQL Server “by accident;” in other words, the accidental/involuntary DBAs and system administrators who have had guardianship of SQL Server databases added to their roles, because there is a SQL Server in their environment, and someone has got to look after it.
However, the troubleshooting concepts and methodologies covered in this book can be applied by anyone, including seasoned database administrators, to identify and resolve common problems and learn new tricks for managing and maintaining SQL Server.
Contents
  • A Performance Troubleshooting Methodology
  • Disk I/O Configuration
  • High CPU Utilization
  • Memory Management
  • Missing Indexes
  • Blocking
  • Handling Deadlocks
  • Large or Full Transaction Log
  • Truncated Tables, Dropped Objects and Other Accidents Waiting to Happen

Download :  Troubleshooting SQL Sever

Oracle Essentials 4th Edition

Red Gate software is offering the eBook version of “Oracle Essentials 4th Edition: Oracle Database 11g”, published by O’Reilly Media, free of charge for a limited period. Download this 408 page book in pdf format.
Description
We wrote this book for people possessing all levels of Oracle expertise. Our target audiences include DBAs who spend most of their workday managing Oracle, application developers who build their systems on the data available in an Oracle database, and system administrators who are concerned with how Oracle will affect their computing environments.
Contents
  • Introducing Oracle
  • Oracle Architecture
  • Installing and Running Oracle
  • Oracle Data Structures
  • Managing Oracle
  • Oracle Security, Auditing, and Compliance
  • Oracle Performance
  • Oracle Multiuser Concurrency
  • Oracle and Transaction Processing
  • Oracle Data Warehousing and Business Intelligence
  • Oracle and High Availability
  • Oracle and Hardware Architecture
  • Oracle Distributed Databases and Distributed Data
  • Oracle Extended Datatypes
  • Beyond the Oracle Database

Download:  Oracle Essentials