Vi ste ovdje
Overview/Description
Identify how to to monitor performance, automate maintenance, calibrate and manage resources, and streamline job scheduling using Oracle Database 11g's intelligent infrastructure enhancements.
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...
Overview/Description
Every business should identify security threats and concerns and develop policies to protect itself. Maintaining the integrity of important data, and protecting data by controlling access to it are also key steps in business security. This course describes business security requirements and defines least privilege, authorization, and authentication. It also covers security policies, the concept of in-depth security, and applies these concepts to prevent SQL injection. Maintaining data integrity, protecting data, and controlling data access are also covered.
Target...
Overview/Description
Restoring files is easily accomplished using the Oracle Secure Backup catalog. This course demonstrates how to browse the catalog for file-system backup data, create catalog-based restore requests, and perform file-system restoration. In addition, this course explores the Oracle Secure Backup processes, configuring defaults and policies, browsing the primary Oracle Secure Backup catalogs, and performing preconfigured catalog backup. Common tasks such as managing clients, media servers, and volumes are also covered.
Target Audience
Database administrators, support...
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
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.7
Lesson ObjectivesOracle Database 11g: Managing Data Dictionary Views and Large Data Sets
identify the steps for using data...
Overview/Description
To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.
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.3
Lesson ObjectivesOracle Database 11g: Managing Data in Different Time Zones
recognize the steps for managing time zones and time intervals.
recognize the...
Overview/Description
To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.
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)
1.3
Lesson ObjectivesOracle Database 11g: Managing PL/SQL Code and Dependencies...
Overview/Description
To identify ways to ensure that resources are being put to best use and database jobs are performed when they should be, using the Database Resource Manager and the Scheduler.
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.9
Lesson ObjectivesOracle Database 11g: Managing Resources and Task Automation
identify the steps for accessing and...
Overview/Description
Identify the steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators
Prerequisites
A working knowledge of SQL
Expected Duration (hours)
2.0
Lesson ObjectivesOracle Database 11g: Managing the Schema, Data, and Concurrency
recognize the features and functions of schemas and data types, and identify the steps for modifying a table.
recognize the...
Overview/Description
To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.
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.3
Lesson ObjectivesOracle Database 11g: Managing Time Zones and Datetime Functions
recognize the steps for managing time zones and time intervals.
recognize the steps for using...
Overview/Description
recognize the steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds.
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators
Prerequisites
A working knowledge of SQL
Expected Duration (hours)
2.4
Lesson ObjectivesOracle Database 11g: Managing Undo Data, Database Security, and Maintenance
recognize the steps for managing undo operations in Oracle Database 11g to allow users to roll back transactions....