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
相关文档:
用date型字段进行数据检索时需要注意:数据格式化!
此数据格式化不同于用SimpleDateFormat("yyyy-MM-dd")对象进行格式化,而是用Oracle的内置函数to_date()
或标识符date来格式化。
例如:
有个字段是date数据,我想查询某某年度的数据。
错误写法:s ......
数据字典dict总是属于Oracle用户sys的。
1、用户:
select username from dba_users;
改口令
alter user spgroup identified by spgtest;
2、表空间:
select * from dba_data_files;
select * from dba_tablespaces;//表空间
select tablespace_name,sum(bytes), sum(b ......
查询及删除重复记录的SQL语句
1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2、删除表中多余的重复记录,重复记录是根据 ......
转自:http://tech.it168.com/a2009/1023/788/000000788673.shtml
1、范围
本文讨论的是Oracle数据库提供的数据复制机制,所讨论的解决方案全部与平台无关。
2、介绍
复制是目标数据库与源数据库之间数据保持同步的一种机制,复制可以分成不同的类型,如:
2.1数据库内的复制
在这种情况下,一个 ......
序列(SEQUENCE)是序列号生成器,可以为表中的行自动生成序列号,产生一组等间隔的数值(类型为数字)。其主要的用途是生成表的主键值,可以在插入语句中引用,也可以通过查询检查当前值,或使序列增至下一个值。
创建序列需要CREATE SEQUENCE系统权限。序列的创建语法如下:
CREATE SEQUENCE 序列名
[INCREMENT BY n]
[ST ......