|
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
|
||||||||||
The Database Training Seminars and Classes
From Online Training Directory
Access 97
    This course introduces the database functions of Microsoft Access 97, such as working with Access menus and dialog boxes, creating and editing tables, formatting columns and rows, and planning table design. Accomplished users will work on advanced forms, use parameter and crosstab queries, and employ complex calculation expressions and selection criteria. more...Access 97 Level 1
Students will learn the database fundamentals of Microsoft Access 97, such as working with Access menus and dialog boxes, creating and editing tables, formatting columns and rows, and planning table design. Students will also learn about records, wizards and shortcuts, and AutoForms. more...
From Serebra Learning Corporation
CA-IDMS R Application Programming Part I ver 12
Explains CA-IDMS structure and environment, teaches how to access and manipulate records and sets, and details how they are physically stored in the database. Programmers, analysts and systems designers. more...CA-IDMS R Application Programming Part II ver12
Explains CA-IDMS structure and environment, teaches how to access and manipulate records and sets, and details how they are physically stored in the database. Programmers, analysts and systems designers. more...Data Modeling
To be able to use a database to store data, you have to design it. The first step in designing a database is data modeling. Data modeling enables a database designer to create a model that represents the way in which information is likely to be organized in the database. This data model is then reviewed by the people who are expected to use the final database. Subsequent steps in database more...Microsoft Works 2003 - Creating Databases
The Works 2003: Creating Databases course explores the database interface, and the student then learns about entering data, and database tables, and forms. more...SQL Server 7.0 Management Part I
...rd features. This course presents a comprehensive view of the database development process by outlining the processes of creating the database managing elements and data and building retrieval features. Students begin with an overview of elemental database objectives. The student learns to use Transact-SQL commands SQL Server 7.0 Wizards and SQL Server 7.0 Managers to manage database contents more...SQL Server 7.0 Web Integration
...'s overall Web strategy including reasons for linking the databases to Web clients possible tasks that can be accomplished through Web applications tools used for integration and technologies involved. This course introduces the overall concept of web and database integration with Microsoft's SQL Server 7.0 and then describes the elements of and enhancements to the Web Assistant in more...Oracle 8i DBA - Introducing Procedure Builder
This course aims to introduce you to the various components of Procedure Builder. It explains the features of the Procedure Builder components such as the Object Navigator the PL/SQL Interpreter the Program Unit Editor the Stored Program Unit Editor and the Database Trigger Editor. It describes how you can use the components of Procedure Builder to create debug and execute program units. Related 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
...stance 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 OEM and the steps to start and shut down an more...Oracle9i Database Administration: Create a Database
...abase 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 databases. The course also covers the new features 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 Database Administration: Manage Security
This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database. more...MS Office 2000: Access for Professionals I
This course teaches the student how to create a database and add tables and records to the database. The student will also learn how to retrieve data from a database using filters. more...Commerce Solutions with Microsoft Site Server 3.0 - Part 1
This is the first course in a two part series that will help students prepare for the Microsoft Certified Professional exam 70-057 Designing and Implementing Commerce Solutions with Microsoft Site Server 3.0 Commerce Edition. At the completion of this course students will learn to understand the methods and procedures of designing a Commerce site; identify the structure of a Commerce Server site more...Oracle8i Database Administration: Manage an Instance
This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course participants will learn about the concepts and procedures associated with Oracle architectural components using the database administration tools managing an Oracle instance and using National Language Support. 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...Oracle8i Database Administration: Manage Data Storage
This course is the fourth 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 tables. In addition this course will teach users about maintaining data integrity clusters and index-organized tables and methods for loading and reorganizing data. more...Oracle8i Database Administration: Manage Security
This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course participants will learn about the concepts and tasks associated with managing security. more...Oracle9i Database Administration: Manage an Instance
...stance 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 OEM and the steps to start and shut down an more...Oracle9i Database Administration: Create a Database
...abase 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 databases. The course also covers the new features of 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 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 Database Administration: Manage Security
This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database. more...Oracle SQL for End Users Part 2
This course is the second in a two-part SQL for End Users series that is based on Introduction to Oracle: SQL and PL/SQL. In this course the learner displays data from multiple tables by using equijoins non-equijoins and self joins. In addition this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database. This course also covers 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...Oracle8 Database Administration - Manage an Instance
This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course participants will learn about the concepts and procedures associated with Oracle architectural components using the database administration tools managing an Oracle instance and using National Language Support. 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...Oracle8 Database Administration - Manage Data Storage
This course is the fourth 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 tables. In addition this course will teach users about maintaining data integrity clusters and index-organized tables and methods for loading and reorganizing data. more...Oracle8 Database Administration - Manage Security
This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course participants will learn about the concepts and tasks associated with managing security. more...Oracle SQL Specifics: Retrieving and Formatting Data
This course is the first 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. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will learn how SQL more...Lotus Domino R5 Development Part 2: Application Development Fundamentals
This is the second course in a nine part series for webmasters application developers and graphic designers that will introduce Notes/Domino features web-specific tasks and basic system administration tasks to be up on the web quickly and to use Domino to create Web sites and Web applications. At the completion of this course students will learn how to create a database in Domino Designer and more...Fundamentals of MS Access 2000
This course familiarizes the students with the database fundamentals and teaches them how to perform database maintenance using MS Access. This course focuses on creation and design of databases and tables. The students will also learn the concept of querying tables. more...IDMS
Explains IDMS structure and environment, teaches how to access and manipulate records and sets, and details how they are physically stored in the database. more...CA-IDMS/R Application Programming (ver 10.2)
Explains CA-IDMS structure and environment, teaches how to access and manipulate records and sets, and details how they are physically stored in the database. more...CA-IDMS/R Application Programming (ver 12) (DOS)
Explains CA-IDMS structure and environment, teaches how to access and manipulate records and sets, and details how they are physically stored in the database. more...
From 123-CBT Computer Based Training
NDS 8 0 Advanced Tools Diagnostics Part 2
 Course Overview This is the second course in a three part series that teaches server background processes, as well as how to perform partition and replica operations within the Novell NDS environment. This course will cover how to remove a server, how to amend the properties of a server, how to verify process completion and synchronize replicas. Learn To • Cover NDS design guidelines, more...Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention
