|
Provided by: 123-CBT Computer Based Training Oracle Database Administration Workshop I Part 2 |
 |
Oracle Database 10g is the first database designed for enterprise grid computing, the most flexible and cost-effective way to manage enterprise information. This course covers salient aspects of Oracle Database 10g such as user and data management. The basic aspects of database management such as database integrity constraints, transferring data, and defining tables and schemas has been discussed at length. Attention has been paid to DML and also to PL/SQL code, which is Oracle's proprietary fourth generation programming language that enables Oracle applications to interact over different operating systems and hardware platforms.
Learn To:
The target course audience is Data Administrators, PL/SQL Developers, and Technical consultants who have experience with the Oracle9i Database.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
4 hours
Objectives:
Unit 1: Managing Users
Learn To:
- Identify features of database user accounts and profiles in Oracle Database 10g.
- Identify options you can configure when creating a user.
- Identify options used to grant privileges to a user.
- Identify features of schemas.
- Identify rules for naming database objects.
- Match data types in Oracle Database 10g with their features.
The target course audience is Data Administrators, PL/SQL Developers, and Technical consultants who have experience with the Oracle9i Database.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
4 hours
Objectives:
Unit 1: Managing Users
- Identify features of database user accounts and profiles in Oracle Database 10g.
- Identify options you can configure when creating a user.
- Identify options used to grant privileges to a user.
- Identify features of quotas assigned to users.
- Identify the features of roles assigned to users.
- Identify features of schemas.
- Identify rules for naming database objects.
- Match data types in Oracle Database 10g with their features.
- Identify options for creating and modifying a table.
- Identify data integrity constraints used to impose restrictions on data stored in columns.
- Identify actions that you can perform on a table using Enterprise Manager.
- Identify features of views.
- Identify features of sequences.
- Identify features of SQL statements used in data manipulation.
- Identify tasks for exporting data using the Data Pump utility.
- Identify features of data import using the Data Pump utility.
- Identify features of SQL*loader.
- Identify features of SQL* Loader control files.
- Identify features of SQL*Loader data files.
- Distinguish between the direct and conventional path loads.
- Identify features of PL/SQL.
- Identify features of PL/SQL objects.
|
|
||||||||
Training
Provided by 123-CBT Computer Based Training
Oracle Database Administration Workshop I Part 2
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
