Binding: Paperback Dewey Decimal Number: 005.133 EAN: 9780596102159 Format: Illustrated ISBN: 0596102151 Label: O'Reilly Media, Inc. Manufacturer: O'Reilly Media, Inc. Number Of Items: 1 Number Of Pages: 342 Publication Date: April 26, 2006 Publisher: O'Reilly Media, Inc. Sales Rank: 17827 Studio: O'Reilly Media, Inc.
Product DescriptionAnyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly.
If you're new to databases, or need a SQL refresher, 'Learning SQL on SQL Server 2005' is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft's SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge.
Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, 'Learning SQL on SQL Server 2005' starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you'll learn:
Beginning SQL commands, such as how and where to type an SQL query, and how to create, populate, alter and delete tables
How to customize SQL Server 2005's settings and about SQL Server 2005's functions
About joins, a common database mechanism for combining tables
Query development, the use of views and other derived structures, and simple set operations
Subqueries, aggregate functions and correlatedsubqueries, as well as indexes and constraints that can be added to tables in SQL Server 2005
Whether you're an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company's IT department, 'Learning SQL on SQL Server 2005' will get you up to speed on SQL in no time.
Customer Reviews
Average Rating:
Rating: - Excellent Book
I started reading this book two days ago and i was totally a novice at programming in SQL. I am now writing JOIN statements that i would never have thought possible and i'm looking forward to going even further while reading this book. It is a great book and easy to follow. I highly recommend this book.
Rating: - Good Intro to Microsofts SQL Server
I gave this book 4 stars as it's not intended for a complete novice to Relational Databases, but it still can you get you up and running. Also the book is laid out in a textbook or coursebook type manner so it can be applicable to a teaching setting and not a bulky bible like many SQL references that are out there.
Rating: - Workman-like Overview of SQL
I was looking for a book to refresh my SQL skills and settled on Learning SQL on SQL Server after reading the many positive reviews. It sounded like just what I was looking for. My expectations took a downward turn after working through the first few chapters of the book. While the book is technically competent, the way that SQL is presented is lifeless. Working through the book is a trudge with few pleasant stops on the journey. You will learn SQL if you read through the text and work the exercises, ... Read More
Rating: - Where the beef??
Wow...it is amazing the difference between 2 sites reviews - if you go to O'Reilly's site (yes the publisher) scroed it much lower - you would think you were reading reviews of a different book. This was one of the poorest books I have read in several years - and I really hate saying that as I was *highly* looking forward to this book.
My complaints are:
1. Review questions at the end of each chapter but no answers to the reviews or questions at the end of each chapter - not even ... Read More
Rating: - The title says it all!
This is an excellent book. It's well written and provides good code examples for every concept. It is written for users who which to learn SQL on SQL Server 2005; the title of the book says it all!
After reading the book, it felt as if I had completed a university course with lectures, lab work, and homework assignments. So, I estimate I saved $500 and all the time I would have spent in an evening class.
I highly recommend this book. It's one of the best computer books ... Read More
- Workman-like Overview of SQL
- Where the beef??
- The title says it all!
