Vi ste ovdje
Overview/Description
Identify the elements of the Oracle Database 11g architecture and recognize the tools and steps required to install the Oracle Database 11g software
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: Database Architecture and Installation
identify the main structural components of Oracle Database 11g.
identify the components of the Oracle Database 11g memory structures.
identify the functions of...
Overview/Description
Identify the steps for creating a new Oracle Database 11g database and then configuring it and managing the instance, and also recognize the steps for configuring new Oracle Net Listeners and database connectivity.
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: Database Creation, Instance Management, and Connectivity
recognize the steps for creating, configuring, or deleting a database using...
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
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....
Overview/Description
recognize ways to make use of Oracle Database 11g's tools for moving and recovering data, reporting on problems, and installing updates to enhance a database.
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators
Prerequisites
A working knowledge of SQL
Expected Duration (hours)
2.2
Lesson ObjectivesOracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database
recognize the tools required and steps performed in identifying whether a recovery is necessary, and then recovering various types of...
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...