Online Indexes eLearning

Word XP Proficient Expert ...se Master Documents - Create A Master Document Create Indexes & Tables Of Contents - Mark Index Entries - Create & Modify An Index - Create & Modify A Table Of Contents Use Mail Merge - About Mail Merge - Use Mail Merge - Use Outlook As A Data Source - Create Labels Create Online Forms - About Forms - Create A Form - Modify A Form Distribute Word Documents  more...

Discover Word 2007 Level 3 Discover Word 2007: Level 3 Microsoft Discover Word 2007 from Technology Skills is a rich, multimedia tool for users of Microsoft Word 2007. Word 2007 builds on the word processing features of previous versions of the software program to provide powerful tools for creating and sharing professional documents through a fresh and efficient new look. Topics cover word processing concepts, document  more...

Oracle Database 11g Controlling User Access and Managing Schema Objects Oracle Database 11g: Controlling User Access and Managing Schema Objects Oracle To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.  more...

Database Objects in Oracle Database 10g Database Objects in Oracle Database 10g Oracle To demonstrate how to create database views, sequences, indexes, and synonyms  more...

Oracle Database 11g Using DDL Views Sequences Indexes and Synonyms Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms Oracle To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.  more...

Oracle Database 11g R2 Managing Database Space Duplication Oracle Database 11g R2: Managing Database Space & Duplication Oracle To effectively manage space, you can configure automatic management by the Oracle database server. This allows you to generate alerts about potential problems and recommend possible solutions. This course explores how to use the Oracle database server for automatic space management, proactively monitor and manage tablespace  more...

Advanced Document Navigation and Document Reviews in Word 2007 Advanced Document Navigation and Document Reviews in Word 2007 Microsoft Microsoft Office Word 2007 has many features that enable you to create robust documents that can be easily navigated, reviewed, and recovered if issues are encountered. This course explains how tables of contents are created, modified and deleted in conjunction with the use of tables of figures and tables of  more...

SQL Server 2008 Data Management ...tiple filegroups within a database. This makes tables and indexes that contain large amounts of data more manageable. Partitions in the database may need to be split to allow for more data to be stored, or data from one partition may need to be moved to another partition. SQL Server 2008 provides Transact-SQL statements to ensure that administrators can perform these tasks to manage the table  more...

Creating Implementing Database Objects in SQL Server 2008 ...s to allow access to the data within specific tables, and indexes to optimize the performance of the database for data retrieval. This course identifies each of these database objects and demonstrates the steps required to administer them within the SQL Server 2008 Management Studio tool. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft  more...

Creating Modifying Table Index Partitions in SQL Server 2008 ...partitions to manage subsets of data for large tables and indexes. Partitions can be used to improve the read/write performance on tables within a database by allowing the data within tables to be spread across multiple filegroups, whereas standard tables must be contained within a single filegroup. Data that is stored within partitions is treated as a logical entity, and the partitioned tables  more...

Querying Managing XML Data inSQL Server 2008 ...l data type, XML schema collations, and how to create XML indexes. It also explores how to retrieve data using FOR XML, process XML data using OPENXML, and how to query data using the XQuery language. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will  more...

Oracle Database 11g Controlling User Access Managing Objects Oracle Database 11g: Controlling User Access & Managing Objects Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.  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 Indexes Access Paths and Join Operations ...Indexes, Access Paths and Join Operations Oracle Access paths are the ways in which data is retrieved from the database, and there are a number of different access paths which can be used for tables and indexes. This course explores the access paths used for tables, such as full table, rowid, and sample table scan. It also examines the access paths used for indexes, such as unique, range,  more...

Oracle Database 11g R2 Application Performance Enhancements ...s for intelligent cursor sharing and the use of invisible indexes. It provides two different caches. The first cache includes SQL Query Result Cache used to cache query results or query blocks for future use, which reduces memory use and provides scalability. The second cache is the PL/SQL cross-section function result caching mechanism, which provides a language-supported and system-managed  more...

FrameMaker II: Diving In ...ultiple files; generate and format tables of contents and indexes; use cross-references, footnotes, variables, and conditional text; and convert documents to other formats, such as Adobe PDF and HTML. You can download the trial version of this software from the Adobe FrameMaker product site. This course provides an in-depth look at the core features of Adobe FrameMaker. This course covers the  more...

Dreamweaver MX Web Applications ...Queries Creating Queries How Queries are Created Creating Indexes MS SQL Server 2000 Upsizing to MS SQL 2000 What are Stored Procedures What are Views SQL What is SQL Select Statements Using Where & Order By Retrieving Data Using LIKE Connecting to Databases Web & Application Servers Types of Application Servers Installing Personal Web Server Configuring PWS Configuring IIS Interfacing with  more...

