Online Tuning eLearning

Monitoring and Security in Exchange Server 2007 Monitoring and Security in Exchange Server 2007 Microsoft Microsoft Certified Technology Specialist Exchange Server 2007, Configuration (Exam 70-236) To ensure that the Exchange Server 2007 environment runs smoothly, it is necessary to monitor system activity and the performance of your Exchange servers. Monitoring allows you to obtain data that can assist in tuning the performance of the  more...

Oracle Database 10g New Tuning Performance-monitoring and Analysis Features Oracle Database 10g: New Tuning, Performance-monitoring, and Analysis Features Oracle To use Oracle 10g's new tuning, performance-monitoring, and analysis features  more...

OracleAS 10g Tuning and Reconfiguring the Middle Tier OracleAS 10g: Tuning and Reconfiguring the Middle Tier Oracle To describe how to optimize the performance of Oracle Application Server components and to explain how to perform reconfiguration tasks in the Oracle Application Server middle tier and infrastructure  more...

Oracle Database 11g R2 Managing Database Memory Performance Oracle Database 11g R2: Managing Database Memory & Performance Oracle Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which  more...

Oracle Database 11g R2 Using Monitoring Tuning RMAN ...Tuning RMAN Oracle Reconstructing the contents of all or part of a database from a backup typically involves two phases. The first phase is the retrieval of a copy of the data file from the backups. The second involves reapplying changes to the file that occurred since the backup, using archived and online redo logs. To effectively administer an Oracle Database 11g database, recovery  more...

Monitoring Exchange Server 2010 Mail Flow Performance Monitoring Exchange Server 2010 Mail Flow & Performance Microsoft Microsoft Certified Technology Specialist Exchange Server 2010, Configuration (Exam 70-662) To ensure that the Exchange Server 2010 environment runs smoothly, it is necessary to monitor system activity and the performance of your Exchange servers. Monitoring allows you to obtain data that can assist in tuning the performance  more...

SQL Server 2008 Database Monitoring and Performance ... as possible, administrators use a variety of performance tuning and monitoring tools. The SQL Server Profiler enables administrators to use trace files and logs to analyze a database's performance. They can also use the Windows System Monitor to monitor SQL Server 2008 using counters, which monitor specific aspects of the server for performance issues. SQL Server 2008 includes the Activity  more...

Gathering Performance Data in SQL Server 2008 ...ssible, SQL Server 2008 provides a variety of performance tuning and optimization utilities. Among these utilities are the SQL Server Profiler and the Database Engine Tuning Advisor. The SQL Server Profiler allows you to use trace files and logs to analyze your database s performance. The Database Engine Tuning Advisor allows you to analyze a database s workload and effectively configure the  more...

Oracle Database 11g Performance Tuning Methodology Tools ...Tuning Methodology & Tools Oracle Oracle Database 11g provides a variety of tools that can be used for performance tuning in an Oracle database environment. These tools can be used to diagnose and tune common SQL-related and instance-related problems as well as proactively tune an Oracle database. One such tool, Enterprise Manager, can be used to monitor an Oracle database using the many  more...

Oracle Database 11g Using AWR Defining Problems ...in, and utilize statistics for problem detection and self-tuning purposes. This course explains how to create and manage AWR snapshots, and demonstrates how to use the snapshots to generate individual AWR reports as well as AWR compares period reports. It discusses the identification of performance issues, setting the tuning priorities, how to tune depending on the particular application life  more...

Oracle Database 11g Metrics Alerts Baselines AWR Tools Services ...ts that can be used to monitor and manage the performance tuning of an Oracle Database 11g environment. Automatic Workload Repository (AWR) based tools can be used to tune automatic maintenance tasks and generate and read ADDM and ASH reports. This course demonstrates how to create static and repeating baselines, compute baseline statistics, define alert thresholds, and generate ADDM and ASH  more...

Oracle Database 11g Problem SQL Statements Oracle Optimizer Oracle Database 11g: Problem SQL Statements & Oracle Optimizer Oracle Oracle Database 11g helps to identify problem SQL statements using Oracle Optimizer and execution plans. This course discusses SQL statement processing and the role of the Oracle Optimizer and execution plans. It also explains how to generate and view execution plans using the DBMS_XPLAN package, the EXPLAIN PLAN command,  more...

