Vi ste ovdje
Overview/Description
RMAN manages the disk space in the Flash Recovery Area, and by putting RMAN in control of your backup and restore operations, you simplify your availability-related processes. This course describes integrated disk and tape backup, how to register the administrative server in Enterprise Manager, checking RMAN backup and recovery settings, creating database backup storage selectors, and using time-managed and content-managed expiration policies. It also explores performing an OSB-encrypted RMAN backup to tape and restoring a data file from a tape backup. You can also back...
Overview/Description
Recognize the steps for enhancing the performance of large objects, caching query results, and performing other miscellaneous tasks in Oracle Database 11g.
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)
2.3
Lesson...
Overview/Description
Oracle Secure Backup (OSB) maintains its own catalog of OSB and their rights on the administrative server. You can preauthorize users for the use of the obtool command line, RMAN, or both. You can also associate an OSB user with multiple Windows domain accounts or a single account that applies to all Windows domains. This course explores managing user access control for OSB, adding a user with preauthorized access, host authentication, backup security characteristics, encryption, and host encryption policies.
Target Audience
Database administrators, support engineers,...
Overview/Description
recognize ways in which storage has been enhanced in Oracle Database 11g using Automatic Storage Management's (ASM's) commands and extensions.
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)
1.7
Lesson ObjectivesOracle...
Overview/Description
identify the steps for maintaining storage structures and automating storage management in Oracle Database 11g, and for managing privileges, roles, and other security features for users.
Target Audience
Database Administrators, Database Designers, Developer
Support Engineers, and Technical Administrators
Prerequisites
A working knowledge of SQL
Expected Duration (hours)
2.5
Lesson ObjectivesOracle Database 11g: Storage Structures and User Security
recognize the purposes of table spaces and datafiles.
recognize the steps for creating a new tablespace.
recognize how to...
Overview/Description
To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.
Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants
Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning
Expected Duration (hours)
2.3
Lesson ObjectivesOracle Database 11g: Subprograms, Packages...
Overview/Description
To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.
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)
2.3
Lesson ObjectivesOracle Database 11g: Subprograms, Packages, and Exception Handling
identify the benefits of modularized and layered subprogram design.
recognize the...
Overview/Description
To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.
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: Subqueries and Regular Expressions
identify the steps for writing multiple-column and scalar subqueries.
recognize the steps for solving problems by using...
Overview/Description
To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.
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.9
Lesson ObjectivesOracle Database 11g: Subqueries, Set Operators, and...
Overview/Description
To recognize the steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks, and also for making sure that any changes to a database can be easily reversed, if necessary, using Oracle Database 11g's flashback features.
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 ObjectivesOracle Database 11g:...