Overview

ORACLE 11G: SQL 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.

Full Product Details

Author:   Joan Casteel (Tidewater Community College)
Publisher:   Cengage Learning, Inc
Imprint:   Course Technology Inc
Edition:   2nd edition
Dimensions:   Width: 18.80cm , Height: 3.00cm , Length: 23.40cm
Weight:   1.050kg
ISBN:  

9781439081242

ISBN 10:   1439081247
Pages:   620
Publication Date:   25 June 2009
Audience:   College/higher education ,  Tertiary & Higher Education
Format:   Mixed media product
Publisher's Status:   Active
Availability:   In stock  
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.

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. Tables for the Justlee Database. B. SQL Plus & ISQL Plus User's Guide. C. SQL Sytax Guide. D. Introductoin to Third Party Tool (TOAD). E. Oracle 11g Practice Exams. F. Oracle Resources. G. SQL Loader.

Reviews

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. Tables for the Justlee Database. B. SQL Plus & ISQL Plus User's Guide. C. SQL Sytax Guide. D. Introductoin to Third Party Tool (TOAD). E. Oracle 11g Practice Exams. F. Oracle Resources. G. SQL Loader.

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions