|
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
|
||||||||||
Custom Search
Views Training Seminars and Classes
From Online Training Directory
Excel 97
    This course introduces students to the introductory, intermediate, and advanced aspects of Excel 97. It starts out teaching basic spreadsheet features and moves up to the most powerful aspects of Excel, such as adjusting default settings, creating views and custom toolbars, protecting worksheets, and applying passwords. more...Excel 97 Level 3
This advanced level course introduces the accomplished Excel user to the most powerful aspects of Excel. Some topics that will be covered include adjusting default settings; creating views and custom toolbars; protecting worksheets and applying passwords; and importing data from other applications. more...Access 97 Level 2
Students in this course will learn to master the more powerful aspects of Microsoft Access 97, including a variety of views, data types and field properties, and summary reports and mailing labels. more...
From Serebra Learning Corporation
Microsoft SQL Server 7.0: Implementing a Database - Part 4
This is the fourth 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. more...Microsoft Visual InterDev 6.0: Implementing Server Technologies
This is the final course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to identify the features and installation requirements of Microsoft Transaction Server (MTS) and the features of MTS components; more...Microsoft Outlook 2000 Proficient User
This course prepares IT Professionals to send messages to people inside and outside their organization, schedule appointments and meetings, maintain a contact list, and organize their activities with tasks, notes, and journal entries. more...Microsoft Office 2000 - Beginning FrontPage
To provide an introduction to the core concepts of Microsoft FrontPage 2000 Anyone wishing to become familiar with FrontPage 2000 or needing to create professional-standard Internet or intranet sites quickly and easily; students who wish to become certified as a Microsoft Office Specialist more...Enhancing and Managing Web Sites with FrontPage 2002
To explain how to enhance and maintain FrontPage 2002 web sites Anyone wishing to become familiar with FrontPage 2002 or needing to create professional-standard Internet or intranet sites quickly and easily more...Structuring Web Pages with Macromedia Dreamweaver MX
To describe how to use Dreamweaver MX to structure a web site Web professionals; home users and end users wishing to create effective Internet or intranet sites quickly and easily; Macromedia Flash MX developers using Macromedia Dreamweaver MX to create web pages more...Object-Oriented Analysis and Design with UML Designing the System
To introduce architectural analysis and design, and the role of key mechanisms Web developers more...Building ADO NET DataSets
To describe how to use ADO.NET's disconnected DataSet object model, including DataSets, DataAdapters, DataTables, DataRelations, DataRows, and DataColumns C# programmers and candidates for the Microsoft MCSD and MCAD certification paths more...Building ADO NET DataSets
To describe how to use ADO.NET's disconnected DataSet object model, including DataSets, DataAdapters, DataTables, DataRelations, DataRows, and DataColumns Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths 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...Project Server 2003 Enterprise Features and Views
To implement Project Server 2003 Enterprise features and views Systems administrators, systems engineers, systems analysts, IT consultants, and IT professionals with responsibility for planning and implementing Project Server 2003; learners preparing for MCSE certification exams 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...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 11i Oracle Projects Security Model and Page Layouts
To use Oracle Projects to secure function and data access within Projects applications, and use page layouts to manipulate views of project information Functional Implementers; Project Managers; Sales Consultants more...Oracle 11i Oracle Projects Security Model and Page Layouts
To use Oracle Projects to secure function and data access within Projects applications, and use page layouts to manipulate views of project information Functional Implementers; Project Managers; Sales Consultants 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...Using Advanced Features in Oracle 10g
To outline the processes and considerations for using the advanced features of Oracle Database 10g Oracle database administrators and database operators more...Oracle Database 10g New Storage Features
To identify the new storage features of Oracle Database 10g 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...Oracle Database 10g Performance Tuning Tuning Data
This course provides an overview of performance pages and dynamic views. Additionally, the course covers key concepts related to metrics, alerts, baselines, and Statspack. This course is designed for DBAs, database architects, support engineers, and technical consultants. 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...Microsoft Works Suite 2004 - Creating Databases
This course helps the learner create databases by covering Works Database essentials, working with data, and performing common tasks. It also covers database fundamentals such as database interface and database views. The course includes related topics such as manipulating data, performing common tasks, and working with forms and reports. A home computer user with basic to intermediate skills who more...Advanced Features of Outlook 2002
The Using Advanced Features of Outlook 2002 WBT is the second course of the Office XP: Outlook 2002 curriculum. It provides users with an in depth knowledge of customizing the Outlook 2002 interface and its various features based on individual requirements. It also provides students hands on training about the concepts and processes involved in using MS Outlook 2002 with the Exchange server and more...Getting Started with PowerPoint 2002
The Getting Started with PowerPoint 2002 WBT is the first course in the Office XP: PowerPoint 2002 curriculum. This course will be useful for users who want to create a professional presentation, and add different components to it to enhance the visual appeal of a slide show. The course describes the fundamentals of PowerPoint 2002 and introduces its features. It teaches the user to create slides, more...Getting Started with FrontPage 2002
The Getting Started with FrontPage 2002 course is the first course in the FrontPage XP curriculum. This course covers the features of Office XP and FrontPage 2002. It teaches the requirements and the steps for developing a Web site. Additionally, it covers the installation of FrontPage 2002 Server Extensions, customization of FrontPage 2002, and usage of the Help features, templates and wizards, more...Working with Documents in Word 2007
Microsoft Office Word 2007 has various design features that can be used to enhance your Word documents. These include Clip Art, SmartArt, WordArt, shapes, curves, lines, and diagrams to name a few. This course explains how to use Word 2007's Drawing Tools, including working with WordArt, AutoShapes, Pictures, Clip Art, and SmartArt. It also demonstrates the use of headers, footers, and page more...Creating and Designing a Project
In the corporate world, the project is a fundamental building block. Each project in which a company engages is unique, and fulfills an individual or corporate goal. And each project comprises a series of related tasks that culminate in a project deliverable. Microsoft Office Project 2007 is a comprehensive tool for project managers responsible for the overall design of projects, enabling them to more...Getting Started with MS Word 2007
This course covers important features and components of the Word 2007 interface. It also teaches the procedures of creating new documents, formatting text, and using different views to customize the display of documents. Additionally, the course teaches how to format paragraphs to enhance readability, create lists to organize text, and use styles to quickly format documents. Users who desire to more...Getting Started with FrontPage 2003
To introduce the basic features and functionality of Microsoft FrontPage 2003 Anyone wishing to become familiar with FrontPage 2003 or needing to create professional-standard Internet or intranet sites quickly and easily more...Working with Documents in Word 2003
To provide an overview of the document formatting, navigation, and recovery features in Word 2003 Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2003; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2003; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent more...Outlook 2003 and Business Contact Manager
To demonstrate how to use Outlook 2003 with Business Contact Manager Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003 more...Office 2000 - Advanced Project
To explain and demonstrate how to administrate and use advanced features of Project Central Anyone wishing to gain advanced knowledge of Microsoft Project 2000; candidates for Microsoft Office Specialist certification; end users seeking competence in Microsoft Project 2000 more...Microsoft Office 2000 - Intermediate Project 2000
To explain and demonstrate how to customize projects and handle multiproject environments using Microsoft Outlook and Project Central Business managers, planners, and team members who want to track and manage project tasks, costs, and resources; candidates for Microsoft Office Specialist certification; anyone wishing to gain a basic understanding of Project 2000; end users seeking competence in more...Microsoft Office 2000 - Beginning Outlook
To describe how to use Outlook 2000 in the integration of desktop applications and to show how Outlook 2000 can be used in most organizational and communications tasks Anyone wishing to gain an understanding of Microsoft Outlook 2000, candidates for Microsoft Office Specialist certification, and end-users seeking competence and proficiency in the use of Microsoft Outlook 2000 more...Administering Web Sites in FrontPage 2003
To introduce the issues involved in administering web sites in FrontPage 2003 Anyone wishing to become familiar with FrontPage 2003 at an advanced level or needing to create professional-standard Internet or intranet sites quickly and easily more...Customizing E-mail Views Navigation and E-mail Accounts in Outlook 2003
To demonstrate how to customize e-mail, views, and navigation and configure additional e-mail accounts in Outlook 2003 Personnel at all levels of the enterprise; end users seeking competency in the use of Microsoft Outlook 2003; end users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Outlook 2003 more...Advanced Customization
To identify how to structure your project using advanced customization features Anyone wishing to gain advanced knowledge of Microsoft Office Project Professional 2003; candidates for Microsoft User Specialist certification; end users seeking competence in Microsoft Office Project Professional 2003 more...Microsoft Outlook 98 Advanced
The Microsoft Outlook 98 Advanced course introduces you to additional features of Outlook, which are not covered in the Basic course, and which will help to enhance and broaden your information management skills. As you work through each unit in the course, you will learn how to work with a directory of contacts; create tasks on an electronic to-do list; track activities, times, and ideas in an more...Microsoft Project 98 Basic
Microsoft Project 98 is the leading project management software tool. This course provides an introduction to project management and using Project 98 to help manage projects. After completing this course, you should understand basic principles of project management and be able to use Project 98 to assist in creating a project Work Breakdown Structure and in sequencing tasks in order to create a more...Microsoft Project 98 Advanced
This course provides advanced-level training using Microsoft Project 98. A fictitious information technology consulting firm, Scott & Associates, is used throughout the course to illustrate important concepts. This course is designed for individuals who want to achieve advanced-level proficiency using Microsoft Project 98. more...Getting Started w Word 2003
The Getting Started with Word 2003 WBT is the first course in the Word 2003 curriculum. This course introduces the features and functionality of Word 2003. It acquaints users with the Word 2003 interface and introduces simple concepts, such as creating, editing, and saving a file. Additionally, this course enables a user to navigate Word documents, use different views, customize the display, and more...Getting Started w PowerPoint 2003
The Getting Started with PowerPoint 2003 WBT is the first course in the PowerPoint 2003 curriculum. This course will be useful for users who want to create a professional presentation, and add different components to it to enhance the visual appeal of a slide show. The course describes the fundamentals of PowerPoint 2003 and introduces its features. It teaches the user to create slides, add more...Basics of FrontPage 2000
The Basics of FrontPage 2000 WBT is the first course in the FrontPage 2000 curriculum. It acquaints the students with the basic concepts of Web designing, and the usage of FrontPage 2000. Users who need to plan, design and implement Web sites. more...Managing Worksheets and Customizing Excel 2003
The Managing Worksheets and Customizing Excel 2003 WBT is the second course in the Excel 2003 curriculum. It teaches the students how to effectively manage worksheets and customize them according to needs in Excel 2003. The tasks involved in managing worksheets and customizing them include navigating within worksheets and workbooks, organizing related information in worksheets, using various more...ECDL ICDL 4 Module 5 Database - Getting Started with Access 2003
To outline the concepts and processes for creating and navigating an Access 2003 database. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details. End users wanting to attain competency in using a database application; end users wanting to become familiar with database concepts; end users wanting to attain more...ECDL ICDL 4 Module 5 Database - Basic Access 2003 Tables
To outline the processes for creating and modifying tables. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details. End users wanting to attain competency in using a database application; end users wanting to become familiar with database concepts; end users wanting to attain competency in using Microsoft Access more...Microsoft Project 2002 Fundamentals
The Microsoft Project 2002 Fundamentals introduces students to the fundamentals of Project 2002. The course covers how to create schedule and manage projects using Project 2002. It covers how to create and schedule tasks how to create and use a Work Breakdown Structure (WBS) how to create and assign resources and how to create and use calendars. The course also deals with filtering grouping more...Microsoft Project 2003 Fundamentals
This the first of a two-part curriculum covers fundamental Project 2003 skills used in the areas of Task Calendar and Outlining management manipulation of data views and reports and project updating tracking and conflict resolution. more...Microsoft Project 2003 Proficient User
This the second course in a two-part curriculum covers Project 2003 proficiency-level skills i.e. advanced management of Tables Views and Reports the customization automation and exchange of data Project consolidation and collaboration and Project Server and Project Web Access. more...Oracle 8i PL/SQL - Adv SQL, SQL *Plus & Data Dictionary
In this course you will learn to create subqueries and queries using SET operators. The course describes the SQL *PLUS file commands and SET commands that are used to customize the SQL *PLUS environment. Furthermore the course discusses the SQL *Plus format commands and script files. The concept of data dictionary tables and views is also covered in the course. Related Exam: Oracle Exam #1Z0-001: more...Oracle 8i PL/SQL - DML and DDL Statements
...ements. It explains the concept of creation of tables and views. It also covers the various commands for manipulating a database. In addition the course explains the transaction processing features. It highlights the concept of altering a table definition in a database dropping a table adding comments to a table and renaming a table. It describes the various methods of managing constraints more...Oracle 8i DBA - Oracle Instance, the Start-up and Shutdown Procedure
The course is aimed at familiarizing the learner with the Oracle instance. It teaches you the learner about the startup and shutdown processes and the different stages of startup and shutdown. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping you the learner type in the commands more...Oracle 8i DBA - Data Dictionary and Database Files
...med at familiarizing the student with the Data Dictionary views and database files. The course enables the learner to manage log and control files. The uses and contents of control files will be discussed as well as obtaining information from control files. The planning use and troubleshooting of redo log files will also be explained. The course also provides a list of Data Dictionary views more...Oracle 8i DBA - Oracle Storage Architecture
This course is designed to give an Oracle DBA the necessary knowledge and skills to manage data storage. It will provide detailed information about logical structures such as tablespaces segments extents and Oracle data blocks. The creation and management of rollback segments will also be covered. The course also provides a list of data dictionary views that help in managing these logical more...Oracle 8i DBA - Managing Oracle Database Security
This course is aimed to familiarize the learner with the basic concepts of Oracle 8i administration of security user roles and resources. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping the learner to type-in the commands to perform administrative tasks. Related Exam: Oracle more...MS SQL Server 2000: Design and Implementation Part 3: Managing Objects
This is the third course in a five part series that will teach students how to work with SQL Server data objects. Students will learn how to create and manage view, stored procedures, user-defined functions, and triggers. 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: Manage an Instance
The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are performed by using 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 Performance Tuning: Strategies and Techniques
In this course, you are introduced to the strategies and techniques used for tuning the Oracle9i server. more...Oracle9i Performance Tuning: Managing Memory and Disk I/O
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. 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...Lotus Notes 4.6 Mail
This course is designed to provide students with the skills and knowledge of Lotus Notes and discusses the relationship between database, documents, forms and views. more...Microsoft SQL Server 2000 Querying with Transact-SQL Part 2: Working with Queries
This course will teach students how to work with queries. The course will also introduce views stored procedures triggers and user-defined functions. more...Oracle Reports: Report Fundamentals
...Report Builder executables module types the Report editor views Report Builder editor objects and the Reentrant Wizard are also a part of the course. In addition this course will help students learn how to create and modify the different types of reports such as Tabular Form-like Break Mailing Label and Matrix report styles. The student learns how to use the Live Previewer document a report more...Oracle9i Database Administration: Manage an Instance
The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are performed by 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...Advanced Oracle PL/SQL: Design Considerations and Object Types
This course introduces students to subtypes subprograms cursor variables and the NOCOPY parameter used in advanced function definitions and packages. Students also learn about object types data dictionary views and collections. 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...Lotus Domino R5 System Administration Part 1: Planning a Notes/Domino Infrastructure
This is the first course in a ten part series for system administrators who are responsible for Domino server and Notes client. At the completion of this course students will learn how to identify the concepts related to the planning of a Notes/Domino infrastructure; and identify the concepts related to protocols remote access connections and standard database views in Domino. more...Lotus Notes R5: Collecting and Organizing Information
This course provides participants with the fundamental skills to use Lotus Notes R5 on a daily basis in their workplace. At the completion of this course students will learn how to identify the different application types in Lotus Notes the features provided for Lotus Notes mails and the features of Notes replication; use Notes workspace to perform common tasks; create and enhance documents using more...Lotus Notes R5: Managing and Sharing Information
This course provides participants with the skills necessary to use Lotus Notes R5 on a daily basis in their workplace. At the completion of this course students will learn how to design and manage forms and views; search domains address books and the Internet for information; automate routine tasks by using agents; browse the Web by using the Personal Web Navigator; manage Web pages in Lotus more...Supply Chain Management
The course Supply Chain Management is intended to give company executives and interested experts in various industries an overview of the content goals possibilities and challenges of Supply Chain Management. As most chores within the supply chain today cannot do without the use of computer software the course shows concrete examples using SAP within different industry areas. The course transfers 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...Basic PL/SQL Programming
The Basic PL/SQL Programming WBT is the second course in this curriculum. This course will enable users to create views, sequences, synonyms, records, tables, functions, and procedures. Additionally, it will enable users to create different kinds of PL/SQL blocks. 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...
From 123-CBT Computer Based Training
Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention
 ...nce, 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. Learn To: o Match the component of database storage with its definition. o Avoid dynamic more...Oracle9i Peformance Tuning Managing Memory and Disk I O
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the more...Oracle9i Performance Tuning Architecture Strategy
...rocess trace files. o Identify the functions of the DBA views used to provide data storage statistics. o Match the dynamic performance views with the statistics they provide. o Match the V$ views used to collect system-wide statistics with their functions. o Identify the factors taken into consideration in selecting the physical structure for data. o Match the index types with their more...Oracle9i Database Admin Manage an Instance
...This course also explains the various dynamic performance views and initialization parameters and the globalization support that is provided. Learn To • Identify the memory structures of the SGA and the information stored in the database and nondatabase files. • Identify the connection procedures and the processes generated during database connection. • Identify the more...Oracle9i SQL DML and DDL
...CREATE SEQUENCE statement. o Identify the properties of views. o Match the clauses of the CREATE VIEW statement with their functions. o Create a public synonym by using the CREATE PUBLIC SYNONYM statement. o Remove a synonym by using the DROP PUBLIC SYNONYM statement. o Identify the features of Oracle database security. o Create users in an Oracle database. o Match the types of more...SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries
... how to work with queries. The course will also introduce views, stored procedures, triggers, and user-defined functions. Learn To Identify advantages of using aliases for table names. Identify the guidelines for using joins. Identify the considerations for using inner joins. Identify considerations for using subqueries. Create a derived table by using a subquery. Create a more...SQL Server 2000 Design Implement Databases Part 3 Managing Objects
...s, and triggers. Learn To Identify the features of views. Identify the considerations for creating views. Create a view by using Transact-SQL. Match the different user-defined functions with their characteristics. Create a user-defined function by using Transact-SQL. Identify characteristics of schema binding. Identify the features of stored procedures. Identify the considerations more...IBM DB2 Universal Database V6 1 App Devel Curriculum
...ting 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 application. This more...IBM DB2 Universal Database V6 1 App Devel Curriculum
...ting 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 application. This more...IBM DB2 Universal Database V6 1--Fundamentals
...objects, ensure 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 more...IBM DB2 Universal Database V6 1--Fundamentals
...objects, ensure 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 more...IBM DB2 Universal Database V6 1 Admin Curriculum
...ting 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 Administration more...IBM DB2 Universal Database V6 1 Admin Curriculum
...ting 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 Administration more...GroupWise 5 5 Admin Part 1--System Fundamentals
...roupWise client. Identify the default GroupWise calendar views. Post an appointment. Schedule a group appointment. Create a Multi-User list. Create a task. Create a reminder note for another person. Create a folder using the GroupWise client. Link a message to a folder using the GroupWise client. Share a folder using GroupWise. Track the status of a message using GroupWise. Identify more...Oracle8i Backup and Recovery Strategies Backups
...eters in the init.ora file. Identify the data dictionary views used to obtain the archive log information. Unit 3: Oracle Recovery Manager Duration: 2 Hour(s) Select the features of Recovery Manager (RMAN). Start Recovery Manager by using the RMAN command. Identify the events that occur during the connection process after the RMAN command is executed. Select the situations in more...Oracle8i Performance Tuning Managing Memory Disk I O
Course Overview This 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 more...Oracle8i Performance Tuning Architecture Strategy
...tistics using the dynamic troubleshooting and performance views. Diagnose statistics using the UTBSTAT/UTLESTAT output report. Identify appropriate OEM tuning tools. Use the available data access methods to tune the logical design of the database. List the primary steps for operating system tuning. Identify similarities between operating system and database tuning. C ontent more...Oracle8i Database Admin Create Databases
...ify 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 Identify tablespaces and data files. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network more...Lotus Domino R5 System Admin Part 1 Planning a Notes Domino Infrastructure
...rotocols, remote access connections and standard database views in Domino. L earn To: Identify the concepts related to the planning of a Notes/Domino infrastructure. Identify the concepts related to protocols, remote access connections and standard database views in Domino. C ontent Emphasis Skills-Based A udience This course series is for system administrators who more...Oracle Database 10g Administration Workshop II Part 4
...such as Resource Manager, the Scheduler, and materialized views.
Learn To:
Identify features of Automatic Storage Management (ASM).
Identify features of Automatic Storage Management (ASM) architecture.
Identify key concepts related to creating and accessing an Automatic Storage Management (ASM) instance.
Identify features of Resource Manager.
Identify key concepts related to more...Access 2000 Fundamentals
...of each Access 2000 database object. Identify the object views available in Access 2000. Print database objects. Create a new database in Access 2000. Access help on a specified subject by using the office Assistant. Unit 2: Access 2000 Tables Duration: 2 - 3 Hour(s) Create a table by using the Table Wizard. Create a table by using the Design view. Create a table by entering more...Oracle Reports R6 Enhance Reports
...ies of the Layout Model sections. Match the Layout Model views with their properties. Create a default layout for a report by using the Report Wizard. Sequence the steps to create a default layout for a section of the report by using the Report Wizard. Display the layout view for a report section by using the section option. Apply conditional formatting to a layout object by using the more...Oracle Reports R6 Report Fundamentals
...names, the Report Builder module types, the Report editor views, the different categories of objects available in a Report Module with their descriptions. Create a report using Report Wizard. Invoke the Reentrant wizard. Create Form Like, Break, Mailing Label, and Matrix types of reports using the reentrant Report Wizard. Modify reports in Live Previewer. Match report file types and more...Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention
...egment efficiency.
Query the V$TRANSACTION and V$SESSION views to help estimate the volume of rollback data.
Estimate the volume of rollback data.
Identify actions that reduce the amount of rollback.
Select the appropriate actions that increase the probability of successful completion when executing a large transaction.
Adjust the configuration of your rollback segments to resolve the more...Oracle8 Performance Tuning Managing Memory and Disk I O
...e function of the User Global Area.
Match the diagnostic views of the Library Cache with their respective definitions.
Perform the steps to determine the percentage of parse calls that find a cursor to share using GETHITRATIO column of the V$LIBRARYCACHE view
Perform the steps to determine the reloads-to-pins ratio from the V$LIBRARYCACHE view.
Identify the steps used to size the Library more...Oracle8 Performance Tuning Strategies and Techniques
...tistics using the dynamic troubleshooting and performance views.
Diagnose statistics using the UTBSTAT/UTLESTAT output report.
Identify appropriate Oracle Enterprise Manager (OEM) tuning tools.
Use the available data access methods to tune the logical design of the database.
List the primary steps for operating system tuning.
Identify similarities between operating system and more...Oracle8 Network Administration Net8 Configuration and Troubleshooting ...rameters with their functions. Match the data dictionary views used to verify MTS setup with their contents. Sequence the steps involved in the Connection Pooling process. Identify the syntax of the init.ora parameter MTS_DISPATCHERS that needs to be configured to enable Connection Pooling. Unit 3: Connection Manager Duration | ||||||||||