Oracle 9i Fundamentals Tutorial and Hands-on Guide

Author: Computer Vocational Education Alliance, edited by Fu Yusheng / Shi Leping
Publisher:
Publish Date: 2004-10-01
Features: This book features:
● A reasonable knowledge structure and detailed hands-on guidance, helping readers understand and familiarize themselves with the principles of the Oracle database system and master its common functions.
● Introduces both SQLPlus and Oracle Enterprise Manager, two different types of management tools, allowing readers to grasp command-line operations while using graphical interface management tools.
● Suitable as a textbook for relevant courses in universities and colleges, as well as a primary textbook for vocational education schools.
This book starts with basic concepts and operations, combined with numerous examples, to comprehensively introduce how to manage Oracle databases using the Oracle database management system. The book consists of 16 chapters. Chapters 1–4 primarily cover Oracle's fundamental concepts, how to install Oracle, database theory, Oracle's architecture, and the configuration and usage of the Oracle Enterprise Manager. Chapters 5 and 6 focus on how to create databases and start or shut down databases. Chapters 7–14 mainly discuss how to manage Oracle files and schema objects, Oracle security, and how to use SQL statements. Chapters 15 and 16 introduce advanced database management topics such as backing up databases, restoring databases, and importing/exporting data.
In terms of structure, the book first introduces relevant knowledge, then provides hands-on guidance with numerous examples to demonstrate operations, and finally includes appropriate exercises to help readers learn, understand, and review the material covered. The inclusion of both SQLPlus and Oracle Enterprise Manager in this book is a distinctive feature. It avoids the discomfort that beginners may experience when using only one management tool, enabling readers to master the use of graphical interface tools while also understanding the specific commands being executed.
This book starts with basic concepts and operations, combined with numerous examples, to comprehensively introduce how to manage Oracle databases using the Oracle database management system. The book consists of 16 chapters. Chapters 1–4 primarily cover Oracle's fundamental concepts, how to install Oracle, database theory, Oracle's architecture, and the configuration and usage of the Oracle Enterprise Manager. Chapters 5 and 6 focus on how to create databases and start or shut down databases. Chapters 7–14 mainly discuss how to manage Oracle files and schema objects, Oracle security, and how to use SQL statements. Chapters 15 and 16 introduce advanced database management topics such as backing up databases, restoring databases, and importing/exporting data.
In terms of structure, the book first introduces relevant knowledge, then provides hands-on guidance with numerous examples to demonstrate operations, and finally includes appropriate exercises to help readers learn, understand, and review the material covered. The inclusion of both SQLPlus and Oracle Enterprise Manager in this book is a distinctive feature. It avoids the discomfort that beginners may experience when using only one management tool, enabling readers to master the use of graphical interface tools while also understanding the specific commands being executed.