Operating Systems Books

Introduction

On this page are a range of books to which are recommended for software development.

Select from programming books on :-

Database Theory and Design
MS Access
MySQL

Database Theory and Design

Database System Concepts

The Fourth edition of Database System Concepts has been extensively revised from the 3rd edition. The new edition provides improved coverage of concepts, extensive coverage of new tools and techniques, and updated coverage of database system internals.

This text is intended for a first course in databases at the undergraduate. Database System Concepts, 4th ed. offers a complete background in the basics of database design, languages, and system implementations.

Concepts are presented using intuitive descriptions, and important theoretical results are covered, but formal proofs are omitted. The fundamental concepts and algorithms covered in Database System Concepts 4th ed. are based on those used in existing commercial or experimental database systems. The authors present these concepts and algorithms in a general setting that is not tied to one particular database system

Database in Depth: The Relational Model for Practitioners

This book sheds light on the principles behind the relational model, which is fundamental to all database-backed applications and, consequently, most of the work that goes on in the computing world today. Database in Depth: The Relational Model for Practitioners goes beyond the hype and gets to the heart of how relational databases actually work. The authors present these concepts and algorithms in a general setting that is not tied to one particular database system.

Database in Depth will appeal not only to database developers and designers, but also to a diverse field of professionals and academics, including database administrators (DBAs), information modelers, database consultants, and more. Virtually everyone who deals with relational databases should have at least a passing understanding of the fundamentals of working with relational models.

MS Access

Expert One-on-One Microsoft Access Application Development

What is this book about?
If you are developing databases for your own use, the process need not be complicated. But when you build databases for clients, many of whom may not be familiar with Access or comfortable with databases in general, you have a lot more work to do. Expert One-on-One Microsoft Access Application Development makes that process easier. In these pages, you discover how to set up tables and relationships to ensure that the database is properly normalized. Then you write VBA code to create the connective tissue that turns a bunch of tables, queries, forms, and reports into a complete and coherent application. You also find out about the important but often inadequately documented area of Automation code, which is used to communicate with other Office applications. Over years of working with Access, the author has created some add-ins to save time when developing applications. She shows you how to use them to create a main menu for an application, automatically apply a naming convention to database objects, and ensure a consistent and professional appearance of the application's forms. This book helps you write VBA code that unites database components into an application that works.

What does this book cover?
Here's what you'll discover in this book: how to build integrated Access-based applications that support multiple clients and databases; tips for streamlining application creation; maintenance required throughout an application's life cycle, including migrating data from legacy systems and upgrading Office; how to use Automation code to exchange data among Office components and even some non-Office programs; ways to avoid glitches when building Access applications that work with Excel, Word, and Outlook.

Who is this book for?
This book is for experienced Access users who are familiar with creating Access objects and writing VBA code, but who need help transitioning from competent users/programmers to full-fledged Access developers.

Databases: Design, Development and Deployment Using Microsoft Access

This is a book that teaches the more advanced topics of database design through the use of Microsoft Access. The second edition has been completely updated to give students the latest information. By using Microsoft's Access 2002, students will learn the intricacies of developing a database. Also with the ever-growing area of web programming, students will have a chapter tying database and web programming together and another chapter specifically on VB Script. Lastly, a revamped chapter on security will address the ever-changing and important issues of this area.

MySQL

MySQL Administrator's Guide

Written by the creators of MySQL and edited by one of the most highly respected MySQL authors, the MySQL Administrator's Guide is the authoritative guide to installing, administering, and working with the MySQL database server. Based on the official online MySQL Reference Manual, the MySQL Administrator's Guide covers topics and provides information essential to anyone administering a MySQL database server or developing MySQL applications.

PHP and MySQL Web Development

The definitive best-selling book on combining these two open source tools to create dynamic Web sites - updated for PHP 5 and MySQL 5. A new, updated, and revised edition of the best-selling #1 book on any open source programming topic. New edition updates the material and code to MySQL 5 and PHP 5, and includes new coverage of PHP's object model and validation.