Vi ste ovdje
Overview/Description
outline the uses of management tools in Oracle Database 11g, such as SQL Performance Analzer, SQL tuning sets, and SQL plan baselines, and outline how you can use them to effectively manage change and execute SQL plans.
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...
Overview/Description
A service is a grouping of related tasks within a database with common functionality, quality expectations, and priority relative to other services. It provides a single-system image for managing competing applications running within a single instance and across multiple instances and databases. Using standard interfaces, such as the Database Configuration Assistant, Enterprise Manager, and SRVCTL, services can be configured, administered, enabled, disabled, and measured as a single entity. This course provides an introduction to services and discusses how to configure...
Overview/Description
To identify the steps for preparing a database for backup and then for performing various types of RMAN backups and monitoring them using reports and dynamic performance views, and also for performing user-managed backups and recoveries.
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.7
Lesson ObjectivesOracle Database 11g: Configuring for...
Overview/Description
To recognize the steps for configuring all aspects of backup and recovery functionality in Oracle Database 11g, using ARCHIVELOG mode, retention policies, a Flash Recovery Area, and an RMAN recovery catalog.
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.8
Lesson ObjectivesOracle Database 11g: Configuring for Recovery
identify the benefits of...
Overview/Description
Oracle Secure Backup or OSB is centralized tape-management software that allows you to backup and restore data using a variety of machine architectures. This course covers how OSB complements the Oracle backup and recovery options, as well as terminology, interface options, and backup management features. Additionally, it explores how to decide on the structure of your administrative domain, perform preinstallation tasks, and install OSB on Linux. Installing OSB on Windows, locating OSB installed files, verifying your installation, and removing OSB are also covered....
Overview/Description
To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.
Target Audience
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.
Prerequisites
Familiarity with data processing concepts and techniques
Expected Duration (hours)
1.8
Lesson ObjectivesOracle Database 11g: Controlling User Access and Managing Objects
identify the steps for granting and revoking system and object privileges.
grant privileges...
Overview/Description
To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).
Expected Duration (hours)
1.8
Lesson ObjectivesOracle Database 11g: Controlling User Access and Managing Schema Objects
identify the steps for granting and revoking system and...
Overview/Description
To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.
Target Audience
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.
Prerequisites
Familiarity with data processing concepts and techniques
Expected Duration (hours)
2.0
Lesson ObjectivesOracle Database 11g: Conversion Functions, Conditional Expressions, Group Functions, and Joins
identify the...
Overview/Description
To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.
Target Audience
Database Administrators, Database Designers, Developer
Support Engineers, and Technical Administrators.
Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)
Expected Duration (hours)
2.0
Lesson ObjectivesOracle Database 11g: Conversion Functions, Group Functions, and Joins
identify the...
Overview/Description
To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows.
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).
Expected Duration (hours)
1.7
Lesson ObjectivesOracle Database 11g: Data Dictionary Views and Large Data Sets
identify the steps...
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
