Oracle from Beginner to Mastery

Name: Oracle from Beginner to Mastery
ISBN: 9787115493422

魔乐科技（MLDN）软件实训中心 / 史卫亚 / 张闻强Posts & Telecom Press · ChinaAug 2021

3.5

Word count: 138K words
Chapters: 210
ISBN: 9787115493422

Report an error Find this book

Summary

Aimed at zero-foundation learners and using an example-driven approach, this book clearly and accessibly introduces Oracle-related knowledge and practical skills.

Part 1, Basic Knowledge, mainly covers Oracle installation and configuration, SQL fundamentals, advanced SQL restricted queries, Oracle single-row functions, multi-table queries, grouped statistical queries, subqueries, basic Oracle data operations, Oracle table creation and management, and Oracle data integrity; Part 2, Core Technologies, mainly covers the use of Oracle database objects, PL/SQL programming, cursors, stored procedures and functions, triggers and packages, tablespace management, control file and log file management, Oracle security management, and database backup and recovery; Part 3, Advanced Applications, mainly introduces the PowerDesigner design tool and database design, accessing Oracle in ASP, accessing Oracle in Java, accessing Oracle in JSP, and accessing Oracle in PHP; Part 4, Project Practice, mainly covers the design and implementation of a B/S-based job-seeking website and the design and implementation of an idle-goods trading website. The book provides instructional videos synchronized with the entire book content. In addition, a large amount of related learning material is provided as a bonus to support readers' extended learning.

This book is suitable for any reader who wants to learn Oracle—regardless of whether they work in a computer-related industry or have prior exposure to Oracle, they can quickly

Editor's review

Published by Posts & Telecom Press, Oracle from Beginner to Master is a classic introductory text on database technology. Written by the MLDN Software Training Center, it distills the organization's years of practical experience in Oracle database teaching and training. Using Oracle 12c as its primary version, the book systematically builds a complete knowledge system from basic concepts to advanced applications, making it especially suitable for beginners and intermediate developers who want to master Oracle database technology systematically. The structure is clear: from database fundamentals, SQL, and PL/SQL programming to database management and performance tuning, every core module is explained in detail and supported by extensive example code and step-by-step procedures, giving the book a strongly practical orientation.

From a professional standpoint, the book's strength lies in its modular decomposition of complex database concepts and techniques, which lowers the learning barrier through a step-by-step approach. The author team's background in technical training makes the book focus on the practicality and operability of knowledge transfer, avoiding the dryness of purely theoretical textbooks. The analysis of Oracle database architecture, the discussion of SQL optimization approaches, and the introduction to backup and recovery mechanisms all reflect the authors' deep understanding of real-world work scenarios.

It should be noted, however, that because Oracle database versions iterate quickly, the book's 12c-centered content may not cover changes in the latest versions with respect to certain new features. Still, for building a solid database knowledge framework, the core concepts and foundational skills it provides remain highly valuable for learning. As a transitional text from beginner to master, it successfully strikes a balance between theoretical depth and practical guidance.

Who it's for

A good fit for

Students in computer-related majors who want to learn database technology systematically
Workplace newcomers currently engaged in or planning to pursue database management or back-end development
Developers with experience in other databases who want to move to the Oracle technology stack
Readers preparing for Oracle-related certifications who are looking for systematic review materials

Not a good fit for

Readers who want to learn about specific new features in the latest Oracle versions (such as 19c and 21c)
Senior DBAs with years of hands-on Oracle experience who are seeking in-depth kernel principles or extreme optimization solutions

Reading tips

Reading in chapter order is recommended; complete the first eight chapters to build a foundation in SQL and PL/SQL before moving on to the management chapters
Be sure to practice the hands-on sections in an Oracle database environment; the sample code in the book can be verified line by line
For the management chapters, cross-reference the official documentation to understand the context of parameter settings and best practices

About the publisher

Posts & Telecom Press China · Founded in 1953

Posts & Telecom Press is known for its strengths in science and technology, computing, and information and communications titles, and has extended its publishing into photography, art, software learning, and inspirational growth, giving it a fairly diverse range. Its catalog includes computing and communications works such as Refactoring and Patterns (Revised Edition) and Huawei Switch Learning Guide (Second Edition), alongside bilingual collector's editions such as The Little Prince (Chinese-English-French illustrated collector's edition), The Great Gatsby, and Three Days to See. Beijing Ten Years: 1980-1990 and Ghost Blade: WLOP Personal Illustration Collection reflect its presence in photography and art. Its authors include Antoine de Saint-Exupéry, Helen Keller, Joshua Kerievsky, Wang Da, Zhang Zhaozeng, and WLOP.

