Online Optimizer eLearning - Training Resources

Oracle9i Peformance Tuning Managing Memory and Disk I O ...inistering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the OPTIMIZER_MODE parameter values with their description. o Identify the methods of creating stored outlines. o Identify the three major areas of the Shared Pool. o Identify the parameters used to tune the Shared Pool. o Identify the goals for tuning the Library Cache. o  more...

SQL Server 2000 Design Implement Databases Part 4 Managing Indexes ...g composite indexes. Identify the functions of the query optimizer. Identify the features of cost-based optimization. Sequence the steps for processing queries by using query optimizer. Audience The audience for this course includes database designers, database managers, and technical managers. Candidates for Exam 70-229 operate in medium to large computing environments that use SQL  more...

Oracle8i Performance Tuning Managing Memory Disk I O ...ment by using AUTOTRACE. Identify the characteristics of optimizer modes. Set the optimizer mode at the session level by using the OPTIMIZER_MODE parameter. Unit 2: Tuning the Shared Pool Duration: 1.5 - 2 Hour(s) Select the contents of the library cache. Identify the contents of the data dictionary cache. Select the functions of the Multithreaded Server Connection. Identify the  more...

Oracle8 Performance Tuning Managing Memory and Disk I O ...fficient SQL statements. Identify the characteristics of optimizer modes. Perform the steps to set the optimizer mode at the instance level using the OPTIMIZER_MODE parameter. Perform the steps to register a module using the SET_MODULE procedure. Perform the steps to track a module using the READ_MODULE procedure. Perform the steps to view statistics for the current session using the  more...

Exchange Server 5 5 Concepts and Administration - Part 3 ...m database files. Run the Microsoft Exchange Performance Optimizer by using the Microsoft Exchange Optimizer option. Display the performance optimizer log by using the Start button. Match the Exchange Server maintenance utilities with their functions. Match the database size maintenance methods with their uses. Identify the factors to be considered when planning a backup strategy. Select  more...

Oracle SQL Tuning Diagnostics and Tuning Schema ... efficient data access methods that are available for the optimizer. Create the appropriate database objects before starting to tune SQL statements. C ontent Emphasis Skills-Based A udience Application Developers, Database Administrators, and Designer/Developers. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Managing Performance Duration: 2 - 3  more...

Oracle SQL Tuning Tuning SQL and the Optimizer ...n 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. Identify the factors in SQL code design that affect response time. Identify the methods to improve network performance.  more...

SQL Server 7 0 - Implementing a Database - Part 2 Course Overview This is the second course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Implement data integrity. Create and maintain indexes. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database  more...

Oracle Database 10g New Features for Administrators Part 2 ...oad Repository (AWR). Identify guidelines for gathering optimizer statistics. Identify features of Automatic SQL Tuning. Identify features of SQL Tuning Advisor. 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  more...

mySAP com - Overview The Computer Based Training course (CBT) mySAP.com Overview aims to provide all employees of your company an introduction to SAP's answer to e-business, and the possibilities that mySAP.com offers. Trainees will be shown why mySAP.com was developed and the key components it contains. Furthermore, it shows how application hosting can be controlled throughout the system's entire life cycle,  more...

SAP Advanced Planner Optimizer APO Overview ...o Supply Chain Management (SCM). o Advanced Planner and Optimizer (APO). o APO Integration and Technology. o APO Planning Components. o Supply Chain Cockpit (SCC). o Demand Planning. o Supply Network Planning and Deployment. o Production Planning & Detailed Scheduling (PP/DS). o Transportation Planning (TP/VS). o Global Available-to-Promise (ATP). Audience The intended  more...

SAP R 3 4 6 Curriculum ...egic Enterprise Management (SEM) SAP Advanced Planner & Optimizer (APO) - Overview mySAP.com Workplace Overview SAP R/3 FI AR / AP: Organization, Master Records and Posting SAP R/3 4.6 FI AR / AP: Account/Document Posting and Periodic Processing SAP R/3 4.6 FI Payments SAP R/3 4.6 FI: General Ledger Organization and G/L Account SAP R/3 4.6 FI: General Ledger Posting and Periodical  more...