Access 2000 User Series ...ield Properties 2.5 Input Masks 2.6 The Lookup Wizard 2.7 Indexes 3.0 Working with Relationships (27 Minutes) 3.1 Introduction to Relationships 3.2 Benefits of Relationships 3.3 Types of Relationships 3.4 Referential Integrity 3.5 Indexes and Relationships 3.6 Printing Relationships 4.0 Designing Simple Queries (27 Minutes) 4.1 Selecting Fields & Ordering the Query Result 4.2 Refining Queries  more...

Access 2000 Intermediate ...ield Properties 2.5 Input Masks 2.6 The Lookup Wizard 2.7 Indexes 3.0 Working with Relationships (27 Minutes) 3.1 Introduction to Relationships 3.2 Benefits of Relationships 3.3 Types of Relationships 3.4 Referential Integrity 3.5 Indexes and Relationships 3.6 Printing Relationships 4.0 Designing Simple Queries (27 Minutes) 4.1 Selecting Fields & Ordering the Query Result 4.2 Refining Queries  more...

Tables and Indexes in Oracle9i To describe how to manage tables and indexes in an Oracle9i database  more...

SQL Server 2000 Indexes To describe and show how to create and manage indexes  more...

Oracle Database 11g Managing the Schema Data and Concurrency 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  more...

Oracle Database 10g SQL Fundamentals I Part 2 ...r creating and dropping synonyms. Identify features of indexes. Identify the syntax for creating and dropping indexes. Identify features of the data dictionary. Identify the contents and usage of data dictionary views. Unit 2: Objects and Data Management Identify tasks to be performed for granting system privileges. Identify tasks to be performed for granting object  more...

Oracle SQL Specifics Creating and Managing Database Objects ...ions. Learners will create and maintain views, sequences, indexes and synonyms. Additionally, users will learn how to control database access, add new users, and provide alternative names for objects using synonyms. Finally, participants will learn how to format query output, control the SQL*Plus environment, and specify variables at runtime. L earn To: Create and manage tables.  more...

Oracle SQL Tuning Diagnostics and Tuning Schema ...g optimal access paths, such as partitioned views, B-tree indexes, bitmapped indexes, index clusters, and hash clusters. Participants will then be able to test the results of their tuning efforts using performance analysis tools. L earn To: Identify the need and areas for tuning the performance of SQL statements. Identify tuning steps. Identify the tools that help you  more...

Oracle SQL Tuning Tuning SQL and the Optimizer ...ing. Identify the conditions that will block the use of indexes in a given code. Identify the guidelines for writing the SQL code that requires low response time. Identify whether or not a query to accomplish a given task should use a given view. Identify the type of query that will be appropriate in a given situation. Select the query that will produce minimum network traffic in a  more...

Oracle8 Database Administration - Create Databases ...ents, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered. L earn To: Plan and create a database. Create the data dictionary view. Use the data dictionary view to retrieve information. Identify the properties and benefits of using stored procedures and packages. Plan for the creation of  more...

Oracle8 Database Administration - Manage Storage Structures ...te and maintain rollback segments, temporary segments and indexes. L earn To: Identify how storage structure components work. Manage rollback segments. Manage temporary segments. Manage indexes. C ontent Emphasis Skills-Based A udience Database Administrators, system administrators, network administrators, and technical support professionals.  more...

Oracle8 Performance Tuning Strategies and Techniques ... Define appropriate use of B-tree, bitmap and reverse key indexes. Define appropriate use of index-organized tables. Define appropriate use of clusters. Define appropriate use of histograms. Unit 5: Generic Operating System Tuning Issues and Oracle Duration: 1 Hour(s) List the primary steps for operating system tuning. Identify similarities between operating system and  more...

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention ...ks, detect and resolve row migration and monitor and tune indexes. 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. Reconfigure and monitor rollback segments, define the number and sizes of rollback segments and allocate rollback segments to transactions  more...

SQL Server 7 0 - Implementing a Database - Part 2 ...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 solution with Microsoft SQL Server 7.0. Participants should have completed Microsoft SQL Server 7.0: System Administration (Course Series 72470 - 72474) and the first course in this series.  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3 ...r designing an index. Identify the features of full-text indexes. Create an index on a table. Maintain an index. Build a Data Transformation Services (DTS) package to transfer data from a Microsoft SQL Server 7.0 database to a data warehouse database. Unit 2: Replication Duration: 1 - 2 Hour(s) Create a publication in a SQL Server 7.0 database by using the Enterprise Manager.  more...

