Used and New from Other Sellers
Used and New from Other Sellers
from $60.73
Usually ships in 1-2 business days
(Save 61%)
Other sellers (Paperback)
-
All (6)
from
$60.73
-
New (2)
from
$141.99
-
Used (4)
from
$60.73
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$141.99
Seller since Sat Jan 01 01:01:01 EST 2011
Brand new and unread! Join our growing list of satisfied customers!
Ships from: Phoenix, MD
Usually ships in 1-2 business days
- •Standard, 48 States
- •Standard (AK, HI)
$142.00
Seller since Tue Jan 01 01:01:01 EST 2008
Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.
Ships from: Westminster, MD
Usually ships in 1-2 business days
- •Canadian
- •International
- •Standard, 48 States
- •Standard (AK, HI)
More About This Textbook
Overview
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.
Product Details
Related Subjects
Meet the Author
Joan E. Casteel combines more than 12 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 has served as associate professor of information technology and business for more than eight years 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 with the charge of building the campus ID card program to encompass four campuses, using a recently deployed Oracle-based system. 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. The author of two successful books on Oracle from Course Technology, part of Cengage Learning, Casteel was one of the principal investigators for the National Science Foundation grant for career pathways.
Table of Contents
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