- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
Used Trade Paper
Ships in 1 to 3 days
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Oracle 9i : SQL With Introduction To PL/ SQL and CD (03 Edition)by Lannes Morris-murphy
Synopses & ReviewsPlease note that used books may not include additional media (study guides, CDs, DVDs, solutions manuals, etc.) as described in the publisher comments.
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.
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.
Oracle9i SQL not only prepares students for the first exam in both the Oracle Database Administrator (DBA) and Internet Application Developer Certification Tracks; it offers them a solid understanding of Oracle9i SQL 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. A business case that follows the progress of an online book retailer, JustLee Books, runs through every chapter, and many of the examples in each chapter build on this case. In addition, hands-on activities at the end of each chapter, such as review questions, assignments, and a case project, help to reinforce Oracle9i SQL skills.
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.
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 and 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\n
What Our Readers Are Saying