Oracle SQL Interactive Workbook
Prentice Hall (Verlag)
978-0-13-015745-4 (ISBN)
- Titel erscheint in neuer Auflage
- Artikel merken
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!
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.
(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.
| Erscheint lt. Verlag | 12.5.2000 |
|---|---|
| Verlagsort | Upper Saddle River |
| Sprache | englisch |
| Gewicht | 1024 g |
| Themenwelt | Informatik ► Datenbanken ► Oracle |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| ISBN-10 | 0-13-015745-7 / 0130157457 |
| ISBN-13 | 978-0-13-015745-4 / 9780130157454 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
