- Jubilee offer: spend £10 or more on any product sold by Amazon.co.uk on or before June 6 and you can buy The Diamond Jubilee A Classical Celebration Album for just £2.50 Here's how (terms and conditions apply)
Learning SQL
and over one million other books are available for Amazon Kindle .
Learn more
| ||||||||||||||||||
 Trade In this Item for up to £7.35
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Learning SQL for an Amazon.co.uk gift card of up to £7.35, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Special Offers and Product Promotions
Frequently Bought Together
Product details
|
More About the Author
Product Description
Book Description
Master SQL Fundamentals
Product 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.
Inside This Book
(Learn More)
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
23 of 24 people found the following review helpful
Format:Paperback|Amazon Verified Purchase
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.
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
Format: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
Format: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.
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.
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
Reasonable book to get you going.
After many years avoiding SQL, I thought I'd better have a go and decided to go with this book.
The book is well written and has some good examples to follow; However, with... Read more
The book is well written and has some good examples to follow; However, with... Read more
Published 2 months ago by Blue
excellent book
Before start to buy this i have no idea about this book. but i like to learn SQL i searched at amazon and two read two people comments with a hope i bought this book. Read more
Published 22 months ago by karesh
Listmania!
|
|
Look for similar items by category
- Books > Computing & Internet > Databases > Beginners & Introduction > SQL & Relational Databases
- Books > Computing & Internet > Databases > Data Storage & Management > Data Mining
- 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 > 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.
|
