Oracle 11g: From Beginner to Mastery (2nd Edition)

Name: Oracle 11g: From Beginner to Mastery (2nd Edition)
ISBN: 9787302458227

Mingri Technology (Jilin Province Mingri Technology Co., Ltd.)Tsinghua University Press2017

No rating yet

Word count: 909 words
Chapters: 23
Series: Software Development Video Lecture Series
ISBN: 9787302458227

Report an error Find this book

Summary

Part of Tsinghua University Press's Software Development Video Lecture Series, this Oracle primer is written by the Mingri Science and Technology team, long engaged in software development and IT education, and built around Oracle 11g to teach database development and administration to readers with no prior background. The book has 19 chapters in four parts. Part 1, Fundamentals (Chapters 1–6), begins with Oracle's history, relational database theory, Oracle 11g installation and uninstallation, and common management tools, then covers instance startup and shutdown; the database architecture (logical storage structures—data blocks, extents, segments, tablespaces—and physical structures such as data files, control files, and log files, plus the SGA and PGA, foreground and background processes, and the data dictionary); common SQL*Plus commands; and a systematic introduction to SQL fundamentals (retrieval, filtering, grouping, sorting, multi-table joins, common system functions, subqueries, and insert, update, and delete operations), PL/SQL programming (block structure, variables and data types, flow control, cursors, exception handling), and stored procedures, functions, triggers, and packages. Part 2, Core Techniques (Chapters 7–12), covers managing control files and log files, managing tablespaces and data files, table objects and constraints, indexes, views, synonyms, sequences and other objects, table and index partitioning, and user management and privilege assignment. Part 3, Advanced Applications (Chapters 13–18), addresses database control, Oracle system tuning, SQL statement optimization, data backup and recovery, data export and import, and Oracle 11g flashback technology. Part 4, Project Practice (Chapter 19), uses an Enterprise HR Management System as a comprehensive case that ties together the preceding chapters. Every topic is explained with concrete examples, and the program code carries detailed comments; the accompanying DVD provides full voice-over video instruction and the example source code, so readers can watch while they practice and practice until they understand.

Editor's review

这是一本把“入门”和“上手”结合得比较好的Oracle教材。它的长处不在理论深度，而在路径清晰：先装库、认结构，再学SQL与PL/SQL，然后进入表空间、日志、权限、分区这些真正属于DBA日常的活，最后用“企业人事管理系统”把一个项目的从建表到备份走一遍。对完全没碰过Oracle的读者来说，这种“先跑起来再说”的编排能有效降低畏难情绪。第2版在原版基础上补充了数据库控制等内容，章节由18章扩展为19章，配套DVD提供全程语音视频和全部实例源码，代码在Windows XP/2003/7下经过调试，边看视频边敲代码的学习方式对自学者很友好。需要提醒的是，本书讲的是Oracle 11g，这个版本如今在生产环境中已属老版本，语法和工具（如企业管理器）与12c、19c、23ai存在差异，读者应把重点放在SQL、PL/SQL、体系结构、表空间与备份恢复这些跨版本通用的底层能力上，版本相关的操作细节则结合官方文档和当前环境核对。

Who it's for

A good fit for

零基础想系统学习Oracle数据库的在校学生与转行人员
需要快速补齐SQL、PL/SQL与数据库管理基础的初级开发人员
从事运维工作、需要了解表空间、权限、备份恢复的初级DBA
习惯跟着视频和源码动手练习、偏好实例驱动学习的自学者

Not a good fit for

已具备多年Oracle运维经验、想深研内部机制与调优原理的资深DBA
希望在12c、19c或云数据库环境中直接照搬操作步骤的读者
只想查阅命令速查、不愿按章节系统练习的读者

Reading tips

先完成第1—2章的安装与体系结构，务必亲手装好一套实例，后面所有练习都依赖它。
第4—6章SQL与PL/SQL是全书核心，建议每个例子都手敲一遍，不要跳过“实践与练习”。
第7—12章按DBA日常任务顺序推进，可结合自己所在环境的表空间和用户权限对照理解。
读第19章项目实战前回顾前面章节，把它当作一次综合自查，再补充当前版本的官方文档。
光盘/DVD资源需光驱或镜像文件，也可先整理出源码目录，边看视频边对照运行。