Introduction to the Internet and World Wide Web ...with Internet services. Identify the features of Web indexes and directories. Search Websites by using various strategies. Download and upload files by using File Transfer Protocol (FTP). C ontent Emphasis Skills-Based A udience End users and business professionals who have work-related duties that require the use of the Web and a Web browser. Some learners  more...

SQL and PL SQL DML and DDL ...constraints. Create sequences. Create views. Create indexes. Manage system privileges. C ontent Emphasis Skills-Based A udience Application Developers, Database Administrators, Designer/Developers, System Analysts, and Technical Support Professionals. Prior to taking this course, participants should be able to use a graphical user interface (GUI) and should be familiar  more...

Oracle8i Database Admin Create Databases ...ents, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered. L earn To: Identify and create a database. Identify the data dictionary views. Identify the data dictionary views to retrieve information. Identify the scripts to set up the PL/SQL environment. Identify control files Identify redo log files  more...

Oracle8i Database Admin Manage Storage Structures ...te and maintain rollback segments, temporary segments and indexes. L earn To: Identify the database storage structures and their relationships. Manage rollback segments. Manage temporary segments. Manage indexes. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, Technical Support Professionals.  more...

Oracle8i Performance Tuning Architecture Strategy Course Overview This 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,  more...

Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention ...s. Detect and resolve row migration. Monitor and tune indexes. Recognize, diagnose, and resolve performance problems associated with sorts. Recognize, diagnose, and resolve performance problems associated with rollback segments. Define levels of locking and list the possible causes of contention. Use Oracle utilities to detect and resolve lock contention. Prevent locking problems  more...

Oracle Database 10g Administration Workshop II Part 1 ...inguistic comparisons. Identify features of linguistic indexes. Identify features of linguistic sorts that can be customized. Match the views used to obtain parameter information with their descriptions. Distinguish between different types of character set scanner utilities. Identify key concepts related to data conversion between client and server character sets. Identify key  more...

Oracle Database 10g New Features for Administrators Part 3 Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Resource Manager, job Scheduler, tablespace monitoring, shrinking segments, and partitioning enhancements. Learn To: Identify features of Resource Manager in Oracle Database 10g.  more...

IBM DB2 Universal Database V6 1--Fundamentals ...nsure data validation and integrity, and create views and indexes. Master basic Structure Query Language (SQL). Manage database operations. C ontent Emphasis Skills-Based A udience This course is intended for database administrators and application developers. Students should have a fundamental understanding of relational database technology, including concepts of databases,  more...

IBM DB2 Universal Database V6 1--Fundamentals ...nsure data validation and integrity, and create views and indexes. Master basic Structure Query Language (SQL). Manage database operations. C ontent Emphasis Skills-Based A udience This course is intended for database administrators and application developers. Students should have a fundamental understanding of relational database technology, including concepts of databases,  more...

