 |
Oracle SQL Interactive Workbook View Larger Image | Alice Rischert
Prentice Hall, Paperback, 2nd edition, Published December 2002, 851 pages, ISBN 0131002775 | List Price: $49.99
Our Price: $31.95
You Save: $18.04 (36% Off)
| | | Availability: Out-Of-Stock |
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
Appropriate for beginning to intermediate courses in Oracle SQL.
Fully updated and expanded for Oracle 9i, this integrated book-and-Web learning
solution is designed to help students master SQL on Oracle Systems as quickly
as possible. Its unique workbook-based pedagogy incorporates hands-on, real-world
labs, exercises, and projects, as well as an outstanding Web-based training
site containing “Test Your Thinking” project solutions and detailed
explanations, an Author's Corner that connects students with the book's expert
author; additional self-review exercises with instant feedback and explanations;
and an exclusive Virtual Study Lounge where students can interact with each
other. The book's coverage includes every fundamental SQL concept, skill, and
technique, including entity-relationship diagrams, SQL*Plus, SELECT and other
statements, Boolean operations, functions, pseudocolumns, joins, complex joins,
subqueries, relational operators, DML, DQL, DDL, and the Oracle Data Dictionary.
Features
- NEW—Fully updated and expanded to reflect Oracle 9i's version
of SQL.
- Helps students rapidly master the most valuable features incorporated in
the latest version of Oracle SQL.
- Uniquely effective hands-on workbook format—Gives students
hands-on practice through real-world exercises, labs, and projects.
- Helps students master Oracle SQL more rapidly and retain more of what they
learn.
- Comprehensive coverage of Oracle SQL fundamentals—Covers ERDs,
SQL*Plus, key SQL statements, Boolean operations, functions, joins, subqueries,
relational operators, DML, DQL, DDL, Oracle Data Dictionary, and more.
- Gives students a single resource for learning all the Oracle SQL skills
they are likely to need.
- Web-based training module—Supports the book with an extensive,
integrated set of online features.
- Gives students access to constant updates on even more learning resources.
URL: www.phptr.com/rishert.
- By one of the world's leading database educators—Authored
by Alice Rischert, chair of the Database Application Development and Design
track at Columbia University's School of Continuing Education.
- Lets students benefit from authoritative coverage by a leading expert in
both database technology and database instruction.
- Virtual Study Lounge—Provides an online venue where students
can interact with each other.
- Helps students resolve their own questions and learn from each other.
Table of Contents
Foreword.
Acknowledgments.
About the Author.
Introduction.
1. SQL and Data.
Lab 1.1 Data, Databases, and the Definition
of SQL. LAB 1.2 Table Relationships. Lab 1.3 The Student Schema Diagram. Chapter
1 Test Your Thinking.
2. SQL: The Basics.
Lab 2.1 The SQL*Plus Environment. Lab 2.2 The
Anatomy of a SELECT Statement. LAB 2.3 Editing a SQL Statement. Commands. LAB
2.4 The WHERE Clause: Comparison and Logical Operators. LAB 2.5 The ORDER BY
Clause. Test Your Thinking.
3. Character, Number, and Miscellaneous Functions.
Lab 3.1 Character Functions. Lab 3.2 Number
Functions. Lab 3.3 Miscellaneous Single-row Functions. Chapter 3 Test Your Thinking.
4. Date and Conversion Functions.
Lab 4.1 Applying Oracle's Date Format Models.
Lab 4.2 Performing Date and Time Math. Lab 4.3 Using the New Oracle 9i DATETIME
Datatypes. Lab 4.4 Performing Calculations with the INTERVAL Datatype. Lab 4.5
Converting from One Datatype to Another. Chapter 4 Test Your Thinking.
5. Aggregate Functions, Group By, and Having.
Lab 5.1 Aggregate Functions. Lab 5.2 The GROUP
BY and HAVING Clauses. Chapter 5 Test Your Thinking.
6. Equijoins.
Lab 6.1 The Two-Table Join. Lab 6.2 Joining
Three or More Tables. Chapter 6 Test Your Thinking.
7. Subqueries.
Lab 7.1 Simple Subqueries. Lab 7.2 Correlated
Subqueries. Lab 7.3 Inline Views, Scalar Subquery Expressions, and the Subquery
WITH Clause. Lab 7.4 ANY, SOME, and ALL Operators in Subqueries. Chapter 7 Test
Your Thinking.
8. Set Operators.
Lab 8.1 The Power of UNION and UNION ALL. Lab
8.2 The MINUS and INTERSECT Set Operators. Chapter 8 Test Your Thinking.
9. Complex Joins.
Lab 9.1 Outer Joins. Lab 9.2 Self-Joins. Chapter
9 Test Your Thinking.
10. Insert, Update, and Delete.
Lab 10.1 Creating Data and Transaction Control.
Lab 10.2 Updating and Deleting Data. Chapter 10 Test Your Thinking.
11. Create, Alter, and Drop Tables.
Lab 11.1 Creating and Dropping Tables. Lab 11.2
Altering Tables and Manipulating Constraints. Chapter 11 Test Your Thinking.
12. Views, Indexes, and Sequences.
Lab 12.1 Creating and Modifying Views. Lab 12.2
Indexes. Lab 12.3 Sequences. Chapter 12 Test Your Thinking.
13. The Data Dictionary and Dynamic SQL Scripts.
Lab 13.1 The Oracle Data Dictionary Views. Lab
13.2 Dynamic SQL Scripts. Chapter 13 Test Your Thinking.
14. Security.
Lab 14.1 Users, Privileges, Roles, and Synonyms.
Chapter 14 Test Your Thinking.
15. Advanced SQL Queries.
Lab 15.1 Advanced SQL Concepts and Analytical
Functions. Lab 15.2 ROLLUP and CUBE Operators. Lab 15.3 Hierarchical Queries.
Chapter 15 Test Your Thinking.
16. SQL Optimization.
Lab 16.1 The Oracle Optimizer and Writing Effective
SQL Statements. Chapter 16 Test Your Thinking.
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.
|
|
