LinuxLinks.com
Newbies What Next ? News Forums Calendar

Search





News Sections
Home
General News (3973/0)
Reviews (628/0)
Press Releases (464/0)
Distributions (187/0)
Software (859/0)
Hardware (522/0)
Security (192/0)
Tutorials (344/0)
Off Topic (181/0)


User Functions
Username:

Password:

Don't have an account yet? Sign up as a New User


Events
There are no upcoming events




6 of the Best Free SQL Books

6 of the Best Free SQL Books

Structured Query Language (SQL) is a specialized programming language originally developed by IBM in the early 1970s. The language is designed specifically for accessing and manipulating data held in a relational database management system (RDBMS).

Almost all database management systems have a SQL implementation. It is the most popular query language for database administrators, as it provides good functionality, power, and relative ease of use. It is widely used in both industry and academia, often for large, complex databases.

SQL was standardized by the American National Standards Institute (ANSI) in 1986 and has undergone many revisions. The language consists of a data definition language and a data manipulation language. The language is divided into a number of elements: clauses, expressions, predicates, queries, and statements.

SQL is one of the easiest languages to learn and use. The focus of this article is to select some of the finest SQL books which help database administrators quickly get up to speed with this special-purpose programming language. All of the books are available to download for free.

To cater for all tastes, we have chosen a good range of books. All of the texts here come with our strongest recommendation. So get reading (and downloading).

1. Practical PostgreSQL

Practical PostgreSQL
Website www.commandprompt.com/ppbook/
Author Joshua D. Drake, John C. Worsley
Format HTML
Pages 640

Practical PostgreSQL is a comprehensive book that shows the reader how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. It also covers the many advanced features, such as transactions, versioning, replication, and referential integrity that enable developers and DBAs to use PostgreSQL for serious business applications.

The thorough introduction to PostgreSQL's PL/pgSQL programming language explains how you can use this very useful but under-documented feature to develop stored procedures and triggers. The book includes a complete command reference, and database administrators will benefit from the chapters on user management, database maintenance, and backup & recovery. With Practical PostgreSQL, the reader will discover quickly why this open source database is a great open source alternative to proprietary products from Oracle, IBM, and Microsoft.

Chapters cover:

  • Introduction and Installation
  • Using PostgreSQL - cover understanding SQL, using SQL with PostgreSQL, operators and functions, PostgreSQL clients (psql and PgAccess), and advanced features
  • Administrating PostgreSQL - authentication and encryption, database management, user and group management
  • Programming with PostgreSQL - PL/pgSQL, JDBC, and LXP
  • PostgreSQL Command Reference
  • Appendixes: Multibyte Encoding Types, Backend Options for Postgres, Binary COPY Format, and Internal pyql Variables

2. SQL Performance Explained

SQL Performance Explained
Website use-the-index-luke.com/sql/table-of-contents
Author Markus Winand
Format HTML
Pages 204

SQL Performance Explained helps developers to improve database performance. The focus is on SQL; it covers all major SQL databases without getting lost in the details of any one specific product.

Starting with the basics of indexing and the WHERE clause, SQL Performance Explained guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) tools like Hibernate.

Topics covered include:

  • Anatomy of an Index - the fundamental structure of an index
  • The Where Clause - explains all aspects of the where clause, from very simple single column lookups to complex clauses for ranges and special cases such as LIKE
  • Performance and Scalability - looks at Performance and Scalability
  • The Join Operation - an explanation of how to use indexes to perform a fast table join
  • Clustering Data - the difference between selecting a single column and all columns
  • Sorting and Grouping - even order by and group by can use indexes
  • Partial Results - explains how to benefit from a "pipelined" execution if you donít need the full result set
  • Insert, Delete and Update
  • Appendices: Execution Plans, Myth Directory, and Example Schema

3. A Primer on SQL

A Primer on SQL
Website www.dreamincode.net/.../entry-4251-my-free-ebook-a-primer-on-sql
Author Rahul Batra
Format PDF
Pages 42

A Primer on SQL is a fairly short ebook teaching the basics of SQL. The author assumes that the reader has no previous experience of SQL.

While the examples and text use Ingres as the database management system, the code should work correctly on any SQL compliant database. Since this text deals largely with teaching SQL in a product independent manner, rather than the teaching of Ingres per se, details with respect to installation and specific operations of the product is kept to a minimum.

