Online Enterprise Manager eLearning Training

Oracle9i Database Admin Perform Database Backups ... such as RMAN, standard SQL*Plus commands, and the Oracle Enterprise Manager Console. Students assess the status of critical database files using SQL*Plus commands. In addition, students create a standby database, identify the steps involved in synchronizing a standby database, and activate, refresh, and update a standby database. Learn To • Identify the factors to consider when  more...

Oracle9i Database Admin Create a Database ...and change the properties of a tablespace by using Oracle Enterprise Manager. • Create read-only tablespaces and drop tablespaces, identify the benefits of multiple tablespaces, and specify storage parameters and retrieve data dictionary information. • Identify the features of undo tablespaces and manage undo tablespaces. Audience The intended audience for this course  more...

Oracle9i Database Admin Manage an Instance ...mmit. • Identify the tasks of a DBA and the Oracle Enterprise Manager tools used by a DBA. • Identify the OEM console components, steps to set up these components, and the functions of the OEM DBA tools. • Identify the default DBA user accounts and set up authentication methods to validate users. • Identify the parameters stored in the parameter file, their uses, and  more...

SQL Server 2000 Database Admin Part 2 Manag Databases ...roperties. View database information by using SQL Server Enterprise Manager. Match the different types of data integrity with their characteristics. Identify the different types of constraints. Identify guidelines for creating constraints. Audience Candidates for this exam operate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server  more...

Oracle8i Performance Tuning Architecture Strategy ... prior to taking this course, and experience using Oracle Enterprise Manager (OEM). This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA) Track Exam 4, 1Z0-024. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Tuning the Oracle8i Server: Overview Duration: 1.5 - 2 Hour(s) Match the tuning goals with the appropriate job  more...

Oracle8i Database Admin Manage an Instance ...dentify Oracle architectural components. Use the Oracle Enterprise Manager (OEM) interface. Manage an Oracle instance. Use National Language Support (NLS). C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT  more...

Oracle Database 10g Administration Workshop II Part 3 ...quence the steps for configuring Flashback Database using Enterprise Manager (EM). Identify options for monitoring Flashback Database. Identify guidelines for managing the Flash Recovery Area. Identify the methods for performing a Flashback Database operation. Identify considerations for using the Flashback Database feature. Identify features of Flashback time navigation methods.  more...

Oracle8 Performance Tuning Strategies and Techniques ...AT/UTLESTAT output report. Identify appropriate Oracle Enterprise Manager (OEM) tuning tools. Use the available data access methods to tune the logical design of the database. List the primary steps for operating system tuning. Identify similarities between operating system and database tuning. C ontent Emphasis Skills-Based A udience Database administrators, system  more...

Oracle8 Database Administration - Manage an Instance ...s. Use the Server Manager line mode and the Oracle Enterprise Manager (OEM) interface. Manage an Oracle instance. Learn about the features of National Language Support (NLS). C ontent Emphasis Skills-Based A udience Database Administrators, system administrators, network administrators and technical support professionals. Prior to taking this course, participants  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 5 ...rosoft Access database into Microsoft Repository by using Enterprise Manager. Display data lineage by using the metadata browser. Identify the benefits of Type Information Model. Identify the benefits of Open Information Model. Identify the benefits of Unified Modeling Language Model. Identify the benefits of Database Model. Identify the benefits of Data Type Model. Identify the benefits  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3 ...ps necessary to build and manage replication by using the Enterprise Manager; build a dimension and assign its member properties; build an aggregation and identify the guidelines for optimizing aggregation performance; and build a cube and a partition and manage them. L earn To: Create a data warehouse database. Perform the steps necessary to build and manage replication by using  more...

Visual C 6 0 Designing Implementing Distributed Applications - Part 3 ...components. Modify the properties of a database by using Enterprise Manager. Create a table by using Enterprise Manager. Create an index by using Enterprise Manager. Create a relationship between two tables to enforce referential integrity. Import data from an external source by using Enterprise Manager. Access data from a single table by using the SELECT statement. Access data from  more...

