ORACLE 11G DBA course given in English.
This course is aim to train the great DBA with good English speaking.
In recent years, more demands of Oracle DBA, but most of Senior DBAs are required to speak good English.
English has become the great barrier for more peoples in their career development, you must have the deep feeling about it if you work in the foreign company.
In IT English course, Learning IT knowledge in English just like killing two birds with one stone, not only it can help you to master of Professional IT English terminologies as soon as possible, but it can help you to take the reins of IT technology, enjoy yourself to listen to the Professional English IT lectures.
Therefore, Oracle 11G DBA courses come to you at the right time, this is for those who has the basic English background and willing to be the Professional Oracle DBA.
Requirements: good English listening, no need of Database or relevant computer experience.
First 10 registers could get the discount, please contact me as soon as you can.
Of course, you can cancel your membership at any time. There is no risk. Try my VIP Program for you and speak English confidently, grow more successful and become a true DBA.
Learn path:
1.The SQL introuduction
2.PLSQL introuduction
3.Database Architecture
4.Backup and Recovery
5.Performance Tuning
6.High availability
And also provide the On demand course per the customer requirements.
For more information, please contact me by MSN
baiwentao@hotmail.com
相关文档：
以上为转载,多数并未验证.
其中,select trunc(sysdate,'dd') from dual,得到的是: 2009-3-23 上午12:00:00 ,与下文并不一样!
oracle trunc()函数的用法
1.TRUNC(for dates)
TRUNC函数为指定元素而截去的日期值。
其具体的语法格式如下：
TRUNC（date[,fmt]）
其中：
date 一个日期值
fmt 日期格式，该日期将 ......
SQL中的单记录函数
一、字符函数
1.ASCII
返回与指定的字符对应的十进制数;
SQL> select ascii(’A’) A,ascii(’a’) a,ascii(’0’) zero,ascii(’ ’) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
......
查询及删除重复记录的SQL语句
1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2、删除表中多余的重复记录，重复记录是根据 ......
隔离级别（isoation level）
隔离级别定义了事务与事务之间的隔离程度。
隔离级别与并发性是互为矛盾的：隔离程度越高，数据库的并发性越差；隔离程度越低，数据库的并发性越好。
ANSI/ISO SQ92标准定义了一些数据库操作的隔离级别：
未提交读（read uncommitted）
提交读（read committed） &n ......
1. 创建视图：
CREATE OR REPLACE VIEW SM_V_UNIT_AUTH AS
SELECT T2.UNIT_ID,
T2.SUPER_UNIT_ID,
T1.AUTH_ID,
T1.AUTH_NAME,
T1.A ......