Chapters cover:

  • An Introduction to SQL
  • Getting your Database ready - covers the basic of creating a database, inserting data, and writing a query
  • Constraints - a rule that you apply or abide by while doing SQL operations. This chapter examines selective fields INSERT, primary key constraint, unique key constraint, and the differences between a primary key and a unique key
  • Operations on Tables - drop tables, create new tables from existing tables, modify tables, verifying the result in Ingres and other database systems
  • Writing Basic Queries - a query is a SQL statement that is used to extract a subset of data from your database and presents it in a readable format
  • Manipulating Data - looks at the Data Manipulation Language (DML) part of SQL which is used to make changes to the data inside a relational database
  • Organizing your Data - covers normalization, atomicity, repeating groups, and splitting the table
  • Doing more with Queries - more examples of how we can modify SELECT statements; counting the records in a table, column aliases, and using the LIKE operator
  • Aggregation and Grouping - an aggregate function is used to compute summarization information from a table or tables. Looks at using DISTINCT with COUNT, using MIN to find minimum values, grouping data with the GROUP BY clause of a SELECT query, and the HAVING clause
  • Understanding Joins - a join operation allows you to retrieve data from multiple tables in a single SELECT query

This material is licensed under the Open Publication License, v1.0 or later.

Next Section: 6 of the Best Free SQL Books - Part 2

Bookmark and Share


Last Updated Sunday, May 25 2014 @ 06:27 AM EDT


We have written a range of guides highlighting excellent free books for popular programming languages. Check out the following guides: C, C++, C#, Java, JavaScript, CoffeeScript, HTML, Python, Ruby, Perl, Haskell, PHP, Lisp, R, Prolog, Scala, Scheme, Forth, SQL, Node.js (new), Fortran (new), Erlang (new), Pascal (new), and Ada (new).


Group Tests
All Group Tests

Top Free Software
6 Office Suites
7 Document Processors
6 Lean Desktops
6 Desktop Search
9 Project Management
9 Groupware Apps
14 File Managers
10 Databases
21 Backup Tools
21 DVD Tools
21 Window Managers
21 Productivity Tools
9 Terminal Emulators
21 Financial Tools
21 Text Editors
21 Video Emulators
21 Home Emulators
42 Graphics Apps
6 CAD Apps
42 Scientific Apps
10 Web Browsers
42 Email Apps
12 Instant Messaging
10 IRC Clients
7 Twitter Clients
12 News Aggregators
11 VoIP Apps
11 Remote Display Apps
42 Best Games
42 More Games
21 More Games
21 Notable Games (1)
21 Notable Games (2)
21 Notable Games (3)
8 ASCII Games
9 Educational Games
42 Audio Apps
42 Video Apps
6 Screencasting Apps
80 Security Apps
9 System Monitoring
6 Family History Apps
11 PDF Tools
6 Music Servers
6 Collection Managers
7 Calculator Apps
8 Geometry Apps
Free Console Apps
14 Multimedia
Programming
8 Compilers
9 IDEs
9 Debuggers
7 Revision Control Apps
6 Doc Generators
'Free' Proprietary
21 Closed-Source Apps
Top Commercial Apps
42 Games
Free Web Software
21 Web CMS
14 Wiki Engines
8 Blog Apps
6 eCommerce Apps
5 Human Resource Apps
10 ERP
10 CRM
6 Data Warehouse Apps
8 Business Intelligence
6 Point-of-Sale

All Group Tests

Other Articles
Migrating from Windows
Back up your data
Distribution Guide
Distro Portal Pages
20 Free Linux Books
Running Linux Under Windows


Older Stories
Sunday 03/30
  • Increasing Lab Efficiency with an Open Source LIMS (0)
  • Keep a Watchful Eye with these Console Based Process Viewers (0)

  • Saturday 03/15
  • Focus on Your Writing by Using Markdown Editors (0)

  • Sunday 03/09
  • Experience Home Computers that Missed the Big Time (0)

  • Monday 03/03
  • Molly: Children of the Universe (0)

  • Sunday 03/02
  • Up-and-Coming Clients to Tweet (0)
  • Reminiscing the Wonderful ZX Spectrum (0)

  • Monday 02/17
  • Need a Good Bitcoin Client? (0)

  • Sunday 02/09
  • 5 Highly Promising Cross-Platform IDEs (0)
  • Play the Best Linux Puzzle Games (0)


  • Vote

    What do you find MOST attractive about Open Source software?

    Amount of customization
    Security
    Freedom provided
    Speed of development
    Quality
    Multiple versions
    Cost
    Potential to contribute
    Ability to modify code
    Results
    4720 votes | 2 comments

    Built with GeekLog and phpBB
    Comments to the webmaster are welcome
    Copyright 2009 LinuxLinks.com - All rights reserved