Category: SQL

Introducing Microsoft SQL Server 2012

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

SQL for Web Nerds

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

Introduction to Databases for the Web

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

Blackfish SQL Developers Guide

  • 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