Head first SQL

Select an Action

Title:

Head first SQL

Author:

Beighley, Lynn.

ISBN:

9780596526849

Personal Author:

Beighley, Lynn.

Publication Information:

Beijing ; Sebastopol : O'Reilly, c2007.

Physical Description:

xxxv, 571 p. : ill. ; 24 cm.

Series:

Head first series

Head first series.

General Note:

"A brain-friendly guide"--Cover.

Includes index.

Contents:

Data and tables: a place for everything -- The select statement: Gifted data retrieval -- Delete and update: A change will do you good -- Smart table design: Why be normal? -- Alter: Rewriting the past -- Advanced select: Seeing your data with new eyes -- Multi-table database design: Outgrowing your table -- Joins and multi-table operations: Can't we all just get along? -- Subqueries: Queries within queries -- Outer joins, self joins, and unions: New maneuvers -- Constraints, views, and transactions: Too many cooks spoil the database -- Security: Protecting your assets.

Abstract:

Presents an instructional guide to SQL which uses humor and simple images to cover such topics as the structure of relational databases, simple and complex queries, creating multiple tables, and protecting important table data.

Subject Term:

SQL (Computer program language)

Electronic Access:

Contributor biographical information http://catdir.loc.gov/catdir/enhancements/fy0912/2008295849-b.html
Publisher description http://catdir.loc.gov/catdir/enhancements/fy0915/2008295849-d.html
Table of contents only http://catdir.loc.gov/catdir/enhancements/fy1304/2008295849-t.html

Copies:

Available:*

Library	Material Type	Item Barcode	Shelf Number	Copy	Status
Searching... 1:IIEMSA	1:GEN-BOOK	33168025783925	005.7565H 2007	1	Searching... Unknown

Bound With These Titles

On Order

Summary

Is your data dragging you down? Are your tables all tangled up? Well we've got the tools to teach you just how to wrangle your databases into submission. Using the latest research in neurobiology, cognitive science, and learning theory to craft a multi-sensory SQL learning experience, Head First SQL has a visually rich format designed for the way your brain works, not a text-heavy approach that puts you to sleep.

Maybe you've written some simple SQL queries to interact with databases. But now you want more, you want to really dig into those databases and work with your data. Head First SQL will show you the fundamentals of SQL and how to really take advantage of it. We'll take you on a journey through the language, from basic INSERT statements and SELECT queries to hardcore database manipulation with indices, joins, and transactions. We all know "Data is Power" - but we'll show you how to have "Power over your Data". Expect to have fun, expect to learn, and expect to be querying, normalizing, and joining your data like a pro by the time you're finished reading!