版权信息
内容提要
序
前言
第0章 Oracle学习指南
0.1 Oracle的来源
0.2 Oracle的技术体系
0.3 Oracle的学习路线图
0.4 Oracle的应用领域及现状
0.5 Oracle的开发/运行平台
0.6 Oracle工作岗位及前景
0.7 Oracle国内外认证
0.8 Oracle的优势/劣势
第1篇基础知识
第1章 Oracle安装与配置
1.1 Oracle的软硬件环境
1.2 Oracle的安装与配置
1.3 Oracle服务
1.4 Oracle常用数据管理工具
1.5 实战练习
1.6 高手点拨
第2章初识SQL
2.1 SQL概述
2.2 scott用户数据表分析
2.3 SELECT子句及简单查询
2.4 实战练习
2.5 高手点拨
第3章高级SQL限定查询
3.1 selct限定查询语法
3.2 关系运算符
3.3 逻辑运算
3.4 范围运算：BETWEEN…AND
3.5 空判断
3.6 IN操作符
3.7 模糊查询
3.8 查询排序
3.9 实战练习：查询练习
3.10 高手点拨
第4章 Oracle的单行函数
4.1 字符串函数
4.2 数值函数
4.3 日期函数
4.4 转换函数
4.5 通用函数
4.6 综合范例
4.7 实战练习
4.8 高手点拨
第5章多表查询
5.1 认识多表查询
5.2 表的连接
5.3 SQL:1999 语法定义
5.4 数据集合操作
5.5 综合范例
5.6 实战练习
5.7 高手点拨
第6章分组统计查询
6.1 统计函数（分组函数）
6.2 分组统计
6.3 多表查询与分组统计
6.4 HAVING子句
6.5 综合范例
6.6 实战练习
6.7 高手点拨
第7章子查询
7.1 子查询概念的引入
7.2 在WHERE子句中使用子查询
7.3 在HAVING子句中使用子查询
7.4 在SELECT子句中使用子查询
7.5 在FROM子句中使用子查询
7.6 综合范例：复杂查询
7.7 实战练习
7.8 高手点拨
第8章 Oracle数据的基本操作
8.1 数据增加
8.2 数据修改
8.3 数据删除
8.4 事务处理
8.5 数据伪列
8.6 综合范例
8.7 实战练习
8.8 高手点拨
第9章 Oracle的表创建与管理
9.1 常用数据类型
9.2 创建数据表
9.3 复制表
9.4 截断表
9.5 为表重命名
9.6 删除数据表
9.7 闪回技术
9.8 修改表结构
9.9 综合范例
9.10 实战练习
9.11 高手点拨
第10章 Oracle的数据完整性
10.1 数据完整性
10.2 非空约束
10.3 唯一约束
10.4 主键约束
10.5 检查约束
10.6 外键约束
10.7 修改约束
10.8 综合范例
10.9 实战练习
10.10 高手点拨
第2篇核心技术
第11章 Oracle的数据库对象的使用
11.1 序列的概念及使用
11.2 同义词的作用
11.3 视图的定义及使用
11.4 索引的定义及使用
11.5 实战练习
11.6 高手点拨
第12章 PL/SQL编程
12.1 PL/SQL程序结构
12.2 变量与常量
12.3 条件语句
12.4 循环语句
12.5 异常处理
12.6 综合范例
12.7 实战练习
12.8 高手点拨
第13章游标
13.1 游标的定义和类型
13.2 游标的创建及使用
13.3 游标FOR循环
13.4 综合范例
13.5 实战练习
13.6 高手点拨
第14章存储过程与函数
14.1 存储过程
14.2 函数
14.3 综合范例
14.4 实战练习
14.5 高手点拨
第15章触发器和程序包
15.1 触发器概述
15.2 触发器创建
15.3 程序包
15.4 综合范例
15.5 实战练习
15.6 高手点拨
第16章表空间管理
16.1 表空间概述
16.2 表空间的创建
16.3 表空间维护
16.4 表空间查询
16.5 实战练习
16.6 高手点拨
第17章控制文件及日志文件的管理
17.1 控制文件的管理
17.2 重做日志文件的管理
17.3 归档日志文件的管理
17.4 实战练习
17.5 高手点拨
第18章 Oracle的安全管理
18.1 用户管理
18.2 权限管理
18.3 角色管理
18.4 综合范例
18.5 实战练习
18.6 高手点拨
第19章数据库备份与恢复
19.1 备份与恢复概述
19.2 数据的导出与导入
19.3 数据库的冷备份及恢复
19.4 将Excel文件导入到Oracle数据库中
19.5 综合范例
19.6 实战练习
19.7 高手点拨
第3篇高级应用
第20章 PowerDesigner设计工具及数据库设计
20.1 PowerDesigner设计工具
20.2 综合范例：数据库分析与设计
20.3 实战练习
20.4 高手点拨
第21章在ASP中访问Oracle
21.1 ASP基本知识
21.2 在ASP中访问数据库的机制
21.3 配置ODBC
21.4 综合范例
21.5 实战练习
21.6 高手点拨
第22章在Java中访问Oracle
22.1 在Java中访问数据库的机制
22.2 在Java中访问Oracle的方法
22.3 实战练习
22.4 高手点拨
第23章在JSP中访问Oracle
23.1 在JSP中连接Oracle的方法
23.2 数据的增删改查
23.3 实战练习
23.4 高手点拨
第24章在PHP中访问Oracle
24.1 在PHP中连接Oracle的方法
24.2 数据的增删改查
24.3 实战练习
24.4 高手点拨
第4篇项目实战
第25章基于B/S结构的求职网的设计与实现
25.1 需求与分析
25.2 数据库设计
25.3 界面设计
25.4 主要功能及实现
25.5 高手点拨
第26章闲置品交易网站的设计与实现
26.1 需求与分析
26.2 数据库设计
26.3 界面设计
26.4 主要功能及实现
26.5 高手点拨

