Oracle-开篇-学习经验
时间:2021-07-01 10:21:17
帮助过:14人阅读
and implementing rules for
data integrity
Choosing a programming environment for a new development project
Writing server-side PL/SQL or Java subprograms and client-side procedural code that use SQL statements
Creating the application interface with the chosen development tool
Establishing a Globalization Support environment for developing globalized applications
Instantiating applications in different databases for development, testing, education, and deployment in a production environment
数据库管理员的职责,Oracle官方说法:
Oracle DBAs are responsible for understanding the Oracle Database architecture and how the database works. DBAs can expect to perform the following tasks:
- Installing, upgrading, and patching Oracle Database software
- Designing databases, including identifying requirements, creating the logical design (conceptual model), and physical database design
- Creating Oracle databases
- Developing and testing a backup and recovery strategy, backing up Oracle databases regularly, and recovering them in case of failures
- Configuring the network environment to enable clients to connect to databases
- Starting up and shutting down the database
- Managing storage for the database
- Managing users and security
- Managing database objects such as tables, indexes, and views
- Monitoring and tuning database performance
- Investigating, gathering diagnostic data for, and reporting to Oracle Support Services any critical database errors
- Evaluating and testing new database features
前面是基本介绍,下面是本人整理的学习经验,主要从PL/SQL和数据库,两个方面介绍:
一、PL/SQL
- 基础语法
- 函数
- 异常
- 优化
二、Oracle数据库
- 实例(内存、进程)
- 文件
- 管理
不同工作对工作技能要求不同,所以请根据自身情况选择学习的重点,当然懂得越多对工作来说越有利,接下来我将分节进行详细介绍。
附Oracle官方文档地址,此地址在日常工作和学习中很重要:https://docs.oracle.com/en/database/oracle/oracle-database/index.html
Oracle-开篇-学习经验
标签:oracl Once ocs network ams programs 数据库运维 语法 ora