Oracle 10g: SQL (Paperback)

by Joan Casteel (Author)

Editorial Reviews

Product Description
Oracle 10g: SQL prepares students for the first exam in both the Oracle Database Administrator (DBA) and Oracle Forms Developer certification tracks and offers them a solid understanding of Oracle10g and how to use it effectively. This textbook is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle. Students begin with a solid foundation for creating databases (7 chapters) then strengthen their knowledge in creating queries (7 chapters). To assist students in bridging SQL topics to further studies, the last two chapters introduce students to SQL tuning, compare Oracle’s SQL syntax to other databases (MS SQL Server and MySQL) and describe how SQL can be embedded in applications (ASP.net). This textbook also covers SQL*Plus and iSQL*Plus so students can identify and distinguish the differences between these interfaces.

About the Author
Joan Casteel has more than twelve years of experience in application development in various business environments. She has been teaching Oracle development at Tidewater Community College for the past seven years in the Database Specialist curriculum. Joan has authored two textbooks for Course Technology, a part of Cengage Learning.

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.1 x 7.4 x 1.5 inches
• Shipping Weight: 2.5 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars See all reviews (4 customer reviews)
• Amazon.com Sales Rank: #280,166 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #15 in	Books > Computers & Internet > Databases > Oracle > SQL
  #29 in	Books > Computers & Internet > Databases > Oracle > PL & SQL

Customer Reviews

Most Helpful Customer Reviews

8 of 8 people found the following review helpful:

4.0 out of 5 stars Great intro into Oracle, April 24, 2007

By	rdblakemore (Parker, CO) - See all my reviews

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.

3 of 3 people found the following review helpful:

4.0 out of 5 stars Accomplishes it's goal, July 12, 2008

By	Konstantinos o Philosophos "aka. 9th century ... (Southern CA USA) - See all my reviews

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.

1 of 1 people found the following review helpful:

5.0 out of 5 stars Oracle 10g SQL Review, November 16, 2008

By	Eric G. De Leon (PR) - See all my reviews (REAL NAME)

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.