Category: SQL

Introducing Microsoft SQL Server 2012

Introducing Microsoft SQL Server 2012

Introducing Microsoft SQL Server 2012

Author Ross Mistry and Stacia Misner
Format PDF
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.

Continue reading

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

Sams Teach Yourself Microsoft SQL Server 7 in 21 Days

  • 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



  • 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

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