Oracle SQL Interactive Workbook
Published on 12. May 2000
Book
Paperback/Softback
516 pages
978-0-13-015745-4 (ISBN)
Description
Before Oracle DBAs and developers can move on to sophisticated application development, they must gain an in-depth understanding of Oracle SQL. Oracle SQL Interactive Workbook is the fastest way to master Oracle SQL. This integrated book-and-Web learning solution teaches all the Oracle SQL skills you need, through hands-on, real-world labs, exercises, projects, and our great Web-based training site! Coverage includes every key Oracle SQL concept, including: entity-relationship diagrams, the SQL*Plus environment, SELECT and other statements, Boolean operations, joins, aggregate and not-aggregate functions; pseudocolumns; complex joins and subqueries; relational operators; date and conversion functions; DML, DDL, and more. A free Web-based training module includes a Virtual Study Lounge where readers can interact with the author; "Test Your Thinking" project solutions and explanations, interactive Q&As, self-review exercises, new projects, book updates, and more!
More details
Language
English
Place of publication
Upper Saddle River
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Width: 234 mm
Thickness: 35 mm
Weight
1024 gr
ISBN-13
978-0-13-015745-4 (9780130157454)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions
Alice Rischert
Oracle SQL Interactive Workbook
Book
01/2003
2nd Edition
Prentice Hall
€39.60
Article exhausted; check for reprint
Persons
Alexandrea Morrison and Alice Rischart are faculty members at the Columbia University School of Continuing Education. Series Technical Advisor Douglas Scherer is a certified Oracle database administrator, and President and Founder of Core Paradigm, Inc. He has been an Oracle specialist, database architect, and consultant to a wide range of leading companies, including Deutsche Bank. He is also a member of the faculty at the Columbia University School of Continuing Education.
Content
(NOTE: All chapters conclude with Test Your Thinking.)
1. SQL and Data.
Data, Databases, and the Definition of SQL. A Case Study Schema Diagram. Referential Integrity and Table Relationships. The SQL *PLUS Environment.
2. SQL: The Basics.
The Anatomy of a SELECT Statement. Editing a SQL Statement. The WHERE Clause: Comparison and Logical Operators. The ORDER BY Clause.
3. Character and Number Functions.
Character Functions. Number Functions.
4. Date and Conversion Functions.
Converting from One Datatype to Another. Applying Oracle's Date Format Models. Performing Date and Time Math. The NVL and DECODE Functions.
5. Aggregate Functions, GROUP BY, and HAVING.
Aggregate Functions. The GROUP BY and HAVING Clauses.
6. Equijoins.
The Two Table Join. Joining More Than Two Tables.
7. Subqueries.
Simple Subqueries. Correlated Subqueries. ANY, COME, 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.
Manipulaitng Data and Transaction Control.
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.
DECODE Magic and In-line Views. Hierarchical Queries.
16. SQL Optimization.
The Oracle Optimizer and Writing Effective SQL Statement.
Appendix A: Answers to Self-Review Questions.
Appendix B: SQL Formatting Guide and SQL*Plus Command Reference.
Appendix C: Student Database Schema.
Index.
1. SQL and Data.
Data, Databases, and the Definition of SQL. A Case Study Schema Diagram. Referential Integrity and Table Relationships. The SQL *PLUS Environment.
2. SQL: The Basics.
The Anatomy of a SELECT Statement. Editing a SQL Statement. The WHERE Clause: Comparison and Logical Operators. The ORDER BY Clause.
3. Character and Number Functions.
Character Functions. Number Functions.
4. Date and Conversion Functions.
Converting from One Datatype to Another. Applying Oracle's Date Format Models. Performing Date and Time Math. The NVL and DECODE Functions.
5. Aggregate Functions, GROUP BY, and HAVING.
Aggregate Functions. The GROUP BY and HAVING Clauses.
6. Equijoins.
The Two Table Join. Joining More Than Two Tables.
7. Subqueries.
Simple Subqueries. Correlated Subqueries. ANY, COME, 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.
Manipulaitng Data and Transaction Control.
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.
DECODE Magic and In-line Views. Hierarchical Queries.
16. SQL Optimization.
The Oracle Optimizer and Writing Effective SQL Statement.
Appendix A: Answers to Self-Review Questions.
Appendix B: SQL Formatting Guide and SQL*Plus Command Reference.
Appendix C: Student Database Schema.
Index.