Database Systems Using Oracle: A Simplified Guide To SQL And PL/SQL

0.0

This text aims at students of Database System courses in the disciplines of computer science and IT. It introduces students to relational database concepts and database designing techniques, teaching 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 future reference. Throughout the text, the author uses two real-life running databases as a model to enrich sequential comprehension of concepts by the reader. The text concludes with an introduction to the architecture and administration of Oracle 8, the new features of Oracle 8i, and the concepts of object orientation. Table of Contents Foreword. Preface. Acknowledgments. Part 1: DATABASE CONCEPTS-Database Concepts: A Relational Approach. Database Design: Data Modeling and Normalization. Part 2: THE ORACLE SQL-Oracle 8: An Overview. Oracle Tables: Creation and Modification. Working with Tables: Data Management and Retrieval. Multiple Tables: Joins and Sub-Queries. Advanced Features: Objects, Transactions, and Control. Part 3: PL/SQL-PL/SQL: Programming Language Basics. SQL and Control Structures in PL/SQL. Cursors and Exceptions. Composite Data Types: Records and Tables. Procedures, Functions, and Packages. Part 4: MISCELLANEOUS TOPICS-Oracle Database Administration. Oracle 8i: An Overview and Web Tools. Appendices: A-Sample Databases: Table Definitions. B-Quick Reference to SQL and PL/SQL Syntax. C-Additional References. Index.