Vi ste ovdje
Overview/Description
To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies
Target Audience
PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers
Prerequisites
The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL
Expected Duration (hours)
1.8
Lesson ObjectivesOracle Database...
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,...
Overview/Description
An important aspect of Oracle Database administration is to understand how a database and its major components function. Also as an Oracle Database administrator, you need to be able to recover when problems occur in the database. This is accomplished using backups, which are used to protect against problems such as media failure, user errors, and application errors. This course reviews the major architectural components of the Oracle Database 11g architecture, such as memory structures, background processes, and the logical and physical storage structures. This course...
Overview/Description
As an Oracle Database administrator, it is important to plan the database to ensure that the database software is installed properly. Planning involves the logical storage structure, the overall design, and a backup strategy. It is also important to manage the database instance after the installation to ensure that it runs properly, and is started and shut down correctly to avoid problems. This course describes the DBA tasks to plan a database installation and how to use the Database Configuration Assistant (DBCA) to install the Oracle Database 11g software. It...
Overview/Description
Administering an Oracle database requires monitoring and diagnosing data failures and recovering from them. Oracle Database 11g Release 2 provides the Data Recovery Advisor which eases this task by automatically detecting errors when they occur and providing repair advice. The use of the Automatic Diagnostic Repository can also be used, which holds diagnostic information about critical error events. Flashback technology can be used when a logical corruption occurs in the Oracle database and you need to recover data quickly and easily. With the use of a Flashback Table,...
Overview/Description
Oracle Database 11g Release 2 offers new diagnosability enhancements to help DBAs in diagnosing, resolving, and preventing problems. These new features include enhancements to problem and incident identification, running health checks, and performing repairs on SQL statements. These features enables the DBA to quickly and efficiently diagnose issues and report problems to Oracle Support, as well as reducing damage and interruptions. This course discusses using Automatic Diagnostic Repository, creating and submitting Incident Packages to Oracle Support, running health...
- 1 od 13
- ››
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