FAQ

Is this book suitable for readers with no prior knowledge?

The book is positioned as a from-beginner-to-master guide. The first few chapters explain basic database concepts and fundamental SQL syntax in detail, with numerous examples, making it friendly to beginners. However, some basic computer knowledge is recommended.

Is the content outdated?

The book uses Oracle 12c as its primary version. Core foundational content such as SQL syntax, PL/SQL programming, architecture, and backup and recovery has changed little across versions and remains highly valuable for learning. Some new features (such as details of multitenant container management) require supplementation from the latest version documentation.

How does this book differ from other Oracle introductory books?

Written by a training institution, the book emphasizes step-by-step presentation of knowledge points and hands-on exercises, often with summaries and practice questions at the end of chapters, making it suitable for self-study. The writing style is plain and avoids excessive theoretical exposition, focusing on operational guidance and solving common problems.

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

魔乐科技（MLDN）软件实训中心 Author

Mole Technology (MLDN) Software Training Center is a compiling organization that appears under a collective byline. Public information about it is limited, and its founding date, location, and staff composition remain unclear. Judging from the two works in the collection, Java Programming Technology Encyclopedia and Oracle from Beginner to Mastery, the center's compiling focus lies in programming design and general computing, with topics leaning toward practical technologies such as Java programming and Oracle databases, aimed at readers who wish to systematically enter or deepen their mastery of development skills. Both works are technical tutorial books that emphasize the completeness of the knowledge system and guidance for hands-on practice, making them suitable references for study and consultation. Owing to limited materials, no further introduction to the organization's background or compiling team can be provided at this time.

史卫亚 Author · China

Shi Weiya, PhD and associate professor, teaches at the School of Information Science and Engineering, Henan University of Technology. His main research interests include machine learning, big data retrieval, databases, image and video processing, artificial intelligence, and pattern recognition. He has published more than 30 papers in core journals and conferences at home and abroad, and has participated in compiling computer textbooks such as Java from Beginner to Master. Four of his works are currently included in the library, covering introductory Python programming for young learners, Oracle database study, Python 3.x web scraping practice, and Java language fundamentals. These titles address both absolute beginners and project-based practice, serving programming novices and computer science students and reflecting his ongoing commitment to teaching and textbook writing.

张闻强 Author

Zhang Wenqiang is an author whose publicly available information is limited; the main verifiable identity is that of a computer book author, with his work Oracle from Beginner to Master included in the general computing category. Judging from the title and classification, the book is aimed at database beginners and covers the fundamentals and practical use of Oracle databases, making it a technical tutorial that balances introductory and more advanced content. Writing of this kind typically emphasizes clear explanations of concepts, coherent operational steps, and workable examples, so that readers without a database background can gradually master the core material. The work reflects, to some extent, the author's commitment to and experience in popularizing database technology. Beyond this, reliable public records of the author's education, professional career, and other works are lacking, so no speculation is made here and only the existing work is described objectively.