Imate žicu za učenje?

Overview/Description Oracle Database server is highly secure, but to fully maximize the security features offered, the database must be well protected as well. This course explores how to configure Oracle Database 11g in a secure manner by adhering to industry standard best security practices for operational database deployments. It covers applying the principle of least privilege to the database, locking and expiring default user accounts, changing default user passwords, creating strong passwords, enforcing password management, and protecting the data dictionary. Target Audience Database...
Overview/Description Problems that occur with Oracle RAC instances can be difficult to diagnose because they span across two or more nodes in a cluster. Oracle Database 11g provides various methods for diagnosing and debugging Oracle Clusterware and RAC components. This course discusses the basics of debugging and the use of diagnostics in a RAC environment, including how to use Oracle Clusterware diagnostic files, the DIAG process, and the Cluster Verification Utility (CVU). In addition, it explains and demonstrates in detail the steps involved in adding and removing nodes and instances in...
Overview/Description To identify the steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and also for enabling and configuring automatic memory management and automatic shared memory management. 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) 2.2 Lesson...
Overview/Description recognize the steps for detecting, diagnosing, and repairing critical errors and data failures in Oracle Database 11g, using its enhanced, proactive, diagnostic tools, such as Automatic Diagnostic Repository, Support Workbench, SQL Repair Advisor, and the Data Recovery Advisor. 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...
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...

Koraci do učenja

1Prijavi se

Prijavite se, a ako nemate korisničko ime, registrirajte se.

2Pronađi i upiši program

Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.

3Uči

Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.

»Detaljne upute

Trebate pomoć?