LinuxLinks.com
Newbies What Next ? News Forums Calendar

Search





News Sections
Home
General News (3987/0)
Reviews (637/0)
Press Releases (465/0)
Distributions (197/0)
Software (911/0)
Hardware (537/0)
Security (192/0)
Tutorials (356/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 Saturday, July 04 2015 @ 01:25 PM 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
100 Essential Apps
All Group Tests


Top Free Software
5 Office Suites
3 Lean Desktops
7 Document Processors
4 Distraction Free Tools
9 Project Management
4 Business Solutions
9 Groupware Apps
14 File Managers
10 Databases
21 Backup Tools
21 Productivity Tools
5 Note Taking Apps
9 Terminal Emulators
21 Financial Tools
5 Bitcoin Clients
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
42 Best Games
9 Steam Games
42 Audio Apps
5 Music Streaming
42 Video Apps
5 YouTube Tools
80 Security Apps
9 System Monitoring
8 Geometry Apps
Free Console Apps
14 Multimedia
4 Audio Grabbers
9 Internet Apps
3 HTTP Clients
5 File Managers
Programming
8 Compilers
9 IDEs
9 Debuggers
7 Revision Control Apps
6 Doc Generators
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

Other Articles
Migrating from Windows
Back up your data
20 Free Linux Books
24 Beginner Books
12 Shell Scripting Books


Older Stories
Sunday 04/12
  • First Peek at XBian on the Raspberry Pi 2 (0)

  • Saturday 04/04
  • First Look at OSMC RC on the Raspberry Pi 2 (0)

  • Sunday 03/29
  • First Steps with OpenELEC on the Raspberry Pi 2 (0)
  • Ubuntu MATE 15.04 for Raspberry Pi 2 (0)

  • Monday 03/16
  • MIPS Creator CI20 v Raspberry Pi 2 (0)
  • Raspberry Pi 2: Raspbian (ARMv6) v Linaro (ARMv7) (0)

  • Friday 03/06
  • Raspberry Pi 2 review (0)

  • Sunday 02/22
  • Chess in a Few Bytes (0)
  • Learn the Art of Computer Programming With These Great Free Beginner Books (2)
  • CD Audio Grabbers (0)


  • Vote

    What Linux distribution do you run on your main computer?

    Debian
    Fedora
    Mint
    Slackware
    openSuSE
    Arch
    Ubuntu
    Redhat
    Mageia
    CentOS
    FreeBSD
    Results
    842 votes | 3 comments

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