Vi ste ovdje
Overview/Description
All encryption has two parts: an algorithm, which is a procedure or a method of manipulating data, and a key or a secret that allows data to be decrypted. This course discusses the issues and challenges of encryption and describes key management solutions. It also describes the encryption options available with Oracle Database 11g. Using DBMS_CRYPTO to generate random encryption keys and encrypting and decrypting table columns are also covered.
Target Audience
Database administrators, security administrators, security compliance auditors, security compliance professionals...
Overview/Description
Enterprise User Security addresses the user, the administrative, and the security challenges by centralizing storage and management of user-related information in a Lightweight Directory Access Protocol-compliant directory service. This course describes the basic components of Enterprise User Security. It shows the architecture of this feature and describes the installation process. The components required to create and manage an enterprise user are discussed. In addition, the course explains the techniques for using the enterprise user in the context of the database...
Overview/Description
An execution plan is the output of the optimizer and is presented to the execution engine for implementation. The execution plan instructs the execution engine about the operations it must perform for retrieving the data required by a query most efficiently. This course explores gathering, displaying, and interpreting execution plans. It also covers the EXPLAIN PLAN command and the PLAN_TABLE, using AUTOTRACE, dynamic performance views that contain execution plan information, the Automatic Workload Repository (AWR), and SQL monitoring. The star schema is the simplest data...
Overview/Description
There is no single best architecture for accommodating Internet requests requiring access to corporate intranets. Instead, trade-offs must be made between two competing goals â security of the intranet against an Internet attack and ease of access to services by both Internet and intranet clients. This course describes how firewalls are used to restrict network access and the guidelines for positioning servers within firewalls. It also explores how to configure Oracle Connection Manager to accept or reject connection requests and log connection events, and how to read...
Overview/Description
To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.
Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.
Prerequisites
Previous programming experience and knowledge of SQL
Expected Duration (hours)
1.9
Lesson ObjectivesOracle Database 11g: Getting Started With PL/SQL
recognize the features and capabilities of SQL...
Overview/Description
To recognize the steps for utilizing Oracle Database 11g's globalization support features to ensure that information and data is displayed in a user's native language, and that territory and language-dependent conventions are adhered to.
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Prerequisites
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I
Expected Duration (hours)
1.2
Lesson ObjectivesOracle Database 11g: Globalization...
Overview/Description
In Oracle Database 11g, RAC and Data Guard together provide the benefits of system-level, site-level, and data-level protection, resulting in high levels of availability and disaster recovery without loss of data. This course explains how to configure connections for high availability using various types of workload distribution and load balancing, including Fast Application Notification (FAN), Fast Connection Failover (FCF), and Transparent Application Failover (TAF). It also discusses designing for high availability by minimizing downtime using Data Guard, Data Guard...
Overview/Description
Access paths are the ways in which data is retrieved from the database, and there are a number of different access paths which can be used for tables and indexes. This course explores the access paths used for tables, such as full table, rowid, and sample table scan. It also examines the access paths used for indexes, such as unique, range, full, fast full, skip, and index join index scans, as well as bitmap indexes and combining bitmap indexes. Additionally, this course discusses B*-tree, bitmap, composite, and invisible indexes and nullable columns when using indexes....
Overview/Description
Recognize the enhancements to Oracle Database 11g's installation and upgrade processes, as well as its various post-upgrade steps, and recognize how to create a new database.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA's considering upgrading their systems to 11g
Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
Expected Duration (hours...
Overview/Description
Oracle Database 11g: Real Application Clusters (RAC) enable high utilization of a cluster of standard, low-cost modular servers and offers high availability, scalability, and important grid computing features. This course provides an introduction to Oracle Database 11g: Real Application Clusters (RAC) and demonstrates how to fulfill the pre-installation requirements for Oracle Clusterware as well as how to install and configure Clusterware. It also demonstrates the installation of Automatic Storage Management (ASM) and Oracle Database software and then explains how to...
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