Oracle Database 11g SQL Performance Database Replay Oracle Database 11g: SQL Performance & Database Replay Oracle Database Replay allows you to test the impact of a system change by replaying a real-world workload on a test system before it is exposed to a production system. This course demonstrates how to use Database Replay to capture and replay workloads to test the impact of a system change. It also explains how to use SQL Performance  more...

Oracle Database11g Shared Pool Buffer Cache Tuning ...Tuning Oracle The buffer cache is an extremely important component for the performance, scalability, and reliability of the database. This course demonstrates how to identify the symptoms that indicate a buffer cache problem and how to use the various methods available to resolve common performance issues related to the buffer cache. It also discusses the sizing of the buffer cache and  more...

Oracle Database 11g Tuning PGA Temporary Space AMM ...Tuning PGA, Temporary Space & AMM Oracle Oracle Database 11g provides various methods for tuning, monitoring and managing memory and temporary tablespaces. Automatic Program Global Area (PGA) memory management adapts the SQL memory allocation based on PGA memory available, SQL operator needs, and system workload. A temporary tablespace is used to store transient data generated explicitly  more...

Oracle Database 11g Segment Space I O and Performance Tuning ...Tuning Oracle Oracle Database 11g provides various methods for tuning segment space usage and input/output (I/O). This course explains how to use Automatic Segment Space Management (ASSM) to tune segment space usage, how to shrink segments using SQL or the Enterprise Manager, and how to use table compression. Automatic Storage Management (ASM) capabilities save you time by automating  more...

ORACLE DATABASE 11G PERFORMANCE TUNING ORACLE DATABASE 11G: PERFORMANCE TUNING Oracle  more...

Oracle Database 11g Architecture SQL Tuning Optimization ...Tuning & Optimization Oracle The Oracle Database server consists of an Oracle Database and one or more Oracle Database instances. SQL (Structured Query Language) is the language with which all programs and users access an Oracle Database. Monitoring the performance of and tuning database components, as well as the SQL statements used to access and manipulate the database, helps to ensure  more...

Oracle Database 11g Application Tracing Automatic SQL Tuning ...Tuning Oracle Oracle Database implements tracing by generating a trace file for each server process when you enable the tracing mechanism. This course explores configuring the SQL Trace facility to collect session statistics, using the TRCSESS utility to consolidate SQL trace files, formatting trace files using the tkprof utility, and interpreting the output of the tkprof command. Tuning  more...

ORACLE DATABASE 11G SQL TUNING ORACLE DATABASE 11G: SQL TUNING Oracle  more...

Oracle Dabase 11g Tape Vaulting Duplication Tuning ...Tuning Oracle Oracle Secure Backup uses a volume rotation policy to track a backup volume as it moves from its originating location to a storage location and is eventually recycled. This process is known as vaulting. This course covers configuring and using tape vaulting and a tape vaulting environment, viewing tape rotation reports, and troubleshooting vaulting. This course also explores  more...

Oracle Database 11g RAC Performance Tuning ...Tuning Oracle Performance Tuning uses diagnostic tools to gather statistics, statistic rates, and sampled statistics in order to tune the database system to provide the best performance as efficiently as possible. Although there are specific tuning areas for Oracle Database 11g: RAC, such as instance recovery and interconnect traffic, you will get the best performance by tuning your RAC  more...

Oracle Database 11g R2 Intelligent Infrastructure Enhancements ...hering performance metrics for problem detection and self-tuning purposes. The information gathered can be viewed by the DBA using either reports or views, as well as the alert log. Oracle Database 11g has expanded features for automatic SQL tuning and the Automatic Workload Repository, which allows the DBA to ensure the database is running efficiently, and by using the Enhanced Resource  more...

Oracle Database 11g R2 The ASM Instance Network Connectivity ...t by the DBA. Some of these tasks include I/O performance tuning, file system, cluster file system, and raw device management, and data file movements and reorganizations. When ASM is used, an ASM instance is also used. The ASM instance allocates memory and uses the SGA differently than in a database instance. This course describes the ASM instance and how it works, and demonstrates how to  more...

Beginning Webmastering Techniques( with site design/management focus ) ...tabase issues. Topics Covered : Site design, Performance Tuning, Adding audio, video and simple add-ons and also a broad overview of other Webmastering areas of speciality. Prerequisite: Some programming experience is helpful. Familiarity with networking concepts will also be helpful. Software/Hardware Requirement : A student will need to have access to a PC( 486 or higher ), internet  more...