SQL Server 2000 Designing Implementing Databases Curriculum The MS SQL Server 2000 Designing & Implementing Database Curriculum includes the following courses: MS SQL Server 2000: Design & Implement Databases Part 1(Intro. to SQL Server) MS SQL Server 2000: Design & Implement Databases Part 2 (Managing Data) MS SQL Server 2000: Design & Implement Databases Part 3(Managing Objects) MS SQL Server 2000: Design & Implement Databases Part 4(Managing  more...

SQL Server 2000 Design Implement Databases Part 4 Managing Indexes ...ries that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries. Learn To Identify the features of clustered indexes. Identify the features of nonclustered indexes. Retrieve information from the sysindexes table.  more...

Advanced Project Leadership Bringing Home the Value ...d value management. Calculate deviations and efficiency indexes for an ongoing project. Interpret earned value management systems to judge project progress. Identify characteristics of different project types. Identify other parameters used to classify projects. Identify the benefits of classifying projects. Identify potential issues and guidelines for applying valuation techniques  more...

Word XP Expert User ...oration and forms. Lastly, this course will cover tables, indexes and referencing, advanced document navigation and data tables. Learn To • Modify the first page header or footer of a document. • Modify a bulleted list. • Modify a numbered list. • Distribute a document for revision by using e-mail. • Revise a document by using the Track Changes feature.  more...

C Programming for the Microsoft NET Platform Part 5 ...and how to use properties to enable field-like access and indexes to enable array-like access. The course also teaches how to create custom user-defined attributes. Learn To • Identify characteristics of operators. • Identify functions of predefined C# operators. • Identify characteristics of operator overloading. • Identify characteristics of the accessors of a  more...

Oracle9i Database Admin Create a Database ... management of rollback segments, temporary segments, and indexes. In addition, this course discusses how to create and maintain databases. The course also covers the new features of Oracle9i, such as Oracle Managed Files and Undo tablespaces, and the new features of the LogMiner utility. Learn To • Discuss the guidelines for creating an OFA structure and the information in the  more...

Oracle9i Database Admin Manage Storage Structures ...g segment free space, undo space, temporary segments, and indexes. Learn To • Identify the types of segments in the storage hierarchy. • Identify the benefits, working, and packages of automatic management of segment free space. • Identify the ways in which extents are controlled by segments. • Identify the block space utilization parameters. • Retrieve  more...

Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention ...Students learn about migration and chaining, 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  more...

Oracle 9i New Features Database Administration This course introduces learners to the Oracle9i 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.  more...

Oracle 9i New Features Backup Recovery Performance Tuning ... the LogMiner viewer. Identify the indexes that support online index rebuild. Identify the new functionalities of index-organized tables. Sequence the steps in performing an online redefinition of a table. Identify the considerations applied when the database is in a quiesced state.  more...

Systems Analysis Using Client Server Model Part 3 Client Server Design ...nts with their functions. o Identify characteristics of indexes. o Identify advantages of implementing distributed data processing in a Client Server environment. o Identify the factors to consider when performing data distribution analysis. o Identify factors to consider when implementing data replication. o Identify functions of the client in a Client Server system. o Match the  more...

Database Technologies Introduction to SQL ...ROLLBACK). o Identify the general overview of views and indexes, including how to create these database elements. Audience Associate database administrators, technical support consultants, and associate programmer/analysts are some of the types of people who would benefit from this course. This course is intended for people who are relatively new to the world of corporate IT and databases.  more...

Word 2003 Expert Part 2 ... reference. To insert document indexes and tables. To publish a Web document. To structure an Extensible Markup Language (XML) document. Audience The target audience will range from new users to power users, although the vast majority will have had some exposure to previous versions of Word. Fundamental PC and  more...

IIS 4 0 Creating Configuring a Web Server - Part 4 ... indexing process. Distinguish word lists and persistent indexes index types in the indexing process, on the basis of different parameters. Identify the types of merges. Issue a query to search for a word on Index Server. Identify the Index Server query features. Match the ways of issuing a query with their features. Sequence the steps in the query process. Create a content query on  more...

IBM DB2 Universal Database V6 1 Admin Curriculum ...such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL. Students will also learn how to plan, implement and maintain new and existing DB2 databases. This curriculum consists of 2 Skill Builder courses: Course 13431 IBM DB2 Universal Database V6.1 Fundamentals Course 13432 IBM DB2 Universal Database V6.1  more...

IBM DB2 Universal Database V6 1 Admin Curriculum ...such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL. Students will also learn how to plan, implement and maintain new and existing DB2 databases. This curriculum consists of 2 Skill Builder courses: Course 13431 IBM DB2 Universal Database V6.1 Fundamentals Course 13432 IBM DB2 Universal Database V6.1  more...

IBM DB2 Universal Database V6 1--Fundamentals ...nsure data validation and integrity, and create views and indexes. Master basic Structure Query Language (SQL). Manage database operations. C ontent Emphasis Skills-Based A udience This course is intended for database administrators and application developers. Students should have a fundamental understanding of relational database technology, including concepts of databases,  more...

IBM DB2 Universal Database V6 1--Fundamentals ...nsure data validation and integrity, and create views and indexes. Master basic Structure Query Language (SQL). Manage database operations. C ontent Emphasis Skills-Based A udience This course is intended for database administrators and application developers. Students should have a fundamental understanding of relational database technology, including concepts of databases,  more...

IBM DB2 Universal Database V6 1 App Devel Curriculum ...such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL. Students will also learn how to apply this knowledge to developing DB2-based applications, including using application objects such as schemas, user-defined types and functions, and stored procedures, as well as using embedded and dynamic SQL within an  more...

IBM DB2 Universal Database V6 1 App Devel Curriculum ...such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL. Students will also learn how to apply this knowledge to developing DB2-based applications, including using application objects such as schemas, user-defined types and functions, and stored procedures, as well as using embedded and dynamic SQL within an  more...

C Programming for the Microsoft NET Platform Part 5 ...and how to use properties to enable field-like access and indexes to enable array-like access. The course also teaches how to create custom user-defined attributes. Learn To • Identify characteristics of operators. • Identify functions of predefined C# operators. • Identify characteristics of operator overloading. • Identify characteristics of the accessors of a  more...