About the publisher

Tsinghua University Press China · Founded in 1980

Founded in 1980, Tsinghua University Press has 57 titles in our collection, covering popular science, medicine, health, law, philosophy and social sciences. Representative works include medical popular-science books such as Cancer Truth: Doctors Are Reading It Too and New Knowledge on Cancer by Bo Luo (Li Zhizhong), legal titles such as Sunshine Is the Best Preservative: Express Delivery of Major Global Anti-Corruption Cases, and works like Qi Ge's A Brief History of Philosophy with Big Ideas and Liu Yunhao's From the Internet to a New Industrial Revolution. Its authors include science writers, medical researchers, the Renmin University of China anti-corruption master's class and university scholars, reflecting a publishing profile that balances academic seriousness with accessible reading. As public information is limited, this profile is based only on the titles in our collection.

Part 1: Fundamentals
Chapter 1: Overview of Oracle 11g
Chapter 2: Oracle 11g Architecture
Chapter 3: SQL*Plus Commands
Chapter 4: Fundamentals of SQL
Chapter 5: PL/SQL Programming
Chapter 6: Procedures, Functions, Triggers, and Packages
Part 2: Core Techniques
Chapter 7: Managing Control Files and Log Files
Chapter 8: Managing Tablespaces and Data Files
Chapter 9: Table Objects
Chapter 10: Other Data Objects
Chapter 11: Table Partitioning and Index Partitioning
Chapter 12: User Management and Privilege Assignment
Part 3: Advanced Applications
Chapter 13: Database Control
Chapter 14: Oracle System Tuning
Chapter 15: Optimizing SQL Statements
Chapter 16: Oracle Data Backup and Recovery
Chapter 17: Data Export and Import
Chapter 18: Oracle 11g Flashback Technology
Part 4: Project Practice
Chapter 19: Enterprise Human Resources Management System

FAQ

这本书讲的是哪个Oracle版本？现在学还有用吗？

全书以Oracle 11g为蓝本，2017年出版。11g已属较老版本，但SQL语法、PL/SQL、体系结构、表空间管理、备份恢复等核心知识在12c、19c中依然通用；涉及具体工具界面和版本特性的操作，建议对照当前版本的官方文档核实。

零基础、没学过数据库能直接读吗？

可以。第1章从Oracle发展史和关系型数据库基本理论讲起，包括E-R模型与设计范式，安装步骤也有说明。建议先按书安装实例并熟悉SQL*Plus，再进入SQL和PL/SQL部分，学习曲线会更平缓。

第2版和第1版有什么区别？

第1版（2012年，ISBN 9787302289333）共18章；第2版共19章，增加了“数据库控制”一章，并在实例与配套视频上做了更新，随书DVD含全程语音讲解和全部源代码。

书里的例子和光盘资源怎么用比较好？

建议先自己按书上步骤敲一遍代码，遇到报错再看源码和视频比对；光盘需光驱或挂载镜像读取，可先把源代码目录复制到本地，按章节编号整理，方便随查随用。

Comments

Find this book

This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.

About the author

Mingri Technology (Jilin Province Mingri Technology Co., Ltd.) Author

Mingri Technology, whose full name is Jilin Province Mingri Technology Co., Ltd., is a high-tech company specializing in software development, education and training, and the integration of software development educational resources, and it organizes the compilation of computer programming textbooks. Its works are aimed mainly at programming beginners and focus on learning languages such as Python, Java, C#, and SQL, as well as GUI design and web front-end development; its common categories are programming design, computer fundamentals, and software learning. Representative works include the upgraded editions of Python GUI Design, SQL, and Java in the “Zero Foundation Learning” series, along with study notes on HTML+CSS+JavaScript and a complete self-study course on C#. The company has developed textbook series such as “From Beginner to Master” and “Software Development Video Lecture Hall”; related textbooks have received industry and university press awards, and several titles have long ranked among the top sellers in their categories. Public information is limited; the author name is an institutional byline, and the focus is on the compilation and publication of computer programming educational materials.