The Art of Professional Telephone Communication ...u can use to turn the telephone into a selling advantage. Tuning in to key words will indicate buying style and presentation preferences. You want to know how to ?read? your customer with those key words. Your use of both incoming and outgoing voice mail affects the success you have with people returning calls. The telephone is a tool that casts a wide affect on the sales process from getting  more...

Maintenance and Performance Tuning in WebSphere 5 0 To give an overview of how to maintain and tune the WebSphere environment  more...

Configuring WebSphere 5 0 Session Management and Failover To demonstrate how to configure WebSphere session management, tuning, security, and failover  more...

The Health Care Industry Overview Version 2 ... and processes for compliance. As a result, they are fine-tuning their business strategies and turning to information technology to eliminate inefficiencies in the value chain, to address issues of access, to improve quality, and to reduce cost. This course provides a high-level view of the health care industry environment, including its key players, trends, structure, and relevant business  more...

Why Customer Driven Today in America, the emphasis is on service. Health care organizations, insurance agencies, investment brokers, and accountants sell services rather than products. As the popularity of the Internet increases, all companies are forced to focus on service through company web sites that put them into direct contact with customers. Customer satisfaction--and quality--is quickly becoming the  more...

Cisco BSCI 3 0 Tuning OSPF Configurations To enable you to describe OSPF network types, operations, information flows, single area and multiarea routing  more...

Cisco BSCI 3 0 Tuning BGP Implementations To enable you to recognize BGP neighbor states, attributes, best-path selection, and authentication and troubleshooting techniques.  more...

Cisco BSCI 3 0 Tuning OSPF Configurations To enable you to describe OSPF network types, operations, information flows, single area and multiarea routing  more...

Cisco BSCI 3 0 Tuning BGP Implementations To enable you to recognize BGP neighbor states, attributes, best-path selection, and authentication and troubleshooting techniques.  more...

Cisco BSCI 3 0 Tuning BGP Implementations To enable you to recognize BGP neighbor states, attributes, best-path selection, and authentication and troubleshooting techniques.  more...

Cisco BSCI 3 0 Tuning OSPF Configurations To enable you to describe OSPF network types, operations, information flows, single area and multiarea routing  more...

Cisco BSCI 3 0 Tuning BGP Implementations To enable you to recognize BGP neighbor states, attributes, best-path selection, and authentication and troubleshooting techniques.  more...

Cisco BSCI 3 0 Tuning OSPF Configurations To enable you to describe OSPF network types, operations, information flows, single area and multiarea routing  more...

Oracle Database 11g Change Management Overview and SQL Plan Management 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.  more...

Oracle Database 11g Database Replay and Automatic SQL Tuning Explain the benefits and uses of Oracle Database 11g's crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database  more...

Oracle Database 11g Supporting RMAN and Using Flashback Technology 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.  more...

Oracle Database 11g Database Performance and Space Management To identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces.  more...

Performance Tuning Methodology and Tools in Oracle9i To describe the methods and goals of database tuning and the utilities and tools used to analyze and tune an Oracle9i database  more...

Tuning Memory Structures in Oracle9i To describe how to tune Oracle9i memory structures  more...

Tuning Database Structures in Oracle9i To describe how to tune components of an Oracle9i database  more...

Tuning Systems and Applications in Oracle9i To describe how to tune systems and applications in Oracle9i  more...

Oracle Database 10g Administration Workshop II Part 3 ...e advisory framework. Sequence the steps in an advisor tuning session. Sequence the steps for creating a custom Automatic Database Diagnostic Monitor (ADDM) task manually. Audience: The target audience is Data Administrators, Technical Consultants, Support Engineers, and Sales Consultants. Deployment: Self-Study Language Options: US English Total  more...

Oracle Database 10g Administration Workshop I Part 4 ...eatures of instance recovery. Identify key concepts of tuning instance recovery. Audience: The target audience is Data Administrators, Technical Consultants, Support Engineers, and Sales Consultants. Deployment: Self-Study Language Options: US English Total Learning Time: 4 hours Objectives: Unit 1: Undo and Lock Management  more...

Oracle SQL Tuning Diagnostics and Tuning Schema ...course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths, such as partitioned views, B-tree indexes, bitmapped indexes, index clusters, and hash clusters. Participants  more...

