Vi ste ovdje
Overview/Description
To use Oracle 10g's new tuning, performance-monitoring, and analysis features
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
3.0
Lesson ObjectivesOracle Database 10g: New Tuning, Performance-monitoring, and Analysis Features
identify how to use the new optimizer statistics in Oracle Database 10g.
use the SQL Tuning Advisor in a given scenario...
Overview/Description
To provide an overview of Oracle Net Services and Shared Server
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
2.8
Lesson ObjectivesOracle Database 10g: Oracle Net Services and Shared Servers Release 2
recognize how to create and configure an Oracle Net listener in Oracle Database 10g.
recognize how to monitor Oracle Net Services using the Listener Control utility.
create and configure an Oracle Net Listener.
configure local name...
Overview/Description
To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
2.0
Lesson ObjectivesOracle Database 10g: The SQL*Loader and PL/SQL Release 2
identify the function of the SQL*Loader and the files it uses.
recognize how to load data using the SQL*Loader.
load data using the SQL*Loader.
identify the characteristics of PL/SQL objects, functions, and procedures....
Overview/Description
To explain how to manage users, implement security, and audit database activity on an Oracle 10g database
Target Audience
Anyone wanting to learn about Oracle Database 10g database administration
Prerequisites
An understanding of database concepts and technologies
Expected Duration (hours)
3.3
Lesson ObjectivesOracle Database 10g: Users and Security Release 2
recognize how to create user accounts and profiles.
recognize how to grant privileges and assign quotas to users.
recognize how to create a role and assign it to a user.
administer user accounts on an Oracle 10g...
Overview/Description
To recognize Oracle 10g's Flashback technology and use Flashback features
Target Audience
Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
Prerequisites
Experience in the administration of Oracle 8i or 9i databases
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 10g: Using Flashback
recognize flashback technology and its features.
use Flashback Database in a given scenario.
use Enterprise Manager to flash back a dropped table in a given scenario...
Overview/Description
Oracle Database 11g Release 2 offers improved and new features to provide better application performance. It offers online table redefinition, which allows tables to be modified without affecting the availability of the table to users and does not affect any of its dependencies. This allows for easier application changes and improved query and DML performance. Application performance in Oracle Database 11g Release 2 is also improved by the use of adaptive cursor sharing, which allows for intelligent cursor sharing and the use of invisible indexes. It provides two...
Overview/Description
Oracle Database 11g Release 2 provides many improvements from its previous releases. This includes enhancements to ASM and storage to improve performance and to reduce server maintenance down time. This course identifies the enhancements in each of these areas. It also demonstrates how to use ASM fast mirror resync, manage ASM users, disk groups, ACLs, and Intelligent Data Placement, as well as table compression, SQL Access Advisor, and segment creation. It is one of a series of courses in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-...
Overview/Description
Preparing for and performing data recovery and completing database backups are expected job duties of an Oracle Database 11g Database Administrator (DBA) to ensure that the database is available for users when they require it. They also need to ensure if a failure does occur that the loss of data is minimized as much as possible and they can recover the database in an efficient manner. As an Oracle DBA, it is important to understand the various internal consistency checks a database performs as it moves from the shutdown stage to being fully open. Equally important is an...
Overview/Description
Oracle Database 11g Release 2 offers new and improved features to ensure for continuous data access, even during unplanned failures and scheduled maintenance tasks. New RMAN features make it easier to backup, recover and duplicate databases in a timely manner while minimizing data loss. It also offers Flashback technology, giving DBAs additional protection against data loss, as well as the Data Recovery Advisor which automatically diagnoses data failures and offers suggestions on how to correct the issues. This course demonstrates how to backup and recover database,...
Overview/Description
To understand how an Oracle Database functions, it is important to gain a basic understanding of its major components. This course identifies the major architectural components of the Oracle Database 11g Release 2, explains memory structures, describes background processes, and explores the logical and physical storage structures. In addition, this course describes the role of a database administrator (DBA) and the tasks and tools required for this role. This course also covers how to plan for the Oracle Grid Infrastructure and Oracle Database 11g software installations,...
Koraci do učenja
Prijavite se, a ako nemate korisničko ime, registrirajte se.
Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.
Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.
Trebate pomoć?
- Česta pitanja - FAQ
- telefon: +385 1 6558 440
- email: support@cognita.hr
- Kontakt forma
