For Database Systems courses focusing on SQL and/or Oracle, Oracle and SQL courses offered in the departments of Computer Science, CIS, MIS, IT, and Continuing Education.
Updated to cover Oracle 9i, this text first introduces students to relational database concepts and database designing techniques, then teaches them how to design and implement accurate and effective database systems. With its subsequent in-depth coverage of SQL (the universal query language for relational databases) and PL/SQL (Oracle's procedural language extension to SQL), this text serves not only as an introductory guide but also as a valuable future reference. Part IV, Advanced Topics, allows students to further understand and utilize Oracle 9i architecture and administration.
Oracle is the premier database package used in industry and it is the preferred choice of many academic institutions to teach relational database applications. Database Systems Using Oracle provides the most comprehensive coverage of the Structured Query Language (SQL) and the Programming Language/ Structured Query Language (PUSQL) in Oracle version 8 or higher.
Mastery of Oracle SQL and PUSQL languages is greatly facilitated by the provision of clear, step-by-step instructions, supplemented by hands-on examples, exercise questions, and lab activities. Throughout the text the author uses two real-life running databases as a model as well as a dedicated section on SQL statements with an additional third database scenario. Exposure to these databases increases comprehension of real-life database issues.
Features: - Comprehensive coverage of the relational concepts and the database designing techniques necessary to design and implement effective database systems.
- Thorough coverage of SQL.
- Complete coverage of PL/SQL.
- An introduction to the architecture and administration of Oracle 8, Oracle 8I, and the concept of object orientation.
- Each chapter contains many exercise questions and lab activities promoting the "learn-by-doing" approach.
- A companion website offers instant student assessment materials and PowerPoint slides for each chapter.