Visual C 6 0 Designing Implementing Desktop Applications - Part 1 ... - 2 Hour(s) Register SQL Server 6.5 by using the SQL Enterprise Manager. Configure SQL Server 6.5 by using the Microsoft SQL Enterprise Manager. Configure a SQL Server database by using the SQL Enterprise Manager. Set permissions for a specific user by using the By User tab. Install Microsoft Message Queue Server (MSMQ). Create a queue by using the Microsoft Message Queue Explorer.  more...

Oracle Database 10g Adminsitration Workshop I Part 3 This course provides an understanding of the Database Security. This course will help the learner to understand the benefits of database auditing and monitoring. It also covers Database Listeners and Services. The concept of shared and dedicated servers is also covered. After going through this course, the learners would be able to tune the system for best performance by configuring automatic  more...

Oracle Database 10g Administration Workshop II Part 2 ...ands. Identify backup maintenance functions provided by Enterprise Manager (EM). Match various RMAN dynamic views with their functions. Sequence the steps that are performed to monitor an RMAN backup. Unit 2: Diagnostic Sources and Recovery Identify features of the alert.log file. Identify features of alerts. Identify options that enable you to configure alerts. Identify  more...

Oracle Database Administration Workshop I Part 2 ... Identify actions that you can perform on a table using Enterprise Manager. Identify features of views. Identify features of sequences. Identify features of SQL statements used in data manipulation. Identify tasks for exporting data using the Data Pump utility. Identify features of data import using the Data Pump utility. Identify features of SQL*loader. Identify features of  more...

SQL Server 7 0 System Administration - Part 2 ...quence the steps to implement server authentication using Enterprise Manager. Perform the steps for setting Mixed Mode authentication using Enterprise Manager. Identify the three types of security accounts available for login creation. Perform the steps for adding a Windows NT login using Enterprise Manager. Perform the steps for adding a SQL Server login using Transact-SQL. Perform the  more...

Oracle e-Business 11i System Admin Fundamentals 2 ...cessing management. Identify key features of the Oracle Enterprise Manager. Define a concurrent manager. Unit 2: Profile Options and Custom Programs (3 hours) Identify key features of profile options. Match profile options with their functions. Identify steps for setting personal profile options. Identify guidelines for incorporating custom programs. Identify guidelines for  more...

Oracle Database 10g Administration Workshop II Part 1 ... Sequence the steps to set the listener password by using Enterprise Manager (EM). Identify steps to set the listener password by using Net Manager. Identify features of the RMAN. Match various RMAN components with their features. Identify features of RMAN media management. Audience: The target audience is Data Administrators, Technical Consultants, Support Engineers, and Sales  more...

Oracle Database 10g New Features for Administrators Part 4 ... Identify the steps to relocate SYSAUX occupants by using Enterprise Manager (EM). Identify conditions for renaming tablespaces in Oracle Database 10g. Audience: The target course audience is Data Administrators, PL/SQL Developers, and Technical consultants who have experience with the Oracle9i Database. Deployment: Self-Study Language Options: US English Total  more...

Oracle Database 10g Administration Workshop I Part 1 Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will be taught to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Learn To:  more...

Oracle 9i New Features Database Administration ...racle9i enhancements in server-side manageability, Oracle Enterprise Manager, and globalization. Learn To Identify memory and space management improvements. Describe segment and index management improvements. Identify improvements in database operations and performance. Recognize  more...

MS Project Server 2003 Introduction Part 1 ...dentify the steps to create a SQL Server 2000 login using Enterprise Manager. Audience: This course is intended for IT professionals and network administrators who are responsible for configuring and managing an organization's enterprise project management solution. They have one to three years of experience operating in large computing environments that run Microsoft Windows a a 2000  more...

Oracle Application Server 10g Administration Part 1 ...tributes of grid technology. Identify benefits of using Enterprise Manager Grid Control comprehensive management system. Identify features of Oracle Application Server 10g (OracleAS). Audience: The course is intended for Web Administrators and Technical Consultants who have a working experience with Linux Operating Systems. Deployment: Self-Study Language Options: US  more...

Oracle Application Server 10g Administration II Part 1 ...ents. Learn To: Identify enhancements in Oracle Enterprise Manager (OEM) Application Server Control to manage a customized and distributed environment. Identify the uses of Oracle Process Management and Notification Server (OPMN) in the OracleAS environment. Identify considerations for choosing the topology for a site. Sequence the steps involved in installing Identify  more...