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/

Sams Teach Yourself Microsoft SQL Server 7 in 21 Days

Sponsor Advertisement

  • Author: Richard Waymire and Rick Sawtell
  • Format: online HTML
  • Price: free

Sams Teach Yourself Microsoft SQL Server 7 in 21 Days gives you the features and capabilities of SQL Server 7, in a tutorial environment. This book features information on: Row-level locking; SQL Server Query Analyzer (formerly the ISQL/w); Microsoft Manage-ment Console (platform that the Enterprise Manager is now based upon); Update Replication feature (multisite, improved performance and scriptable replication objects); New Wizards such as: Create Database, Create Job, Index Tuning, Version Upgrade and Security; SQL Server Agent which provides unattended job execution and alter/response management; New Transact-SQL statements such as ALTER PROCEDURE, ALTER TRIGGER; and information on recursive triggers and local cursors. It walks you through the features of SQL Server 7, increasing the performance and scalability of your database.

Chapters include:

  • Part 1: Week 1 At a Glance
  • Day 1. Introduction to SQL Server 7.0 and Relational Databases
  • Day 2. Installing SQL Server 7.0
  • Day 3. Using the SQL Server 7.0 Tools and Utilities
  • Day 4. Creating and Implementing Databases, Files, and Filegroups
  • Day 5. Using SQL Server Login and User Security
  • Day 6. Working with Permissions
  • Day 7. Implementing Backups in SQL Server 7.0
  • Part 2: Week 2 At a Glance
  • Day 8. Restoring SQL Server Databases
  • Day 9. Creating Tables
  • Day 10. Using SQL Server 7.0 Data Transformation Services
  • Day 11. Retrieving Data with Queries
  • Day 12. Data Modification with Queries
  • Day 13. Enhancing Performance with Indexing
  • Day 14. Ensuring Data Integrity
  • Part 3: Week 3 At a Glance
  • Day 15. Working with Views, Stored Procedures, and Triggers
  • Day 16. Programming SQL Server 7.0
  • Day 17. Understanding Replication Design and Methodologies
  • Day 18. Implementing Replication Methodologies
  • Day 19. Using the SQL Server Agent
  • Day 20. Configuring and Monitoring SQL Server 7.0
  • Day 21. Integrating SQL Server and the World Wide Web

Read: Sams Teach Yourself Microsoft SQL Server 7 in 21 Days

Sams Teach Yourself SQL in 24 Hours

Sponsor Advertisement

 

 

  • Author: Ryan Stephens, Ron D. Plew
  • Format: online HTML
  • Price: free

Sams Teach Yourself SQL in 24 Hours, Third Edition presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises, and quizzes. New material covers more information on transactions, constructs, embedded databases, and object-oriented programming. In this edition, the authors include examples based on a database like MySQL, a very popular open source database.
Chapters include:

  • Part I: A SQL Concepts Overview
  • Hour 1. Welcome to the World of SQL
  • Part II: Building Your Database
  • Hour 2. Defining Data Structures
  • Hour 3. Managing Database Objects
  • Hour 4. The Normalization Process
  • Hour 5. Manipulating Data
  • Hour 6. Managing Database Transactions
  • Part III: Getting Effective Results from Queries
  • Hour 7. Introduction to the Database Query
  • Hour 8. Using Operators to Categorize Data
  • Hour 9. Summarizing Data Results from a Query
  • Hour 10. Sorting and Grouping Data
  • Hour 11. Restructuring the Appearance of Data
  • Hour 12. Understanding Dates and Times
  • Part IV: Building Sophisticated Database Queries
  • Hour 13. Joining Tables in Queries
  • Hour 14. Using Subqueries to Define Unknown Data
  • Hour 15. Combining Multiple Queries into One
  • Part V: SQL Performance Tuning
  • Hour 16. Using Indexes to Improve Performance
  • Hour 17. Improving Database Performance
  • Part VI: Using SQL to Manage Users and Security
  • Hour 18. Managing Database Users
  • Hour 19. Managing Database Security
  • Part VII: Summarized Data Structures
  • Hour 20. Creating and Using Views and Synonyms
  • Hour 21. Working with the System Catalog
  • Part VIII: Applying SQL Fundamentals in Today’s World
  • Hour 22. Advanced SQL Topics
  • Hour 23. Extending SQL to the Enterprise, the Internet, and the Intranet
  • Hour 24. Extensions to Standard SQL

Read: Sams Teach Yourself SQL in 24 Hours

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

PHP and MySQL Programming

Sponsor Advertisement

My image
  • Author: Wikibooks, the open-content textbooks collection
  • Format: HTML
  • Price: free

This book provides an beginners introduction  to PHP and interacting with MySQL databases. It also includes some material related to developing desktop CLI applications and processing XML.

The book is a work in progress, and there may be incomplete or missing chapters.

Chapters include:

  • Introduction to PHP
  • Syntax Overview
  • File Handling
  • Database Connectivity
  • Session Handling
  • Command Line Programming
  • Form Handling
  • Introduction to MySQL
  • Creating a Database
  • Creating a Table
  • Basic Queries
  • Common Functions and Operators
  • XML and PHP

http://en.wikibooks.org/wiki/PHP_and_MySQL_Programming

Blackfish SQL Developers Guide

Sponsor Advertisement

  • Author: Steven T. Shaughnessy, Jens Ole Lauridsen
  • Format: archived PDF
  • Price: free

Blackfish SQL is a high-performance, small-footprint, transactional database that  was originally implemented as an all-Java database called JDataStore. This is now called Blackfish SQL for Java.
Blackfish SQL was then ported from Java to C#. The C# implementation is called Blackfish SQL for Windows.

This book is intended for developers implementing Blackfish SQL database applications and system administrators responsible for installing, deploying, and maintaining Blackfish SQL databases.

A CodeGear Developer Network membership is needed in order to download the .zip file. Registration is free.

Chapters include:

  • Overview
  • System Architecture
  • Establishing Connections
  • Administering Blackfish SQL
  • Using Blackfish SQL Security
  • Using Stored Procedures and User Defined Functions
  • Using Triggers in Blackfish SQL Tables
  • Stored Procedures Reference
  • SQL Reference
  • Optimizing Blackfish SQL Applications
  • Deploying Blackfish SQL Database Applications
  • Troubleshooting

http://cc.embarcadero.com/Item/24980