Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Oracle 10g: SQL 1st Edition

4.4 out of 5 stars 16 customer reviews
ISBN-13: 978-1418836290
ISBN-10: 141883629X
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used
$10.10
Condition: Used: Very Good
Comment: VERY GOOD - In great shape. May have been read once or twice. Some minor wear. Eligible for Free Prime and Super Saver Shipping - 100% Condition Satisfaction Guarantee
Access codes and supplements are not guaranteed with used items.
46 Used from $6.09
FREE Shipping on orders over $25.
More Buying Choices
7 New from $46.48 46 Used from $6.09

There is a newer edition of this item:

Oracle 12c: SQL
$150.86
(3)
In Stock.
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Barron's
Navigate global markets with Barron's digital membership Learn more
click to open popover

Editorial Reviews

Review

1. Overview of Database Concepts 2. Basic SQL SELECT Statements 3. Table Creation and Management 4. Constraints 5. Data Manipulation and Transaction Control 6. Additional Database Objects 7. User Creation and Management 8. Restricting Rows and Sorting Data 9. Joining Data from Multiple Tables 10. Selected Single-Row Functions 11. Group Functions 12. Subqueries and Merge 13. Views 14. Formatting Readable Output 15. Exploring SQL Topics in Application Development Appendices A. Justlee Database B. SQL Plus & ISQL Plus User"s Guide C. SQL Sytax Guide D. Introductoin to Third Party Tool (TOAD) E. Practice Exams F. Oracle Resources G. SQL Loader

About the Author

Joan E. Casteel combines more than 15 years of hands-on experience in application development in various business environments with strong teaching skills to clarify important application and software concepts for today's readers. An award-winning instructor, Ms. Casteel serves as associate professor of information technology and business at Tidewater Community College, where she has been an integral part of the Database Specialist curriculum. She has joined a newly formed team at the college in charge of building a campus ID card program to encompass four campuses, using a recently deployed Oracle-based system. In addition the team is developing new Oracle APEX applications to improve college-wide financial services support. Ms. Casteel has been recognized by her colleagues for her professional accomplishments, including creating an Oracle virtual machine image for students and handling recruitment efforts for database specialist career studies. Ms. Casteel is the author of two successful books on Oracle from Course Technology, part of Cengage Learning, covering SQL and PL/SQL which serve as the introductory course sequence in the college's database career path.
NO_CONTENT_IN_FEATURE

China
Engineering & Transportation Books
Discover books for all types of engineers, auto enthusiasts, and much more. Learn more

Product Details

  • Paperback: 640 pages
  • Publisher: Course Technology; 1 edition (January 27, 2006)
  • Language: English
  • ISBN-10: 141883629X
  • ISBN-13: 978-1418836290
  • Product Dimensions: 9 x 7.4 x 1.4 inches
  • Shipping Weight: 2.5 pounds
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (16 customer reviews)
  • Amazon Best Sellers Rank: #442,729 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

Format: Paperback
This book was the required reading for a database concepts class as part of a master's program. It's a great introduction into not only to SQL, but also Oracle. As someone who has worked with SQL often, but never with Oracle, I found this book to be very informative and helpful. It will serve as a good reference in the future.
1 Comment 12 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
The goal of this book is to teach SQL used in Oracle 10g. It's does pretty fair job in reaching it's goal.
What it is and what it is not:

- it is a book on 10g SQL.
It covers most if not all what one can expect to learn from one book on Oracle 10g SQL. It covers: briefly basic of database development theory, Data Control Language, Data Manipulation Language, Data Definition Language. Pretty much every aspect of the Oralce SQL you need from introductory class. It uses handy practical examples throughout the book, based on database created by the author. CD with files included (even though I didn't install any of it. We used college database and SQL Plus)

- it is not a book on database administration.
While it has section on user creation/management, it's prime goal is not how to properly install and backup database. And what's covered is not as extensive as you would expect from DBA text.

- I don't remember finding any bugs, or typos with any examples. That's good.
- Overall pretty good resource. I learned great deal of this book.
Comment 6 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I have a background in data analysis and decided to take a formal course in SQL to fill in some holes in my knowledge and leverage learning from the professor's experience. This book was used as the core of that course.

Based on that, I recommend this book as a fine introduction to SQL and to Oracle syntax. You will receive a solid grounding in SQL and introductory Oracle, imho.

Thirteen of the fifteen chapters provide good foundation in SQL and Oracle, though as one would expect, working the exercises is critical for learning, including use of an Oracle SQL development environment (more on that, below).

Even ch 7 about Users and Roles has its uses but in my opinion, that is secondary to core SQL.

Ch 14 about formatting reports, important to know how write CSV output for ingestion by Excel or other programs, but one will find any company will use separate reporting software and do not use crude SQL output directly as a screen interface report format. It would be like using a mainframe screen interface, what you'd envision Lucifer having you use in Hell [vi a close second, for that matter!], as accustomed to GUIs and smart phone interfaces as you are! The business people wouldn't be able to stand it...

The book also touches on more powerful and widely useful concepts in its into treatment to use of variables and substitution in ch 5. That serves as a touchpoint for integrating the database with other programs, maybe web pages or automation of data analysis.

The Syntax Summary at the end of each chapter serves as a succinct review section and mini-reference just before the chapter exercises.
Read more ›
Comment 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
"Just the facts" approach - each chapter sets up a business problem and the rest of the chapter walks through the SQL needed to provide solutions.

Terse and to the point, makes a great reference after the class.

No fluff.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
SELECT *
FROM AMAZON
WHERE reviews BETWEEN 1 AND 5

Yes, I am doing well enough learning this to get certificated! AND THEN, PL/SQL Here I COME to .. be confused! hahaha
USE 10g with this, there is a CD in back. 11g is new and cooler but not for this book;
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I bought this for my Oracle: Intro to SQL class and it would have been perfect, but the instructor didn't like the order of the chapters and the book lacks some detail as to how you actually do some of the lessons.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Overall:
Strengths: Complete and Great Book, easy follow up scripts and excellent examples. Excellent reference source.

Weakness: the cds included (in my case) both of the cd installs but program does not work. I had a hard time installing them. Don't accept password. I needed to uninstall it completely and install Oracle 10g enterprise version to get my work done.

But putting this CD matter away, the book is excellent.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
It's an easy book to understand and learn from. It explains SQL statemen clearly with their related examples that help you get the purpose of what you are studying.
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse