The item you selected is unavailable, but we found something similar.

Oracle SQL Interactive Workbook by Rischert, Alice - Picture 1 of 1

Oracle SQL Interactive Workbook by Alice Rischert (2002, Trade Paperback, Revised edition)

Be the first towrite a review.

ThriftBooks (3574902)
99% positive feedback

Price:

$5.62

Free shipping

Estimated delivery Tue, May 14 - Sat, May 18

Returns:

30 days returns. Seller pays for return shipping.

Condition:

Acceptable

Oracle SQL Interactive Workbook by Rischert, Alice Readable copy. Pages may have considerable notes/highlighting. ~ ThriftBooks: Read More, Spend Less

About this product

Product Information

Oracle SQL Interactive Workbook, Second Edition is the only integrated book-and-Web learning solution that teaches all the Oracle 9i SQL skills you need, hands on, through labs, exercises, and projects-complete with a Web-based training site! Fully updated for Oracle 9i, author Alice Rischert covers all types of joins (including the new ANSI join syntax); SQL functions; subqueries set operators; sequences, views, and indexes; data dictionary; dynamic SQL; security; optimization; the SQL*Plus and iSQL*Plus environments; and much more.

Product Identifiers

Publisher
Prentice Hall PTR
ISBN-10
0131002775
ISBN-13
9780131002777
eBay Product ID (ePID)
2236405

Product Key Features

Author
Alice Rischert
Publication Name
Oracle Sql Interactive Workbook
Format
Trade Paperback
Language
English
Features
Revised
Publication Year
2002
Type
Textbook
Number of Pages
851 Pages

Dimensions

Item Length
9.1in
Item Height
1.2in
Item Width
9.3in
Item Weight
42.4 Oz

Additional Product Features

Lc Classification Number
Qa76.73.S67m68 2002
Edition Description
Revised Edition
Edition Number
2
Table of Content
(NOTE: All chapters conclude with Test Your Thinking. ) Foreword. Acknowledgments. About the Author. Introduction. 1. SQL and Data. Data, Databases, and the Definition of SQL. Table Relationships. The Student Schema Diagram. 2. SQL: The Basics. The SQL*Plus Environment. The Anatomy of a SELECT Statement. Editing a SQL Statement. The WHERE Clause: Comparison and Logical Operators. The ORDER BY Clause. 3. Character, Number, and Miscellaneous Functions. Character Functions. Number Functions. Miscellaneous Single-]Row Functions. 4. Date and Conversion Functions. Applying Oracle's Date Format Models. Performing Date and Time Math. Using the New Oracle 9i DATETIME Datatypes. Performing Calculations with the INTERVAL Datatype. Converting from One Datatype to Another. 5. Aggregate Functions, Group By, and Having. Aggregate Functions. The GROUP BY and HAVING Clauses. 6. Equijoins. The Two-Table Join. Joining Three or More Tables. 7. Subqueries. Simple Subqueries. Correlated Subqueries. Inline Views, Scalar Subquery Expressions, and the Subquery WITH Clause. ANY, SOME, and ALL Operators in Subqueries. 8. Set Operators. The Power of UNION and UNION ALL. The MINUS and INTERSECT Set Operators. 9. Complex Joins. Outer Joins. Self-Joins. 10. Insert, Update, and Delete. Creating Data and Transaction Control. Updating and Deleting Data. 11. Create, Alter, and Drop Tables. Creating and Dropping Tables. Altering Tables and Manipulating Constraints. 12. Views, Indexes, and Sequences. Creating and Modifying Views. Indexes. Sequences. 13. The Data Dictionary and Dynamic SQL Scripts. The Oracle Data Dictionary Views. Dynamic SQL Scripts. 14. Security. Users, Privileges, Roles, and Synonyms. 15. Advanced SQL Queries. Advanced SQL Concepts and Analytical Functions. ROLLUP and CUBE Operators. Hierarchical Queries. 16. SQL Optimization. The Oracle Optimizer and Writing Effective SQL Statements. Appendix A. Answers to Self-Review Questions. Appendix B. SQL Formatting Guide. Appendix C. SQL*Plus Command Reference. Appendix D. Student Database Schema. Appendix E. Table and Column Descriptions. Appendix F. Additional Example Tables. Appendix G. Navigating through the Oracle Documentation. Appendix H. Resources. Index.
Copyright Date
2003
Target Audience
Scholarly & Professional
Topic
Desktop Applications / Databases, Programming Languages / Sql, Databases / General
Lccn
2002-155440
Dewey Decimal
005.75/65
Dewey Edition
21
Illustrated
Yes
Genre
Computers

All listings for this product

