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 (878/0)
Hardware (522/0)
Security (192/0)
Tutorials (345/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 - Page 2

6 of the Best Free SQL Books - Page 2

4. Sams Teach Yourself SQL in 24 Hours

Sams Teach Yourself SQL in 24 Hours
Website www.informit.com/library/library.aspx?b=STY_Sql_24
Author Ron Plew, Ryan Stephens
Format HTML
Pages 670

Sams Teach Yourself SQL in 24 Hours presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises, and quizzes. This book was written primarily for those with very little or no experience with relational database management systems using SQL.

This book is not a complete SQL reference and should not be relied on as a sole reference of SQL. However, this book combined with a complete SQL command reference could serve as a complete solution.

Chapters cover:

  • SQL Concepts Overview
  • Building Your Database
  • Getting Effective Results from Queries
  • Building Sophisticated Database Queries
  • SQL Performance Tuning
  • Using SQL to Manage Users and Security
  • Summarized Data Structures
  • Applying SQL Fundamentals in Today's World

5. SQL for Web Nerds

SQL for Web Nerds
Website philip.greenspun.com/sql/
Author Philip Greenspun
Format HTML
Pages 300

SQL for Web Nerds is a structured online book on SQL, based on the Oracle database. Queries, transactions, triggers, and RDBMS concepts are covered. Tap into the power of the relational database management system for concurrency control and transaction management.

  • Data modeling - tell the relational database management system what elements of the data you will store, how large each element can be, what kind of information each element can contain, what elements may be left blank, which elements are constrained to a fixed range, and whether and how various tables are to be linked
  • 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) examining atomicity, consistency, and mutual exclusion
  • Triggers - fragments of code that you tell Oracle to run before or after a table is modified
  • Views - a way of building even greater abstraction
  • Style
  • Escaping to the procedural world: PL/SQL and Java executing inside the Oracle server
  • Trees in Oracle SQL - shows the reader that a row in an SQL database can be thought of as an object, a pointer from one object to another can be represented by storing an integer key in a regular database column, demonstrates the Oracle tree extensions (CONNECT BY ... PRIOR), and how to work around the limitations of CONNECT BY with PL/SQL
  • 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 - a way of splitting up data until each table represents propositions about a single type of thing

6. Developing Time-Oriented Database Applications in SQL

Developing Time-Oriented Database Applications in SQL

Website www.cs.arizona.edu/people/rts/
Author Richard T. Snodgrass
Format PDF
Pages 528

Developing Time-Oriented Database Applications in SQL is an out-of-print book which shows professional SQL programmers how to effectively develop applications that involve time-oriented data and queries. It explains in detail how to record temporal data in tables using the SQL types, how to define appropriate integrity restraints, how to correctly update temporal tables using interactive and embedded SQL, and how to write a wide range of interactive and embedded SQL queries involving temporal tables.

Sample queries include time-slice queries, different kinds of temporal joins, temporal coalescing, temporal aggregates, temporal unions, differences, and intersections.

This book assumes that the reader is comfortable with the SQL query language.

Chapters cover:

  • Fundamental concepts - valid-time state tables, transaction-time state tables, and bitemporal tables
  • Instants and intervals - also looks at predicates, constructors, implementation considerations and more
  • Periods - literals, predicates, constructors, and implementation considerations
  • Defining state tables - initial schema, adding history, temporal keys, handling now, uniqueness, referential integrity, and constraint attributes
  • Querying state tables - extracting the current state, extracting prior states, sequenced queries, nonsequenced variants, and eliminating duplicates
  • Modifying State Tables - current / sequenced / nonsequenced modifications, modifications that mention other tables, and temporal partitioning
  • Retaining a Tracking Log - defining the tracking log, queries, modifications, permitting insertions, backlogs, using after-images consistently, and transaction semantics
  • Transaction-Time State Tables - definition, maintenance, queries, temporal partitoning, and vacuuming
  • Bitemporal Tables - definition, modifications, queries, integrity partioning, and vaccuming
  • Temporal Database Design - properly sequencing the design, conceptual / logical / physical design, advanced design aspects, benefits, and application development
  • Language Directions - SQL-92, SQL-92 limitations, SQL3, periods, defining valid-time state tables, querying and modifying state tables, retaining a tracking log, transaction-time state tables, bitemporal tables, capstone case, migration, and additional constructs of SQL3

Back to the Beginning: 6 of the Best Free SQL Books - Page 1

Bookmark and Share


Last Updated Monday, May 26 2014 @ 03:23 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
All Group Tests

Top Free Software
5 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
Saturday 08/02
  • The Best Lightweight Graphical Email Clients (0)

  • Sunday 07/20
  • Excellent Free Distraction-Free Tools for Writers (0)
  • Pick of the Bunch: Console Internet Applications (0)
  • Mobile Phone Management Made Easy (0)

  • Saturday 06/28
  • Easy File Comparisons With These Great Free Diff Tools (0)
  • 9 ASCII Games You'll Want to Play Again and Again (0)

  • Friday 06/13
  • 12 Remarkable Free Shell Scripting Books (0)

  • Saturday 06/07
  • Open Source LDAP Solutions (0)

  • Monday 06/02
  • Delightful ASCII Art Tools (0)

  • Saturday 05/31
  • Best Tools for Network Inventory Management (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
    4847 votes | 2 comments

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