Learning SQL

Learning SQL
by Alan Beaulieu

Learning SQL
List Price: $34.95
Our Price: $13.95
You Save: $21.00 (60%)
Availability: Usually ships in 24 hours
Buy Used: from $1.55 (click here)
Category: Book
See more book details and other editions


(Click here)
Buy this book at online book store in your country
Canada | UK | Germany | France

Book Summary Information

Author: Alan Beaulieu
Edition: Paperback
Audio: English (Unknown); English (Original Language); English (Published)
Published: 2005-08-29
ISBN: 0596007272
Number of pages: 312
Publisher: O'Reilly Media

Book Reviews of Learning SQL

Book Review: SQL 101
Summary: 5 Stars

Over the past 30+ years programming languages (popular ones) have come, gone, and new ones seem to appear every couple of years or so. FORTRAN, COBOL, Pascal, C, C++, Java, and now C#... the question isn't IF the next big language is going to come but WHEN. While the way we program has changed, the de facto standard for talking and creating databases hasn't changed much since the early 70s when SQL was created. While refined and standardized several times since its inception, SQL remains the tried and true backbone way of communicating with all databases, whether they are Oracle, SQL Server, MYSql, Access, etc.

For this reason, it is not only important, but I believe ESSENTIAL for all developers in this day and age to come quickly up to speed and learn what SQL is because no matter who you are, at some point (probably sooner than later) you will have to use SQL in your development career. Back when I was introduced to SQL in the mid 90s I knew nothing of what SQL was, thrown into it by immediately looking at SELECT queries, INSERTS, and so on. I would have loved some overview teaching guide to help me get my feet wet, instead learning the hard way.

Have no fear, those days are over.

With 'Learning SQL', Alan Beaulieu gives a great overview of what SQL is and what makes it so important in the world today. More than any other programming language, databases are what keeps the world moving on a daily basis, whether it's the financial sector, health care, government, etc. No matter where you using a computer, you will be accessing a database and for that data to be grabbed and manipulated, you will need to use SQL to make your calls/updates.

O'Reilly has a storied tradition of making great "Learning" books, and the same can easily be said here as well. I find it amazing that it took so long for a Learning SQL book to come out, but sometimes it's better to wait and let the finished product be even better with age.

Highlights include:

History of SQL (background)
Creating and populating a database
Using SELECT statements to get data
Filtering data with conditions
Querying multiple tables at once
Working with sets (UNIONS et al)
Data generation, conversion, manipulation
GROUP statements
Creating subqueries
JOINS in detail
Adding conditional logic
The importance of Transactions
Performance gains via Indexes and Constraints

For anyone that isn't a SQL expert, this is a great refresher for all. For anyone that is new or an amateur in their SQL careers, this book is absolutely a gem.

This should be required reading for all database 101 students, and I give it an A+ for not only the content within but the simplicity with which it is to read.

***** HIGHEST POSSIBLE RECOMMENDATION

Summary of Learning SQL

SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements.

To help you attain this fundamental SQL knowledge, look to Learning SQL, an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language.

Learning SQL moves you quickly through the basics and then on to some of the more commonly used advanced features. Among the topics discussed:

  • The history of the computerized database
  • SQL Data Statements--those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and delete
  • SQL Schema Statements--those used to create database objects, such as tables, indexes, and constraints
  • How data sets can interact with queries
  • The importance of subqueries
  • Data conversion and manipulation via SQL's built-in functions
  • How conditional logic can be used in Data Statements
Best of all, Learning SQL talks to you in a real-world manner, discussing various platform differences that you're likely to encounter and offering a series of chapter exercises that walk you through the learning process. Whenever possible, the book sticks to the features included in the ANSI SQL standards. This means you'll be able to apply what you learn to any of several different databases; the book covers MySQL, Microsoft SQL Server, and Oracle Database, but the features and syntax should apply just as well (perhaps with some tweaking) to IBM DB2, Sybase Adaptive Server, and PostgreSQL.

Put the power and flexibility of SQL to work. With Learning SQL you can master this important skill and know that the SQL statements you write are indeed correct.

Data Mining Books

