Books

Database

Database Explorations

The database field is full of important problems still to be solved and interesting issues that need to be examined. Some of those problems and issues are explored in this book. It reports on some of the most recent investigations in this field.

Database Fundamentals

Learn the basics of relational database theory and other information models. This book discusses database logical and physical design, and introduces you to the SQL language. Practice with hands-on exercises.

Databases, Types, and The Relational Model: The Third Manifesto

This is a book on database management that is based on an earlier book by the same authors,Foundation for Future Database Systems: The Third Manifesto. It can be seen as an abstract blueprint for the design of a DBMS and the language interface to such a DBMS. In particular, it serves as a basis for a model of type inheritance. This book is essential reading for database professionals.

MongoDB

Introduction to MongoDB

This interactive tutorial is designed for Software Professionals who are willing to learn MongoDB Database in simple and easy steps. It will throw light on MongoDB concepts and after completing this tutorial you will be at an intermediate level of expertise, from where you can take yourself at higher level of expertise.

SQL

Developing Time-Oriented Database Applications in SQL

Whether you are a database designer, programmer, analyst, or manager, you have probably encountered some challenges and experienced some of the frustrations associated with time-varying data. Where do you turn to fix the problem and see that it does not happen again?In Developing Time-Oriented Database Applications in SQL, a leading SQL researcher teaches you effective techniques for designing and building database applications that must integrate past and current data.

Written to meet a pervasive, enduring need, this book will be indispensable if you happen to be part of the flurry of activity leading up to Y2K.

Introduction to SQL

This is an open-source introduction to SQL guide that will help you to learn the basics of SQL and start using relational databases for your SysOps, DevOps, and Dev projects. No matter if you are a DevOps/SysOps engineer, developer, or just a Linux enthusiast, you will most likely have to use SQL at some point in your career.

The guide is suitable for anyone working as a developer, system administrator, or a DevOps engineer and wants to learn the basics of SQL.

SQL For Web Nerds

This is a free online SQL book by Philip Greenspun. It covers data modeling, simple queries, complex queries, transactions, triggers, views, style, PL/SQL and Java, trees, handling dates in Oracle, limits in Oracle, tuning, data warehousing, foreign and legacy data and normalization.

SQL Server

Defensive Database Programming

The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected. To the SQL Server programmer, this means T-SQL code that behaves consistently and predictably in cases of unexpected usage, doesn't break under concurrent loads, and survives predictable changes to database schemas and settings.

Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience and robustness.

Mastering SQL Server Profiler

SQL Server Profiler is one of the most useful of SQL Server's "built-in" tools, recording data about various SQL Server events. "Mastering SQL Server Profiler" will make it easier for you to learn how to use Profiler, analyze the data it provides, and to take full advantage of its potential for troubleshooting SQL Server problems. All the examples have been optimized to work with both SQL Server 2005 and 2008.

Protecting SQL Server Data

In Protecting SQL Server Data, John Magnabosco demonstrates how sensitive data, stored in SQL Server, can be protected using an efficient and maintainable encryption-based data architecture.

He explains how to assess and categorize data elements according to sensitivity, regulate access to the various categories of data using database roles, views and stored procedures, and then how to implement a secure data architecture using features such as cell-level encryption, transparent data encryption, one-way encryption, obfuscation, and more.

MySQL

MySQL 8.0 Tutorial Excerpt

This is the MySQL Tutorial from the MySQL 8.0 Reference Manual.

NoSQL

NoSQL Databases

A NoSQL database environment is, simply put, a non-relational and largely distributed database system that enables rapid, ad-hoc organization and analysis of extremely high-volume, disparate data types.

NoSQL databases are sometimes referred to as cloud databases, non-relational databases, Big Data databases and a myriad of other terms and were developed in response to the sheer volume of data being generated, stored and analyzed by modern users (user-generated data) and their applications (machine-generated data).

The Little Redis Book

PostgreSQL

The Internals of PostgreSQL for database administrators and system developers

In this document, the internals of PostgreSQL for database administrators and system developers are described.

PostgreSQL is an open source multi-purpose relational database system which is widely used throughout the world. It is one huge system with the integrated subsystems, each of which has a particular complex feature and works with each other cooperatively. Although understanding of the internal mechanism is crucial for both administration and integration using PostgreSQL, its hugeness and complexity prevent it. The main purposes of this document are to explain how each subsystem works, and to provide the whole picture of PostgreSQL.