Oracle SQL Interactive WorkBook

Alice Risch

852 pages, parution le 05/02/2003 (2^eme édition)

Ajouter à une liste

Indisponible

Résumé

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.

Contents

1. SQL and Data.
2. SQL: The Basics.
3. Character, Number, and Miscellaneous Functions.
4. Date and Conversion Functions.
5. Aggregate Functions, Group By, and Having.
6. Equijoins.
7. Subqueries.
8. Set Operators.
9. Complex Joins.
10. Insert, Update, and Delete.
11. Create, Alter, and Drop Tables.
12. Views, Indexes, and Sequences.
13. The Data Dictionary and Dynamic SQL Scripts.
14. Security.
15. Advanced SQL Queries.
16. SQL Optimization.
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.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Prentice Hall
Auteur(s)	Alice Risch
Parution	05/02/2003
Édition	2^eme édition
Nb. de pages	852
Format	18 x 23,5
Couverture	Broché
Poids	1205g
Intérieur	Noir et Blanc
EAN13	9780131002777