Don't just learn "generic" SQL! Learn SQL to get results with the world's top database platforms: Oracle 9i for the enterprise, and Microsoft Access 2000 for the desktop! Based on John Patrick's hands-on SQL course for IT pros at the University of California, Berkeley, SQL Fundamentals, Second Edition shows exactly how to retrieve the data you want, when you need it, in any application -- from ad hoc reports to the data warehouse. Unlike competitive books, SQL Fundamentals, Second Edition emphasizes practical concepts and examples from the latest versions of both leading SQL implementations: Access 2000 on the desktop, and Oracle 9i for the enterprise. You'll start with the basics: creating simple queries to retrieve information from a single table. Next, you'll move on to more complex queries involving many tables. Patrick shows how to create tables and views that divide a complex process into a series of simple steps; summarize your data; work with each form of join; and much more. Throughout, he emphasizes techniques for writing SQL queries that are easy to understand, verify, modify, and extend. All tables used in the book are furnished in both Oracle and Access format.The accompanying CD-ROM contains a library of Access databases and code for building Oracle databases.
SQL Fundamentals (3rd Edition)
and over one million other books are available for Amazon Kindle. Learn more
| ||||||||||||||||||
|
There is a newer edition of this item:
|
Book Description
Frequently Bought Together
Product Details
Would you like to update product info or give feedback on images?
|
Product Description
From Amazon
SQL Fundamentals deserves praise because it documents the implementation of Structured Query Language (SQL) in Oracle databases and Access databases simultaneously. Readers find out how to do simple single-table queries, more complicated multitable queries, table creation, joins, unions, and calculations in both environments in a variety of circumstances. For those who've never worked with SQL before and plan to use one of the two covered platforms, this book will make a fine starting point, since it explains elementary SQL concepts too.
Here's the approach: Author John J. Patrick sets out a task--for example, writing a statement that yields a left outer join of two databases. Then he proceeds to accomplish the task in both Access and Oracle, presenting the platforms' respective SQL statements side by side. The differences between the two implementations of SQL are obvious, making it easy for someone familiar with one of the two environments to adapt to the other. The reader will also find the numbered and highlighted key passages, which include details on the facing page, very helpful.
Patrick, who based this book on a university course he teaches, knows the value of practical experience--he's loaded SQL Fundamentals with exercises in addition to the tasks he completes himself. He leaves most of these to the reader but provides solutions to some of the more interesting ones. Databases for the illustrations and exercises are included on the companion CD-ROM. --David Wall
From the Inside Flap
Preface
SQL is now one of the most important computer languages. It is used in over 100 software products, and new ones are being added all the time. This book shows you how to get the most out of your database. It explains how to use SQL to solve practical problems, using the most widely used SQL products Oracle and Microsoft Access. Oracle and Access are both widely used, easily available and run on personal computers. By learning these two products in detail, you will have all the basic skills to use any of the many products based on SQL.
Every concept in this book is illustrated with an example of SQL code. In most cases, a task is set, then the SQL code is given to complete that task. The beginning and result tables of data are also shown. There are more than 200 of these examples. Each part stands on its own. You can read this book sequentially or skip around to find the parts that you need.
Be sure to look at the appendices for practical tips on how to run Oracle and Access. The CD-ROM contains the database files and the code for all the examples.
In several places throughout this book, I have expressed opinions about computer technology, something that many other technical books avoid doing. These opinions are my own and I take full responsibility for them. I also reserve the right to change my mind.
Inside This Book
(Learn More)
Browse and search another edition of this book.
Browse and search another edition of this book.
Customer Reviews
Most helpful customer reviews
Format:Paperback
I use many computer texts, and this title is one of the best, most clearly written guides/manuals I have seen. It has excellent organization, clear presentation, easy-to-understand examples. If you need SQL this is definitely the book. In a genre where authors often slap together sloppy books in record time (for low pay) this is a standout.
Format:Paperback
Choosing one particular SQL book out of the dozens available was not an easy task. Here are the reasons that made me choose this one over the others:
* Book organization - Chapters are very well structured with very descriptive sections, making it easy to find what you want. The first page of every chapter lists the contents by section
* Ease of reading - Everything is explained and described with tables or diagrams. Chapters are summarized at the end with the most important points covered. SQL code is explained in detail using numeric references that are explained separately from the code. Other books clutter the code with explanations making them hard to read and follow
* Oracle and Access code examples - Two of the most widely used DBs are covered, allowing the reader to see the slight, but nevertheless important differences in coding requirements for each platform. Command results are also presented for every example to allow the reader to compare them with their results
* Topics covered - From What is SQL to How to use Oracle and Access, the book is detailed and specific without being overkill
* CD - It contains all the examples in the book, plus all the tables and data. The CD is compatible with 98/ME/XP/2000 and NT. The Oracle code can be used with Unix and their flavors
Some examples could have been more realistic though, instead of using lunches, fruits and colors in many of them. But this is a very personal opinion that will not affect the evaluation.
I have no regrets in choosing this book, it has made me understand the SQL virtues and also its limitations. The book was definitely created with a wide audience in mind, written with no silly jokes and no fancy graphics or fonts to show off. This is a very straight, solid SQL foundation book for people with not much time for distractions.
This is a *very* useful book. It explains the SQL language in a very clear and concise manner, covering the language in detail and offering excellent explanations. The book is also organized extremely well. The countless diagrams and screen shots are invaluable while working thru the examples.
Having come to a point where I needed to learn SQL (and understand it), and fast, I picked this book out of 4 I was considering. I whole-heartedly believe I made the right decision. Not only did I learn SQL, but I understood it too.
The book covers both MS Access and Oracle so if you're using either of those, and you need to learn the SQL language, this book is a great start! Heck, even if you won't be using Access or Oracle but have access to them for the purpose of the examples (I used Access for the examples but I needed to learn SQL for use with MySQL and MSSQL), this book should benefit you greatly.
Want to see more reviews on this item?
›
Go to Amazon.com to see all 26 reviews
4.5 out of 5 stars
Most recent customer reviews
4.0 out of 5 stars
Good writing; terrible editing
This is a fine, fast introduction to SQL. The writing is clear and concise. The book is very well organized focusing on practical SQL and giving examples in SQL's two major... Read more
Published on May 12 2001
5.0 out of 5 stars
SQL Fundamentals
I found this to be a very good read on SQL. I learned SQL in a whirlwind fashion in college. I then began programming in Oracle and found that I could use some review of SQL. Read more
Published on Jan 30 2001 by Jeff Campbell
4.0 out of 5 stars
Excellent starter to warm you up to "practical" SQL
In need of some fast SQL-knowledge, I bought this book a year ago and have read it twice since then. It covers both Oracle and Access SQL. Read more
Published on Nov 12 2000 by Laurens
3.0 out of 5 stars
Me say: Editing BAD, Content GOOD!
I bought this book to cram for a job interview; although I've spent some time as an Access developer (read: power user), I've never really spent that much time looking at SQL as a... Read more
Published on Jun 13 2000 by Stuart R. Ainsworth
4.0 out of 5 stars
GREAT SQL COMPARISON
This book takes you through each sql command in both the Oracle and Access environment. It is an easy read and starts with the most elementary commands and moves to more advanced... Read more
Published on May 11 2000 by Joan Littleton
5.0 out of 5 stars
SQL Fundmentals
This is a very well organized and practical hands-on book. It explains what you have to do and then if you follow the exercises in the book, it works. Read more
Published on Mar 26 2000
5.0 out of 5 stars
THANK YOU!
I AM A ENGINEERING THAT IS LOOKING TO GET INTO THE IT INDUSTRY (DBMS PRODUCTS). SO I DECIDED TO TEACH MY SELF SQL. I PURCHASED A COUPLE OF OTHER BOOKS. Read more
Published on Dec 11 1999
4.0 out of 5 stars
Excellent book on practical SQL
This is an excellent book on SQL that is practical, because it talks about SQL for Access and (gasp!) Oracle. The organization is neat and the writing crisp clear. Read more
Published on Aug 18 1999
5.0 out of 5 stars
A great book for SQL!
This book carefully describes what you need to know to write SQL statements in either Oracle and Access. Read more
Published on July 11 1999
5.0 out of 5 stars
This is exactly what I needed to learn SQL
I am now actively persuing getting a VB/SQL position. I wanted to teach myself SQL. I pick up languages relatively easy and have no time for crummy writing that complicates the... Read more
Published on July 2 1999
Listmania!
Look for similar items by category
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Programming > Languages & Tools
- Books > Computers & Technology > Software
- Books > Computers & Technology > Web Development > Programming > SQL
- Books > New & Used Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > New & Used Textbooks > Computer Science & Information Systems > Programming Languages
- Books > Qualifying Textbooks - Fall 2007 > Computers & Internet
Feedback
Would you like to update product info or give feedback on images?
|