...Select the advantages of incorporating large extents into the database design. o Reclaim the space from the high water mark by using an ALTER TABLE command. o Query the results of an ANALYZE command to evaluate Oracle data block usage. o Match the actions for recovering space with their description. o Identify the characteristics of the Oracle block size. o Identify the advantages and more...Oracle9i Performance Tuning Architecture Strategy
...e of index organized tables. o Identify the features of the Database Resource Manager. o Identify the guidelines used to administer resource consumer groups. o Identify the processes implemented by resource plans and resource plan directives. o Identify the measures that can be taken to tune memory performance. o Identify the I/O tuning areas that can improve overall system more...Oracle9i Database Admin Manage Security
... This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database. Learn To • Define and maintain the five components of the security domain of a user in a given environment. more...Oracle9i Database Admin Manage Data Storage
...erview 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. Learn To • Identify the row storage method used by the various tables and the more...Oracle9i Database Admin Manage Storage Structures
...ctures 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, and indexes. Learn To • Identify the more...Oracle9i Database Admin Create a Database
...abase 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 databases. The course also covers the new features more...Oracle9i Database Admin Manage an Instance
...stance 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 OEM and the steps to start and shut down an more...Oracle9i SQL DML and DDL
...ase. 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. The course also explains the use of external tables and how to create the external tables. Learn To: o Identify the data structures in an Oracle server. o Identify the rules for naming tables in a database. o Identify the more...SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries
Course Overview This course will teach students 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 more...SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data
Course Overview This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL. Learn To Identify the basic types of statements used in Transact-Structured Query Language (SQL). Identify the functions of Data Definition Language (DDL) statements. Identify the functions of Data Control Language (DCL) statements. more...SQL Server 2000 Design Implement Databases Part 4 Managing Indexes
Course Overview 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. Learn To Identify the features of clustered indexes. Identify the features of nonclustered more...SQL Server 2000 Design Implement Databases Part 3 Managing Objects
Course Overview 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. Learn To Identify the features of views. Identify the considerations for creating views. Create a view by using Transact-SQL. Match the different more...SQL Server 2000 Design Implement Databases Part 2 Managing Data
Course Overview This is the second course in a five part series that will teach students how to work with SQL Server data. Learn To Identify the SQL Server 2000 system-supplied data types. Add a user defined data type. Match the parts of a data row with their features. Identify characteristics of entity modeling. Identify features of attributes. Identify requirements for logical more...SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server
Course Overview This is the first course in a five part series that presents students with both theoretical and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases. Learn To Identify the features and functions of SQL Server 2000. Match the components of the client-server communication process with their features. Identify more...SQL Server 2000 Database Admin Part 4 Managing Data
... publisher-subscriber metaphor. Identify the features of the Database Maintenance Plan Wizard. Troubleshoot a database by using the Database Consistency Checker (DBCC). Identify the guidelines for performing a Database Consistency Checker (DBCC) SHOWCONTIG. Audience Candidates for this exam operate in medium to very large computing environments that use SQL Server 7.0 (and plan to more...SQL Server 2000 Database Admin Part 2 Manag Databases
...ation and management of objects. Learn To Identify the database option categories. Identify features of the tools used to view database properties. View database information by using SQL Server Enterprise Manager. Match the different types of data integrity with their characteristics. Identify the different types of constraints. Identify guidelines for creating constraints. more...SQL Server 2000 Database Admin Part 1 Install SQL Server 2000
...n. Identify the types of SQL Server databases. Identify the database objects related to SQL Server. Identify the features of the SQL Server 2000 object-naming standard. Audience Candidates for this exam operate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server more...IBM DB2 Universal Database V6 1--Fundamentals
...eps of a distributed installation for DB2 clients. Match the database directories with their descriptions. Catalog a node and a database using the CATALOG command. Identify the functions of the DB2 Administration Server instance. Match the DB2 command interfaces with their characteristics. Identify the tasks performed using the Control Center. Match security levels with their definitions. more...IBM DB2 Universal Database V6 1--Fundamentals
...eps of a distributed installation for DB2 clients. Match the database directories with their descriptions. Catalog a node and a database using the CATALOG command. Identify the functions of the DB2 Administration Server instance. Match the DB2 command interfaces with their characteristics. Identify the tasks performed using the Control Center. Match security levels with their definitions. more...GroupWise 5 5 Admin Part 3--System Maintenance
...ffice using NetWare Administrator. Sequence the steps of the database information change process. Sequence the steps of the database movement process. Sequence the steps of the message movement process. Unit 3: Database Maintenance Duration: 2 Hour(s) Identify the categories of GroupWise database maintenance. Identify the problems that occur with databases. Identify the symptoms more...Oracle Designer 6i First Class Design Generation
...finitions. o Identify how to refine, generate and build the database design. o Identify how to design and generate an application system that includes an Oracle Developer form and an Oracle WebServer application. Audience Targeted audiences for this course are Business Analysts; Project Leaders; Designer/Developers; Web Application Developers; Data Administrators, and Database more...Oracle Designer 6i First Class Analysis
...he Applications Design Transformer. Identify the uses of the Database Design Transformer. Identify the uses of the Design Editor. Identify the characteristics of the techniques involved in system development. Identify the components of a Process Model. Identify the components of a Function Hierarchy Diagram. Identify the components of an Entity Relationship Diagram. Identify the more...Oracle8i Backup and Recovery Strategies Backups
...recovery catalog using Recovery Manager (RMAN). Display the database archive modes and identify the effects of running a database in a given archive mode. Identify different methods to perform physical database backups. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. more...Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention
...Select the advantages of incorporating large extents into the database design. Identify the characteristics of the Oracle block size. Identify the advantages and disadvantages of small data block and large data block sizes. Identify the functions of the PCTFREE and PCTUSED parameters. Identify the guidelines for setting the PCTFREE parameter. Calculate and set the PCTFREE parameter when 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
...ailable 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 Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed more...Oracle8i Database Admin Manage Security
... This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and tasks associated with managing security. L earn To: Define and maintain the security domains for users in a given environment. Define and maintain a named set of resources and password more...Oracle8i Database Admin Manage Data Storage
... This course is the fourth 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 tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L earn To: more...Oracle8i Database Admin 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. L earn To: Identify the database more...Oracle8i Database Admin Create Databases
... 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. L earn To: Identify more...Oracle8i Database Admin Manage an Instance
... This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To: Identify more...Lotus Domino R5 System Admin Part 7 Security Planning Implementation
...io. Identify the guidelines for setting server access in the database ACL to ensure proper database replication. Create a role from the workspace. Control access to a form by creating a form Create access list. Control access to a view by creating a view read access list. Unit 4: Document Security Duration: 1 Hour(s) Identify the characteristics of the Readers field in document more...Windows NT 4 0 Cluster Server Wolfpack - Part 1
...nicate in specific situations.
Identify the functions of the Database Manager.
Identify the activities performed by the Node Manager when it detects node failure.
Identify the functions of the Event Processor.
Identify the functions of the Communication Manager.
Identify the functions of the Global Update Manager.
Sequence the tasks performed by the Resource/Failover Manager when pushing more...Windows NT 4 0 Cluster Server Wolfpack - Part 1
...nicate in specific situations.
Identify the functions of the Database Manager.
Identify the activities performed by the Node Manager when it detects node failure.
Identify the functions of the Event Processor.
Identify the functions of the Communication Manager.
Identify the functions of the Global Update Manager.
Sequence the tasks performed by the Resource/Failover Manager when pushing more...Lotus Domino R5 Development Part 9 Web Site Design
...y levels in a Domino Web site with their features. Match the database settings used to secure data on a Domino Web site with their functions. Set up Domino Web site security by using server settings in the server document. Restrict access to a Domino data directory by using Domino Administrator. Create a realm to secure a Domino Web site by using Domino Administrator. Set up a certificate more...Lotus Domino R5 Development Part 8 Application Architecture
...he factors that affect application performance. Identify the database design considerations for optimum application performance. Identify the form design considerations for optimum application performance. Identify the view design considerations for optimum application performance. Identify the shared resources considerations to achieve optimum performance. Identify the application more...Oracle Database 10g Administration Workshop II Part 3
...nology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption.
Learn To:
Identify features of Flashback technology.
Identify features of Flashback Database. more...Access 2000 Expert User
...plit a database between its data and its objects by using the Database Splitter. Optimize the performance of a database by using the Performance Analyzer. Update the link of a linked table in a database by using the Linked Table Manager. Create a data access page by using the Page Wizard. Group the records of a data access page in Design view. Sort the records of a data access page by more...Access 2000 Fundamentals
... Duration: 2 - 3 Hour(s) Identify the advantages of the database approach over the traditional approach for storing and accessing data. Match the relational database components with their definitions. Sequence the steps involved in planning a relational database. Match the Access 2000 interface components with their functions. Open an existing database in Access 2000. Identify the more...Oracle Reports R6 Enhance Reports
...objects by using the link tool in the Data Model. Modify the database column to display the contents of a file by using the property palette. Identify the properties of a summary column. Create a formula column using the tool palette in the Data Model. Identify the uses of placeholder column. Unit 2: Layout Model Duration: 1 - 2 Hour(s) Identify the properties of the Layout Model more...Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention
...Oracle Expert repository.
Specify the options to display the database class data.
Change the duration and sample frequency of collecting instance statistics.
Access schema class data.
View environment class data.
View the workload class data.
View the display and edit options for collected data.
Locate the default rules.
View the tuning analysis.
View recommendations suggested by more...Oracle8 Performance Tuning Managing Memory and Disk I O
...using the appropriate SQL statements.
Unit 3: Tuning the Database Buffer Cache
Duration: 1 - 2 Hour(s)
Identify the characteristics of the Buffer Cache.
Sequence the steps used to manage the Buffer Cache.
Select the tuning technique used to monitor the Buffer Cache.
Perform the steps to view the statistics used to calculate the cache hit ratio using the V$SYSSTAT view.
Perform more...Oracle8 Performance Tuning Strategies and Techniques
...ailable 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 Emphasis
Skills-Based
A udience
Database administrators, system administrators, applications designers and developers, and technical support professionals.
Prior to taking more...Oracle8 Backup and Recovery - Troubleshooting and Recovery
...ith a missing
Identify the situations when you can start the database with missing data files.
Identify the methods to enable parallel recovery activities.
Identify the internal activities involved in the parallel recovery operations.
Identify the situations when considerations must be taken for Read-Only tablespace recovery.
Identify the methods to recover from loss of control file. more...Oracle8 Backup and Recovery - Strategies and Backups
...kups with and without RMAN.
L earn To:
Identify the database administrator goals and the criteria for defining a backup and recovery strategy.
Describe the structures and processes in the Oracle architecture.
Identify the implications of operating a database in a given archive mode and identify the steps to change the archive mode.
Set the init.ora parameters and configure more...Oracle8 Database Administration - Manage Security
...
This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and tasks associated with managing security.
L earn To:
Define and maintain the security domains for users in a given environment.
Define and maintain a named set of resources and password more...Oracle8 Database Administration - Manage Data
... This course is the fourth 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 tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data.
L earn To:
more...Oracle8 Database Administration - Manage 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.
L earn To:
Identify how storage more...Oracle8 Database Administration - Create Databases
... 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.
L earn To:
Plan and more...Oracle8 Database Administration - Manage an Instance
...
This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support.
L earn To:
Identify more...Exchange Server 5 5 Concepts and Administration - Part 3
...Server maintenance utilities with their functions.
Match the database size maintenance methods with their uses.
Identify the factors to be considered when planning a backup strategy.
Select a backup strategy for a given scenario.
Make a backup of the Microsoft Exchange Databases on a tape drive by using the Backup option.
Identify the functions of the Exchange Server-specific switches. more...Frontpage 2000 Expert User
C ourse Overview This course prepares IT Professionals to create, organize and manage a Web using FrontPage 2000. L earn To: Import and modify an existing Web. Customize a FrontPage Web. Client-server interaction. C ontent Emphasis Skills-Based A udience This course is intended for end users using Microsoft FrontPage 2000. Participants should have a basic more...Frontpage 2000 Expert User
Course Overview This course prepares IT Professionals to create, organize and manage a Web using FrontPage 2000. L earn To: Import and modify an existing Web. Customize a FrontPage Web. Client-server interaction. C ontent Emphasis Skills-Based A udience This course is intended for end users using Microsoft FrontPage 2000. Participants should have a basic more...Visual C 6 0 Designing Implementing Desktop Applications - Part 5
...reate an ODBC database application. Create a display for the database application. Modify an ODBC database application to manipulate the database. Modify an ODBC database application to filter the records that satisfy the criteria entered by the user. Identify the advantages of using DAO to connect to a database. Match the Data Access Objects (DAO) database classes supported by MFC with more...Visual InterDev 6 0 Active Server Pages and Data Access
C ourse Overview
This is the third 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 of Active Server Pages (ASP); create a server script and debug the server-side script; more...Microsoft Visio 2003 Expert User
... master shapes from each record in a database table using the Database Wizard.
Audience:
This course is intended for personnel with significant prior experience; end users wishing to extend their skills in the areas of advanced diagram development and technical aspects of Microsoft Visio 2003. Experience with the Windows 2000/XP interface and basic knowledge of Visio 2003 is assumed. It more...Visual InterDev 6 0 Planning a Web Application
...
Identify the features of Web-based architecture.
Match the database models with their advantages.
Match the Microsoft client products that are used to build and deploy Web solutions with their features.
Match the Microsoft server products that are used to build and deploy Web solutions with their features.
Match the development products that are used to build and deploy Web solutions with more...Crystal Reports v10 Introduction to Report Design Part 3
...d exporting a report.
Identify the options for updating the database file location accessed by a report.
Identify the key aspects of Crystal Translator.
Audience:
This course is designed for report designers who are responsible for creating and distributing reports. The course does not assume prior experience with Crystal Reports.
Deployment:
Self-Study
Accreditation
CEU more...Microsoft FrontPage 2003 Expert User
...stomize a drop-down box in a form.
Identify features of the Database Results Wizard for creating a data-driven page.
Set up a form handler to send form results to a Microsoft Access 2003.
Insert a data view in a Web page.
Add Web Parts to a Web page.
Connect Web Parts using the Web Part Connections Wizard to integrate data.
Create an ASP.NET data-driven Web page using the Database more...Oracle Database 10g Adminsitration Workshop I Part 3
...the Database Security. This course will help the learner to understand the benefits of database auditing and monitoring. It also covers Database Listeners and Services. The concept of shared and dedicated servers is also covered. After going through this course, the learners would be able to tune the system for best performance by configuring automatic alerts and thresholds.
Learn To:
more...Oracle Database 10g Administration Workshop I Part 4
Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will also be taught about undo management, lock management, and backup and recovery techniques.
Learn To:
Identify benefits of undo data.
Identify features of undo segments.
Identify undo management tasks that a DBA should perform to more...Oracle SQL Specifics Retrieving and Formatting Data
...can be used in SQL SELECT statements to extract data from the database and how SET operators can be used to combine multiple queries into a single query. Users will also learn how subqueries and correlated subqueries can help to solve data retrieval problems. Finally, participants will learn how to retrieve data based on a hierarchical relationship between rows.
L earn To:
Define more... | ||||||||||
