Category: Databases

Introducing Microsoft SQL Server 2012

Sponsor Advertisement

My image
  • Author: Ross Mistry and Stacia Misner
  • Format: PDF, EPUB, MOBI
  • Price: free

This book is for anyone who has an interest in SQL Server 2012 and wants to understand its capabilities. In a book of this size, we cannot cover every feature that distinguishes SQL Server from other databases or previous versions, and consequently we assume you have some   familiarity with SQL Server already. You might be a database administrator (DBA), an application developer, a business intelligence solution architect, a power user, or a technical decision maker. Regardless of your role, we hope you can use this book to discover the features in SQL Server 2012 that are most beneficial to you.

Chapters include:

  • SQL Server 2012 Editions and Engine Enhancements
  • High-Availability and Disaster-Recovery Enhancements
  • Performance and Scalability
  • Security Enhancements
  • Programmability and Beyond-Relational Enhancements
  • Integration Services
  • Data Quality Services
  • Master Data Services
  • Analysis Services and PowerPivot
  • Reporting Services

http://blogs.msdn.com/b/microsoft_press/archive/2012/03/15/free-ebook-introducing-microsoft-sql-server-2012.aspx

MySQL 5.5 Reference Manual

Sponsor Advertisement

My image
  • Author: Oracle
  • Format: online HTML, PDF, EPUB
  • Price: free

This is the official reference manual for MySQL 5.5.

Chapters include:

  • Preface and Notes
  • General Information
  • Installing and Upgrading MySQL
  • Tutorial
  • MySQL Programs
  • MySQL Server Administration
  • Backup and Recovery
  • Optimization
  • Language Structure
  • Internationalization and Localization
  • Data Types
  • Functions and Operators
  • SQL Statement Syntax
  • Storage Engines
  • High Availability and Scalability
  • MySQL Enterprise Monitor
  • MySQL Workbench
  • Replication
  • Partitioning
  • Stored Programs and Views
  • INFORMATION_SCHEMA Tables
  • MySQL Performance Schema
  • Connectors and APIs
  • Extending MySQL

http://dev.mysql.com/doc/

SQL for Web Nerds

Sponsor Advertisement

My image
  • Author: Philip Greenspun
  • Format: online HTML
  • Price: free

A nicely structured manuscript on SQL by Philip Greenspun, based on the Oracle database. Queries, transactions, triggers, and RDBMS concepts are covered.

Chapters include:

  • Data modeling
  • simple queries: one table, one table with subquery, JOIN, JOIN with subquery, OUTER JOIN
  • more complex queries: GROUP BY, aggregates, HAVING
  • Transactions (inserts and updates)
  • triggers
  • views
  • style
  • escaping to the procedural world: PL/SQL and Java executing inside the Oracle server
  • trees
  • handling dates in Oracle
  • limits in Oracle; how they will bite you and how to work around them
  • tuning, what to do when your query runs too slowly
  • data warehousing, what to do when your query doesn’t answer your questions
  • foreign and legacy data, making foreign Web sites look like local SQL tables
  • normalization

http://philip.greenspun.com/sql/

CouchDB: The Definitive Guide

Sponsor Advertisement

My image
  • Author: J. Chris Anderson, Jan Lehnardt, and Noah Slater
  • Format: online HTML
  • Price: free

The book is designed to guide you gently through using CouchDB with clear but practical scenarios. It progressively showcases key features, starting with simple document CRUD, working through to advanced MapReduce, and culminating with deployment tuning for performance and reliability.

Chapters include:

  • Why CouchDB?
  • Eventual Consistency
  • Getting Started
  • The Core API
  • Design Documents
  • Finding Your Data with Views
  • Validation Functions
  • Show Functions
  • Transforming Views with List Functions
  • Standalone Applications
  • Managing Design Documents
  • Storing Blog Posts in Documents
  • Displaying Blog Posts with Shows
  • Viewing Lists of Blog Posts
  • Scaling Basics
  • Replication
  • Conflict Management
  • Load Balancing
  • Clustering
  • Change Notifications
  • Views for SQL Jockeys
  • Security
  • High Performance
  • Recipes
  • Installing on Unix-like systems
  • Installing on Mac OS X
  • Installing on Windows
  • Installing from Source
  • JSON Primer
  • The Power of B-Trees

http://books.couchdb.org/relax/

Introduction to Databases for the Web

Sponsor Advertisement

My image
  • Author: Selena Sol
  • Format: online HTML
  • Price: free

This is a free four part course, suitable for webmasters and web developers with little or no database experience. The goal of this tutorial is to introduce database concepts and give you the tools you need to get to work using the databases available to you. The first part introduces the various types of database systems, especially relational databases and the SQL language. Examples are given of creating and manipulating a database and tables within it.

Chapters include:

  • What is a Database
  • Types of Databases
  • Analytic Databases
  • Operational Databases
  • Databases Models
  • Hierarchical Databases
  • Network Databases
  • Relational Databases
  • Client Server Databases
  • Good Database Design
  • Talking to a Database
  • The Basics of the SQL Database
  • Tables
  • The Data Dictionary
  • Basics of an SQL Query
  • Data Types
  • Logging on to the Database
  • A Sample Database
  • Creating Databases
  • Creating Tables
  • Deleting Databases and Dropping Tables
  • Altering a Table
  • Retrieving Data
  • Wildcards
  • Where
  • And, Or, and Not
  • Between
  • In
  • Like
  • Null
  • Order by
  • Performing math
  • Maximums and Minimums
  • Counting Records
  • Distinct
  • Averages
  • Joins
  • Subquerries
  • Adding Data
  • Modifying Data
  • Deleting Data
  • Server Side Database Communication With CGI
  • Chains of Communication
  • Using Perl 5 and the DBI Module to Communicate With Databases
  • The DBI Module
  • The DBI API
  • Getting the Pieces
  • Installing Perl
  • Installing a Web Server : Sambar
  • Running CGI Applications on a Single Station Local Area Network
  • Setting up a Sample Database
  • Putting it all together with a DBI-Aware CGI Script
  • Intro to JDBC
  • JDBC Application Environment Setup
  • Using JDBC to Connect to a Database
  • Using JDBC to Query a Database
  • Using JDBC to Modify a Database
  • More on JDBC
  • JDBC by Example

http://www.extropia.com/tutorials/sql/toc.html