- Paperback: 312 pages
- Publisher: O'Reilly Media; 1 edition (29 Aug 2005)
- Language English
- ISBN-10: 0596007272
- ISBN-13: 978-0596007270
- Product Dimensions: 23 x 17.8 x 2.4 cm
- Average Customer Review: 4.5 out of 5 stars See all reviews (4 customer reviews)
-
Amazon Bestsellers Rank:
415,239 in Books (See Top 100 in Books)
- #23 in Books > Computers & Internet > Computer Science > Programming > Introduction to Programming > SQL
- #34 in Books > Computers & Internet > Computer Science > Databases > Beginners & Introduction > SQL & Relational Databases
- #49 in Books > Computers & Internet > Computer Science > Databases > SQL
- See Complete Table of Contents
Learning SQL
and over 900,000 other books are available for Amazon Kindle .
Learn more
| ||||||||||||||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Amazon.co.uk Trade-In Store for more details. |
|
There is a newer edition of this item:
|
Product details |
More About the Author
Product Description
Review
"If you have been avoiding coming to grips with SQL, or if you feel that you are only just coping with putting together queries and designing tables, then this is the book you need to understand what is going on." - Mike James, VSJ, July/August 2006
Product Description
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
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.
Inside This Book
(Learn More)
Front Cover | Copyright | Table of Contents | Excerpt | Index
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
23 of 24 people found the following review helpful:
5.0 out of 5 stars
An Excellent Book,
By
This review is from: Learning SQL (Paperback)
After wanting to get a better grasp on SQL and its Syntax I bought this book along with it other companion "SQL Cookbook".It has a nicely written and easy to understand flow with exercises at the end of each chapter. I find this a great help as when you have read the chapter, you can try and solve the exercises and hopefully it will have sunk in more. The hardest section is on subqueries as it seem that you can put them everywhere(ugggh). It also explains the nuances with SQL Server and Oracle, as the syntax changes for little things like altering tables and transaction. So in all a very good book that will prove a useful reference and tool for improving ones knowledge of SQL.
16 of 17 people found the following review helpful:
5.0 out of 5 stars
Fantastic book for begginers,
By
This review is from: Learning SQL (Paperback)
I'm not a programmer and I bought this book having no idea of SQL, and I can say I learned a lot from it. It's easy to understand and it's well structured. Maybe it doesn't cover every aspect of SQL, but it's the place to start to write your first queries. Give it a try, you won't regret!
3 of 3 people found the following review helpful:
3.0 out of 5 stars
Good start, becoming undecided,
By
This review is from: Learning SQL (Paperback)
I purchased this book to help me get to grips with the SQL syntax before starting a new job.I have experience of working with databases and have found the book so far to be a good introduction to SQL - I don't think it would necessarily be a good introduction to databases, so if you're new to SQL and database administration, you may want to look elsewhere or purchase an introductory text to databases to complement this book. To really get the most out of this book you need to use the online resources and complete the tests at the end of each chapter - which is where the book is let down. All the effort of making the text easy to read and follow is ruined by the mismatch between the examples in the book and the data supplied on the O'Reilly site. There are positives and negatives to this - a huge negative is that for a while I thought I was getting things wrong, and repeatedly doubting myself and my ability to learn SQL. A positive on the other hand is that it makes you look at the database structure and raw data to see why you can't get the answer that the book suggests is possible. After much investigation, I discovered the data populated via the online SQL file doesn't match to the data being used by the author. After a while this just becomes annoying, especially when you try to complete the tests and can't get the correct answers. You then have to either populate the data (good practice I suppose) or modify your query to get a different answer, using the same approach. The book would get five stars if it wasn't for the problems mentioned above. Delivery etc, excellent as always from Amazon.
Share your thoughts with other customers: Create your own review
Would you like to see more reviews about this item?
|
Most Recent Customer Reviews |
Listmania!
Look for similar items by category
- Books > Computing & Internet > Computer Science > Information Systems
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > Beginners & Introduction > SQL & Relational Databases
- Books > Computing & Internet > Databases > Data Storage & Management > Data Warehousing
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Theory
- Books > Computing & Internet > Databases > SQL
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Introduction to Programming > SQL
- Books > Science & Nature > Engineering & Technology
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
