Oracle SQL Interactive Workbook

Oracle SQL Interactive Workbook

By (author)  , By (author) 

List price: US$42.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

-- Unique workbook pedagogy with hands-on exercises, programming projects and a free Web-based training module.-- Covers every key Oracle SQL concept: SQL*Plus, DDL, DML, DQL, the Oracle Data Dictionary, and more!-- The author chairs the Database Application Development and Design track at Columbia University School of Continuing Education.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.
show more

Product details

  • Paperback | 516 pages
  • 172.7 x 231.1 x 38.1mm | 1,020.59g
  • Prentice Hall
  • Upper Saddle River, United States
  • English
  • 0130157457
  • 9780130157454

Table of contents

(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.
show more

About Alexandrea Morrison

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.
show more