item 1 Oracle SQL Interactive Workbook by Rischert, Alice
$5.62
Last oneFree shipping
item 2 Oracle SQL Interactive Workbook by Rischert, Alice
$6.01
Free shipping
item 3 Oracle SQL Interactive Workbook (2nd Edition) - Paperback - GOOD
$6.37
Free shipping
item 4 Oracle SQL Interactive Workbook (Pr..., Rischert, Alice
$7.69
Free shipping
item 5 Oracle SQL Interactive Workbook Paperback Alice Rischert
$9.58
Free shipping

See all 5

Best Selling in Textbooks

See all

Current slide {CURRENT_SLIDE} of {TOTAL_SLIDES}- Best Selling in Textbooks

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)
4.6 out of 5 stars based on 15 product ratings
$35.70 New
$34.00 Used
Leadership : Theory and Practice by Peter G. Northouse (2021, Trade Paperback, Revised edition)
5.0 out of 5 stars based on 1 product rating
$19.98 New
$10.00 Used
Self Heal by Design : The Role of Micro-organisms for Health by Barbara O'Neill (2018, Trade Paperback)
5.0 out of 5 stars based on 14 product ratings
$29.99 New
---- Used
Research Design : Qualitative, Quantitative, and Mixed Methods Approaches by J. David Creswell and John W. Creswell (2022, Trade Paperback)
4.2 out of 5 stars based on 5 product ratings
$20.98 New
$18.00 Used
Diagnostic and Statistical Manual of Mental Disorders : DSM-5-TR by American Psychiatric Association (2022, Hardcover)
4.9 out of 5 stars based on 7 product ratings
$41.45 New
$38.99 Used
Cognitive Behavior Therapy : Basics and Beyond by Judith S. Beck (2020, Hardcover)
5.0 out of 5 stars based on 4 product ratings
$19.80 New
$17.66 Used
Encyclopedia of Counseling : Master Review and Tutorial for the National Counselor Examination, State Counseling Exams, and the Counselor Preparation Comprehensive Examination by Howard Rosenthal (2017, Trade Paperback, Revised edition,New Edition)
4.9 out of 5 stars based on 17 product ratings
$23.29 New
$17.99 Used

Save on Textbooks

Current slide {CURRENT_SLIDE} of {TOTAL_SLIDES}- Save on Textbooks

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR Brand new
$32.00
Trending at $42.75
IBC 2021 International Building Code, Paperback - Brand New
$59.95
Trending at $63.99
National Electrical Code (NEC) NFPA 70 2020 Edition Spiral USA STOCK
$33.90
Trending at $36.40
International Residential Code for One and Two-Family Dwellings 2021 free ship
$58.00
Trending at $68.00
Publication Manual of the American Psychological Association: 7th Edition, 2020
$14.45
Trending at $15.97
National Electrical Code 2023 Edition by National Fire Protection SPIRAL
$35.10
Trending at $42.59

Shop by category

Oracle SQL Interactive Workbook by Alice Rischert (2002, Trade Paperback, Revised edition)

About this product

Product Information

Product Identifiers

Product Key Features

Dimensions

Additional Product Features

All listings for this product

item 1 Oracle SQL Interactive Workbook by Rischert, Alice

item 2 Oracle SQL Interactive Workbook by Rischert, Alice

item 3 Oracle SQL Interactive Workbook (2nd Edition) - Paperback - GOOD

item 4 Oracle SQL Interactive Workbook (Pr..., Rischert, Alice

item 5 Oracle SQL Interactive Workbook Paperback Alice Rischert

Best Selling in Textbooks

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)

Leadership : Theory and Practice by Peter G. Northouse (2021, Trade Paperback, Revised edition)

Self Heal by Design : The Role of Micro-organisms for Health by Barbara O'Neill (2018, Trade Paperback)

Research Design : Qualitative, Quantitative, and Mixed Methods Approaches by J. David Creswell and John W. Creswell (2022, Trade Paperback)

Diagnostic and Statistical Manual of Mental Disorders : DSM-5-TR by American Psychiatric Association (2022, Hardcover)

Cognitive Behavior Therapy : Basics and Beyond by Judith S. Beck (2020, Hardcover)

Encyclopedia of Counseling : Master Review and Tutorial for the National Counselor Examination, State Counseling Exams, and the Counselor Preparation Comprehensive Examination by Howard Rosenthal (2017, Trade Paperback, Revised edition,New Edition)

Save on Textbooks

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR Brand new

IBC 2021 International Building Code, Paperback - Brand New

National Electrical Code (NEC) NFPA 70 2020 Edition Spiral USA STOCK

International Residential Code for One and Two-Family Dwellings 2021 free ship

Publication Manual of the American Psychological Association: 7th Edition, 2020

National Electrical Code 2023 Edition by National Fire Protection SPIRAL

You may also like

Workbook Study Paperbacks Prep Revised Edition

Revision/Practice Study Workbooks Prep Revised Edition

Study Workbooks Prep Revised Edition

Revision/Practice Workbook Study Paperbacks Prep

Paperback Dictionaries Revised Edition

Workbook Study Hardcovers Prep Revised Edition