Oracle SQL Tuning Tuning SQL and the Optimizer ...ourse is the second in a two-part series on SQL Statement Tuning. This course will help application developers to design SQL statements that can reuse parsing and influence the optimizer to improve performance. L earn To: Identify the factors that affect network traffic. Identify the factors that affect parsing. Identify the guidelines for the reuse of parsed code.  more...

Oracle8 Certified Database Administrator Curriculum ...roubleshooting and Recovery (ID#446) Oracle8 Performance Tuning: Architecture & Strategy (ID#456) Oracle8 Performance Tuning: Managing Memory and Disk I/O (ID#460) Oracle8 Performance Tuning: Optimizing Sorts and Minimizing Contention (ID#465) Oracle8 Network Administration: Net8 Architecture and Strategy (ID#449) Oracle8 Network Administration: Net8 Configuration and Troubleshooting  more...

Oracle8 Performance Tuning Strategies and Techniques ...s course is the first in a three-part Oracle8 Performance Tuning series. This course will introduce participants to tools and techniques used to improve the performance of the Oracle8 server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally, students will overview the operating  more...

Oracle8 Performance Tuning Curriculum The Oracle8 Performance Tuning Curriculum consists of the following courses: Oracle8 Performance Tuning: Strategies and Techniques Oracle8 Performance Tuning: Managing Memory and Disk I/O Oracle8 Performance Tuning: Optimizing Sorts and Minimizing Contention To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle8 Performance Tuning Managing Memory and Disk I O ... course is the second in a three-part Oracle8 Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log buffer. Finally,  more...

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention ...s course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student will use Oracle tools  more...

SQL Server 7 0 - Implementing a Database - Part 2 ...on-leaf level pages. Identify the functions of the Index Tuning wizard. Select the methods of managing data fragmentation. Perform the steps to display the base table size and fragmentation. Select when to use the DBCC DBREINDEX statement. Select the methods available to manually update the index statistics. Identify the information the SHOWPLAN statements return when executed. Select  more...

Oracle8i Performance Tuning Curriculum The Oracle 8i Performance Tuning Curriculum includes the following courses: Oracle 8i Performance Tuning: Architecture & Strategy Oracle 8i Performance Tuning: Managing Memory & Disk I/O Oracle 8i Performance Tuning: Optimizing Sorts & Minimizing Contention To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle8i Performance Tuning Architecture Strategy ... course is the first in a three-part Oracle8i Performance Tuning series. This interactive course will introduce participants to tools and techniques used to improve the performance of the Oracle8i server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally, students will overview  more...

Oracle8i Performance Tuning Managing Memory Disk I O ...course is the second in a three-part Oracle8i Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log buffer. Finally,  more...

Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention ... course is the third in a three-part Oracle8i Performance Tuning series. This interactive course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student will use  more...

OCDBA8i Curriculum The Complete OCDBA8i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics(ID#322) Oracle 8i Backup and Recovery: Strategies & Backups(ID#7486) Oracle 8i Backup and Recovery: Troubleshooting & Recovery(ID#7487) Oracle 8i Database Admin.: Manage an  more...

Building Cisco Multilayer Switched Networks Part 2 ...twork model. Identify commands to configure port-level tuning with PortFast. Identify commands to configure UplinkFast and BackboneFast. Identify commands to configure Multiple Spanning Tree (MST). Identify commands to configure EtherChannel. Identify the commands used to configure PAgP and LACP. Identify options to configure EtherChannel load balancing. Identify commands  more...

Oracle Database 10g New Features for Administrators Part 1 ..., configuration and performance enhancements, Application tuning, space management, backup and recovery enhancements, and security enhancements. Learn To: Match goals of Oracle Database 10g manageability with the methods of achieving them. Identify features of the Oracle Database 10g manageability strategy. Identify attributes of Grid computing. Identify new installation  more...

Oracle Database 10g New Features for Administrators Part 2 ...management, manageability infrastructure, and application tuning and monitoring. Learn To: Identify features of Automatic Database Diagnostic Monitor (ADDM). Identify options for analyzing Automatic Database Diagnostics Monitor (ADDM) results. Identify features of Automatic Shared Memory Management (ASMM). Identify features of Automatic Workload Repository (AWR).  more...

SQL Server 2000 Database Admin Part 5 Maint SQL Server 2000 ...ver 2000 monitoring. Identify guidelines for performance tuning. Identify the factors to consider when detecting database performance problems. Audience The audience for this course include system administrators, database administrators, application developers, systems analysts, and software engineers. A prerequisite skill for this course is an understanding of basic relational database  more...

Oracle9i Certified Database Administrator Track Curriculum The Complete Oracle9i Certified Database Administrator Track Curriculum includes the following curriculums: Introduction to Oracle9i: SQL Curriculum (ID#8054) Oracle9i Database: Fundamentals I Curriculum (ID#8058) Oracle9i Database: Fundamentals II Curriculum (ID#8064) Oracle9i Database: Performance Tuning Curriculum (ID#8068) To review individual curriculum descriptions, please select the  more...

Oracle9i Database Performance Tuning Curriculum The Oracle9i Database: Performance Tuning Curriculum includes the following courses: Oracle9i Performance Tuning: Architecture and Strategy Oracle9i Performance Tuning: Managing Memory and Disk I/O Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle9i Performance Tuning Architecture Strategy ... are introduced to the strategies and techniques used for tuning the Oracle9i server. Learn To: o Match the tuning goals with the appropriate job role. o Identify common tuning problems that directly affect database performance. o Identify appropriate tuning goals. o Identify key information recorded by the alert log. o Identify the parameters that control the location and format of  more...

Oracle9i Peformance Tuning Managing Memory and Disk I O ... used to tune the Shared Pool. o Identify the goals for tuning the Library Cache. o Identify the descriptions of redo entries. o Match the statistics used to diagnose disk I/O contention with their descriptions. o Identify the two parameters that allow the DBA to limit the amount of memory used for each Java session. o Identify the performance guidelines to reduce the activity on an  more...

Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention ...aining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting. Learn To: o Match the component of database storage with its definition. o Avoid dynamic allocation of extents by using the ALTER TABLE command. o Avoid the dynamic allocation disadvantages by  more...

Oracle 9i New Features Backup Recovery Performance Tuning This course introduces students to high availability and fault recovery, data protection and disaster recovery, LogMiner enhancements, online operations, and Recovery Manager enhancements. Students also learn about schema improvements, system improvements, and scalable session state management. Learn To Identify the new features designed to reduce unplanned  more...

Lotus Domino R6 Admin New Features Curriculum The IBM Lotus Domino 6 Administration New Features Curriculum includes the courses that provide an introduction to the new features of Domino 6. Students will learn how to set up and secure the administration environment, and about policy-based management. Students will also learn to manage Web users and files, to control mail and about LDAP enhancements and performance optimization. This  more...

Lotus Domino 6 for Release 5 Administrators Part 1 This course provides an introduction to the new features of Domino 6. You learn how to set up the administration environment and how to secure it. Finally, you learn about policy-based management. Learn To: o To match options available when installing Domino 6 server software with their functions. o To identify Domino 6 server configuration enhancements. o To identify the steps involved  more...

Lotus Domino 6 for Release 5 Administrators Part 2 This is the second course of the series on the new features of Domino 6. This course teaches how to manage Web users and files. You will also learn how to control mail and about the LDAP enhancements in Domino 6. Finally, you learn about performance optimization in Domino 6. This includes monitoring the server environment and the various methods used to improve performance. Learn To: o To  more...

Oracle Application Server 10g Administration II Part 1 ...omponents and the tools and techniques for monitoring and tuning the components. 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  more...

Oracle Application Server 10g Administration II Part 4 ...tor the OracleAS components and processes. It also covers tuning the various components of the OracleAS, as well as backup and recovery of OracleAS. Finally, it provides guidance on reconfiguring the OracleAS middle-tier components. Learn To: Identify features of Oracle Diagnostic Logging (ODL). Identify options for configuring component logging. Sequence the steps to search  more...

Making Telephone Calls Count ... like she has really been "heard" and understood? By fine-tuning your listening skills, you'll be able to deliver truly superior customer service. Different customers have different communication styles. By tuning into each customer's communication style and responding appropriately, you'll make stronger connections and build better rapport. In today's automated world, sometimes, just the act  more...

Certification in Oracle Applications Technologies ...undamentals -II IZ0-033 Oracle 9i Database- Performance Tuning IZ0-141 Oracle Forms- Build Internet Applications IZ0-040 Oracle Database 10g- New Features for Administrators IZ0-042 Oracle Database 10g - Administration - I IZ0-043 Oracle Database 10g - Administration - II Iz0-048 Oracle Database 10g- R2- RAC for Administrators IZ0-047 Oracle Database 10g a SQL Expert IZ0-046  more...