New Start Computer Tutorial: Oracle9i Basic Tutorial and Hands-on Guidance

Author: Edited by Computer Vocational Education Alliance, Edited by Fu Yusheng, Shi Leping
Publisher:
Publish Date: 2004-10-01
Features: This book starts from basic concepts and operations, combined with numerous examples, comprehensively introduces how to manage Oracle databases using the Oracle Database Management System. The book consists of 16 chapters. Chapters 1-4 mainly cover Oracle's fundamental concepts, how to install Oracle, theoretical knowledge of databases, Oracle's architecture, and the configuration and usage of Oracle Enterprise Manager. Chapters 5 and 6 mainly introduce how to create a database and start or close it. Chapters 7-14 mainly cover how to manage Oracle files and schema objects, Oracle's security management, and how to use SQL statements. Chapters 15 and 16 mainly introduce advanced database management topics such as backing up databases, restoring databases, and importing/exporting data. Structurally, the book first introduces relevant knowledge, then guides users through operations with numerous examples in hands-on tutorials, and finally provides appropriate exercises to help users learn, understand, and review the content. In this book, the introduction and usage of SQLPlus and Oracle Enterprise Manager are also a feature, avoiding the discomfort for beginners caused by using only a single management tool. This allows readers to become familiar with both graphical and command-line management tools, understanding the specific commands executed while using these different types of management tools.