|
Training Classes
| Learning and Development Resources
| Training Directory
| New Training Seminars
| New Training Providers
| Site Map
| Promote Training Seminars
|
Training Keywords
| Training Seminars
| Training Providers
| Regions
|
| Advertise Training Seminars
| Login
|
||||||||||||||||||
Indexes Training Seminars and Classes
From Online Training Directory
FrameMaker II Diving In
   Create books with multiple 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. more...
From Serebra Learning Corporation
Microsoft SQL Server 7.0: Implementing a Database - Part 2
This is the second course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. more...Small Business Server 2000
To provide an overview of Microsoft Small Business Server (SBS) 2000 and its main features, such as its management consoles and monitoring tools, and to show how Microsoft Exchange 2000, ISA Server 2000, and Microsoft SQL Server 2000 integrate with SBS 2000 Network administrators for companies of up to 50 users; IT solutions companies that wish to deploy SBS 2000 more...Managing and Retrieving Content in SharePoint 2003
To illustrate how to configure and manage contents and searching in SharePoint Portal Server 2003 Administrators who intend to deploy SharePoint Portal Server 2003 and SharePoint technologies; IT professionals who wish to gain knowledge of SharePoint products and technologies more...Tables and Indexes in Oracle9i
To describe how to manage tables and indexes in an Oracle9i database Anyone wanting to learn about Oracle9i database administration more...Defining and Manipulating Data in Oracle 9i
To describe how to define database objects and manipulate the data stored within them in an Oracle9i database Junior database administrators, application developers, and database operators more...Scalability and Performance in Oracle9i
To describe the scalability and performance enhancements available in an Oracle9i database Database operators, administrators, and developers interested in the new technical features and benefits of an Oracle9i database more...Tuning Systems and Applications in Oracle9i
To describe how to tune systems and applications in Oracle9i Anyone wishing to learn about Oracle9i database performance tuning more...Oracle Database 10g Monitoring and Maintenance Release 2
To demonstrate how to control database performance and configure proactive database maintenance Anyone wanting to learn about Oracle Database 10g database administration more...Oracle Database 10g New Features in VLDB Support
To use Oracle 10g's new VLDB support features Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g more...Managing Database Access in a DB2 UDB
To describe database access management in DB2 UDB Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator more...Accessing Data and Manipulating DB2 UDB Database Objects
To access data and manipulate database objects Anyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certification more...Advanced Formatting and Navigation in Word 2002
To provide a detailed overview of the advanced formatting and navigation features in Word 2002 Personnel at all levels of the enterprise; advanced end-users seeking proficiency in the use of Microsoft Word 2002; advanced end-users seeking to obtain Microsoft Office User Specialist (MOUS) certification at Expert level in the use of Microsoft Word 2002 more...Managing Large and Collaborative Documents
...ter documents, footnotes, endnotes, cross-references, and indexes. Apart from managing long documents, the course also focuses on reviewing documents as well as incorporating changes. It also teaches the users to share and protect documents in a Workgroup. Additionally, the course explains the process of creating and modifying Web documents by adding hyperlinks, media clips, and other Web more...Adobe InDesign CS2 Beyond the Basics
This course teaches concepts related to creating multipage documents and using master pages. In this course, you will learn how to add pages to a document, organize pages in a document, and create and apply master pages. You will also learn how to combine documents into a book and to create Table of Contents (TOCs) and indexes. In addition, you will learn how to preflight and package a document, more...Oracle 8i PL/SQL - Database Objects and Security
This course is aimed at familiarizing the learner with the inbuilt objects and security options in Oracle. The course includes creating and managing sequences indexes and users. It also includes PL/SQL block PL/SQL records and tables PL/SQL variables and datatypes. Related Exam: Oracle Exam #1Z0-001: Introduction to Oracle: SQL and PL/SQL. more...Oracle8i DBA: Indexes and Constraints
In this course you will learn to create indexes and enforce various constraints. The course describes the reorganization of indexes managing indexes and maintaining constraints. You will also learn how to obtain information about indexes and constraints from the data dictionary. Related Exam: Oracle Exam #1Z0-023: Oracle 8i: Architecture and Administration. more...MS SQL Server 2000: Database Administration Part 2: Managing Databases
 This is the second course in a five part series that will teach students how to plan for managing databases with SQL Server 2000. This course also includes both theoretical and practical instruction in the creation and management of objects. more...MS SQL Server 2000: Design and Implementation Part 4: Managing Indexes
