Oracle SQL
Seiten
2003
Pearson (Verlag)
978-0-13-101138-0 (ISBN)
Pearson (Verlag)
978-0-13-101138-0 (ISBN)
- Titel ist leider vergriffen;
keine Neuauflage - Artikel merken
For courses in Database Management. This text focuses on standard ANSI SQL with a learn-by-doing approach. Students first learn the features of a SQL command, then its usage, based on management questions that typically arise in the management decision-making process.
For courses in Database Management.
Focusing on standard ANSI SQL with a learn-by-doing approach, this text organizes SQL subtopics into short chapters. Students first learn the features of a SQL command, then its usage, based on management questions that typically arise in the management decision-making process. The authors pose management questions and then give examples of how SQL can be used to provide the data needed. In light of the wide adoption of the Oracle relational DBMS product in academic institutions and industry, additional examples of the supplemental commands available in the Oracle implementation of SQL are provided. All of the SQL concepts and commands covered (except in SQL *Plus and PL/SQL) are equally applicable to database management system software that follows the ANSI SQL standard—including DB2, SQL Server, and SYBASE.
For courses in Database Management.
Focusing on standard ANSI SQL with a learn-by-doing approach, this text organizes SQL subtopics into short chapters. Students first learn the features of a SQL command, then its usage, based on management questions that typically arise in the management decision-making process. The authors pose management questions and then give examples of how SQL can be used to provide the data needed. In light of the wide adoption of the Oracle relational DBMS product in academic institutions and industry, additional examples of the supplemental commands available in the Oracle implementation of SQL are provided. All of the SQL concepts and commands covered (except in SQL *Plus and PL/SQL) are equally applicable to database management system software that follows the ANSI SQL standard—including DB2, SQL Server, and SYBASE.
(NOTE: Each chapter begins with Objectives and concludes with Summary, Review Exercises, Learn These Terms, Concepts Quiz, and SQL Coding Exercises and Questions.)
1. Introduction.
2. Creating Tables and Indexes.
3. Single Table Query Basics.
4. Adding Power to Queries.
5. Aggregate Row Functions.
6. Joins.
7. Subqueries.
8. Views, Synonyms, and Sequences.
9. SQL *Plus Reports.
10. Additional Functions.
11. Embedded SQL.
12. Oracle Database Administration.
Appendix A: The Company Database Schema.
Appendix B: The Riverbend Hospital Case.
Appendix C: End-of-Book SQL Coding Exercises.
Appendix D: Solutions to Odd-Numbered Exercises.
| Erscheint lt. Verlag | 3.4.2003 |
|---|---|
| Sprache | englisch |
| Gewicht | 642 g |
| Themenwelt | Informatik ► Datenbanken ► Oracle |
| ISBN-10 | 0-13-101138-3 / 0131011383 |
| ISBN-13 | 978-0-13-101138-0 / 9780131011380 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
Mehr entdecken
aus dem Bereich
aus dem Bereich
building resilient database solutions for continuous operation
Buch | Softcover (2023)
O'Reilly Media (Verlag)
79,80 €
