Provides students with the latest material available for this powerful relational database.
Illustrates for students the general syntax of SQL and PL/SQL, and helps them avoid mistakes.
Enables students to utilize a text that is comprehensive and current.
Provides students with a clearer explanation of relational database concepts.
Provides students with ample opportunities to practice the concepts learned in class.
Enables students to understand how the text's concepts are applied to address real-world needs.
Allows students to use the text with different versions of Oracle and with different environments, making it an invaluable future reference work.
Provides students with ample opportunity to self-test. Enables instructors to check students' progress.
Provides students and instructors with an easily accessible reference.
Gives instructors an easy environment to create tests and quizzes, assign homework, and prepare lectures.
Enables students to use the software to enhance the examples provided in the text.
This easy-to-read book provides quick lessons on relational database terminology and normalization with very little effort. Updated for Oracle 9i, its thorough coverage of Oracle's SQL and PL/SQL and introduction to advanced SQL topics makes this a must for busy professionals. The many examples, with output shown as screenshots, provide ample opportunity for the reader to easily understand and learn to use Oracle and SQL. KEY TOPICS: First introducing relational database concepts, the book covers SQL (Structured Query Language); Programming Language (the extension to SQL); and then proceeds to advanced topics, which include Oracle architecture and database administration with enterprise tools. MARKET: For any IT professional who needs to understand SQL or Oracle database systems.
I. RELATIONAL DATABASE CONCEPTS.1. Database Concepts: A Relational Approach.
II. ORACLE SQL.3. Oracle 9i: An Overview.
III. PL/SQL.10. PL/SQL: A Programming Language.
IV. ADVANCED TOPICS.15. Connecting to Oracle Database: JDBC, SQLJ.