Book Subjects
Most talked about in Data Mining Books
Machine Learning and Its Applications: Advanced Lectures (Lecture Notes in Computer Science / Lecture Notes in Artificial Intelligence) ImageMachine Learning and Its Applications: Advanced Lectures (Lecture Notes in Computer Science / Lecture Notes in Artificial Intelligence)
Springer; Published: 2001-09-21; Paperback; Book
Best price: $55.67
Price in other shops: $69.95
Web Dynamics: Adapting to Change in Content, Size, Topology and Use ImageWeb Dynamics: Adapting to Change in Content, Size, Topology and Use
Springer; Published: 2004-06-14; Hardcover; Book
Best price: $79.41
Price in other shops: $129.00
Discovery Science: 8th International Conference, DS 2005, Singapore, October 8-11, 2005, Proceedings (Lecture Notes in Computer Science / Lecture Notes in Artificial Intelligence) ImageDiscovery Science: 8th International Conference, DS 2005, Singapore, October 8-11, 2005, Proceedings (Lecture Notes in Computer Science / Lecture Notes in Artificial Intelligence)
Springer; Published: 2005-11-14; Paperback; Book
Best price: $69.31
Price in other shops: $78.00
Advances in Database Technology - EDBT 2004 ImageAdvances in Database Technology - EDBT 2004
Springer; Published: 2004-04-14; Paperback; Book
Best price: $111.27
Price in other shops: $129.00
Collaborative Knowledge Acquisition from Semantically Disparate, Distributed Data Sources (Advanced Information and Knowledge Processing) ImageCollaborative Knowledge Acquisition from Semantically Disparate, Distributed Data Sources (Advanced Information and Knowledge Processing)
by Vasant Honavar, Doina Caragea
Springer; Published: 2012-04-13; Hardcover; Book
Best price: $84.75
Price in other shops: $99.00
Adaptive Web Sites: A Knowledge Extraction from Web Data Approach - Volume 170 Frontiers in Artificial Intelligence and Applications ImageAdaptive Web Sites: A Knowledge Extraction from Web Data Approach - Volume 170 Frontiers in Artificial Intelligence and Applications
by J. D. Velasquez, V. Palade
IOS Press; Published: 2008-01-15; Hardcover; Book
Best price: $161.00
Kdd Proceedings 2000: Conference of Knowledge Discovery of Data-Mining ImageKdd Proceedings 2000: Conference of Knowledge Discovery of Data-Mining
Assn for Computing Machinery; Published: 2000-08; Paperback; Book
Best price: $78.00
COMPLIFE 2007: 3rd International Symposium on Computational Life Science (AIP Conference Proceedings) ImageCOMPLIFE 2007: 3rd International Symposium on Computational Life Science (AIP Conference Proceedings)
American Inst. of Physics; Published: 2007-09-26; Hardcover; Book
Best price: $61.00
Price in other shops: $85.00
Molecular Sequence Analysis: A Primer on Computational and Bioinformatic Approaches ImageMolecular Sequence Analysis: A Primer on Computational and Bioinformatic Approaches
by Sudhir Kumar, Alan Filipski
Wiley-Liss; Published: 2009-01-26; Paperback; Book
Price in other shops: $69.95
Fuzy Model Tools Data Mining Replace ImageFuzy Model Tools Data Mining Replace
by Cox
Academic Press; Paperback; Book
Similar Books and other products
SQL Pocket Guide (Pocket Reference (O'Reilly)) ImageSQL Pocket Guide (Pocket Reference (O'Reilly))
by Jonathan Gennick
O'Reilly Media; Published: 2006-04-24; Paperback; Book
Best price: $11.66
Price in other shops: $14.99
Learning Perl ImageLearning Perl
by Randal L. Schwartz, brian d foy, Tom Phoenix
O'Reilly Media; Published: 2011-07-01; Paperback; Book
Best price: $22.24
Price in other shops: $39.99
Database Modeling and Design, Fifth Edition: Logical Design (The Morgan Kaufmann Series in Data Management Systems) ImageDatabase Modeling and Design, Fifth Edition: Logical Design (The Morgan Kaufmann Series in Data Management Systems)
by Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish
Morgan Kaufmann; Published: 2011-02-24; Paperback; Book
Best price: $52.11
Price in other shops: $64.95
Data Analysis Using SQL and Excel ImageData Analysis Using SQL and Excel
by Gordon S. Linoff
Wiley; Published: 2007-10-01; Paperback; Book
Best price: $27.16
Price in other shops: $45.00
SQL in a Nutshell (In a Nutshell (O'Reilly)) ImageSQL in a Nutshell (In a Nutshell (O'Reilly))
by Kevin Kline, Brand Hunt, Daniel Kline
O'Reilly Media; Published: 2008-12-02; Paperback; Book
Best price: $22.55
Price in other shops: $44.99
SQL Pocket Guide (Pocket Guides) ImageSQL Pocket Guide (Pocket Guides)
by Jonathan Gennick
O'Reilly Media; Published: 2010-12-01; Paperback; Book
Best price: $8.32
Price in other shops: $14.99
Head First SQL: Your Brain on SQL -- A Learner's Guide ImageHead First SQL: Your Brain on SQL -- A Learner's Guide
by Lynn Beighley
O'Reilly Media; Published: 2007-09-01; Paperback; Book
Best price: $22.00
Price in other shops: $44.99
SQL Cookbook (Cookbooks (O'Reilly)) ImageSQL Cookbook (Cookbooks (O'Reilly))
by Anthony Molinaro
O'Reilly Media; Published: 2005-12-23; Paperback; Book
Best price: $21.99
Price in other shops: $39.95
Sams Teach Yourself SQL in 10 Minutes (3rd Edition) ImageSams Teach Yourself SQL in 10 Minutes (3rd Edition)
by Ben Forta
Sams; Published: 2004-04-10; Paperback; Book
Best price: $12.69
Price in other shops: $24.99
Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners (SQL Exam Prep Series 70-433 Volume 1 of 5) (Sql Design Series) ImageBeginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners (SQL Exam Prep Series 70-433 Volume 1 of 5) (Sql Design Series)
by Rick A Morelan
BookSurge Publishing; Published: 2009-12-30; Paperback; Book
Best price: $17.39
Price in other shops: $25.00
Book store. Illustrated catalog of books on different categories