This is the fourth course in a five part series 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. more...Microsoft Word 2002 Expert User
This course covers skills particular to the expert user of Word 2002. Advanced text and document handling is covered along with document styles and macros. Learners will cover group editing and document distribution, advanced workgroup collaboration and forms. Lastly, this course will cover tables, indexes and referencing, advanced document navigation and data tables. more...Oracle9i SQL: DML and DDL
The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table. more...Oracle9i Database Administration: Create a Database
The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this course discusses how to create and maintain more...Oracle9i Database Administration: Manage Storage Structures
The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course, participants learn the concepts associated with storage structure components. In addition, this course teaches users the procedures for managing segment free space, undo space, temporary more...Oracle9i Database Administration: Manage Data Storage
This course is the fourth in the series covering the database administration strategies and procedures provided in Oracle9. This course covers the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. more...Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention
The content of this course includes details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views. 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. more...C# Programming for MS .NET - Part 5: Operators, Properties, and Attributes
This is the final course in a five part series that covers operators, properties, and attributes. The learner will understand how to implement operators, delegates, and events, 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. more...MS Office 2000: Word for Experts I
This course teaches the student how to organize Word documents using features such as table of contents, cross-referencing, and indexes. The course also teaches the student how to modify and protect documents. more...C# Programming for MS .NET - Part 5: Operators, Properties, and Attributes
This is the final course in a five part series that covers operators properties and attributes. The learner will understand how to implement operators delegates and events 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. more...MS SQL Server 2000: Design and Implementation Part 4: Managing Indexes
This is the fourth course in a five part series 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. more...Microsoft Word 2002 Expert User
This course covers skills particular to the expert user of Word 2002. Advanced text and document handling is covered along with document styles and macros. Learners will cover group editing and document distribution advanced workgroup collaboration and forms. Lastly this course will cover tables indexes and referencing advanced document navigation and data tables. more...Oracle8i Database Administration: Create a Database
This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course participants will learn about the concepts associated with storage structure components managing rollback segments temporary segments and indexes. In addition creating and maintaining databases will be covered. more...Oracle8i Database Administration: Manage Storage Structures
This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course participants will learn the concepts associated with storage structure components. In addition this course will teach users how to create and maintain rollback segments temporary segments and indexes. more...Oracle9i Database Administration: Create a Database
The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components management of rollback segments temporary segments and indexes. In addition this course discusses how to create and maintain more...Oracle9i Database Administration: Manage Storage Structures
The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course participants learn the concepts associated with storage structure components. In addition this course teaches users the procedures for managing segment free space undo space temporary segments more...Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention
The content of this course includes details about each component of an Oracle database instance such as data blocks disks memory CPU and dynamic views. 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. more...Oracle8 Database Administration - Create Database
This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course participants will learn about the concepts associated with storage structure components managing rollback segments temporary segments and indexes. In addition creating and maintaining databases will be covered. more...Oracle8 Database Administration - Manage Data Storage Structures
This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course participants will learn the concepts associated with storage structure components. In addition this course will teach users how to create and maintain rollback segments temporary segments and indexes. more...Oracle SQL Specifics: Creating and Managing Database Objects
This course is the second in a two-part series on Oracle SQL Specifics that will teach participants how to use commands functions and operators supported by Oracle as extensions to standard SQL. Users will learn how to create and manage tables build integrity constraints and use the COMMIT and ROLLBACK statements to control transactions. Learners will create and maintain views sequences indexes more...Oracle SQL and SQL*Plus: SQL*Plus and Reporting
This course is the second in a two-part series on Oracle SQL Specifics that will teach participants how to use commands functions and operators supported by Oracle as extensions to standard SQL. Users will learn how to create and manage tables build integrity constraints and use the COMMIT and ROLLBACK statements to control transactions. Learners will create and maintain views sequences indexes more...Oracle SQL Tuning: Diagnostics and Tuning the Schema
This 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 will more...SQL Basic Skills
This course will provide the student with an overview of database objects, such as tables, indexes, views and triggers. Additionally, the students willl be able to query and update tables using SQL statements. more...SQL Advanced Skills
This course is the second course in the SQL Programming curriculum that consists of two courses. The course describes the statements used to manipulate data and to work with tables, indexes, and views. The students will also be able to describe the functioning of cursors, stored procedures, triggers, and transactions. more...Implementing an SQL 7.0 Data Warehouse
The Implementing an SQL 7.0 Data Warehouse course is the second course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It helps students to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of creating files and filegroups and helps students to select an application programming interface for more...DB2 Design & Administration (Rel 2.3)
Provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance. more...DB2 Design & Administration (ver 3.1)
Provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance. more...DB2 Design & Administration (ver 4.x)
This course provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance. more...SQL Data Management
Gives students a practical grasp of SQL commands for manipulating data, and teaches commands to define tables, views, and indexes. more...MS SQL Server 6.5: Design & Management
In this course, students will learn to implement a database design on Microsoft SQL Server 6.5. Specific topics include: SQL Server implementor roles and responsibilities; data modeling and data definition concepts; database object creation, such as tables; and basic data retrieval, manipulation, and modification. This course, together with MS SQL Server 6.5 DB Design Il, prepares students for more...Implementing an MS SQL Server 7.0 Data Warehouse
This course teaches the student how to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of crating files and filegroups and helps students to select an application programming interface for accessing a data source. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL more...
From 123-CBT Computer Based Training
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...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 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...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...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...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...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...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...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 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...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...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 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 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...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...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 database 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. Prior to taking 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 redo log more...Introduction to the Internet and World Wide Web
...g 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 may benefit 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...Oracle Database 10g SQL Fundamentals I Part 2
...or 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 test an more...Oracle SQL Tuning Tuning SQL and the Optimizer
...ning.
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 given 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 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...Oracle Database 10g Administration Workshop II Part 1
...linguistic 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.
Identify 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...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...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...
From The Virtual Training Company
Adobe InDesign 2 0
...ment support, which is great for allowing the creation of indexes and tables of content. Virtual Training Company author Andrew Hathaway begins slowly by introducing and explaining the interface and palettes of InDesign 2.0, setting up a new document, and how to use many of the tools, such as line tools and frame tools. He then moves on to adding text and graphics, formatting, editing, applying more...Adobe FrameMaker 5 5
...nd publication design. Version 5.5 allows you to generate indexes and tables of contents, create layouts with up to 100 master pages, and import formats. Virtual Training Company's tutorial on this application shows you how to do all of this and more. Diane Presler takes you through 12 hours of training on aspects of Framemaker 5.5 such as typography, objects, frames, and cross-referencing and more...
From Teach Me IT
Managing Large and Collaborative Documents
...ter documents, footnotes, endnotes, cross-references, and indexes. Apart from managing long documents, the course also focuses on reviewing documents as well as incorporating changes. It also teaches the users to share and protect documents in a Workgroup. Additionally, the course explains the process of creating and modifying Web documents by adding hyperlinks, media clips, and other Web more...Oracle SQL and PL/SQL: Basic Concepts
The Oracle SQL and PL/SQL: Basic Concepts WBT is the first course in this curriculum. This curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-001. This course explains the basic concepts regarding a DBMS, RDBMS, and ORDBMS, and give an Oracle implementation of these. It also provides users with the basic functionality of PL/SQL for creating, viewing, more...Managing Oracle8 Objects
...ging various database objects, such as datafiles, tables, indexes, clusters, views, sequences, synonyms and schema objects. After completing this course, the user will be able to:
Monitor multiple databases
Manage rollback segments
Manage and alter tablespaces
Manage datafiles
Alter datafile availability
Manage and alter tables
Describe and create indexes
Manage clusters
Manage hash more...Implementing an Oracle8 Data Warehouse
Implementing an Oracle8 data warehouse is the second course in the Oracle8 Data Warehousing curriculum. The course provides the users an insight into the functionalities of an Oracle data warehouse and enables them to organize for building a data warehouse. Apart from getting familiar with the concepts of moving and managing data, the users also receive a sound understanding of SQL*Loader, a more...SQL Advanced Skills
...atements used to manipulate data and to work with tables, indexes, and views. Users will also be able to describe the functioning of cursors, stored procedures, triggers, and transactions. After completing this course, the user will be able to:
Define a relational database
Insert new records in an existing table
Insert records from another table
Update and delete data from a table
Create more...Retrieving Data in SQL Server 2000
...d use views to retrieve data. It also introduces users to indexes and teaches them how to implement full-text search. Additionally, the users will learn to create stored procedures and cursors. After completing this course, the user will be able to:
Insert and modify data in a database
Retrieve data using a simple SELECT statement and with a JOIN clause
Retrieve data based on conditions more...Managing SQL Server 7.0
... Full-Text Search for specific columns and tables
Create indexes to support Full-Text Search
Identify the parts of a database
Create a database
Load data using INSERT and SELECT INTO statements
Load data using SQL services
Describe the process of automated administration
Define jobs, operators, and alerts
Plan the security requirements for linked servers and databases
Manage security more...Implementing an SQL 7.0 Data Warehouse
...nce the efficiency of queries by using different types of indexes. It also describes the process of creating files and filegroups and helps students to select an application programming interface for accessing a data source. After completing this course, the student will be able to:
Describe the considerations involved in designing a database
Create files and filegroups
Choose an API for more...SQL Server 7.0 - Basics
SQL Server 7.0 - Basics presents the concept of database and tables in SQL Server 7.0. It also covers the tools used to maintain data integrity. This course is the first course of the three courses in the Implementing SQL Server curriculum. The Implementing SQL Server curriculum prepares the students for the Microsoft Certification exam Implementing and Designing Databases with Microsoft SQL more...Advanced Features of Acrobat 4.0 - II
The Advanced Features of Acrobat 4.0 II WBT is the final course in the three-course curriculum on Acrobat 4.0. This course is designed to acquaint users with methods of adding interactive features, special effects, and digital signatures to PDF documents. The course also provides information regarding indexing of PDF documents that helps in searching for required information. Additionally, the more...
From Skillspride Online Training
Lotus Notes 4.6 Advanced User
This course is an advanced presentation of some of the more technical user features of Lotus Notes. Users who appreciate a challenging experience will enjoy venturing into Notes database design and automation features. Readers will learn to use and create queries, full text indexes, agents and SmartIcons. To import & export data, link & embed objects and write basic formulas, plus understand more...Lotus Notes 4.5 Advanced User
This course is an advanced presentation of some of the more technical user features of Lotus Notes. Users who appreciate a challenging experience will enjoy venturing into Notes database design and automation features. Readers will learn to use and create queries, full text indexes, agents and SmartIcons. To import & export data, link & embed objects and write basic formulas, plus understand more...Microsoft SQL Server 2000 Programming Part 1
This course along with our " SQL Server 2000 Programming Part 2 course will introduce readers to the major topics of building database applications with Microsoft SQL Server 2000. The key focus of the course is on server database design and implementation using SQL Server 2000, but it also covers some client development including Access 2000's ADP format, Visual Basic using ADO, and ASP with XML. more...Microsoft SQL Server 2000 Programming Part 2
This course along with our " SQL Server 2000 Programming Part 1 course will introduce readers to the major topics of building database applications with Microsoft SQL Server 2000. The key focus of the course is on server database design and implementation using SQL Server 2000, but it also covers some client development including Access 2000's ADP format, Visual Basic using ADO, and ASP with XML. more...
| ||||||||||||||||||
