| | |  | Investigations | Home » » Learning SQL | | | | | | | Description: | | Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.
Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: - Move quickly through SQL basics and learn several advanced features
- Use SQL data statements to generate, manipulate, and retrieve data
- Create database objects, such as tables, indexes, and constraints, using SQL schema statements
- Learn how data sets interact with queries, and understand the importance of subqueries
- Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements
Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.
| | | Features: | |
• ISBN13: 9780596520830
• Condition: New
• Notes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, prices and service to the competition. 100% Satisfaction Guaranteed
| | | Product Details: | | | Author:
| Alan Beaulieu | | Paperback:
| 336 pages | | Publisher:
| O'Reilly Media | | Publication Date:
| April 20, 2009 | | Language:
| English | | ISBN:
| 0596520832 | | Package Length:
| 9.06 inches | | Package Width:
| 7.01 inches | | Package Height:
| 0.79 inches | | Package Weight:
| 1.01 pounds | | Average Customer Rating:
| based on 33 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 Write an online review and share your thoughts with other customers.
1 of 1 found the following review helpful:
Good book for begineersJul 09, 2010 I would recommend this book to anyone who is starting to learn SQL.
This book is a begineers book teaching various SQL statements like SELECT, INSERT, DELETE. The book starts off with the available database models like Network, Object and Heirarchical models and then goes ahead and explains the commands. The commands are written for MySQL which is freely available for download and install. The author also explains the variations in Oracle and SQL Server where appropriate.
The commands are grouped together and covered one by one. The topics covered are statements like SELECT, INSERT, DELETE, aggregate functions, joining more than one table, set operations like union, intersection, views, indexes, constraints, transaction etc.
There is also "Test your knowledge" at the end of each chapter which helps you to reinforce what you just learnt with the solutions at the end of the book in case you are struck and don't know how to proceed.
This book just introduces all the beginners concept in a nice way. The examples are simple to follow and learn.
PROS : Covers all SQL commands, Show different variations among Database vendors
CONS : Begineer book (no indepth knowledge)
1 of 1 found the following review helpful:
Easy to understandMay 26, 2010 I don't have any technical experience writing queries and I found this book easy to read and understand. I would highly recommend it!
1 of 3 found the following review helpful:
Bad quality binding.Mar 03, 2010 The book content is fine, unfortunately the book is just falling apart after very little use. And it seems I've missed the return window. So this is my only option to voice a complaint.
4 of 4 found the following review helpful:
An excellent introduction to SQLJan 05, 2010 The header on the front page of this book says "A Pain-Free Introduction to SQL..." and that's what the book exactly is.
The book introduces and discusses SQL statements for DB creation, population, querying - and subquerying -, data generation, conversion and manipulation. The SQL statements are illustrated through practical sound examples all the way long. In each section where a new topic is addressed, the author reveals the SQL statement that implements or illustrates it, discusses the whys and hows, then comments on the actual results returned by the database after the statement is executed. Although the statement examples are run on MySQL and author assumes version 4.1.11 or later will be used, running them on another DB and/or version should not be a problem as the statements are mainly based on ANSI SQL syntax, except for a few identified as such. MySQL extensions to the ANSI SQL syntax are addressed in an appendix.
Although I found all parts of the book are useful and worth reading, I believe Chapter 10 on Joins alone justifies the cost of this book. As one of the statements used most in the querying of actual DB applications, if you need good understanding and proper handling of Joins, you ought to read this one.
This is an introductory book to SQL, not to databases. Preliminary basic knowledge on data modeling, tables, indexes, etc. will be helpful understanding the contents of it. Precisely because this is an introductory book, you'll definitely need additional advanced SQL readings - e.g. SQL Cookbook - and your particular database product's SQL reference and its extensions to the language - e.g. T-SQL for MS SQL Server - for serious SQL querying in your DB application.
Good Reference BookDec 10, 2009 I didn't get the chance to read the book from start to finish, due to the lack of time, but I now use it for reference. It was very easy to use and had more details compared to some SQL Books that I tried.
| | |
|